| Web Template: |
SELECT websiteID, websiteName, webTemplateID, webTemplateNamePublic FROM twistWebTemplate AS wtmp LEFT JOIN twistWebsite AS wbst ON wtmp.webTemplateWebsiteID = wbst.websiteID WHERE wtmp.deletedDateTime='0000-00-00 00:00:00' AND wtmp.webTemplateIsUIWidget = 1 AND (wtmp.webTemplateWebsiteID = 0 OR wtmp.webTemplateWebsiteID = '') ORDER BY wbst.websiteNamePublic, wtmp.webTemplateNamePublic
|