0001: SET sql_mode = ? 0.0006s

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

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0053s

0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."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_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

0005: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."LocaleFilter_en_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0009s

0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ParentID" = ?) AND ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."LocaleFilter_en_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."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_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."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_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0007s

0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."AllowedLanguageIPs", CASE COALESCE(CAST("SiteConfig"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteConfig"."Title" WHEN '0' THEN "SiteConfig"."Title" ELSE "SiteConfig"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteConfig"."Tagline_en_ZA" AS CHAR), '') WHEN '' THEN "SiteConfig"."Tagline" WHEN '0' THEN "SiteConfig"."Tagline" ELSE "SiteConfig"."Tagline_en_ZA" 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"."CMSLogoID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0004s

0010: 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.0007s

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.0007s

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.0007s

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.0007s

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.0007s

0015: SELECT DISTINCT "Region"."ClassName", "Region"."LastEdited", "Region"."Created", "Region"."SortOrder", CASE COALESCE(CAST("Region"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "Region"."Title" WHEN '0' THEN "Region"."Title" ELSE "Region"."Title_en_ZA" END AS "Title", "Region"."Locale", CASE COALESCE(CAST("Region"."Title_en_US" AS CHAR), '') WHEN '' THEN "Region"."Title" WHEN '0' THEN "Region"."Title" ELSE "Region"."Title_en_US" END AS "Title_en_US", "Region"."Title_en_CA", "Region"."Title_pt_BR", "Region"."Title_es_ES", "Region"."Title_es_CL", "Region"."Title_en_GB", "Region"."Title_en_AU", "Region"."Title_en_ZA", "Region"."Title_en_IN", "Region"."EnglishVariantID", "Region"."ID", CASE WHEN "Region"."ClassName" IS NOT NULL THEN "Region"."ClassName" ELSE 'Aviagen\\Web\\Models\\Region' END AS "RecordClassName" FROM "Region" WHERE ("Region"."ID" = ?) ORDER BY "Region"."SortOrder" ASC LIMIT 1 0.0004s

0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."ParentID", "Page_Live"."BrandStyle", CASE COALESCE(CAST("Page_Live"."BottomContent_en_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."BottomContent" WHEN '0' THEN "Page_Live"."BottomContent" ELSE "Page_Live"."BottomContent_en_ZA" END AS "BottomContent", "Page_Live"."Template", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_ZA" END AS "AddToMainNav", CASE COALESCE(CAST("Page_Live"."BottomContent_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."BottomContent" WHEN '0' THEN "Page_Live"."BottomContent" ELSE "Page_Live"."BottomContent_en_US" END AS "BottomContent_en_US", "Page_Live"."BottomContent_en_CA", "Page_Live"."BottomContent_pt_BR", "Page_Live"."BottomContent_es_ES", "Page_Live"."BottomContent_es_CL", "Page_Live"."BottomContent_en_GB", "Page_Live"."BottomContent_en_AU", "Page_Live"."BottomContent_en_ZA", "Page_Live"."BottomContent_en_IN", 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_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_ZA" 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_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0025s

0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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", "SiteTree_Live"."URLSegment", CASE COALESCE(CAST("SiteTree_Live"."Title_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Title" WHEN '0' THEN "SiteTree_Live"."Title" ELSE "SiteTree_Live"."Title_en_ZA" END AS "Title", CASE COALESCE(CAST("SiteTree_Live"."MenuTitle_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."MenuTitle" WHEN '0' THEN "SiteTree_Live"."MenuTitle" ELSE "SiteTree_Live"."MenuTitle_en_ZA" END AS "MenuTitle", CASE COALESCE(CAST("SiteTree_Live"."Content_en_ZA" AS CHAR), '') WHEN '' THEN "SiteTree_Live"."Content" WHEN '0' THEN "SiteTree_Live"."Content" ELSE "SiteTree_Live"."Content_en_ZA" 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", 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"."ParentID", "Page_Live"."BrandStyle", CASE COALESCE(CAST("Page_Live"."BottomContent_en_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."BottomContent" WHEN '0' THEN "Page_Live"."BottomContent" ELSE "Page_Live"."BottomContent_en_ZA" END AS "BottomContent", "Page_Live"."Template", "Page_Live"."ShowSearch", "Page_Live"."ShowWhatsNew", "Page_Live"."BlockStyle", CASE COALESCE(CAST("Page_Live"."AddToMainNav_en_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."AddToMainNav" WHEN '0' THEN "Page_Live"."AddToMainNav" ELSE "Page_Live"."AddToMainNav_en_ZA" END AS "AddToMainNav", CASE COALESCE(CAST("Page_Live"."BottomContent_en_US" AS CHAR), '') WHEN '' THEN "Page_Live"."BottomContent" WHEN '0' THEN "Page_Live"."BottomContent" ELSE "Page_Live"."BottomContent_en_US" END AS "BottomContent_en_US", "Page_Live"."BottomContent_en_CA", "Page_Live"."BottomContent_pt_BR", "Page_Live"."BottomContent_es_ES", "Page_Live"."BottomContent_es_CL", "Page_Live"."BottomContent_en_GB", "Page_Live"."BottomContent_en_AU", "Page_Live"."BottomContent_en_ZA", "Page_Live"."BottomContent_en_IN", 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_ZA" AS CHAR), '') WHEN '' THEN "Page_Live"."SideImageID" WHEN '0' THEN "Page_Live"."SideImageID" ELSE "Page_Live"."SideImageID_en_ZA" 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_ZA" = 1) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s

0018: 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.0007s

0019: 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.0007s

GET /tmea/news-room/local-news/ross-middle-east-and-africa-association-takes-place-in-dubai/?showqueries=1

[User Warning] None of the following templates could be found: Array ( [0] => Array ( [type] => Includes [0] => UtilityNav ) [1] => UtilityNav ) in themes "Array ( [0] => $public [1] => $default ) "

GET /tmea/news-room/local-news/ross-middle-east-and-africa-association-takes-place-in-dubai/?showqueries=1

Line 215 in /var/www/staging.aviagen.com/vendor/silverstripe/framework/src/View/SSViewer.php

Source

206             $message .= print_r($templates, true);
207 
208             $themes = self::get_themes();
209             if (!$themes) {
210                 $message .= ' (no theme in use)';
211             } else {
212                 $message .= ' in themes "' . print_r($themes, true) . '"';
213             }
214 
215             user_error($message ?? '', E_USER_WARNING);
216         }
217     }
218 
219     /**
220      * Triggered early in the request when someone requests a flush.
221      */

Trace

GET /tmea/news-room/local-news/ross-middle-east-and-africa-association-takes-place-in-dubai/?showqueries=1

[Emergency] Uncaught ValueError: Path cannot be empty

GET /tmea/news-room/local-news/ross-middle-east-and-africa-association-takes-place-in-dubai/?showqueries=1

Line 642 in /var/www/staging.aviagen.com/vendor/silverstripe/framework/src/View/SSViewer.php

Source

633         SSViewer::$topLevel[] = $item;
634 
635         $template = $this->chosen;
636 
637         $cacheFile = TEMP_PATH . DIRECTORY_SEPARATOR . '.cache'
638             . str_replace(['\\','/',':'], '.', Director::makeRelative(realpath($template ?? '')) ?? '');
639         $lastEdited = filemtime($template ?? '');
640 
641         if (!file_exists($cacheFile ?? '') || filemtime($cacheFile ?? '') < $lastEdited) {
642             $content = file_get_contents($template ?? '');
643             $content = $this->parseTemplateContent($content, $template);
644 
645             $fh = fopen($cacheFile ?? '', 'w');
646             fwrite($fh, $content ?? '');
647             fclose($fh);
648         }

Trace