Pre-sale Shortfall Solutions

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."ShowListingImageOnPage", "SiteTree"."ListingSummary", "SiteTree"."Version", "SiteTree"."ListingImageID", "SiteTree"."ParentID", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ID" = 36) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."Created", "SiteConfig"."LastEdited", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LinkedInLink", "SiteConfig"."YoutubeLink", "SiteConfig"."FacebookLink", "SiteConfig"."FooterCol1", "SiteConfig"."FooterCol2", "SiteConfig"."FooterCol3", "SiteConfig"."Copyright", "SiteConfig"."Phone", "SiteConfig"."Fax", "SiteConfig"."OfficeLocationLine1", "SiteConfig"."OfficeLocationLine2", "SiteConfig"."ACL", "SiteConfig"."ABN", "SiteConfig"."PageBannerTitle1", "SiteConfig"."PageBannerTitle2", "SiteConfig"."Placeholder1", "SiteConfig"."Placeholder2", "SiteConfig"."Placeholder3", "SiteConfig"."ReceivedFormPlaceholder", "SiteConfig"."HeaderLinkID", "SiteConfig"."FooterLinkID", "SiteConfig"."SideLinkID", "SiteConfig"."HeaderLogoID", "SiteConfig"."FooterLogoID", "SiteConfig"."HeaderBannerID", "SiteConfig"."PageBannerID", "SiteConfig"."PageBannerLinkID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 36) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 11) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = 36) AND ("File"."ClassName" IN ('Image','Image_Cached')) ORDER BY "File"."Name" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."ShowListingImageOnPage", "SiteTree"."ListingSummary", "SiteTree"."Version", "SiteTree"."ListingImageID", "SiteTree"."ParentID", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "UserDefinedForm"."SubmitButtonText", "UserDefinedForm"."ClearButtonText", "UserDefinedForm"."OnCompleteMessage", "UserDefinedForm"."ShowClearButton", "UserDefinedForm"."DisableSaveSubmissions", "UserDefinedForm"."EnableLiveValidation", "UserDefinedForm"."HideFieldLabels", "UserDefinedForm"."DisableAuthenicatedFinishAction", "UserDefinedForm"."DisableCsrfSecurityToken", "UserDefinedForm"."ReceivedFormPlaceholder", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "UserDefinedForm" ON "UserDefinedForm"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ClassName" IN ('HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "EditableFormField"."ClassName", "EditableFormField"."Created", "EditableFormField"."LastEdited", "EditableFormField"."Name", "EditableFormField"."Title", "EditableFormField"."Default", "EditableFormField"."Sort", "EditableFormField"."Required", "EditableFormField"."CustomErrorMessage", "EditableFormField"."CustomRules", "EditableFormField"."CustomSettings", "EditableFormField"."CustomParameter", "EditableFormField"."Version", "EditableFormField"."ParentID", "EditableFormField"."ID", CASE WHEN "EditableFormField"."ClassName" IS NOT NULL THEN "EditableFormField"."ClassName" ELSE 'EditableFormField' END AS "RecordClassName" FROM "EditableFormField" WHERE ("ParentID" = '56') ORDER BY "EditableFormField"."Sort" ASC 0.0001s

SELECT DISTINCT "EditableFormField"."Name", "EditableFormField"."Sort" AS "_SortColumn0" FROM "EditableFormField" WHERE ("ParentID" = '56') AND ("EditableFormField"."Required" = '1') ORDER BY "_SortColumn0" ASC 0.0001s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowListingImageOnPage", "SiteTree_Live"."ListingSummary", "SiteTree_Live"."Version", "SiteTree_Live"."ListingImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '11') AND (("SiteTree_Live"."ID" != '11')) AND ("SiteTree_Live"."ShowInMenus" = '1') ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

SELECT DISTINCT count(DISTINCT "SideBarBanner"."ID") AS "0" FROM "SideBarBanner" INNER JOIN "SiteConfig_SideBarBanners" ON "SiteConfig_SideBarBanners"."SideBarBannerID" = "SideBarBanner"."ID" WHERE ("SiteConfig_SideBarBanners"."SiteConfigID" = '1') 0.0001s

SELECT DISTINCT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = 42) AND ("File"."ClassName" IN ('Image','Image_Cached')) ORDER BY "File"."Name" ASC LIMIT 1 0.0001s

SELECT DISTINCT "Link"."ClassName", "Link"."Created", "Link"."LastEdited", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Anchor", "Link"."OpenInNewWindow", "Link"."FileID", "Link"."SiteTreeID", "Link"."ID", CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName" ELSE 'Link' END AS "RecordClassName" FROM "Link" WHERE ("Link"."ID" = 4) LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 54) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "0" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '54') AND (("SiteTree_Live"."ID" != '54')) AND ("SiteTree_Live"."ShowInMenus" = '1') 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 7) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "0" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '7') AND (("SiteTree_Live"."ID" != '7')) AND ("SiteTree_Live"."ShowInMenus" = '1') 0.0001s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowListingImageOnPage", "SiteTree_Live"."ListingSummary", "SiteTree_Live"."Version", "SiteTree_Live"."ListingImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '7') AND (("SiteTree_Live"."ID" != '7')) AND ("SiteTree_Live"."ShowInMenus" = '1') ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 11) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "0" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '11') AND (("SiteTree_Live"."ID" != '11')) AND ("SiteTree_Live"."ShowInMenus" = '1') 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 12) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "0" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '12') AND (("SiteTree_Live"."ID" != '12')) AND ("SiteTree_Live"."ShowInMenus" = '1') 0.0001s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowListingImageOnPage", "SiteTree_Live"."ListingSummary", "SiteTree_Live"."Version", "SiteTree_Live"."ListingImageID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '12') AND (("SiteTree_Live"."ID" != '12')) AND ("SiteTree_Live"."ShowInMenus" = '1') ORDER BY "SiteTree_Live"."Sort" ASC 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 51) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "0" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = '51') AND (("SiteTree_Live"."ID" != '51')) AND ("SiteTree_Live"."ShowInMenus" = '1') 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 10) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 13) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 8) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 2) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "Page"."HeaderBannerSource", "Page"."PageBannerSource", "Page"."SideBarBannersSource", "Page"."PageBannerTitle1", "Page"."PageBannerTitle2", "Page"."MainNav", "Page"."ShowEnquiryForm", "Page"."HeaderBannerID", "Page"."PageBannerID", "Page"."PageBannerLinkID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree"."Sort" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("Page"."ID" = 3) AND ("SiteTree"."ClassName" IN ('Page','ErrorPage','RedirectorPage','VirtualPage','ListingPage','CategoryPage','FAQPage','HomePage','TeamListingPage','UserDefinedForm','ContactPage','HeaderForm')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0001s

SELECT DISTINCT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = 2) AND ("File"."ClassName" IN ('Image','Image_Cached')) ORDER BY "File"."Name" ASC LIMIT 1 0.0001s