0001: SET sql_mode = ? 0.0003s

0002: SHOW DATABASES LIKE 'staging\_aviagen\_com' 0.0013s

0003: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0004: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllowedLanguageIPs", CASE COALESCE(CAST("SiteConfig"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Title" WHEN '0' THEN "SiteConfig"."Title" ELSE "SiteConfig"."Title_en_US" END AS "Title", CASE COALESCE(CAST("SiteConfig"."Tagline_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Tagline" WHEN '0' THEN "SiteConfig"."Tagline" ELSE "SiteConfig"."Tagline_en_US" END AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", CASE COALESCE(CAST("SiteConfig"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Title" WHEN '0' THEN "SiteConfig"."Title" ELSE "SiteConfig"."Title_en_US" END AS "Title_en_US", "SiteConfig"."Title_en_CA", "SiteConfig"."Title_pt_BR", "SiteConfig"."Title_es_ES", "SiteConfig"."Title_es_CL", "SiteConfig"."Title_en_GB", "SiteConfig"."Title_en_AU", "SiteConfig"."Title_en_ZA", "SiteConfig"."Title_en_IN", CASE COALESCE(CAST("SiteConfig"."Tagline_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Tagline" WHEN '0' THEN "SiteConfig"."Tagline" ELSE "SiteConfig"."Tagline_en_US" END AS "Tagline_en_US", "SiteConfig"."Tagline_en_CA", "SiteConfig"."Tagline_pt_BR", "SiteConfig"."Tagline_es_ES", "SiteConfig"."Tagline_es_CL", "SiteConfig"."Tagline_en_GB", "SiteConfig"."Tagline_en_AU", "SiteConfig"."Tagline_en_ZA", "SiteConfig"."Tagline_en_IN", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0007s

0005: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0017s

0006: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0013s

0007: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0012s

0008: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllowedLanguageIPs", CASE COALESCE(CAST("SiteConfig"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Title" WHEN '0' THEN "SiteConfig"."Title" ELSE "SiteConfig"."Title_en_US" END AS "Title", CASE COALESCE(CAST("SiteConfig"."Tagline_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Tagline" WHEN '0' THEN "SiteConfig"."Tagline" ELSE "SiteConfig"."Tagline_en_US" END AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", CASE COALESCE(CAST("SiteConfig"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Title" WHEN '0' THEN "SiteConfig"."Title" ELSE "SiteConfig"."Title_en_US" END AS "Title_en_US", "SiteConfig"."Title_en_CA", "SiteConfig"."Title_pt_BR", "SiteConfig"."Title_es_ES", "SiteConfig"."Title_es_CL", "SiteConfig"."Title_en_GB", "SiteConfig"."Title_en_AU", "SiteConfig"."Title_en_ZA", "SiteConfig"."Title_en_IN", CASE COALESCE(CAST("SiteConfig"."Tagline_en_US" AS CHAR), '') WHEN '' THEN "SiteConfig"."Tagline" WHEN '0' THEN "SiteConfig"."Tagline" ELSE "SiteConfig"."Tagline_en_US" END AS "Tagline_en_US", "SiteConfig"."Tagline_en_CA", "SiteConfig"."Tagline_pt_BR", "SiteConfig"."Tagline_es_ES", "SiteConfig"."Tagline_es_CL", "SiteConfig"."Tagline_en_GB", "SiteConfig"."Tagline_en_AU", "SiteConfig"."Tagline_en_ZA", "SiteConfig"."Tagline_en_IN", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0007s

0009: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0011s

0010: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0011: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.001s

0012: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0011s

0013: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0011s

0014: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.001s

0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0017: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."LocaleFilter_en_US" = 1) 0.0014s

0018: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."LocaleFilter_en_US" = 1) 0.0011s

0019: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" WHERE ("SiteTree_Live"."LocaleFilter_en_US" = 1) 0.0012s

0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "HomePage_Live"."SliderType", "HomePage_Live"."ElementalAreaID", "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 "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0021: SELECT DISTINCT "Slide"."ClassName", "Slide"."LastEdited", "Slide"."Created", "Slide"."LocaleFilter_en_US", "Slide"."LocaleFilter_en_CA", "Slide"."LocaleFilter_pt_BR", "Slide"."LocaleFilter_es_ES", "Slide"."LocaleFilter_es_CL", "Slide"."LocaleFilter_en_GB", "Slide"."LocaleFilter_en_AU", "Slide"."LocaleFilter_en_ZA", "Slide"."LocaleFilter_en_IN", "Slide"."SortOrder", CASE COALESCE(CAST("Slide"."Title_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Title" WHEN '0' THEN "Slide"."Title" ELSE "Slide"."Title_en_US" END AS "Title", CASE COALESCE(CAST("Slide"."Content_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Content" WHEN '0' THEN "Slide"."Content" ELSE "Slide"."Content_en_US" END AS "Content", "Slide"."ContentPosition", CASE COALESCE(CAST("Slide"."LinkedURL_en_US" AS CHAR), '') WHEN '' THEN "Slide"."LinkedURL" WHEN '0' THEN "Slide"."LinkedURL" ELSE "Slide"."LinkedURL_en_US" END AS "LinkedURL", CASE COALESCE(CAST("Slide"."Type_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Type" WHEN '0' THEN "Slide"."Type" ELSE "Slide"."Type_en_US" END AS "Type", CASE COALESCE(CAST("Slide"."VimeoID_en_US" AS CHAR), '') WHEN '' THEN "Slide"."VimeoID" WHEN '0' THEN "Slide"."VimeoID" ELSE "Slide"."VimeoID_en_US" END AS "VimeoID", CASE COALESCE(CAST("Slide"."Title_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Title" WHEN '0' THEN "Slide"."Title" ELSE "Slide"."Title_en_US" END AS "Title_en_US", "Slide"."Title_en_CA", "Slide"."Title_pt_BR", "Slide"."Title_es_ES", "Slide"."Title_es_CL", "Slide"."Title_en_GB", "Slide"."Title_en_AU", "Slide"."Title_en_ZA", "Slide"."Title_en_IN", CASE COALESCE(CAST("Slide"."Content_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Content" WHEN '0' THEN "Slide"."Content" ELSE "Slide"."Content_en_US" END AS "Content_en_US", "Slide"."Content_en_CA", "Slide"."Content_pt_BR", "Slide"."Content_es_ES", "Slide"."Content_es_CL", "Slide"."Content_en_GB", "Slide"."Content_en_AU", "Slide"."Content_en_ZA", "Slide"."Content_en_IN", CASE COALESCE(CAST("Slide"."LinkedURL_en_US" AS CHAR), '') WHEN '' THEN "Slide"."LinkedURL" WHEN '0' THEN "Slide"."LinkedURL" ELSE "Slide"."LinkedURL_en_US" END AS "LinkedURL_en_US", "Slide"."LinkedURL_en_CA", "Slide"."LinkedURL_pt_BR", "Slide"."LinkedURL_es_ES", "Slide"."LinkedURL_es_CL", "Slide"."LinkedURL_en_GB", "Slide"."LinkedURL_en_AU", "Slide"."LinkedURL_en_ZA", "Slide"."LinkedURL_en_IN", CASE COALESCE(CAST("Slide"."Type_en_US" AS CHAR), '') WHEN '' THEN "Slide"."Type" WHEN '0' THEN "Slide"."Type" ELSE "Slide"."Type_en_US" END AS "Type_en_US", "Slide"."Type_en_CA", "Slide"."Type_pt_BR", "Slide"."Type_es_ES", "Slide"."Type_es_CL", "Slide"."Type_en_GB", "Slide"."Type_en_AU", "Slide"."Type_en_ZA", "Slide"."Type_en_IN", CASE COALESCE(CAST("Slide"."VimeoID_en_US" AS CHAR), '') WHEN '' THEN "Slide"."VimeoID" WHEN '0' THEN "Slide"."VimeoID" ELSE "Slide"."VimeoID_en_US" END AS "VimeoID_en_US", "Slide"."VimeoID_en_CA", "Slide"."VimeoID_pt_BR", "Slide"."VimeoID_es_ES", "Slide"."VimeoID_es_CL", "Slide"."VimeoID_en_GB", "Slide"."VimeoID_en_AU", "Slide"."VimeoID_en_ZA", "Slide"."VimeoID_en_IN", "Slide"."PageID", "Slide"."ImageID", "Slide"."ID", CASE WHEN "Slide"."ClassName" IS NOT NULL THEN "Slide"."ClassName" ELSE 'Aviagen\\Web\\Models\\Slide' END AS "RecordClassName" FROM "Slide" WHERE ("Slide"."PageID" = ?) AND ("Slide"."LocaleFilter_en_US" = 1) ORDER BY "Slide"."SortOrder" ASC LIMIT 10 0.0013s

0022: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0009s

0023: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."LocaleFilter_en_US", "Element_Live"."LocaleFilter_en_CA", "Element_Live"."LocaleFilter_pt_BR", "Element_Live"."LocaleFilter_es_ES", "Element_Live"."LocaleFilter_es_CL", "Element_Live"."LocaleFilter_en_GB", "Element_Live"."LocaleFilter_en_AU", "Element_Live"."LocaleFilter_en_ZA", "Element_Live"."LocaleFilter_en_IN", "Element_Live"."BackgroundImageTheme", "Element_Live"."Theme", "Element_Live"."Version", CASE COALESCE(CAST("Element_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "Element_Live"."Title" WHEN '0' THEN "Element_Live"."Title" ELSE "Element_Live"."Title_en_US" END AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", CASE COALESCE(CAST("Element_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "Element_Live"."Title" WHEN '0' THEN "Element_Live"."Title" ELSE "Element_Live"."Title_en_US" END AS "Title_en_US", "Element_Live"."Title_en_CA", "Element_Live"."Title_pt_BR", "Element_Live"."Title_es_ES", "Element_Live"."Title_es_CL", "Element_Live"."Title_en_GB", "Element_Live"."Title_en_AU", "Element_Live"."Title_en_ZA", "Element_Live"."Title_en_IN", "Element_Live"."TopPageID", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName" FROM "Element_Live" WHERE ("Element_Live"."ParentID" = ?) AND ("Element_Live"."LocaleFilter_en_US" = 1) ORDER BY "Element_Live"."Sort" ASC 0.0013s

0024: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0005s

0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "HomePage_Live"."SliderType", "HomePage_Live"."ElementalAreaID", "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 "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("HomePage_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0022s

0026: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."TopPageID", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0008s

0027: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE COALESCE(CAST("ImageCTABlock_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "ImageCTABlock_Live"."Content" WHEN '0' THEN "ImageCTABlock_Live"."Content" ELSE "ImageCTABlock_Live"."Content_en_US" END AS "Content", CASE COALESCE(CAST("ImageCTABlock_Live"."LinkedPageText_en_US" AS CHAR), '') WHEN '' THEN "ImageCTABlock_Live"."LinkedPageText" WHEN '0' THEN "ImageCTABlock_Live"."LinkedPageText" ELSE "ImageCTABlock_Live"."LinkedPageText_en_US" END AS "LinkedPageText", "ImageCTABlock_Live"."LinkType", CASE COALESCE(CAST("ImageCTABlock_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "ImageCTABlock_Live"."Content" WHEN '0' THEN "ImageCTABlock_Live"."Content" ELSE "ImageCTABlock_Live"."Content_en_US" END AS "Content_en_US", "ImageCTABlock_Live"."Content_en_CA", "ImageCTABlock_Live"."Content_pt_BR", "ImageCTABlock_Live"."Content_es_ES", "ImageCTABlock_Live"."Content_es_CL", "ImageCTABlock_Live"."Content_en_GB", "ImageCTABlock_Live"."Content_en_AU", "ImageCTABlock_Live"."Content_en_ZA", "ImageCTABlock_Live"."Content_en_IN", CASE COALESCE(CAST("ImageCTABlock_Live"."LinkedPageText_en_US" AS CHAR), '') WHEN '' THEN "ImageCTABlock_Live"."LinkedPageText" WHEN '0' THEN "ImageCTABlock_Live"."LinkedPageText" ELSE "ImageCTABlock_Live"."LinkedPageText_en_US" END AS "LinkedPageText_en_US", "ImageCTABlock_Live"."LinkedPageText_en_CA", "ImageCTABlock_Live"."LinkedPageText_pt_BR", "ImageCTABlock_Live"."LinkedPageText_es_ES", "ImageCTABlock_Live"."LinkedPageText_es_CL", "ImageCTABlock_Live"."LinkedPageText_en_GB", "ImageCTABlock_Live"."LinkedPageText_en_AU", "ImageCTABlock_Live"."LinkedPageText_en_ZA", "ImageCTABlock_Live"."LinkedPageText_en_IN", "ImageCTABlock_Live"."ImageID", "ImageCTABlock_Live"."LinkedPageID", "ImageCTABlock_Live"."LinkedFileID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ImageCTABlock_Live" ON "ImageCTABlock_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND ("Element_Live"."LocaleFilter_en_US" = 1) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0009s

0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0030: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0016s

0031: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0013s

0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "BrandPage_Live"."SliderType", CASE COALESCE(CAST("BrandPage_Live"."DistributorsContent_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."DistributorsContent" WHEN '0' THEN "BrandPage_Live"."DistributorsContent" ELSE "BrandPage_Live"."DistributorsContent_en_US" END AS "DistributorsContent", CASE COALESCE(CAST("BrandPage_Live"."DistributorsDetail_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."DistributorsDetail" WHEN '0' THEN "BrandPage_Live"."DistributorsDetail" ELSE "BrandPage_Live"."DistributorsDetail_en_US" END AS "DistributorsDetail", CASE COALESCE(CAST("BrandPage_Live"."ShowDistributors_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."ShowDistributors" WHEN '0' THEN "BrandPage_Live"."ShowDistributors" ELSE "BrandPage_Live"."ShowDistributors_en_US" END AS "ShowDistributors", CASE COALESCE(CAST("BrandPage_Live"."DistributorsContent_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."DistributorsContent" WHEN '0' THEN "BrandPage_Live"."DistributorsContent" ELSE "BrandPage_Live"."DistributorsContent_en_US" END AS "DistributorsContent_en_US", "BrandPage_Live"."DistributorsContent_en_CA", "BrandPage_Live"."DistributorsContent_pt_BR", "BrandPage_Live"."DistributorsContent_es_ES", "BrandPage_Live"."DistributorsContent_es_CL", "BrandPage_Live"."DistributorsContent_en_GB", "BrandPage_Live"."DistributorsContent_en_AU", "BrandPage_Live"."DistributorsContent_en_ZA", "BrandPage_Live"."DistributorsContent_en_IN", CASE COALESCE(CAST("BrandPage_Live"."DistributorsDetail_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."DistributorsDetail" WHEN '0' THEN "BrandPage_Live"."DistributorsDetail" ELSE "BrandPage_Live"."DistributorsDetail_en_US" END AS "DistributorsDetail_en_US", "BrandPage_Live"."DistributorsDetail_en_CA", "BrandPage_Live"."DistributorsDetail_pt_BR", "BrandPage_Live"."DistributorsDetail_es_ES", "BrandPage_Live"."DistributorsDetail_es_CL", "BrandPage_Live"."DistributorsDetail_en_GB", "BrandPage_Live"."DistributorsDetail_en_AU", "BrandPage_Live"."DistributorsDetail_en_ZA", "BrandPage_Live"."DistributorsDetail_en_IN", CASE COALESCE(CAST("BrandPage_Live"."ShowDistributors_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."ShowDistributors" WHEN '0' THEN "BrandPage_Live"."ShowDistributors" ELSE "BrandPage_Live"."ShowDistributors_en_US" END AS "ShowDistributors_en_US", "BrandPage_Live"."ShowDistributors_en_CA", "BrandPage_Live"."ShowDistributors_pt_BR", "BrandPage_Live"."ShowDistributors_es_ES", "BrandPage_Live"."ShowDistributors_es_CL", "BrandPage_Live"."ShowDistributors_en_GB", "BrandPage_Live"."ShowDistributors_en_AU", "BrandPage_Live"."ShowDistributors_en_ZA", "BrandPage_Live"."ShowDistributors_en_IN", CASE COALESCE(CAST("BrandPage_Live"."ResourceCenterImageID_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."ResourceCenterImageID" WHEN '0' THEN "BrandPage_Live"."ResourceCenterImageID" ELSE "BrandPage_Live"."ResourceCenterImageID_en_US" END AS "ResourceCenterImageID_en_US", "BrandPage_Live"."ResourceCenterImageID_en_CA", "BrandPage_Live"."ResourceCenterImageID_pt_BR", "BrandPage_Live"."ResourceCenterImageID_es_ES", "BrandPage_Live"."ResourceCenterImageID_es_CL", "BrandPage_Live"."ResourceCenterImageID_en_GB", "BrandPage_Live"."ResourceCenterImageID_en_AU", "BrandPage_Live"."ResourceCenterImageID_en_ZA", "BrandPage_Live"."ResourceCenterImageID_en_IN", CASE COALESCE(CAST("BrandPage_Live"."WhatsNewImageID_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."WhatsNewImageID" WHEN '0' THEN "BrandPage_Live"."WhatsNewImageID" ELSE "BrandPage_Live"."WhatsNewImageID_en_US" END AS "WhatsNewImageID_en_US", "BrandPage_Live"."WhatsNewImageID_en_CA", "BrandPage_Live"."WhatsNewImageID_pt_BR", "BrandPage_Live"."WhatsNewImageID_es_ES", "BrandPage_Live"."WhatsNewImageID_es_CL", "BrandPage_Live"."WhatsNewImageID_en_GB", "BrandPage_Live"."WhatsNewImageID_en_AU", "BrandPage_Live"."WhatsNewImageID_en_ZA", "BrandPage_Live"."WhatsNewImageID_en_IN", "BrandPage_Live"."LogoID", "BrandPage_Live"."SimpleLogoID", CASE COALESCE(CAST("BrandPage_Live"."ResourceCenterImageID_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."ResourceCenterImageID" WHEN '0' THEN "BrandPage_Live"."ResourceCenterImageID" ELSE "BrandPage_Live"."ResourceCenterImageID_en_US" END AS "ResourceCenterImageID", CASE COALESCE(CAST("BrandPage_Live"."WhatsNewImageID_en_US" AS CHAR), '') WHEN '' THEN "BrandPage_Live"."WhatsNewImageID" WHEN '0' THEN "BrandPage_Live"."WhatsNewImageID" ELSE "BrandPage_Live"."WhatsNewImageID_en_US" END AS "WhatsNewImageID", "BrandPage_Live"."TagID", "BrandPage_Live"."DistributorsBlocksID", "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 "BrandPage_Live" ON "BrandPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0036s

0033: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0034: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0035: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0036: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0037: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0038: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE COALESCE(CAST("BrandsBlock_Live"."BottomContent_en_US" AS CHAR), '') WHEN '' THEN "BrandsBlock_Live"."BottomContent" WHEN '0' THEN "BrandsBlock_Live"."BottomContent" ELSE "BrandsBlock_Live"."BottomContent_en_US" END AS "BottomContent", CASE COALESCE(CAST("BrandsBlock_Live"."BottomContent_en_US" AS CHAR), '') WHEN '' THEN "BrandsBlock_Live"."BottomContent" WHEN '0' THEN "BrandsBlock_Live"."BottomContent" ELSE "BrandsBlock_Live"."BottomContent_en_US" END AS "BottomContent_en_US", "BrandsBlock_Live"."BottomContent_en_CA", "BrandsBlock_Live"."BottomContent_pt_BR", "BrandsBlock_Live"."BottomContent_es_ES", "BrandsBlock_Live"."BottomContent_es_CL", "BrandsBlock_Live"."BottomContent_en_GB", "BrandsBlock_Live"."BottomContent_en_AU", "BrandsBlock_Live"."BottomContent_en_ZA", "BrandsBlock_Live"."BottomContent_en_IN", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "BrandsBlock_Live" ON "BrandsBlock_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) AND ("Element_Live"."LocaleFilter_en_US" = 1) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0007s

0039: SELECT DISTINCT "PortalItem_Live"."ClassName", "PortalItem_Live"."LastEdited", "PortalItem_Live"."Created", "PortalItem_Live"."Version", CASE COALESCE(CAST("PortalItem_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "PortalItem_Live"."Title" WHEN '0' THEN "PortalItem_Live"."Title" ELSE "PortalItem_Live"."Title_en_US" END AS "Title", "PortalItem_Live"."Sort", CASE COALESCE(CAST("PortalItem_Live"."LinkedPageText_en_US" AS CHAR), '') WHEN '' THEN "PortalItem_Live"."LinkedPageText" WHEN '0' THEN "PortalItem_Live"."LinkedPageText" ELSE "PortalItem_Live"."LinkedPageText_en_US" END AS "LinkedPageText", CASE COALESCE(CAST("PortalItem_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "PortalItem_Live"."Title" WHEN '0' THEN "PortalItem_Live"."Title" ELSE "PortalItem_Live"."Title_en_US" END AS "Title_en_US", "PortalItem_Live"."Title_en_CA", "PortalItem_Live"."Title_pt_BR", "PortalItem_Live"."Title_es_ES", "PortalItem_Live"."Title_es_CL", "PortalItem_Live"."Title_en_GB", "PortalItem_Live"."Title_en_AU", "PortalItem_Live"."Title_en_ZA", "PortalItem_Live"."Title_en_IN", CASE COALESCE(CAST("PortalItem_Live"."LinkedPageText_en_US" AS CHAR), '') WHEN '' THEN "PortalItem_Live"."LinkedPageText" WHEN '0' THEN "PortalItem_Live"."LinkedPageText" ELSE "PortalItem_Live"."LinkedPageText_en_US" END AS "LinkedPageText_en_US", "PortalItem_Live"."LinkedPageText_en_CA", "PortalItem_Live"."LinkedPageText_pt_BR", "PortalItem_Live"."LinkedPageText_es_ES", "PortalItem_Live"."LinkedPageText_es_CL", "PortalItem_Live"."LinkedPageText_en_GB", "PortalItem_Live"."LinkedPageText_en_AU", "PortalItem_Live"."LinkedPageText_en_ZA", "PortalItem_Live"."LinkedPageText_en_IN", "PortalItem_Live"."ParentID", "PortalItem_Live"."LinkedPageID", "PortalItem_Live"."BackgroundImageID", "PortalItem_Live"."ID", CASE WHEN "PortalItem_Live"."ClassName" IS NOT NULL THEN "PortalItem_Live"."ClassName" ELSE 'Aviagen\\Web\\Blocks\\PortalItem' END AS "RecordClassName" FROM "PortalItem_Live" WHERE ("PortalItem_Live"."ParentID" = ?) ORDER BY "PortalItem_Live"."Sort" ASC 0.0014s

0040: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0043: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0044: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0011s

0046: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0047: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

0048: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0011s

0049: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0007s

0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0011s

0051: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0053: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "NewsPage_Live" ON "NewsPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) LIMIT 3)) 0.0012s

0054: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "NewsPage_Live"."PublishDate", "NewsPage_Live"."ExpiryDate", "NewsPage_Live"."Date", CASE COALESCE(CAST("NewsPage_Live"."Teaser_en_US" AS CHAR), '') WHEN '' THEN "NewsPage_Live"."Teaser" WHEN '0' THEN "NewsPage_Live"."Teaser" ELSE "NewsPage_Live"."Teaser_en_US" END AS "Teaser", CASE COALESCE(CAST("NewsPage_Live"."Teaser_en_US" AS CHAR), '') WHEN '' THEN "NewsPage_Live"."Teaser" WHEN '0' THEN "NewsPage_Live"."Teaser" ELSE "NewsPage_Live"."Teaser_en_US" END AS "Teaser_en_US", "NewsPage_Live"."Teaser_en_CA", "NewsPage_Live"."Teaser_pt_BR", "NewsPage_Live"."Teaser_es_ES", "NewsPage_Live"."Teaser_es_CL", "NewsPage_Live"."Teaser_en_GB", "NewsPage_Live"."Teaser_en_AU", "NewsPage_Live"."Teaser_en_ZA", "NewsPage_Live"."Teaser_en_IN", "NewsPage_Live"."ImageID", "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 "NewsPage_Live" ON "NewsPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "NewsPage_Live"."Date" DESC LIMIT 3 0.0085s

0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0056: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0057: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0058: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0059: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", CASE COALESCE(CAST("PeerReviewedArticlesPage_Live"."IntroText_en_US" AS CHAR), '') WHEN '' THEN "PeerReviewedArticlesPage_Live"."IntroText" WHEN '0' THEN "PeerReviewedArticlesPage_Live"."IntroText" ELSE "PeerReviewedArticlesPage_Live"."IntroText_en_US" END AS "IntroText", CASE COALESCE(CAST("PeerReviewedArticlesPage_Live"."IntroText_en_US" AS CHAR), '') WHEN '' THEN "PeerReviewedArticlesPage_Live"."IntroText" WHEN '0' THEN "PeerReviewedArticlesPage_Live"."IntroText" ELSE "PeerReviewedArticlesPage_Live"."IntroText_en_US" END AS "IntroText_en_US", "PeerReviewedArticlesPage_Live"."IntroText_en_CA", "PeerReviewedArticlesPage_Live"."IntroText_pt_BR", "PeerReviewedArticlesPage_Live"."IntroText_es_ES", "PeerReviewedArticlesPage_Live"."IntroText_es_CL", "PeerReviewedArticlesPage_Live"."IntroText_en_GB", "PeerReviewedArticlesPage_Live"."IntroText_en_AU", "PeerReviewedArticlesPage_Live"."IntroText_en_ZA", "PeerReviewedArticlesPage_Live"."IntroText_en_IN", "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 "PeerReviewedArticlesPage_Live" ON "PeerReviewedArticlesPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0022s

0060: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "ArticleResource" WHERE ("ArticleResource"."PeerReviewedArticlesPageID" = ?) LIMIT 3)) 0.0005s

0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", CASE COALESCE(CAST("PeerReviewedArticlesPage_Live"."IntroText_en_US" AS CHAR), '') WHEN '' THEN "PeerReviewedArticlesPage_Live"."IntroText" WHEN '0' THEN "PeerReviewedArticlesPage_Live"."IntroText" ELSE "PeerReviewedArticlesPage_Live"."IntroText_en_US" END AS "IntroText", CASE COALESCE(CAST("PeerReviewedArticlesPage_Live"."IntroText_en_US" AS CHAR), '') WHEN '' THEN "PeerReviewedArticlesPage_Live"."IntroText" WHEN '0' THEN "PeerReviewedArticlesPage_Live"."IntroText" ELSE "PeerReviewedArticlesPage_Live"."IntroText_en_US" END AS "IntroText_en_US", "PeerReviewedArticlesPage_Live"."IntroText_en_CA", "PeerReviewedArticlesPage_Live"."IntroText_pt_BR", "PeerReviewedArticlesPage_Live"."IntroText_es_ES", "PeerReviewedArticlesPage_Live"."IntroText_es_CL", "PeerReviewedArticlesPage_Live"."IntroText_en_GB", "PeerReviewedArticlesPage_Live"."IntroText_en_AU", "PeerReviewedArticlesPage_Live"."IntroText_en_ZA", "PeerReviewedArticlesPage_Live"."IntroText_en_IN", "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 "PeerReviewedArticlesPage_Live" ON "PeerReviewedArticlesPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0024s

0062: SELECT DISTINCT "ArticleResource"."ClassName", "ArticleResource"."LastEdited", "ArticleResource"."Created", "ArticleResource"."Name", "ArticleResource"."PublicationAuthor", "ArticleResource"."Description", "ArticleResource"."Date", "ArticleResource"."AttachmentID", "ArticleResource"."NewsletterPageID", "ArticleResource"."BroilerEconomicsPageID", "ArticleResource"."PeerReviewedArticlesPageID", "ArticleResource"."ImageID", "ArticleResource"."ID", CASE WHEN "ArticleResource"."ClassName" IS NOT NULL THEN "ArticleResource"."ClassName" ELSE 'Aviagen\\Web\\Models\\ArticleResource' END AS "RecordClassName" FROM "ArticleResource" WHERE ("ArticleResource"."PeerReviewedArticlesPageID" = ?) ORDER BY "ArticleResource"."Date" DESC LIMIT 1 0.001s

0063: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0064: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0065: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VideoPage_Live" ON "VideoPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) LIMIT 2)) 0.0009s

0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "VideoPage_Live"."Date", "VideoPage_Live"."VideoType", CASE COALESCE(CAST("VideoPage_Live"."YouTubeID_en_US" AS CHAR), '') WHEN '' THEN "VideoPage_Live"."YouTubeID" WHEN '0' THEN "VideoPage_Live"."YouTubeID" ELSE "VideoPage_Live"."YouTubeID_en_US" END AS "YouTubeID", CASE COALESCE(CAST("VideoPage_Live"."VimeoID_en_US" AS CHAR), '') WHEN '' THEN "VideoPage_Live"."VimeoID" WHEN '0' THEN "VideoPage_Live"."VimeoID" ELSE "VideoPage_Live"."VimeoID_en_US" END AS "VimeoID", CASE COALESCE(CAST("VideoPage_Live"."YouTubeID_en_US" AS CHAR), '') WHEN '' THEN "VideoPage_Live"."YouTubeID" WHEN '0' THEN "VideoPage_Live"."YouTubeID" ELSE "VideoPage_Live"."YouTubeID_en_US" END AS "YouTubeID_en_US", "VideoPage_Live"."YouTubeID_en_CA", "VideoPage_Live"."YouTubeID_pt_BR", "VideoPage_Live"."YouTubeID_es_ES", "VideoPage_Live"."YouTubeID_es_CL", "VideoPage_Live"."YouTubeID_en_GB", "VideoPage_Live"."YouTubeID_en_AU", "VideoPage_Live"."YouTubeID_en_ZA", "VideoPage_Live"."YouTubeID_en_IN", CASE COALESCE(CAST("VideoPage_Live"."VimeoID_en_US" AS CHAR), '') WHEN '' THEN "VideoPage_Live"."VimeoID" WHEN '0' THEN "VideoPage_Live"."VimeoID" ELSE "VideoPage_Live"."VimeoID_en_US" END AS "VimeoID_en_US", "VideoPage_Live"."VimeoID_en_CA", "VideoPage_Live"."VimeoID_pt_BR", "VideoPage_Live"."VimeoID_es_ES", "VideoPage_Live"."VimeoID_es_CL", "VideoPage_Live"."VimeoID_en_GB", "VideoPage_Live"."VimeoID_en_AU", "VideoPage_Live"."VimeoID_en_ZA", "VideoPage_Live"."VimeoID_en_IN", "VideoPage_Live"."ImageID", "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 "VideoPage_Live" ON "VideoPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "VideoPage_Live"."Date" DESC LIMIT 1 0.0029s

0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0068: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0070: SELECT 1 AS "1" WHERE (EXISTS (SELECT * FROM "ArticleResource" WHERE ("ArticleResource"."BroilerEconomicsPageID" = ?) LIMIT 3)) 0.0005s

0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0072: SELECT DISTINCT "ArticleResource"."ClassName", "ArticleResource"."LastEdited", "ArticleResource"."Created", "ArticleResource"."Name", "ArticleResource"."PublicationAuthor", "ArticleResource"."Description", "ArticleResource"."Date", "ArticleResource"."AttachmentID", "ArticleResource"."NewsletterPageID", "ArticleResource"."BroilerEconomicsPageID", "ArticleResource"."PeerReviewedArticlesPageID", "ArticleResource"."ImageID", "ArticleResource"."ID", CASE WHEN "ArticleResource"."ClassName" IS NOT NULL THEN "ArticleResource"."ClassName" ELSE 'Aviagen\\Web\\Models\\ArticleResource' END AS "RecordClassName" FROM "ArticleResource" WHERE ("ArticleResource"."BroilerEconomicsPageID" = ?) ORDER BY "ArticleResource"."Date" DESC LIMIT 1 0.0006s

0073: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0074: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0075: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0076: SELECT DISTINCT "Language"."ClassName", "Language"."LastEdited", "Language"."Created", "Language"."SortOrder", "Language"."Title", "Language"."FullSite", "Language"."LanguageCode", "Language"."LanguageLabel", "Language"."TopContent", "Language"."TechDocsHeader", "Language"."ResourceCenterContent", "Language"."SearchFormText", "Language"."LeftColumnHeader", "Language"."RightColumnHeader", "Language"."ContactLabel", "Language"."ContactText", "Language"."DivisionTitle", "Language"."ContactName", "Language"."AddressLabel", "Language"."Address", "Language"."TelephoneLabel", "Language"."Telephone", "Language"."FaxLabel", "Language"."Fax", "Language"."MediaInquiry", "Language"."MediaInquiryLabel", "Language"."EmailLabel", "Language"."Email", "Language"."ShowAllText", "Language"."NoResources", "Language"."AdobeText", "Language"."TechDocSearchFormKeywordsPlaceholder", "Language"."TechDocSearchFormSubjectPlaceholder", "Language"."TechDocSearchFormTypePlaceholder", "Language"."TechDocSearchFormGenerationPlaceholder", "Language"."TechDocSearchFormBrandPlaceholder", "Language"."TechDocSearchFormAction", "Language"."BackButtonText", "Language"."SortByText", "Language"."DateText", "Language"."LanguageText", "Language"."ShowWhatsNew", "Language"."WhatsNewText", "Language"."EnglishSurrogate", "Language"."HideFromPublic", "Language"."RegionID", "Language"."ID", CASE WHEN "Language"."ClassName" IS NOT NULL THEN "Language"."ClassName" ELSE 'Aviagen\\Web\\Models\\Language' END AS "RecordClassName" FROM "Language" WHERE ("Language"."LanguageCode" = ?) AND (HideFromPublic != 1) ORDER BY "Language"."SortOrder" ASC LIMIT 1 0.0011s

0077: SELECT DISTINCT "FooterLink"."ClassName", "FooterLink"."LastEdited", "FooterLink"."Created", "FooterLink"."SortOrder", "FooterLink"."Position", "FooterLink"."Type", "FooterLink"."Label", "FooterLink"."PageID", "FooterLink"."FileID", "FooterLink"."ID", CASE WHEN "FooterLink"."ClassName" IS NOT NULL THEN "FooterLink"."ClassName" ELSE 'Aviagen\\Web\\Models\\FooterLink' END AS "RecordClassName" FROM "FooterLink" ORDER BY "FooterLink"."SortOrder" ASC 0.0007s

0078: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

0079: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0080: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."IsFolder", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" WHERE ("File_Live"."ID" = ?) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0081: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0082: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0083: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0085: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "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 "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0087: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0019s

0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."ParentID", "Page_Live"."BrandStyle", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav", "Page_Live"."PageTheme", "Page_Live"."HasSimpleHeader", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_US" END AS "AddToMainNav_en_US", "Page_Live"."AddToMainNav_en_CA", "Page_Live"."AddToMainNav_pt_BR", "Page_Live"."AddToMainNav_es_ES", "Page_Live"."AddToMainNav_es_CL", "Page_Live"."AddToMainNav_en_GB", "Page_Live"."AddToMainNav_en_AU", "Page_Live"."AddToMainNav_en_ZA", "Page_Live"."AddToMainNav_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID_en_US", "Page_Live"."SideImageID_en_CA", "Page_Live"."SideImageID_pt_BR", "Page_Live"."SideImageID_es_ES", "Page_Live"."SideImageID_es_CL", "Page_Live"."SideImageID_en_GB", "Page_Live"."SideImageID_en_AU", "Page_Live"."SideImageID_en_ZA", "Page_Live"."SideImageID_en_IN", CASE COALESCE(CAST("Page_Live"."SideImageID_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_US" END AS "SideImageID", "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" WHERE ("SiteTree_Live"."ClassName" IN (?)) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0089: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0006s

0090: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0091: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0092: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", CASE COALESCE(CAST("SiteTree"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."Title" WHEN '0' THEN "SiteTree"."Title" ELSE "SiteTree"."Title_en_US" END AS "Title_en_US", "SiteTree"."Title_en_CA", "SiteTree"."Title_pt_BR", "SiteTree"."Title_es_ES", "SiteTree"."Title_es_CL", "SiteTree"."Title_en_GB", "SiteTree"."Title_en_AU", "SiteTree"."Title_en_ZA", "SiteTree"."Title_en_IN", CASE COALESCE(CAST("SiteTree"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."MenuTitle" WHEN '0' THEN "SiteTree"."MenuTitle" ELSE "SiteTree"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree"."MenuTitle_en_CA", "SiteTree"."MenuTitle_pt_BR", "SiteTree"."MenuTitle_es_ES", "SiteTree"."MenuTitle_es_CL", "SiteTree"."MenuTitle_en_GB", "SiteTree"."MenuTitle_en_AU", "SiteTree"."MenuTitle_en_ZA", "SiteTree"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."Content" WHEN '0' THEN "SiteTree"."Content" ELSE "SiteTree"."Content_en_US" END AS "Content_en_US", "SiteTree"."Content_en_CA", "SiteTree"."Content_pt_BR", "SiteTree"."Content_es_ES", "SiteTree"."Content_es_CL", "SiteTree"."Content_en_GB", "SiteTree"."Content_en_AU", "SiteTree"."Content_en_ZA", "SiteTree"."Content_en_IN", "SiteTree"."LocaleFilter_en_US", "SiteTree"."LocaleFilter_en_CA", "SiteTree"."LocaleFilter_pt_BR", "SiteTree"."LocaleFilter_es_ES", "SiteTree"."LocaleFilter_es_CL", "SiteTree"."LocaleFilter_en_GB", "SiteTree"."LocaleFilter_en_AU", "SiteTree"."LocaleFilter_en_ZA", "SiteTree"."LocaleFilter_en_IN", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE COALESCE(CAST("SiteTree"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."Title" WHEN '0' THEN "SiteTree"."Title" ELSE "SiteTree"."Title_en_US" END AS "Title", "SiteTree"."URLSegment", CASE COALESCE(CAST("SiteTree"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."MenuTitle" WHEN '0' THEN "SiteTree"."MenuTitle" ELSE "SiteTree"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree"."Content" WHEN '0' THEN "SiteTree"."Content" ELSE "SiteTree"."Content_en_US" END AS "Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "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" = ?) AND ("SiteTree"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0009s

0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title_en_US", "SiteTree_Live"."Title_en_CA", "SiteTree_Live"."Title_pt_BR", "SiteTree_Live"."Title_es_ES", "SiteTree_Live"."Title_es_CL", "SiteTree_Live"."Title_en_GB", "SiteTree_Live"."Title_en_AU", "SiteTree_Live"."Title_en_ZA", "SiteTree_Live"."Title_en_IN", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle_en_US", "SiteTree_Live"."MenuTitle_en_CA", "SiteTree_Live"."MenuTitle_pt_BR", "SiteTree_Live"."MenuTitle_es_ES", "SiteTree_Live"."MenuTitle_es_CL", "SiteTree_Live"."MenuTitle_en_GB", "SiteTree_Live"."MenuTitle_en_AU", "SiteTree_Live"."MenuTitle_en_ZA", "SiteTree_Live"."MenuTitle_en_IN", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "Content_en_US", "SiteTree_Live"."Content_en_CA", "SiteTree_Live"."Content_pt_BR", "SiteTree_Live"."Content_es_ES", "SiteTree_Live"."Content_es_CL", "SiteTree_Live"."Content_en_GB", "SiteTree_Live"."Content_en_AU", "SiteTree_Live"."Content_en_ZA", "SiteTree_Live"."Content_en_IN", "SiteTree_Live"."LocaleFilter_en_US", "SiteTree_Live"."LocaleFilter_en_CA", "SiteTree_Live"."LocaleFilter_pt_BR", "SiteTree_Live"."LocaleFilter_es_ES", "SiteTree_Live"."LocaleFilter_es_CL", "SiteTree_Live"."LocaleFilter_en_GB", "SiteTree_Live"."LocaleFilter_en_AU", "SiteTree_Live"."LocaleFilter_en_ZA", "SiteTree_Live"."LocaleFilter_en_IN", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE COALESCE(CAST("SiteTree_Live"."Title_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_US" END AS "Title", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_US" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_US" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_US" END AS "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"."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" = ?) AND ("SiteTree_Live"."LocaleFilter_en_US" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

Aviagen
  • Aviagen
  • Languages Languages
  • Careers

Leaving Aviagen.com

You are leaving Aviagen.com and connecting to AviagenCareers.com.

Continue
  • About
  • Brands
  • Info Center
  • Newsroom
  • Contact
  • Chicken Breeding Explained

About

Corporate

  • About Aviagen – Breeding Success Together
  • Mission, Vision & Values
  • Research & Development – Breeding for Innovation
  • Leadership

Security of Supply

  • Health & Biosecurity
  • Breeding for Security of Supply
  • Compartmentalization

Welfare & Sustainability

  • Breeding for Welfare
  • Breeding for Sustainability

Customer Engagement

  • Breeding for Customer Success
  • Aviagen Production Management School
  • EMEAA Production Management School

Newsroom

  • News
  • Feature Focus
  • Peer-Reviewed Articles
  • Broiler Economics
  • Videos

Chicken Breeding Explained

  • Chicken Breeding Explained
  • Poultry Industry Insights
  • Explainer Videos
  • FAQs
  • Glossary
  • Aviagen
  • About

    Corporate

    • About Aviagen – Breeding Success Together
    • Mission, Vision & Values
    • Research & Development – Breeding for Innovation
    • Leadership

    Security of Supply

    • Health & Biosecurity
    • Breeding for Security of Supply
    • Compartmentalization

    Welfare & Sustainability

    • Breeding for Welfare
    • Breeding for Sustainability

    Customer Engagement

    • Breeding for Customer Success
    • Aviagen Production Management School
    • EMEAA Production Management School
  • Brands
  • Info Center
  • Newsroom
    • News
    • Feature Focus
    • Peer-Reviewed Articles
    • Broiler Economics
    • Videos
  • Contact
  • Chicken Breeding Explained
    • Chicken Breeding Explained
    • Poultry Industry Insights
    • Explainer Videos
    • FAQs
    • Glossary

Aviagen® stands at the forefront of poultry genetics, pioneering research, and innovation on a global scale. Our broiler breeder brands are among the most recognized and respected in the industry and each has a proven record of success in addition to a large and loyal global customer base.

About Aviagen "Link to About Aviagen – Breeding Success Together

Our Brands

Arbor Acres
Indian River
Ross
Rowan Range
Specialty Males

Careers that help feed the world

Feature Focus Link to Driving sustainability in the poultry sector

Info Center

Learn More Link to Info Center

Aviagen Brands

Brands in Your Region Link to Brands

Research & Development

Read More Link to Research & Development – Breeding for Innovation

Out Now – 2024 Sustainability Report

Read More Link to Breeding for Sustainability

Newest Releases

Antonin Bonneau Appointed as President of Aviagen Asia to Drive Strategic Growth

Antonin Bonneau Appointed as President of Aviagen Asia to Drive Strategic Growth

Aviagen Appoints Clara Goldman as Global Director of Export, Logistics & Trade Compliance

Aviagen Appoints Clara Goldman as Global Director of Export, Logistics & Trade Compliance

Aviagen to create $40mn poultry cluster in Uzbekistan

Aviagen to create $40mn poultry cluster in Uzbekistan

Genetic parameters of gait score in purebred broiler lines

Genetic parameters of gait score in purebred broiler lines

Poultry Science; Dagmar Kapell, et al.

Aviagen Global Export Overview

Aviagen Global Export Overview

Broiler Economics: War and Peace, April 2026

Broiler Economics: War and Peace, April 2026

See More News
  • Contact
  • Aviagen Group's Global Privacy Notice
  • Terms of Service
  • Legal Statements and Disclaimers
  • Notice to New Vendors
  • Aviagen Group UK Tax Strategy
  • Aviagen Turkeys
  • Site Map
Languages
Your Privacy Choices California Consumer Privacy Act (CCPA) Opt-Out Icon
Aviagen only uses email addresses ending in @aviagen.com.

© 1998 - 2026 Aviagen Group | Site by McComm

View draft Edit in CMS Log in

Developer tools

  • Dev mode on
  • Flush caches
  • Build database
  • Dev menu

Debugging

  • Show template
  • Show metrics
  • Debug page
  • Debug request
  • Debug failover
  • Show queries
  • Preview write