0002: SHOW DATABASES LIKE 'vivaexp\_silverstripe\_ss5'
0.0001s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0005s
0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."URLSegment" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0005: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."APIKey", "SiteConfig"."DisableSearchEngineVisibility", "SiteConfig"."TwitterUsername", "SiteConfig"."FacebookAdmin", "SiteConfig"."FacebookAppID", "SiteConfig"."HeadScripts", "SiteConfig"."BodyStartScripts", "SiteConfig"."BodyEndScripts", "SiteConfig"."RobotsTXT", "SiteConfig"."RobotsPublishedPagesOnly", "SiteConfig"."DefaultMetaTitle", "SiteConfig"."SupportedBrowser", "SiteConfig"."ContactEmail", "SiteConfig"."ContactPhone", "SiteConfig"."ContactAddress", "SiteConfig"."HeadTagCode", "SiteConfig"."OpenBodyTagCode", "SiteConfig"."CloseBodyTagCode", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."GlobalSocialSharingImageID", "SiteConfig"."CMSLogoID", "SiteConfig"."ID",
CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName"
ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName"
FROM "SiteConfig"
LIMIT 1
0.0001s
0006: SELECT DISTINCT "SEO_variable"."ClassName", "SEO_variable"."LastEdited", "SEO_variable"."Created", "SEO_variable"."Name", "SEO_variable"."Value", "SEO_variable"."ID",
CASE WHEN "SEO_variable"."ClassName" IS NOT NULL THEN "SEO_variable"."ClassName"
ELSE 'SilverStripers\\SEO\\Model\\Variable' END AS "RecordClassName"
FROM "SEO_variable"
ORDER BY "SEO_variable"."Name" ASC
0.0359s
0007: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."PreviewImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0008: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0009: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0010: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0011: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0012: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0013: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0014: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0003s
0015: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0003s
0016: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" INNER JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL))
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("PublishDate" < '2025-08-13 21:42:09')
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0017: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0018: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0019: SELECT DISTINCT "ContactBranch"."ClassName", "ContactBranch"."LastEdited", "ContactBranch"."Created", "ContactBranch"."Country", "ContactBranch"."CountryAcronym", "ContactBranch"."OfficeName", "ContactBranch"."OfficeVisitsByAppointment", "ContactBranch"."FreePhone", "ContactBranch"."LocalPhone", "ContactBranch"."OfficeAddressLine1", "ContactBranch"."OfficeAddressLine2", "ContactBranch"."SortOrder", "ContactBranch"."ContactPageID", "ContactBranch"."ID",
CASE WHEN "ContactBranch"."ClassName" IS NOT NULL THEN "ContactBranch"."ClassName"
ELSE 'ContactBranch' END AS "RecordClassName"
FROM "ContactBranch"
WHERE ("ContactBranch"."CountryAcronym" = ?)
LIMIT 1
0.0003s
0020: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0015s
0021: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0066s
0022: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0023: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0024: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0006s
0025: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0026: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0027: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0028: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0029: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0030: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0031: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0032: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0033: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
ORDER BY "VivaTourCategoryObject_Live"."SortOrder" ASC
0.0005s
0034: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0035: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0687s
0036: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0005s
0037: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0038: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0039: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0040: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0007s
0041: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0042: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0043: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0044: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0045: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "ContactPage_Live"."MainContactEmail", "ContactPage_Live"."MainContactSkype", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ContactPage_Live" ON "ContactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0046: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "OurStoryPage_Live"."Subtitle", "OurStoryPage_Live"."Tagline", "OurStoryPage_Live"."OperationsText", "OurStoryPage_Live"."PersonalisedItinerariesText", "OurStoryPage_Live"."LittleThingsTitle", "OurStoryPage_Live"."LittleThingsText", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "OurStoryPage_Live" ON "OurStoryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0047: SELECT DISTINCT "StaffMember"."ClassName", "StaffMember"."LastEdited", "StaffMember"."Created", "StaffMember"."FirstName", "StaffMember"."Surname", "StaffMember"."Position", "StaffMember"."Email", "StaffMember"."Description", "StaffMember"."SortOrder", "StaffMember"."ProfileImageID", "StaffMember"."BannerImageID", "StaffMember"."ID",
CASE WHEN "StaffMember"."ClassName" IS NOT NULL THEN "StaffMember"."ClassName"
ELSE 'StaffMember' END AS "RecordClassName"
FROM "StaffMember"
ORDER BY "StaffMember"."SortOrder" ASC
0.0001s
0048: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0049: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0051: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0052: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0053: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0054: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (16452))
ORDER BY "_SortColumn0" ASC
0.0001s
0055: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (16452))
AND ("File"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0056: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (16452))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0001s
0057: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (2381))
ORDER BY "_SortColumn0" ASC
0.0001s
0058: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (2381))
AND ("File"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0059: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (2381))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0001s
0060: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (2381))
AND (("File_Live"."ID" NOT IN (2381) OR "File_Live"."ID" IS NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0061: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (2381))
AND (("File_Live"."ID" NOT IN (2381) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0062: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (2381))
AND (("File_Live"."ID" NOT IN (2381) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0001s
0063: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (16452))
AND (("File_Live"."ID" NOT IN (16452) OR "File_Live"."ID" IS NULL))
ORDER BY "_SortColumn0" ASC
0s
0064: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (16452))
AND (("File_Live"."ID" NOT IN (16452) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0065: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (16452))
AND (("File_Live"."ID" NOT IN (16452) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0001s
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0067: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0068: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (20784))
ORDER BY "_SortColumn0" ASC
0.0001s
0069: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (20784))
AND ("File"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0070: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (20784))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0002s
0071: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (20784))
AND (("File_Live"."ID" NOT IN (20784) OR "File_Live"."ID" IS NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0072: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (20784))
AND (("File_Live"."ID" NOT IN (20784) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0073: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (20784))
AND (("File_Live"."ID" NOT IN (20784) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0001s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0075: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0076: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0077: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0078: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0079: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0080: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0081: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0082: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0083: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0084: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0085: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0086: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0087: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0088: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (4324))
ORDER BY "_SortColumn0" ASC
0.0001s
0089: SELECT "File"."ID", "File"."Name" AS "_SortColumn0"
FROM "File"
WHERE ("File"."ID" IN (4324))
AND ("File"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0090: SELECT DISTINCT "File"."ID", "File"."ParentID"
FROM "File"
WHERE ("File"."ID" IN (4324))
AND ("File"."CanViewType" = ?)
ORDER BY "File"."ID" ASC
0.0001s
0091: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (4324))
AND (("File_Live"."ID" NOT IN (4324) OR "File_Live"."ID" IS NULL))
ORDER BY "_SortColumn0" ASC
0.0001s
0092: SELECT "File_Live"."ID", "File_Live"."Name" AS "_SortColumn0"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (4324))
AND (("File_Live"."ID" NOT IN (4324) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "_SortColumn0" ASC
0.0001s
0093: SELECT DISTINCT "File_Live"."ID", "File_Live"."ParentID"
FROM "File_Live"
WHERE ("File_Live"."ID" IN (4324))
AND (("File_Live"."ID" NOT IN (4324) OR "File_Live"."ID" IS NULL))
AND ("File_Live"."CanViewType" = ?)
ORDER BY "File_Live"."ID" ASC
0.0001s
0094: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0095: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0003s
0096: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0097: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0098: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0006s
0099: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0100: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0101: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0102: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0103: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0008s
0104: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0105: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0106: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "HomePage_Live"."HeroSlideshowSpeed", "HomePage_Live"."TrustPilotTag", "HomePage_Live"."GroupExpeditionsSubTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindTitle", "HomePage_Live"."GroupExpeditionsPeaceOfMindContent", "HomePage_Live"."GroupExpeditionsSpecialistsTitle", "HomePage_Live"."GroupExpeditionsSpecialistsContent", "HomePage_Live"."GroupExpeditionsRealExperiencesTitle", "HomePage_Live"."GroupExpeditionsRealExperiencesContent", "HomePage_Live"."GroupExpeditionsValueForMoneyTitle", "HomePage_Live"."GroupExpeditionsValueForMoneyContent", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "HomePage_Live" ON "HomePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0107: SELECT DISTINCT count(DISTINCT "VivaStaticSpecial"."ID") AS "Count"
FROM "VivaStaticSpecial" INNER JOIN "OurStoryPage_StaticSpecials" ON "OurStoryPage_StaticSpecials"."VivaStaticSpecialID" = "VivaStaticSpecial"."ID"
WHERE ("OurStoryPage_StaticSpecials"."OurStoryPageID" = ?)
0.0002s
0108: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaTour_Live"."Featured" = ?)
AND ("VivaTour_Live"."Hidden" = ?)
AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0008s
0109: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0003s
0110: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0111: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0112: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaTour_Live"."Featured" = ?)
AND ("VivaTour_Live"."Hidden" = ?)
AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
LIMIT 3) THEN 1 ELSE 0 END
0.0001s
0113: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaStaticSpecial" INNER JOIN "OurStoryPage_StaticSpecials" ON "OurStoryPage_StaticSpecials"."VivaStaticSpecialID" = "VivaStaticSpecial"."ID"
WHERE ("OurStoryPage_StaticSpecials"."OurStoryPageID" = ?)
AND ("VivaStaticSpecial"."SpecialFeaturedPosition" = ?)) THEN 1 ELSE 0 END
0.0001s
0114: SELECT DISTINCT RAND() AS "_SortColumn0", "VivaDataObjectAsPage_Live"."ClassName", "VivaDataObjectAsPage_Live"."LastEdited", "VivaDataObjectAsPage_Live"."Created", "VivaDataObjectAsPage_Live"."Version", "VivaDataObjectAsPage_Live"."URLSegment", "VivaDataObjectAsPage_Live"."MetaTitle", "VivaDataObjectAsPage_Live"."MetaDescription", "VivaTour_Live"."ImportKey", "VivaTour_Live"."SortOrder", "VivaTour_Live"."InternalName", "VivaTour_Live"."TourName", "VivaTour_Live"."TourTeaser", "VivaTour_Live"."TourDescription", "VivaTour_Live"."TourType", "VivaTour_Live"."TourLengthDays", "VivaTour_Live"."TourFrequencyOverride", "VivaTour_Live"."CostSharing", "VivaTour_Live"."CostUS", "VivaTour_Live"."CostUK", "VivaTour_Live"."CostEU", "VivaTour_Live"."CostAU", "VivaTour_Live"."CostNZ", "VivaTour_Live"."SmartCurrencyPrice", "VivaTour_Live"."SmartCurrencyCode", "VivaTour_Live"."CostNotice", "VivaTour_Live"."SingleSuppPercent", "VivaTour_Live"."CustomisableItinerary", "VivaTour_Live"."Featured", "VivaTour_Live"."Hidden", "VivaTour_Live"."HideFromAPI", "VivaTour_Live"."SearchTerms", "VivaTour_Live"."MapDefaultZoom", "VivaTour_Live"."UpsellToursTitle", "VivaTour_Live"."VideoID", "VivaDataObjectAsPage_Live"."ID",
CASE WHEN "VivaDataObjectAsPage_Live"."ClassName" IS NOT NULL THEN "VivaDataObjectAsPage_Live"."ClassName"
ELSE 'VivaDataObjectAsPage' END AS "RecordClassName"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaTour_Live"."Featured" = ?)
AND ("VivaTour_Live"."Hidden" = ?)
AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
ORDER BY "_SortColumn0" ASC
LIMIT 3
0.0008s
0115: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0002s
0116: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0001s
0117: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0002s
0118: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0002s
0119: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0120: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0001s
0121: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0002s
0122: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0123: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0001s
0124: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0001s
0125: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ParentID" > ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 1
0.0004s
0126: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0002s
0127: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "VivaTourImage_Live"."Sort", "VivaTourImage_Live"."DataObjectID", "VivaTourImage_Live"."DataObjectClass", "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" LEFT JOIN "VivaTourImage_Live" ON "VivaTourImage_Live"."ID" = "File_Live"."ID"
WHERE ("DataObjectClass" IN ('VivaTour'))
AND ("VivaTourImage_Live"."DataObjectID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "VivaTourImage_Live"."Sort" ASC
LIMIT 1
0.0003s
0128: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Styles" ON "VivaTour_Styles"."VivaTourStyleID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Styles"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0002s
0129: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Styles" ON "VivaTour_Styles"."VivaTourStyleID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Styles"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 3
0.0004s
0130: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0002s
0131: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0132: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 2
0.0003s
0133: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0001s
0134: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0001s
0135: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0001s
0136: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0001s
0137: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0138: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0001s
0139: SELECT DISTINCT "SmartCurrencyStoredRate"."ClassName", "SmartCurrencyStoredRate"."LastEdited", "SmartCurrencyStoredRate"."Created", "SmartCurrencyStoredRate"."BaseCurrency", "SmartCurrencyStoredRate"."TargetCurrency", "SmartCurrencyStoredRate"."Rate", "SmartCurrencyStoredRate"."RoundingUnits", "SmartCurrencyStoredRate"."ID",
CASE WHEN "SmartCurrencyStoredRate"."ClassName" IS NOT NULL THEN "SmartCurrencyStoredRate"."ClassName"
ELSE 'SmartCurrencyStoredRate' END AS "RecordClassName"
FROM "SmartCurrencyStoredRate"
WHERE ("SmartCurrencyStoredRate"."BaseCurrency" = ?)
AND ("SmartCurrencyStoredRate"."TargetCurrency" = ?)
LIMIT 1
0.0001s
0140: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0141: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0001s
0142: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0001s
0143: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0144: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ParentID" > ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 1
0.0003s
0145: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0002s
0146: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "VivaTourImage_Live"."Sort", "VivaTourImage_Live"."DataObjectID", "VivaTourImage_Live"."DataObjectClass", "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" LEFT JOIN "VivaTourImage_Live" ON "VivaTourImage_Live"."ID" = "File_Live"."ID"
WHERE ("DataObjectClass" IN ('VivaTour'))
AND ("VivaTourImage_Live"."DataObjectID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "VivaTourImage_Live"."Sort" ASC
LIMIT 1
0.0535s
0147: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Styles" ON "VivaTour_Styles"."VivaTourStyleID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Styles"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0003s
0148: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Styles" ON "VivaTour_Styles"."VivaTourStyleID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Styles"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 3
0.0004s
0149: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0002s
0150: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0151: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 2
0.0004s
0152: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0002s
0153: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0001s
0154: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0002s
0155: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0005s
0156: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0157: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0158: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0159: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0001s
0160: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0006s
0161: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
AND ("VivaTourSpecial"."SpecialType" = ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0162: SELECT DISTINCT "VivaTourItinerary_Live"."ClassName", "VivaTourItinerary_Live"."LastEdited", "VivaTourItinerary_Live"."Created", "VivaTourItinerary_Live"."Version", "VivaTourItinerary_Live"."ImportKey", "VivaTourItinerary_Live"."TourStartLocation", "VivaTourItinerary_Live"."TourEndLocation", "VivaTourItinerary_Live"."TourID", "VivaTourItinerary_Live"."TourDossierID", "VivaTourItinerary_Live"."ID",
CASE WHEN "VivaTourItinerary_Live"."ClassName" IS NOT NULL THEN "VivaTourItinerary_Live"."ClassName"
ELSE 'VivaTourItinerary' END AS "RecordClassName"
FROM "VivaTourItinerary_Live"
WHERE ("VivaTourItinerary_Live"."TourID" = ?)
0.0001s
0163: SELECT DISTINCT "VivaTourItineraryDate"."ClassName", "VivaTourItineraryDate"."LastEdited", "VivaTourItineraryDate"."Created", "VivaTourItineraryDate"."ImportKey", "VivaTourItineraryDate"."StartDate", "VivaTourItineraryDate"."EndDate", "VivaTourItineraryDate"."AvailableSeats", "VivaTourItineraryDate"."ItineraryID", "VivaTourItineraryDate"."ID",
CASE WHEN "VivaTourItineraryDate"."ClassName" IS NOT NULL THEN "VivaTourItineraryDate"."ClassName"
ELSE 'VivaTourItineraryDate' END AS "RecordClassName"
FROM "VivaTourItineraryDate"
WHERE ("VivaTourItineraryDate"."ItineraryID" = ?)
ORDER BY "VivaTourItineraryDate"."StartDate" ASC
0.0001s
0164: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0165: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0166: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0167: SELECT DISTINCT "VivaTourSpecial"."ClassName", "VivaTourSpecial"."LastEdited", "VivaTourSpecial"."Created", "VivaTourSpecial"."SpecialType", "VivaTourSpecial"."SpecialCostUS", "VivaTourSpecial"."SpecialCostUK", "VivaTourSpecial"."SpecialCostEU", "VivaTourSpecial"."SpecialCostAU", "VivaTourSpecial"."SpecialCostNZ", "VivaTourSpecial"."SmartCurrencyPrice", "VivaTourSpecial"."SmartCurrencyCode", "VivaTourSpecial"."SpecialText", "VivaTourSpecial"."SpecialEmbargoStart", "VivaTourSpecial"."SpecialEmbargoEnd", "VivaTourSpecial"."ShowOriginalPrice", "VivaTourSpecial"."TourID", "VivaTourSpecial"."TourItineraryID", "VivaTourSpecial"."TourItineraryDateID", "VivaTourSpecial"."ID",
CASE WHEN "VivaTourSpecial"."ClassName" IS NOT NULL THEN "VivaTourSpecial"."ClassName"
ELSE 'VivaTourSpecial' END AS "RecordClassName"
FROM "VivaTourSpecial"
WHERE ("VivaTourSpecial"."TourItineraryDateID" = ?)
AND ("VivaTourSpecial"."SpecialEmbargoStart" < ?)
AND ("VivaTourSpecial"."SpecialEmbargoEnd" > ?)
ORDER BY "VivaTourSpecial"."SpecialCostUS" ASC
LIMIT 1
0.0002s
0168: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ParentID" > ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 1
0.0003s
0169: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0001s
0170: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "VivaTourImage_Live"."Sort", "VivaTourImage_Live"."DataObjectID", "VivaTourImage_Live"."DataObjectClass", "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" LEFT JOIN "VivaTourImage_Live" ON "VivaTourImage_Live"."ID" = "File_Live"."ID"
WHERE ("DataObjectClass" IN ('VivaTour'))
AND ("VivaTourImage_Live"."DataObjectID" = ?)
AND ("File_Live"."ClassName" IN (?, ?))
ORDER BY "VivaTourImage_Live"."Sort" ASC
LIMIT 1
0.0003s
0171: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Styles" ON "VivaTour_Styles"."VivaTourStyleID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Styles"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0002s
0172: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))) THEN 1 ELSE 0 END
0.0001s
0173: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0174: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID" INNER JOIN "VivaTour_Regions" ON "VivaTour_Regions"."VivaTourRegionID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTour_Regions"."VivaTourID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
LIMIT 2
0.0004s
0175: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ID" = ?)
LIMIT 1
0.0002s
0176: SELECT CASE WHEN EXISTS(SELECT *
FROM "VivaStaticSpecial" INNER JOIN "OurStoryPage_StaticSpecials" ON "OurStoryPage_StaticSpecials"."VivaStaticSpecialID" = "VivaStaticSpecial"."ID"
WHERE ("OurStoryPage_StaticSpecials"."OurStoryPageID" = ?)
AND ("VivaStaticSpecial"."SpecialFeaturedPosition" = ?)) THEN 1 ELSE 0 END
0.0001s
0177: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0178: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0179: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0180: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "OurStoryPage_Live"."Subtitle", "OurStoryPage_Live"."Tagline", "OurStoryPage_Live"."OperationsText", "OurStoryPage_Live"."PersonalisedItinerariesText", "OurStoryPage_Live"."LittleThingsTitle", "OurStoryPage_Live"."LittleThingsText", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "OurStoryPage_Live" ON "OurStoryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0181: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", CASE WHEN "SiteTree_Live"."ClassName" IN ('VivaPage', 'AgentResourcesPage', 'ContactPage', 'ContactPageSuccess', 'DestinationPage', 'EOLandingPage', 'FileResourcePage', 'FindToursPage', 'HomePage', 'OurStoryPage', 'RequestQuoteSuccessPage', 'TeamMemberPage', 'TourPage', 'TourSuccessPage', 'TourTransportPage', 'TrainingPage', 'TravelAgentsPage', 'TravelInformationPage', 'TravellerPage', 'ReserveASpotSuccessPage', 'RequestQuotePage', 'ReserveASpotPage', 'TravellerFlightsPage', 'TravellerPassengerPage') THEN "VivaPage_Live"."HeroImageID" WHEN "SiteTree_Live"."ClassName" IN ('FileResourcePage') THEN "FileResourcePage_Live"."HeroImageID" ELSE NULL END AS "HeroImageID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "FileResourcePage_Live" ON "FileResourcePage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0182: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0001s
0183: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0184: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
0185: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."FocusKeyword", "SiteTree"."MetaKeywords", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."FacebookTitle", "SiteTree"."FacebookDescription", "SiteTree"."TwitterTitle", "SiteTree"."TwitterDescription", "SiteTree"."MetaRobotsFollow", "SiteTree"."MetaRobotsIndex", "SiteTree"."CanonicalURL", "SiteTree"."TrackingCodes", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."FacebookImageID", "SiteTree"."TwitterImageID", "SiteTree"."MetaTitleTemplateID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0002s
0186: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
About Viva Expeditions - The Viva Story | Viva Expeditions
With Viva you will enjoy a richer, deeper, and more meaningful experience.
We bring colour to your world and offer connection through travel.
We will help you uncover the real wonders of Africa, Latin America, New Zealand, the Arctic & Antarctica. By using our first-hand knowledge and expertise to offer creative, personalised itineraries that will challenge your senses. We are not offering only a trip to visit the main tourist sites, we are offering a glimpse into a different world, filled with many wonderful people and many fascinating cultures and colour!
Feel confident when traveling with us with 24/7 support through-out the duration of your journey.
We believe strongly in sustainability, and we select great quality boutique and locally owned hotels, where possible, that are environmentally friendly. We engage with local communities to ensure our presence in their lives has a positive impact, and we support many local initiatives.
If you are looking for a run of the mill experience, viewing the world from a coach seat then Viva is not for you. But if you are looking for true connection with places you visit, we will place you on the ground, connecting with people and the environment in a truly enriching way.
This is our philosophy and is at the heart of everything we create.
Our business is operated through Viva Expeditions Limited and Viva Aotearoa Limited, trading as Viva Expeditions.
Meet the Team
Rachel Williams
Founder & Managing Director
Tara Sutherland
General Manager
Melanie Wright
Marketing Manager
Rosemary McNoe
Business Development Manager
Tanya Gurtin
Africa Product Manager & Destination Specialist
Pia Knarston
Destination Specialist
Beke Grossmann
Destination Specialist
Flor Bojorquez
Destination Specialist
Tracy Davidson
Destination Specialist
Bryony Legg
Destination Specialist
Laura Pattara
Travel Writer
Juanita Vallejo
Marketing Coordinator
Ann Bajar
Website Administrator
Personalised Itineraries, Group Tours & Small Ship Cruises in some of the world’s most pristine destinations
Peace of mind
We want you to travel with confidence, knowing everything is taken care of and all your arrangements are guaranteed. We are with you 24 hours a day, and our team are just a phone call away at any time. So, whenever you need us, we will be there! We are NZ owned & are TAANZ affiliated.
Specialists
We use our expertise to offer creative, personalised itineraries that are individually designed for you, based on your preferred style, accommodation, and interests. We know our destinations inside out and have all travelled extensively, we also conduct regular checks of our hotels, ships, and services to ensure quality.
Real Experiences
We design tailor-made experiences and small-group tours just for you, combining major highlights with off-the-beaten-track locations for a truly unique adventure. Our journeys go beyond the ordinary, offering authentic cultural interactions and uncovering local secrets to ensure you have the trip of a lifetime.
Value for money
All of our tours represent excellent value for money. We work hard to secure the best rates for our guests with no hidden costs, and once booked the services are guaranteed. We are ready to help, with no obligations, in fact we will save you valuable time in planning your incredible journey.
We use our expertise to offer creative, personalised itineraries that challenge people’s senses and allow them to travel with confidence. We believe that true inspiration and growth comes from real experiences and immersion in the world around us. It is about interacting with the people, discovering the culture, finding the best local cuisine, and being blown away by the hidden treasures, the beautiful scenery, and the majestic vistas. We will help you explore natural wonders and the diverse wildlife, seeking the best and most genuine experiences in some of the most remote places on earth.
It’s the little things that count.
Our Custom Tours give you the freedom and flexibility to design an itinerary that is perfect for you. Choose from our selection of inspiring independent itineraries here on our website which can be tailored to suit you, or let us know your requirements and our specialists will be happy to design a perfect itinerary to suit your interests, dates and budget.
Alternatively embark on a fully escorted Small Group Tour with us. A group tour gives you the opportunity to explore these destinations in a fun and exciting environment surrounded by like-minded travellers. All our small group tours provide the perfect balance between organised sightseeing and free time for independent discovery.
Or how about a Small Ship Cruise to Antarctica or the Arctic? A river cruise up the Amazon? Sailing around the Galapagos Islands? Or discovering New Zealand’s magnificent Fiordlands from the sea? Small ship cruising allows you to access regions that are inaccessible by road, pristine and remote locations that are unspoilt, untouched and truly magical.