0002: SHOW DATABASES LIKE 'SS\_wearebvhm\_dev'
0.0003s
0003: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0002s
0004: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0003s
0005: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0018s
0006: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0007: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
WHERE ("Fluent_Locale"."ID" = ?)
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
LIMIT 1
0.0003s
0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE (COALESCE("SiteTree_Localised_es_419"."URLSegment", "SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0015s
0009: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."LinuxRebootNotificationEmailCSV", "SiteConfig"."PrimaryColor", "SiteConfig"."SecondaryColor", "SiteConfig"."SuccessColor", "SiteConfig"."DangerColor", "SiteConfig"."WarningColor", "SiteConfig"."InfoColor", "SiteConfig"."LightColor", "SiteConfig"."DarkColor", "SiteConfig"."NavbarBg", "SiteConfig"."NavbarBgPattern", "SiteConfig"."BodyFont", "SiteConfig"."HeadlineFont", "SiteConfig"."MonospaceFont", CASE
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Footer"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Footer"
ELSE "SiteConfig"."Footer" END
AS "Footer", "SiteConfig"."FooterBg", "SiteConfig"."FooterBgPattern", "SiteConfig"."DefaultBg", "SiteConfig"."DefaultBgPattern", "SiteConfig"."CustomCSS", CASE
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Title"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Title"
ELSE "SiteConfig"."Title" END
AS "Title", CASE
WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN "SiteConfig_Localised_es_419"."Tagline"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."Tagline"
ELSE "SiteConfig"."Tagline" END
AS "Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."LogoID", "SiteConfig"."FaviconSmallID", "SiteConfig"."FaviconLargeID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "SiteConfig_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteConfig" LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_es_419" ON "SiteConfig"."ID" = "SiteConfig_Localised_es_419"."RecordID" AND "SiteConfig_Localised_es_419"."Locale" = ? LEFT JOIN "SiteConfig_Localised" AS "SiteConfig_Localised_en_US" ON "SiteConfig"."ID" = "SiteConfig_Localised_en_US"."RecordID" AND "SiteConfig_Localised_en_US"."Locale" = ?
LIMIT 1
0.001s
0010: SELECT DISTINCT count(DISTINCT "Alert_Live"."ID") AS "Count"
FROM "Alert_Live" INNER JOIN "Page_Alerts" ON "Page_Alerts"."AlertID" = "Alert_Live"."ID" LEFT JOIN "Alert_Localised_Live" AS "Alert_Localised_es_419" ON "Alert_Live"."ID" = "Alert_Localised_es_419"."RecordID" AND "Alert_Localised_es_419"."Locale" = ? LEFT JOIN "Alert_Localised_Live" AS "Alert_Localised_en_US" ON "Alert_Live"."ID" = "Alert_Localised_en_US"."RecordID" AND "Alert_Localised_en_US"."Locale" = ?
WHERE ("Page_Alerts"."PageID" = ?)
AND ("Alert_Live"."Active" = ?)
AND (("Alert_Localised_es_419"."ID" IS NOT NULL) OR ("Alert_Localised_en_US"."ID" IS NOT NULL))
0.0005s
0011: 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"."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.0004s
0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0014s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0015s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0009s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0011s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0009s
0018: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", CASE
WHEN "RedirectorPage_Localised_es_419"."ID" IS NOT NULL THEN "RedirectorPage_Localised_es_419"."ExternalURL"
WHEN "RedirectorPage_Localised_en_US"."ID" IS NOT NULL THEN "RedirectorPage_Localised_en_US"."ExternalURL"
ELSE "RedirectorPage_Live"."ExternalURL" END
AS "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", 'es_419' AS "Locale", CASE WHEN "RedirectorPage_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "RedirectorPage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "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" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "RedirectorPage_Localised_Live" AS "RedirectorPage_Localised_es_419" ON "RedirectorPage_Live"."ID" = "RedirectorPage_Localised_es_419"."RecordID" AND "RedirectorPage_Localised_es_419"."Locale" = ? LEFT JOIN "RedirectorPage_Localised_Live" AS "RedirectorPage_Localised_en_US" ON "RedirectorPage_Live"."ID" = "RedirectorPage_Localised_en_US"."RecordID" AND "RedirectorPage_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_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", 'es_419' AS "Locale", CASE WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0020: SELECT DISTINCT "Fluent_FallbackLocale"."ClassName", "Fluent_FallbackLocale"."LastEdited", "Fluent_FallbackLocale"."Created", "Fluent_FallbackLocale"."Sort", "Fluent_FallbackLocale"."ParentID", "Fluent_FallbackLocale"."LocaleID", "Fluent_FallbackLocale"."ID",
CASE WHEN "Fluent_FallbackLocale"."ClassName" IS NOT NULL THEN "Fluent_FallbackLocale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\FallbackLocale' END AS "RecordClassName"
FROM "Fluent_FallbackLocale"
WHERE ("Fluent_FallbackLocale"."ParentID" = ?)
ORDER BY "Fluent_FallbackLocale"."Sort" ASC
0.0003s
0021: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
WHERE ("Fluent_Locale"."ID" = ?)
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
LIMIT 1
0.0003s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_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", 'en_US' AS "Locale", CASE WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL) OR ("SiteTree_Localised_es_419"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlockPage_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", 'es_419' AS "Locale", CASE WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0024: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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.0003s
0025: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."BackgroundColor", CASE
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."BackgroundPattern"
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."BackgroundPattern"
ELSE "Element_Live"."BackgroundPattern" END
AS "BackgroundPattern", "Element_Live"."CustomCode", CASE
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."TopPageLocale"
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."TopPageLocale"
ELSE "Element_Live"."TopPageLocale" END
AS "TopPageLocale", "Element_Live"."Version", CASE
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."Title"
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Title"
ELSE "Element_Live"."Title" END
AS "Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", CASE
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."ExtraClass"
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."ExtraClass"
ELSE "Element_Live"."ExtraClass" END
AS "ExtraClass", CASE
WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN "Element_Localised_es_419"."Style"
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN "Element_Localised_en_US"."Style"
ELSE "Element_Live"."Style" END
AS "Style", "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", 'es_419' AS "Locale", CASE WHEN "Element_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "Element_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
0.0011s
0026: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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.0003s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."ShowBreadcrumbs", CASE
WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN "Page_Localised_es_419"."CardSummary"
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN "Page_Localised_en_US"."CardSummary"
ELSE "Page_Live"."CardSummary" END
AS "CardSummary", "Page_Live"."CardImageID", "BlockPage_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", 'es_419' AS "Locale", CASE WHEN "Page_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "Page_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlockPage_Live" ON "BlockPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_es_419" ON "Page_Live"."ID" = "Page_Localised_es_419"."RecordID" AND "Page_Localised_es_419"."Locale" = ? LEFT JOIN "Page_Localised_Live" AS "Page_Localised_en_US" ON "Page_Live"."ID" = "Page_Localised_en_US"."RecordID" AND "Page_Localised_en_US"."Locale" = ?
WHERE ("BlockPage_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0028: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementBanner_Live"."TextPosition", "ElementBanner_Live"."TextColor", CASE
WHEN "ElementBanner_Localised_es_419"."ID" IS NOT NULL THEN "ElementBanner_Localised_es_419"."ImageID"
WHEN "ElementBanner_Localised_en_US"."ID" IS NOT NULL THEN "ElementBanner_Localised_en_US"."ImageID"
ELSE "ElementBanner_Live"."ImageID" END
AS "ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "ElementBanner_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "ElementBanner_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "ElementBanner_Live" ON "ElementBanner_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ? LEFT JOIN "ElementBanner_Localised_Live" AS "ElementBanner_Localised_es_419" ON "ElementBanner_Live"."ID" = "ElementBanner_Localised_es_419"."RecordID" AND "ElementBanner_Localised_es_419"."Locale" = ? LEFT JOIN "ElementBanner_Localised_Live" AS "ElementBanner_Localised_en_US" ON "ElementBanner_Live"."ID" = "ElementBanner_Localised_en_US"."RecordID" AND "ElementBanner_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0029: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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.0003s
0030: 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"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "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" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0004s
0031: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."TopPageLocale", "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.0003s
0032: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("Element_Live"."Sort" < ?)
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
0.0004s
0033: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0007s
0034: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0008s
0035: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN "ElementContent_Localised_es_419"."HTML"
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN "ElementContent_Localised_en_US"."HTML"
ELSE "ElementContent_Live"."HTML" END
AS "HTML", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "ElementContent_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_es_419" ON "Element_Live"."ID" = "Element_Localised_es_419"."RecordID" AND "Element_Localised_es_419"."Locale" = ? LEFT JOIN "Element_Localised_Live" AS "Element_Localised_en_US" ON "Element_Live"."ID" = "Element_Localised_en_US"."RecordID" AND "Element_Localised_en_US"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_es_419" ON "ElementContent_Live"."ID" = "ElementContent_Localised_es_419"."RecordID" AND "ElementContent_Localised_es_419"."Locale" = ? LEFT JOIN "ElementContent_Localised_Live" AS "ElementContent_Localised_en_US" ON "ElementContent_Live"."ID" = "ElementContent_Localised_en_US"."RecordID" AND "ElementContent_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("Element_Localised_es_419"."ID" IS NOT NULL) OR ("Element_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0005s
0036: SELECT DISTINCT count(DISTINCT "Link"."ID") AS "Count"
FROM "Link" LEFT JOIN "FooterLink" ON "FooterLink"."ID" = "Link"."ID"
WHERE ("FooterLink"."SiteConfigID" = ?)
AND ("Link"."ClassName" IN (?))
0.0004s
0037: SELECT DISTINCT "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."FileID", "FooterLink"."IconClass", "FooterLink"."Sort", "FooterLink"."HideTitle", "FooterLink"."IconFileID", "FooterLink"."SiteConfigID", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link" LEFT JOIN "FooterLink" ON "FooterLink"."ID" = "Link"."ID"
WHERE ("FooterLink"."SiteConfigID" = ?)
AND ("Link"."ClassName" IN (?))
ORDER BY "FooterLink"."Sort" ASC
0.001s
0038: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0003s
0039: SELECT "BaseTable"."RecordID", MAX("SiteTree_Localised_Versions"."Version") as "LatestVersion" FROM "SiteTree_Localised" AS "BaseTable" INNER JOIN "SiteTree_Localised_Versions" ON "BaseTable"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Localised_Versions"."Locale" = ? INNER JOIN "SiteTree_Versions" ON "SiteTree_Versions"."RecordID" = "SiteTree_Localised_Versions"."RecordID" AND "SiteTree_Versions"."Version" = "SiteTree_Localised_Versions"."Version" WHERE "BaseTable"."Locale" = ? AND "BaseTable"."RecordID" IN (?) GROUP BY "BaseTable"."RecordID"
0.0004s
0040: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0003s
0041: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0042: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0043: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree"."MetaDescription" END
AS "MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree"."ReportClass" END
AS "ReportClass", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree" LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_es_419" ON "SiteTree"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised" AS "SiteTree_Localised_en_US" ON "SiteTree"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree"."ID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0005s
0044: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."URLSegment"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Title"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MenuTitle"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."Content"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."MetaDescription"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MetaDescription"
ELSE "SiteTree_Live"."MetaDescription" END
AS "MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", CASE
WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN "SiteTree_Localised_es_419"."ReportClass"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "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", 'es_419' AS "Locale", CASE WHEN "SiteTree_Localised_es_419"."ID" IS NOT NULL THEN 'es_419'
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_es_419" ON "SiteTree_Live"."ID" = "SiteTree_Localised_es_419"."RecordID" AND "SiteTree_Localised_es_419"."Locale" = ? LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_en_US" ON "SiteTree_Live"."ID" = "SiteTree_Localised_en_US"."RecordID" AND "SiteTree_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND (("SiteTree_Localised_es_419"."ID" IS NOT NULL) OR ("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
Home
Escuela Comunitaria Buena Vista Horace Mann K-8
La escuela comunitaria Buena Vista Horace Mann K-8 es una escuela primaria y secundaria pública de grados K – 8º en el Distrito de la Misión de San Francisco, California, con la orgullosa distinción de ser la primera escuela de doble inmersión en español del Distrito Escolar Unificado de San Francisco.
ParentSquare es la principal herramienta de comunicación de BVHM. Si usted es un padre de BVHM pero no se ha registrado en nuestro directorio electrónico y sistema de comunicación, ParentSquare, por favor visite https://www.parentsquare.com/signin para registrarse para obtener una cuenta. Para obtener más información sobre ParentSquare, revise este video.
Campaña anual de recaudación de fondos
Ayúdenos a llenar el frasco y apoyar nuestra campaña anual de recaudación de fondos hoy. Done aquí
Aviso de la Ley Williams
Una Queja Williams permite a un estudiante, familia, maestro o cualquier miembro del público presentar quejas con respecto a las escuelas K-12 por: Libros de texto y materiales educativos insuficientes; Vacante o mala asignación de maestros; y Condiciones de las instalaciones.
