0001: SET sql_mode = ? 0.0013s
0002: SHOW DATABASES LIKE 'baa\_t\_envirohub' 0.0006s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.004s
0004: SHOW FULL FIELDS IN "Fluent_Domain" 0.0021s
0005: SHOW COLLATION LIKE 'utf8_general_ci' 0.0006s
0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID", CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName" FROM "Fluent_Domain" 0.0004s
0007: SHOW FULL FIELDS IN "Fluent_Locale" 0.0022s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID", CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName" ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName" FROM "Fluent_Locale" ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC 0.0005s
0009: SHOW TABLES LIKE 'SubsiteDomain' 0.0016s
0010: SELECT DISTINCT count(DISTINCT "SubsiteDomain"."ID") AS "Count" FROM "SubsiteDomain" INNER JOIN "Subsite" ON "Subsite"."ID" = "SubsiteDomain"."SubsiteID" AND "Subsite"."IsPublic"=1 WHERE ('envirohub.kr.baa.nz' LIKE replace("SubsiteDomain"."Domain",'*','%')) 0.0003s
0011: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."DefaultSite", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName", "Subsite"."Title" FROM "Subsite" WHERE ("Subsite"."DefaultSite" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0005s
0012: SHOW FULL FIELDS IN "Member" 0.0024s
0013: SHOW FULL FIELDS IN "Group" 0.0019s
0014: SHOW FULL FIELDS IN "Permission" 0.0018s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s
0016: SELECT DISTINCT "Subsite"."ClassName", "Subsite"."LastEdited", "Subsite"."Created", "Subsite"."ShowBusitPages", "Subsite"."Title", "Subsite"."RedirectURL", "Subsite"."DefaultSite", "Subsite"."Theme", "Subsite"."Language", "Subsite"."IsPublic", "Subsite"."PageTypeBlacklist", "Subsite"."ID", CASE WHEN "Subsite"."ClassName" IS NOT NULL THEN "Subsite"."ClassName" ELSE 'SilverStripe\\Subsites\\Model\\Subsite' END AS "RecordClassName" FROM "Subsite" WHERE ("Subsite"."ID" = ?) ORDER BY "Subsite"."Title" ASC LIMIT 1 0.0005s
0017: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllChangesEnabled", "SiteConfig"."ReviewPeriodDays", "SiteConfig"."ReviewFrom", "SiteConfig"."ReviewSubject", "SiteConfig"."ReviewBody", "SiteConfig"."GACode", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterUsername", "SiteConfig"."FooterPhoneLabel", "SiteConfig"."FooterPhoneNumber", "SiteConfig"."FooterCopyright", "SiteConfig"."GlobalWarningActive", "SiteConfig"."GlobalWarningText", "SiteConfig"."GlobalWarningBackgroundColour", "SiteConfig"."GlobalWarningTextColour", "SiteConfig"."GoogleTagManagerCode", "SiteConfig"."FacebookPixelID", "SiteConfig"."GA4Code", "SiteConfig"."UseAltNavigation", "SiteConfig"."UseAltFooter", "SiteConfig"."BarCameraEmailList", "SiteConfig"."LinkTextStyle", "SiteConfig"."SubHeaderStyle", "SiteConfig"."FooterStyle", "SiteConfig"."PrimaryButtonStyle", "SiteConfig"."PrimaryButtonBorderStyle", "SiteConfig"."PrimaryButtonActiveStyle", "SiteConfig"."PrimaryButtonBorderActiveStyle", "SiteConfig"."FooterSignUpURL", "SiteConfig"."FooterLinks1Header", "SiteConfig"."FooterLinks2Header", "SiteConfig"."FacebookLink", "SiteConfig"."TwitterLink", "SiteConfig"."YouTubeLink", "SiteConfig"."LinkedInLink", "SiteConfig"."InstagramLink", "SiteConfig"."CustomSearchID", "SiteConfig"."HeaderLogoAltText", "SiteConfig"."ThemeATitle", "SiteConfig"."FooterContent", "SiteConfig"."FontColourStyle", "SiteConfig"."BodyColourStyle", "SiteConfig"."HeadingStyle", "SiteConfig"."NavigationBarStyle", "SiteConfig"."NavigationBarHoverStyle", "SiteConfig"."NavigationBarLinkTextColour", "SiteConfig"."NavigationBarLinkHoverTextColour", "SiteConfig"."NavigationBarLinkvisitedColour", "SiteConfig"."LogoAltText", "SiteConfig"."PhoneNumber", "SiteConfig"."DisplayPhoneNumber", "SiteConfig"."InstagramURL", "SiteConfig"."SwiftypeEnabled", "SiteConfig"."SwiftypeAccessKey", "SiteConfig"."SwiftypeAPIKey", "SiteConfig"."SwiftypeEngineKey", "SiteConfig"."SwiftypeDomainID", "SiteConfig"."SwiftypeEngineSlug", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."SubsiteID", "SiteConfig"."UniversalSettingsID", "SiteConfig"."AltHeaderImageMobileID", "SiteConfig"."HeaderLogoID", "SiteConfig"."FooterLogo1ID", "SiteConfig"."FooterLogo2ID", "SiteConfig"."FooterLogo3ID", "SiteConfig"."FooterLogo4ID", "SiteConfig"."MainLogoID", "SiteConfig"."LogoID", "SiteConfig"."LogoMobileID", "SiteConfig"."LogoRetinaID", "SiteConfig"."FooterLogoID", "SiteConfig"."FooterLogoRetinaID", "SiteConfig"."FavIconID", "SiteConfig"."AppleTouchIcon144ID", "SiteConfig"."AppleTouchIcon114ID", "SiteConfig"."AppleTouchIcon72ID", "SiteConfig"."AppleTouchIcon57ID", "SiteConfig"."ServiceUpdatePageID", "SiteConfig"."EventsPageID", "SiteConfig"."BackgroundSVGID", "SiteConfig"."PahiConfigID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" WHERE ("SiteConfig"."SubsiteID" IN (0)) LIMIT 1 0.0007s
0018: SELECT DISTINCT "TaxonomyTerm"."ClassName", "TaxonomyTerm"."LastEdited", "TaxonomyTerm"."Created", "TaxonomyTerm"."Name", "TaxonomyTerm"."Sort", "TaxonomyTerm"."ParentID", "TaxonomyTerm"."TypeID", "TaxonomyTerm"."ID", CASE WHEN "TaxonomyTerm"."ClassName" IS NOT NULL THEN "TaxonomyTerm"."ClassName" ELSE 'SilverStripe\\Taxonomy\\TaxonomyTerm' END AS "RecordClassName" FROM "TaxonomyTerm" INNER JOIN "Page_Category" ON "Page_Category"."TaxonomyTermID" = "TaxonomyTerm"."ID" WHERE ("Page_Category"."PageID" = ?) ORDER BY "TaxonomyTerm"."Sort" ASC 0.0008s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."HideSidebarMenu" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."HideSidebarMenu" ELSE NULL END AS "HideSidebarMenu", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."IsImported" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."IsImported" ELSE NULL END AS "IsImported", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_childIDs" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_childIDs" ELSE NULL END AS "Import_childIDs", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_footnotes" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_footnotes" ELSE NULL END AS "Import_footnotes", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_isPublished" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_isPublished" ELSE NULL END AS "Import_isPublished", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_isVisibleInMenu" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_isVisibleInMenu" ELSE NULL END AS "Import_isVisibleInMenu", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_lat" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_lat" ELSE NULL END AS "Import_lat", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_lng" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_lng" ELSE NULL END AS "Import_lng", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageContent" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageContent" ELSE NULL END AS "Import_pageContent", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageID" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageID" ELSE NULL END AS "Import_pageID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageName" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageName" ELSE NULL END AS "Import_pageName", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageTitle" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageTitle" ELSE NULL END AS "Import_pageTitle", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageType" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageType" ELSE NULL END AS "Import_pageType", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_pageURLSegment" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_pageURLSegment" ELSE NULL END AS "Import_pageURLSegment", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_parentID" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_parentID" ELSE NULL END AS "Import_parentID", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_publicationDate" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_publicationDate" ELSE NULL END AS "Import_publicationDate", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_startPublish" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_startPublish" ELSE NULL END AS "Import_startPublish", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_stopPublish" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_stopPublish" ELSE NULL END AS "Import_stopPublish", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Import_summary" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Import_summary" ELSE NULL END AS "Import_summary", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Additional_CSS" WHEN "SiteTree_Live"."ClassName" IN ('BeeCard\\PageTypes\\BeeCardPage') THEN "BeeCardPage_Live"."Additional_CSS" WHEN "SiteTree_Live"."ClassName" IN ('BusPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage') THEN "BusPage_Live"."Additional_CSS" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Additional_CSS" ELSE NULL END AS "Additional_CSS", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'BusRoutePage', 'MobileJourneyPlannerPage', 'FarmMenuPage', 'CustomSearchPage', 'TemplateABasePage', 'WLUGHomePage', 'WaikatoCivilDefenceHomePage', 'CampaignPage', 'BarCameraPage', 'CFNAPage', 'GmapUserLocationPage', 'MasonryPage', 'RainfallPage', 'RiverLevelPage', 'RssFeedPage', 'StockRateCalculatorPage', 'TealMasonryPage', 'ThunderMapsEmbedPage', 'ZoneMapPage', 'AddressBusPredictorPage', 'BeeCard\\PageTypes\\BeeCardPage', 'BusPage', 'Rearea\\Pages\\Page', 'CWP\\Search\\CwpSearchPage', 'SilverStripe\\ErrorPage\\ErrorPage', 'SilverStripe\\IFrame\\IFramePage', 'SilverStripe\\Registry\\RegistryPage', 'CWP\\CWP\\PageTypes\\BaseHomePage', 'CWP\\CWP\\PageTypes\\DatedUpdateHolder', 'CWP\\CWP\\PageTypes\\DatedUpdatePage', 'CWP\\CWP\\PageTypes\\SitemapPage', 'SilverStripe\\CMS\\Model\\RedirectorPage', 'SilverStripe\\CMS\\Model\\VirtualPage', 'SilverStripe\\UserForms\\Model\\UserDefinedForm', 'TemplateAHomePage', 'TemplateAPage', 'BarCameraSinglePage', 'HomePage', 'LandingPage', 'TealPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage', 'Rearea\\Pages\\CategoryPage', 'Rearea\\Pages\\ContentPage', 'Rearea\\Pages\\FullContentPage', 'Rearea\\Pages\\HomePage', 'Rearea\\Pages\\SwiftypeSearchPage', 'Rearea\\Pages\\TwoColumnPage', 'Rearea\\Pages\\EnvirohubMainPage', 'Rearea\\Pages\\ContactPage', 'Rearea\\Pages\\EnvirohubPage', 'Rearea\\Pages\\GreenwheelPage', 'Rearea\\Pages\\HailReportPage', 'Rearea\\Pages\\NewsArticle', 'Rearea\\Pages\\NewsHolder', 'Rearea\\Pages\\PublicationPage', 'Rearea\\Pages\\PublicationsHolder', 'Rearea\\Pages\\StoryPage', 'BusIFramePage', 'StarterHomePage', 'ServiceUpdateHolder', 'WaikatoCivilDefenceEventHolder', 'CWP\\CWP\\PageTypes\\EventHolder', 'CWP\\CWP\\PageTypes\\NewsHolder', 'ServiceUpdatePage', 'WaikatoCivilDefenceEventPage', 'CWP\\CWP\\PageTypes\\EventPage', 'CWP\\CWP\\PageTypes\\NewsPage', 'CWP\\CWP\\PageTypes\\FooterHolder', 'SilverStripe\\Subsites\\Pages\\SubsitesVirtualPage') THEN "Page_Live"."Additional_Javascript" WHEN "SiteTree_Live"."ClassName" IN ('BeeCard\\PageTypes\\BeeCardPage') THEN "BeeCardPage_Live"."Additional_Javascript" WHEN "SiteTree_Live"."ClassName" IN ('BusPage', 'BusAlertPage', 'BusAtoZPage', 'BusContentPage', 'BusHomePage', 'BusitRoutePage', 'BusitRoutesPage', 'FareCalculatorPage', 'FeedbackFormPage') THEN "BusPage_Live"."Additional_Javascript" WHEN "SiteTree_Live"."ClassName" IN ('TealPage') THEN "TealPage_Live"."Additional_Javascript" ELSE NULL END AS "Additional_Javascript", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BeeCardPage_Live" ON "BeeCardPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BusPage_Live" ON "BusPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "TealPage_Live" ON "TealPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0069s
0020: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0066s
0021: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0022s
0022: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0009s
0023: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0002s
0024: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0016s
0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0054s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0005s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0003s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0003s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0049s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0007s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID") AND ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0065s
0032: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."SubsiteID", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) AND ("MenuSet"."SubsiteID" = ?) ORDER BY "MenuSet"."Sort" ASC LIMIT 1 0.0017s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "Page_Live"."HideSidebarMenu", "Page_Live"."IsImported", "Page_Live"."Import_childIDs", "Page_Live"."Import_footnotes", "Page_Live"."Import_isPublished", "Page_Live"."Import_isVisibleInMenu", "Page_Live"."Import_lat", "Page_Live"."Import_lng", "Page_Live"."Import_pageContent", "Page_Live"."Import_pageID", "Page_Live"."Import_pageName", "Page_Live"."Import_pageTitle", "Page_Live"."Import_pageType", "Page_Live"."Import_pageURLSegment", "Page_Live"."Import_parentID", "Page_Live"."Import_publicationDate", "Page_Live"."Import_startPublish", "Page_Live"."Import_stopPublish", "Page_Live"."Import_summary", "Page_Live"."Additional_CSS", "Page_Live"."Additional_Javascript", "Rearea_Pages_Page_Live"."TeReoTitle", "Rearea_Pages_Page_Live"."BannerTitle", "Rearea_Pages_Page_Live"."BannerTeReoTitle", "Rearea_Pages_Page_Live"."BannerSubtitle", "Rearea_Pages_Page_Live"."ItalicizeSubtitle", "Rearea_Pages_Page_Live"."RemoveTitleLine", "Rearea_Pages_Page_Live"."BannerMode", "Rearea_Pages_Page_Live"."BannerStyle", "Rearea_Pages_Page_Live"."TitleBoxColor", "Rearea_Pages_Page_Live"."YoutubeVideoID", "Rearea_Pages_Page_Live"."Keywords", "Rearea_Pages_Page_Live"."Summary", "Rearea_Pages_Page_Live"."PreviewImageID", "SwiftypeSearchPage_Live"."ResultsMessage", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Rearea_Pages_Page_Live" ON "Rearea_Pages_Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SwiftypeSearchPage_Live" ON "SwiftypeSearchPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."SubsiteID" IN (0)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s
0034: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0004s
0035: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0009s
0036: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0002s
0037: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0003s
0038: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."SubsiteID", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) AND ("MenuSet"."SubsiteID" = ?) ORDER BY "MenuSet"."Sort" ASC LIMIT 1 0.0002s
0039: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.001s
0040: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0004s
0041: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0001s
0042: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."SubsiteID" IN (0)) 0.0002s
0043: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."SubsiteID", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) AND ("MenuSet"."SubsiteID" = ?) ORDER BY "MenuSet"."Sort" ASC LIMIT 1 0.0002s
0044: SELECT DISTINCT "SocialMediaIcon"."ClassName", "SocialMediaIcon"."LastEdited", "SocialMediaIcon"."Created", "SocialMediaIcon"."Name", "SocialMediaIcon"."URL", "SocialMediaIcon"."SortOrder", "SocialMediaIcon"."IconID", "SocialMediaIcon"."SiteConfigID", "SocialMediaIcon"."ID", CASE WHEN "SocialMediaIcon"."ClassName" IS NOT NULL THEN "SocialMediaIcon"."ClassName" ELSE 'SocialMediaIcon' END AS "RecordClassName" FROM "SocialMediaIcon" WHERE ("SocialMediaIcon"."SiteConfigID" = ?) 0.0003s
0045: SELECT DISTINCT "MenuSet"."ClassName", "MenuSet"."LastEdited", "MenuSet"."Created", "MenuSet"."Name", "MenuSet"."Description", "MenuSet"."Sort", "MenuSet"."SubsiteID", "MenuSet"."ID", CASE WHEN "MenuSet"."ClassName" IS NOT NULL THEN "MenuSet"."ClassName" ELSE 'Heyday\\MenuManager\\MenuSet' END AS "RecordClassName" FROM "MenuSet" WHERE ("MenuSet"."Name" = ?) AND ("MenuSet"."SubsiteID" = ?) ORDER BY "MenuSet"."Sort" ASC LIMIT 1 0.0001s
0046: SELECT CASE WHEN EXISTS(SELECT * FROM "StickyButton_Live" WHERE ("StickyButton_Live"."SubsiteID" = ?) AND (("StickyButton_Live"."ShowSiteWide" = ?) OR ("StickyButton_Live"."DisplayOnPageID" = ?))) THEN 1 ELSE 0 END 0.0005s
0047: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0003s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s
0049: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s
0050: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."PublicHistory", "SiteTree"."ShareTokenSalt", "SiteTree"."ContentReviewType", "SiteTree"."ReviewPeriodDays", "SiteTree"."NextReviewDate", "SiteTree"."LastEditedByName", "SiteTree"."OwnerNames", "SiteTree"."ShowPageUtilities", "SiteTree"."DesiredPublishDate", "SiteTree"."DesiredUnPublishDate", "SiteTree"."PublishOnDate", "SiteTree"."UnPublishOnDate", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "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"."WorkflowDefinitionID", "SiteTree"."SubsiteID", "SiteTree"."PublishJobID", "SiteTree"."UnPublishJobID", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0007s
0051: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."PublicHistory", "SiteTree_Live"."ShareTokenSalt", "SiteTree_Live"."ContentReviewType", "SiteTree_Live"."ReviewPeriodDays", "SiteTree_Live"."NextReviewDate", "SiteTree_Live"."LastEditedByName", "SiteTree_Live"."OwnerNames", "SiteTree_Live"."ShowPageUtilities", "SiteTree_Live"."DesiredPublishDate", "SiteTree_Live"."DesiredUnPublishDate", "SiteTree_Live"."PublishOnDate", "SiteTree_Live"."UnPublishOnDate", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "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"."WorkflowDefinitionID", "SiteTree_Live"."SubsiteID", "SiteTree_Live"."PublishJobID", "SiteTree_Live"."UnPublishJobID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s