0002: SHOW DATABASES LIKE 'udensdiena\_prod\_test'
0.0009s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0043s
0004: SHOW FULL FIELDS IN "Fluent_Domain"
0.0013s
0005: SHOW COLLATION LIKE 'utf8_general_ci'
0.0006s
0006: SELECT DISTINCT "Fluent_Domain"."ClassName", "Fluent_Domain"."LastEdited", "Fluent_Domain"."Created", "Fluent_Domain"."Domain", "Fluent_Domain"."DefaultLocaleID", "Fluent_Domain"."ID",
CASE WHEN "Fluent_Domain"."ClassName" IS NOT NULL THEN "Fluent_Domain"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Domain' END AS "RecordClassName"
FROM "Fluent_Domain"
0.0004s
0007: SHOW FULL FIELDS IN "Fluent_Locale"
0.0009s
0008: SELECT DISTINCT "Fluent_Locale"."ClassName", "Fluent_Locale"."LastEdited", "Fluent_Locale"."Created", "Fluent_Locale"."Title", "Fluent_Locale"."Locale", "Fluent_Locale"."URLSegment", "Fluent_Locale"."IsGlobalDefault", "Fluent_Locale"."UseDefaultCode", "Fluent_Locale"."Sort", "Fluent_Locale"."Timezone", "Fluent_Locale"."DomainID", "Fluent_Locale"."ID",
CASE WHEN "Fluent_Locale"."ClassName" IS NOT NULL THEN "Fluent_Locale"."ClassName"
ELSE 'TractorCow\\Fluent\\Model\\Locale' END AS "RecordClassName"
FROM "Fluent_Locale"
ORDER BY "Fluent_Locale"."Sort" ASC, "Fluent_Locale"."Locale" ASC
0.0005s
0009: 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.0012s
0010: 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.0006s
0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."URLSegment", "SiteTree_Localised_en_US"."URLSegment", "SiteTree_Live"."URLSegment") = ?)
AND ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0025s
0012: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."FromEmail", CASE
WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."FooterContent"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."FooterContent"
ELSE "SiteConfig"."FooterContent" END
AS "FooterContent", CASE
WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."SecurityLostPasswordContent"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."SecurityLostPasswordContent"
ELSE "SiteConfig"."SecurityLostPasswordContent" END
AS "SecurityLostPasswordContent", CASE
WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."SecurityChangePasswordContent"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."SecurityChangePasswordContent"
ELSE "SiteConfig"."SecurityChangePasswordContent" END
AS "SecurityChangePasswordContent", CASE
WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."WatterBannerTitle"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."WatterBannerTitle"
ELSE "SiteConfig"."WatterBannerTitle" END
AS "WatterBannerTitle", "SiteConfig"."VoteStart", "SiteConfig"."DisableNewVotes", "SiteConfig"."ShowTopNotification", CASE
WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteConfig_Localised_lv_LV"."TopNotificationContent"
WHEN "SiteConfig_Localised_en_US"."ID" IS NOT NULL THEN "SiteConfig_Localised_en_US"."TopNotificationContent"
ELSE "SiteConfig"."TopNotificationContent" END
AS "TopNotificationContent", "SiteConfig"."ShowNotifications", "SiteConfig"."ExtraCode", "SiteConfig"."Lng", "SiteConfig"."Lat", "SiteConfig"."MapZoom", "SiteConfig"."Description", "SiteConfig"."Address", "SiteConfig"."Suburb", "SiteConfig"."State", "SiteConfig"."Country", "SiteConfig"."ZipCode", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."AboutPageID", "SiteConfig"."WatterBannerImageID", "SiteConfig"."VoteStartPageID", "SiteConfig"."PrivacyPolicyID", "SiteConfig"."SitemapID", "SiteConfig"."FacebookID", "SiteConfig"."LinkedInID", "SiteConfig"."PinterestID", "SiteConfig"."InstagramID", "SiteConfig"."TwitterID", "SiteConfig"."YouTubeID", "SiteConfig"."PublicEmailID", "SiteConfig"."PhoneNumberID", "SiteConfig"."TiktokID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "SiteConfig_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteConfig"."ID" = "SiteConfig_Localised_lv_LV"."RecordID" AND "SiteConfig_Localised_lv_LV"."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.002s
0013: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0014: SELECT "Version" FROM "SiteTree_Live" WHERE "ID" = ?
0.0006s
0015: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0004s
0016: 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.0006s
0017: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "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"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
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_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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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 "SiteTree_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 "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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0018: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0005s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0020: SELECT "ID"
FROM "SiteTree_Localised_Live"
WHERE ("RecordID" = ?)
AND ("Locale" = ?)
LIMIT 1
0.0005s
0021: 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.0006s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0009s
0023: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
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.0006s
0025: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE
WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."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", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", CASE
WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementContent_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "ElementContent_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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_lv_LV" ON "ElementContent_Live"."ID" = "ElementContent_Localised_lv_LV"."RecordID" AND "ElementContent_Localised_lv_LV"."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"."ParentID" = ?)
AND (COALESCE("ElementContent_Localised_lv_LV"."HTML", "ElementContent_Localised_en_US"."HTML", "ElementContent_Live"."HTML") IS NOT NULL)
AND ("Element_Live"."ClassName" IN (?, ?, ?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0024s
0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "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"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
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_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_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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 "SiteTree_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 "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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_en_US"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0013s
0027: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0028: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."URLSegment"
ELSE "SiteTree_Live"."URLSegment" END
AS "URLSegment", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Title"
ELSE "SiteTree_Live"."Title" END
AS "Title", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."MenuTitle"
ELSE "SiteTree_Live"."MenuTitle" END
AS "MenuTitle", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."Content"
ELSE "SiteTree_Live"."Content" END
AS "Content", CASE
WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."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_ru_RU"."ID" IS NOT NULL THEN "SiteTree_Localised_ru_RU"."ReportClass"
ELSE "SiteTree_Live"."ReportClass" END
AS "ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'ru_RU' AS "Locale", CASE WHEN "SiteTree_Localised_ru_RU"."ID" IS NOT NULL THEN 'ru_RU'
ELSE NULL END AS "SourceLocale"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_ru_RU" ON "SiteTree_Live"."ID" = "SiteTree_Localised_ru_RU"."RecordID" AND "SiteTree_Localised_ru_RU"."Locale" = ?
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_ru_RU"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
0029: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
0.0023s
0030: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0012s
0031: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0032: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0033: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0011s
0034: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0035: 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.0005s
0036: SELECT DISTINCT count(DISTINCT "Element_Live"."ID") AS "Count"
FROM "Element_Live" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
0.0007s
0037: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE
WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."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", "Element_Live"."ExtraClass", "Element_Live"."Style", "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", 'lv_LV' AS "Locale", CASE WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0038: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE
WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."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", "Element_Live"."ExtraClass", "Element_Live"."Style", "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", 'lv_LV' AS "Locale", CASE WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
0.0008s
0039: 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.0005s
0040: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "SiteTree_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 "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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 ("Page_Live"."ElementalAreaID" = ?)
AND ("SiteTree_Live"."ClassName" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0017s
0041: 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.0006s
0042: 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.0004s
0043: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementImage_Live"."Resize", "ElementImage_Live"."ManualWidth", "ElementImage_Live"."ImageHeight", "ElementImage_Live"."ImageWidth", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."ImageAspectRatio"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."ImageAspectRatio"
ELSE "ElementImage_Live"."ImageAspectRatio" END
AS "ImageAspectRatio", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."Content"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."Content"
ELSE "ElementImage_Live"."Content" END
AS "Content", "ElementImage_Live"."ImageLinkID", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale", "Element_Live"."Sort"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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 "ElementImage_Localised_Live" AS "ElementImage_Localised_lv_LV" ON "ElementImage_Live"."ID" = "ElementImage_Localised_lv_LV"."RecordID" AND "ElementImage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementImage_Localised_Live" AS "ElementImage_Localised_en_US" ON "ElementImage_Live"."ID" = "ElementImage_Localised_en_US"."RecordID" AND "ElementImage_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ID" = ?)
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0009s
0044: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "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"."ObjectID", "File_Live"."ObjectClass", "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.0007s
0045: SELECT DISTINCT count(*) AS "Count"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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 "ElementImage_Localised_Live" AS "ElementImage_Localised_lv_LV" ON "ElementImage_Live"."ID" = "ElementImage_Localised_lv_LV"."RecordID" AND "ElementImage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementImage_Localised_Live" AS "ElementImage_Localised_en_US" ON "ElementImage_Live"."ID" = "ElementImage_Localised_en_US"."RecordID" AND "ElementImage_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("ElementImage_Live"."ImageHeight" > ?)
AND (("Element_Live"."ID" != ? OR "Element_Live"."ID" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
0.0008s
0046: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE
WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."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", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "ElementImage_Live"."Resize", "ElementImage_Live"."ManualWidth", "ElementImage_Live"."ImageHeight", "ElementImage_Live"."ImageWidth", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."ImageAspectRatio"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."ImageAspectRatio"
ELSE "ElementImage_Live"."ImageAspectRatio" END
AS "ImageAspectRatio", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."Content"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."Content"
ELSE "ElementImage_Live"."Content" END
AS "Content", "ElementImage_Live"."ImageLinkID", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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 "ElementImage_Localised_Live" AS "ElementImage_Localised_lv_LV" ON "ElementImage_Live"."ID" = "ElementImage_Localised_lv_LV"."RecordID" AND "ElementImage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementImage_Localised_Live" AS "ElementImage_Localised_en_US" ON "ElementImage_Live"."ID" = "ElementImage_Localised_en_US"."RecordID" AND "ElementImage_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("ElementImage_Live"."ImageHeight" > ?)
AND (("Element_Live"."ID" != ? OR "Element_Live"."ID" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0016s
0047: SELECT DISTINCT count(*) AS "Count"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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 "ElementImage_Localised_Live" AS "ElementImage_Localised_lv_LV" ON "ElementImage_Live"."ID" = "ElementImage_Localised_lv_LV"."RecordID" AND "ElementImage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementImage_Localised_Live" AS "ElementImage_Localised_en_US" ON "ElementImage_Live"."ID" = "ElementImage_Localised_en_US"."RecordID" AND "ElementImage_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("ElementImage_Live"."ImageHeight" > ?)
AND (("Element_Live"."ID" != ? OR "Element_Live"."ID" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
0.0008s
0048: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."ContainerType", "Element_Live"."Size", "Element_Live"."AvailableGlobally", "Element_Live"."Version", CASE
WHEN "Element_Localised_lv_LV"."ID" IS NOT NULL THEN "Element_Localised_lv_LV"."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", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "ElementImage_Live"."Resize", "ElementImage_Live"."ManualWidth", "ElementImage_Live"."ImageHeight", "ElementImage_Live"."ImageWidth", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."ImageAspectRatio"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."ImageAspectRatio"
ELSE "ElementImage_Live"."ImageAspectRatio" END
AS "ImageAspectRatio", CASE
WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementImage_Localised_lv_LV"."Content"
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN "ElementImage_Localised_en_US"."Content"
ELSE "ElementImage_Live"."Content" END
AS "Content", "ElementImage_Live"."ImageLinkID", "ElementImage_Live"."ImageID", "Element_Live"."ID",
CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName"
ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ElementImage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "ElementImage_Localised_en_US"."ID" IS NOT NULL THEN 'en_US'
ELSE NULL END AS "SourceLocale"
FROM "Element_Live" LEFT JOIN "ElementImage_Live" ON "ElementImage_Live"."ID" = "Element_Live"."ID" LEFT JOIN "Element_Localised_Live" AS "Element_Localised_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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 "ElementImage_Localised_Live" AS "ElementImage_Localised_lv_LV" ON "ElementImage_Live"."ID" = "ElementImage_Localised_lv_LV"."RecordID" AND "ElementImage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ElementImage_Localised_Live" AS "ElementImage_Localised_en_US" ON "ElementImage_Live"."ID" = "ElementImage_Localised_en_US"."RecordID" AND "ElementImage_Localised_en_US"."Locale" = ?
WHERE ("Element_Live"."ParentID" = ?)
AND ("ElementImage_Live"."ImageHeight" > ?)
AND (("Element_Live"."ID" != ? OR "Element_Live"."ID" IS NULL))
AND ("Element_Live"."ClassName" IN (?))
AND (("Element_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0014s
0049: 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.0006s
0050: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", CASE
WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN "ElementContent_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "ElementContent_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "Element_Live"."ID" = "Element_Localised_lv_LV"."RecordID" AND "Element_Localised_lv_LV"."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_lv_LV" ON "ElementContent_Live"."ID" = "ElementContent_Localised_lv_LV"."RecordID" AND "ElementContent_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "Element_Live"."Sort" ASC
LIMIT 1
0.0011s
0051: SELECT DISTINCT "WidgetArea_Live"."ClassName", "WidgetArea_Live"."LastEdited", "WidgetArea_Live"."Created", "WidgetArea_Live"."Version", "WidgetArea_Live"."ID",
CASE WHEN "WidgetArea_Live"."ClassName" IS NOT NULL THEN "WidgetArea_Live"."ClassName"
ELSE 'SilverStripe\\Widgets\\Model\\WidgetArea' END AS "RecordClassName"
FROM "WidgetArea_Live"
WHERE ("WidgetArea_Live"."ID" = ?)
LIMIT 1
0.0005s
0052: SELECT DISTINCT count(DISTINCT "Widget_Live"."ID") AS "Count"
FROM "Widget_Live"
WHERE ("Widget_Live"."ParentID" = ?)
0.0005s
0053: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.001s
0054: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."UserFormUpload", "File_Live"."IsTemporary", "File_Live"."Version", "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"."ObjectID", "File_Live"."ObjectClass", "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.0007s
0055: 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", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link"
WHERE ("Link"."ID" = ?)
LIMIT 1
0.0006s
0056: 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", "Link"."ID",
CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName"
ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName"
FROM "Link"
WHERE ("Link"."ID" = ?)
LIMIT 1
0.0006s
0057: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", CASE
WHEN "ProfilePage_Localised_lv_LV"."ID" IS NOT NULL THEN "ProfilePage_Localised_lv_LV"."DrawingsPageContent"
WHEN "ProfilePage_Localised_en_US"."ID" IS NOT NULL THEN "ProfilePage_Localised_en_US"."DrawingsPageContent"
ELSE "ProfilePage_Live"."DrawingsPageContent" END
AS "DrawingsPageContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "ProfilePage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "ProfilePage_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 "ProfilePage_Live" ON "ProfilePage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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 "ProfilePage_Localised_Live" AS "ProfilePage_Localised_lv_LV" ON "ProfilePage_Live"."ID" = "ProfilePage_Localised_lv_LV"."RecordID" AND "ProfilePage_Localised_lv_LV"."Locale" = ? LEFT JOIN "ProfilePage_Localised_Live" AS "ProfilePage_Localised_en_US" ON "ProfilePage_Live"."ID" = "ProfilePage_Localised_en_US"."RecordID" AND "ProfilePage_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.002s
0058: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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"."InheritSideBar", "Page_Live"."BlockIcon", "Page_Live"."SideBarID", "Page_Live"."ElementalAreaID", CASE
WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."FormText"
WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."FormText"
ELSE "RegistrationPage_Live"."FormText" END
AS "FormText", CASE
WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."SuccessContent"
WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."SuccessContent"
ELSE "RegistrationPage_Live"."SuccessContent" END
AS "SuccessContent", CASE
WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN "RegistrationPage_Localised_lv_LV"."LoginContent"
WHEN "RegistrationPage_Localised_en_US"."ID" IS NOT NULL THEN "RegistrationPage_Localised_en_US"."LoginContent"
ELSE "RegistrationPage_Live"."LoginContent" END
AS "LoginContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", 'lv_LV' AS "Locale", CASE WHEN "RegistrationPage_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
WHEN "RegistrationPage_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 "RegistrationPage_Live" ON "RegistrationPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "SiteTree_Localised_Live" AS "SiteTree_Localised_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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 "RegistrationPage_Localised_Live" AS "RegistrationPage_Localised_lv_LV" ON "RegistrationPage_Live"."ID" = "RegistrationPage_Localised_lv_LV"."RecordID" AND "RegistrationPage_Localised_lv_LV"."Locale" = ? LEFT JOIN "RegistrationPage_Localised_Live" AS "RegistrationPage_Localised_en_US" ON "RegistrationPage_Live"."ID" = "RegistrationPage_Localised_en_US"."RecordID" AND "RegistrationPage_Localised_en_US"."Locale" = ?
WHERE ("SiteTree_Live"."ClassName" IN (?))
AND (("SiteTree_Localised_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0018s
0059: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0005s
0060: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0061: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0062: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."ShowInSitemap", "SiteTree"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree"."ExtraCode" END
AS "ExtraCode", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0008s
0063: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."ShowInSitemap", "SiteTree_Live"."AvailableOffline", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."ExtraCode"
WHEN "SiteTree_Localised_en_US"."ID" IS NOT NULL THEN "SiteTree_Localised_en_US"."ExtraCode"
ELSE "SiteTree_Live"."ExtraCode" END
AS "ExtraCode", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", CASE
WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL THEN "SiteTree_Localised_lv_LV"."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", 'lv_LV' AS "Locale", CASE WHEN "SiteTree_Localised_lv_LV"."ID" IS NOT NULL THEN 'lv_LV'
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_lv_LV" ON "SiteTree_Live"."ID" = "SiteTree_Localised_lv_LV"."RecordID" AND "SiteTree_Localised_lv_LV"."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_lv_LV"."ID" IS NOT NULL))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0007s
VENDEN 2023. gada bērnu zīmējumu konkursa "Ūdens mūsu pasaulē" nolikums
Pamatinformācija
1. Avota un dabīgā minerālūdens ražotājs VENDEN organizē zīmējumu konkursu pirmsskolas izglītības iestāžu (bērnudārzu) un izglītības iestāžu, kas īsteno pirmsskolas izglītības programmas, audzēkņiem no visas Latvijas.
2. Zīmējumu konkursa nosaukums un tēma: "Ūdens mūsu pasaulē".
3. Konkurss notiek vairākos posmos:
Zīmējumu sagatavošana un iesniegšana vietnē www.udensdiena.lv: 1.marts – 16. marts;
Publisks balsojums par labākajiem zīmējumiem vietnē www.udensdiena.lv un žūrijas vērtējums: 17. – 29. marts;
Uzvarētāju paziņošana vietnē www.udensdiena.lv un VENDEN sociālajos tīklos: 31. marts;
Apbalvošana: līdz 30. maijam vai citos termiņos pēc atsevišķas vienošanās.
4. Zīmējumi publiskajā balsojumā tiek iedalīti 4 kategorijās:
Vecuma grupa 2 – 4 gadi, individuāla dalība;
Vecuma grupa 5 – 7 gadi, individuāla dalība;
Vecuma grupa 2 – 4 gadi, grupas dalība;
Vecuma grupa 5 – 7 gadi, grupas dalība.
5. Konkursa rezultātā tiek apbalvoti zīmējumu autori un iestādes, kuras tie pārstāv:
5.1. Balvas iegūst pirmsskolas izglītības iestādes vai izglītības iestādes, kas īsteno pirmsskolas izglītības programmas, kuru audzēkņu zīmējumi iegūst lielāko balsu skaitu publiskajā balsojumā katrā no 4. punktā uzskaitītajām kategorijām sporta inventāra vai mācībām noderīgu materiālu iegādei (iepriekš vienojoties ar katru konkrēto iestādi):
1. vieta – nepārsniedzot 500 eiro, ieskaitot PVN;
2. vieta – nepārsniedzot 300 eiro, ieskaitot PVN;
3. vieta – nepārsniedzot 200 eiro, ieskaitot PVN.
5.2. Starp visiem konkursā iesūtītajiem darbiem žūrija nosaka piecus uzvarētājus – pirmās līdz piektās vietas ieguvējus. Balvas iegūst pirmsskolas izglītības iestāde vai izglītības iestāde, kas īsteno pirmsskolas izglītības programmas, kuru uzvarētājs pārstāv, sporta inventāra vai mācībām noderīgu materiālu iegādei (iepriekš vienojoties ar katru konkrēto iestādi):
1. vieta – nepārsniedzot 500 eiro, ieskaitot PVN;
2. vieta – nepārsniedzot 400 eiro, ieskaitot PVN;
3. vieta – nepārsniedzot 300 eiro, ieskaitot PVN;
4. vieta – nepārsniedzot 200 eiro, ieskaitot PVN;
5. vieta – nepārsniedzot 100 eiro, ieskaitot PVN.
5.3. Starp visiem konkursā iesūtītajiem darbiem VENDEN piešķir kolektīva simpātiju balvu. Balvu iegūst pirmsskolas izglītības iestāde vai izglītības iestāde, kas īsteno pirmsskolas izglītības programmas, kuru uzvarētājs pārstāv, sporta inventāra vai mācībām noderīgu materiālu iegādei (iepriekš vienojoties ar katru konkrēto iestādi), nepārsniedzot 500 eiro, ieskaitot PVN.
5.4. Gan publiskajā balsojumā visās četrās 4. punktā noteiktajās kategorijās pirmo desmit vietu ieguvējiem, gan žūrijas vērtējumā pirmās piecas vietas ieguvušo zīmējumu autoriem un VENDEN simpātiju balvas ieguvušā zīmējuma autoram – diplomi un īpašas pārsteigumu balvas no VENDEN.
5.5. Papildus tam pēc žūrijas vērtējuma tiek izvēlēti un apbalvoti 20 zīmējumu autori ar pateicības rakstiem par māksliniecisko izpildījumu un dāvanām no VENDEN, kā arī vēl 25 zīmējumu autori ar pateicības rakstiem par māksliniecisko izpildījumu.
5.6. Balvas netiek izsniegtas naudas vai dāvanu kartes veidā.
5.7. Viena un tā pati iestāde var piedalīties un saņemt balvas visās kategorijās.
5.8. Izglītības iestāde katrā no publiskā balsojuma kategorijām var iegūt tikai 1 (vienu) naudas balvu; ja izglītības iestādes audzēkņu zīmējumi vienā kategorijā iegūst vairākas godalgotas vietas, tai tiek piešķirta tikai lielākā no iegūtajām naudas balvām. Šādā gadījumā zīmējumu autori tiek apbalvoti atbilstoši iegūtajām vietām, bet neizsniegto balvu fonds tiek novirzīts nākamo vietu ieguvušajai(-ām) izglītības iestādei(-ēm).
Noteikumi dalībniekiem
6. Konkursā ar tēmu "Ūdens mūsu pasaulē" tiek aicināti piedalīties pirmsskolas izglītības iestāžu, privāto pirmsskolas izglītības iestāžu un izglītības iestāžu, kas īsteno pirmsskolas izglītības programmas, audzēkņi vecumā no diviem līdz septiņiem gadiem individuāli vai grupā.
7. Bērni nav ierobežoti iztēlē, gatavojot zīmējumu plaknē, vēlams, A4 formātā. Var brīvi izvēlēties tehniku, kurā sagatavot zīmējumu – ar zīmuļiem, flomāsteriem, krītiņiem, ūdens vai guaša krāsām, aplikācijām u.c. Uz zīmējuma nedrīkst būt norādīts tā autora vārds un uzvārds.
8. Sagatavoto zīmējumu nepieciešams ieskenēt vai, ja tādas iespējas nav, kvalitatīvi nofotografēt un saglabāt elektroniski JPG, JPEG vai PNG formātā. Attēlā nedrīkst būt redzami zīmējuma autori.
9. Laikā no 1.marta līdz 16. martam (ieskaitot), darbu nepieciešams augšupielādēt vietnē www.udensdiena.lv. Lai to izdarītu, pirmskolas izglītības iestādes (bērnudārza) vai izglītības iestādes, kas īsteno pirmsskolas izglītības programmas, pārstāvim (piemēram, audzinātājam/ai, auklītei vai vadītājam) nepieciešams aizpildīt reģistrācijas formu un izveidot savu profilu kabinetā. No tā būs iespējams augšupielādēt bērnu zīmējumus, norādot:
Zīmējuma autora/u vārdu un uzvārdu;
Informāciju, vai zīmējums ir individuāli izstrādāts, vairāku autoru vai grupas darbs;
Zīmējuma autora vecumu vai grupas vidējo vecumu, ja tas izstrādāts kolektīvi;
Zīmējuma nosaukumu un/vai aprakstu.
Visi konkursa norises laikā saņemtie personu dati tiek neatgriezeniski dzēsti 6 mēnešu laikā no konkursa noslēguma brīža.
Publiskā balsojuma norise
10. Laika periodā no 2022. gada 17. marta līdz 29. martam augšupielādētie zīmējumi piedalās publiskā balsojumā ar mērķi noteikt uzvarētājus 4. punktā noteiktajās kategorijās.
11. Balsojuma norises vietne: www.udensdiena.lv.
12. Lai piedalītos balsojumā, vietnes apmeklētājiem jāautorizējas caur Facebook vai Google lietotāju profiliem.
13. Balsot var par neierobežotu zīmējumu skaitu, bet ne vairāk kā vienu reizi par vienu un to pašu zīmējumu diennaktī.
14. Par katru zīmējumu balsojums notiek ar 1 līdz 5 punktiem, kur 1 – zemākais iespējamais vērtējums, bet 5 – augstākais. Publiskajā balsojumā iegūtie punkti summējas un par uzvarētājiem tiek noteikti desmit visvairāk punktus ieguvušie katrā no četrām 4. punktā aprakstītajām kategorijām.
15. Par individuāli vai grupā (1 – 5 bērni) izstrādātu zīmējuma autoru/iem balsojumā tiek publiskota šāda informācija: vārds, uzvārda iniciālis, vecums, izglītības iestādes nosaukums. Savukārt, ja zīmējuma izstrādē iesaistījusies visa vai lielākā daļa pirmsskolas izglītības iestādes (bērnudārza) vai izglītības iestādes, kas īsteno pirmsskolas izglītības programmas, grupiņa, par to tiek publiskota šāda informācija: grupiņas nosaukums, tās audzēkņu vidējais vecums, izglītības iestādes nosaukums.
16. Autortiesības un intelektuālā īpašuma tiesības, kas skar konkursa norisi, tajā skaitā VENDEN preču zīmi, ir aizsargātas. Jebkāda veida materiālo vai nemateriālo vērtību piedāvāšana bez VENDEN atļaujas, tiek uzskatīta par VENDEN tiesību aizskārumu. VENDEN patur tiesības uz laiku apturēt vai pārtraukt balsojumu par konkrēto zīmējumu vispār, ja konkursa laikā tiek konstatēta negodprātīga rīcība, tajā skaitā balsu pirkšanas mēģinājumi vai citas darbības ar mērķi negodīgā veidā iegūt vairāk balsu.
Žūrijas vērtējums
17. Lai izvērtētu iesniegto darbu autoru radošās spējas un sasniegumus, zīmējumus vērtē neatkarīga žūrija – Baldones Mākslas skolas pedagogi:
Tālivaldis Muzikants – mākslinieks, Latvijas Mākslinieku savienības biedrs, Baldones Mākslas skolas direktors, mākslas pedagogs,
Ieva Muzikante – māksliniece, Latvijas Mākslinieku savienības biedre, Baldones Mākslas skolas pedagoģe,
Sandra Lagzdiņa – māksliniece, Latvijas Mākslinieku savienības biedre, Baldones Mākslas skolas pedagoģe.
18. Žūrija iesūtītos zīmējumus vērtē pēc sekojošiem kritērijiem:
Ūdens attēlots kā īpaša un nozīmīga mūsu dzīves vērtība;
Autora patstāvīga un radoša tēmas interpretācija;
Patstāvība un oriģinalitāte izpildījumā;
Darba stilistika atbilstoša autora vecumam;
Mākslas darba tēls, emocijas, ekspresija;
Ekoloģiskais aspekts – tīrs ūdens kā dzīvības eksistences pamats.
19. Žūrijas vērtējuma rezultātā tiek noteikti 5 uzvarētāji, pirmās līdz piektās vietas ieguvēji, kas tiek apbalvoti atbilstoši 7. punktā noteiktajai kārtībai. Papildus tam tiek apbalvoti vēl 45 zīmējumu autori, atbilstoši 5.5. punktā noteiktajai kārtībai.
Papildu informācija
20. Piesakoties dalībai konkursā, pretendenti (pirmsskolas izglītības iestādes vai izglītības iestādes, kas īsteno pirmsskolas izglītības programmas) iegūst saskaņojumus publiskai balsošanai par sagatavoto zīmējumu VENDEN norādītajā vietnē.
21. VENDEN patur tiesības sazināties ar zīmējumu autoru pārstāvjiem par iespēju turpmāk izmantot zīmējumus mārketinga nolūkos, piemēram, reprezentatīvo materiālu sagatavošanai.
22. Pēc autora pārstāvju (vecāku) sniegtās piekrišanas zīmējumu publikācijai VENDEN patur tiesības publicēt zīmējumus vai to daļas, fotografēt, skenēt vai citādi digitalizēt zīmējumus, veikt nepieciešamās izmaiņas tajos, tai skaitā, bet ne tikai, mainīt zīmējumu vai to daļu izmērus, pārveidot vai rotēt zīmējumus vai to daļas, veikt korekcijas zīmējumu kontrastā, krāsu toņos, to spilgtumā un/vai citos parametros, dzēst vai koriģēt defektus, nepilnības vai citus zīmējumu elementus, veikt jebkuras citas izmaņas ar mērķi uzlabot zīmējumu un/vai visu reprezentatīvo vai cita rakstura materiālu kopumā izskatu vai efektivitāti bez papildu saskaņošanas.
23. Balvas pirmsskolas izglītības iestādei tiek sagatavotas pēc uzvarētāju paziņošanas, vienojoties ar uzvarētāja pārstāvēto pirmsskolas izglītības iestādi vai izglītības iestādi, kas īsteno pirmsskolas izglītības programmas, par nepieciešamo sporta inventāru un izglītības procesā nepieciešamajiem materiāliem, bet ne vēlāk kā līdz 2023. gada 30. maijam, ja vien puses nav vienojušās par citiem termiņiem.
24. Jebkādas pretenzijas par zīmējumu konkursu tiek risinātas savstarpēji vienojoties starp VENDEN pārstāvjiem un pirmsskolas izglītības iestādi vai izglītības iestādi, kas īsteno pirmsskolas izglītības programmas.
