0002: SHOW DATABASES LIKE 'vivaexp\_silverstripe\_ss5'
0.0002s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0006s
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.0006s
0005: 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" = ?)
AND ("SiteTree_Live"."URLSegment" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0006: 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.0003s
0007: 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.0002s
0008: SELECT DISTINCT "PublishDate" IS NULL AS "_SortColumn0", "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "BlogPost_Live"."FeaturedToursLimit", "BlogPost_Live"."PublishDate", "BlogPost_Live"."AuthorNames", "BlogPost_Live"."Summary", "BlogPost_Live"."AuthorImageID", "BlogPost_Live"."BannerImageID", "BlogPost_Live"."TourRegionID", "BlogPost_Live"."FeaturedImageID", "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 "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?))
AND ("PublishDate" < '2025-08-14 12:46:02')
ORDER BY "_SortColumn0" DESC, "BlogPost_Live"."PublishDate" DESC
LIMIT 1
0.0002s
0009: 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.0001s
0010: 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
0011: 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" INNER JOIN "BlogPost_Live" ON "SiteTree_Live"."ID" = "BlogPost_Live"."ID"
WHERE ("SiteTree_Live"."ID" = ?)
AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0003s
0012: 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
0013: 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
0014: 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.0003s
0015: 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
0016: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
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 "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
0020: 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
0021: 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.0002s
0022: 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-14 12:46:02')
ORDER BY "SiteTree_Live"."Sort" ASC
0.0012s
0023: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0024: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0002s
0025: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0026: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0027: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0028: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
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.0005s
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 "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
0032: 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
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", "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
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", "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
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", "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
0036: 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
0037: 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.0001s
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", "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
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.0002s
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", "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.0002s
0041: 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.0002s
0042: 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.0002s
0043: 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.0002s
0044: 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.0002s
0045: 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.0004s
0046: 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.0001s
0047: 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.0001s
0048: 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
0049: 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.0001s
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", "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.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 "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID",
CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName"
ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName"
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)
LIMIT 1
0.0002s
0053: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0054: 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"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
0.0001s
0055: 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
0056: 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
0057: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0058: SELECT CASE WHEN EXISTS(SELECT *
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "BlogPost_Images" ON "BlogPost_Images"."ImageID" = "File_Live"."ID"
WHERE ("BlogPost_Images"."BlogPostID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))) THEN 1 ELSE 0 END
0.0002s
0059: 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
0060: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0061: 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
0062: 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
0063: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0064: 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
0065: 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"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
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 "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
0068: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0001s
0069: 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
0070: 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
0071: 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
0072: 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.0005s
0073: 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
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"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0001s
The Best Lost Cities of Peru (Besides Machu Picchu) | Viva Expeditions
They may not be featured on travel brochures and they certainly don’t get the attention they deserve, but the best-lost cities of Peru (that aren’t Machu Picchu) are still immensely impressive and absolutely rewarding to visit. Their combined relative anonymity is a blessing in disguise, for here you’ll find some of the best archaeological sites on the planet minus the crowds that descend on more celebrated sites.
Click the links below to skip through the article:
More than a mere attempt to dodge tourists, however, Peru’s most illustrious ancient cities pay homage to all the pre-colonial cultures who inhabited the country which include, but aren’t restricted, to the formidable Incas. Ancient civilizations that lived and thrived atop its snow-capped peaks and in the heart of its most rugged and dramatic landscapes. Avid history lovers who are looking for an in-depth Perutravel experience will find all these places unmissable.
The largest mud-carved ancient city in the world is a sight to behold. As you stand at its entrance admiring its imposing guarding statues and intricately carved walls, it’ll seem like the last 1000 years didn’t even happen. Severe El Nino storms have caused some damage here but there’s still so much of Chan Chan left to admire and the site, near the northern coastal town of Trujillo, remains as awe-inspiring as ever. It’s crazy to think that just half a century ago, this was the largest city in the Americas, home to an estimated 60,000 people and over 10,000 structures. The city was the seat of the prominent Chimu culture that ruled southern Ecuador and northern Peru until sometime in the mid-15th century when it was overpowered by the Incas. This desert region of Peru is arid and seemingly inhospitable yet the aqueducts built by the Chimu aided a flourishing farming trade. You can learn all about the Chimu in Trujillo’s museums before taking an in-depth tour of the ruins, which are simply outstanding.
Choquequirao is an incredible alternative to Machu Picchu or if you have time, a wonderful add-on. The ancient Inca site shares similarities with its more famous neighbour and is also flanked by high Andean peaks in the Sacred Valley of the Incas and reached via a spectacular multi-day hike not many people even know is on offer. Unlike Machu Picchu, however, Choque was not really explored until just a few decades ago and it is believed that over half of it is yet to be discovered. This amazing lost city of Peru was picked up by the tourist radar in 2017 after the Lonely Planet featured it in one of its guides – there are even rumours of a cable-car being installed in the near future and, if this materialises, you can expect the crowds to flock.
Our tip? Head here before it all happens!
Traveling in the historical city Choquequirao, Peru
UNESCO-listed Caral was built by what is widely believed to be the oldest civilization that ever lived in the Americas, the Norte Chico. Unlike Choquequirao, Caral has been thoroughly excavated and studied and although the site may at first appear to be in disrepair – at least compared to Machu Picchu – it is certainly impressive when seen with some perspective. Caral is 5,000 years old and its startling pyramids were built at almost the same time as those of Giza. It was around this time that anthropologists believe we evolved from our hunter-gatherer existence and started to congregate into organised societies, pooling our resources and finally constructing permanent structures where we could live, all year long. The birth of modern civilisation seems to have occurred (almost) concurrently all over the world and, for the Americas, Caral is its primordial example. This wonderful treasure of mankind is found just a few hours north of Lima. As the ancient birthplace of Andean culture, the lost city of Caral is one of the most fascinating lost cities you could discover on Peru travels but do make sure you go with an English-speaking guide who can share interesting info and bring this magnificent place to live.
The Warriors of the Clouds, the Chachapoyas, built a lost city in a hidden nook of the Andean Mountains, surrounded by luscious cloud forests and framed by vertiginous peaks. Kuelap, the “Machu Picchu of the North” is the main and most arresting lost city but it isn’t the only treasure found in the north-western Chachapoyas region, not by a long shot. The modern town – also named Chachapoyas – is a wonderful springboard for exceptional hiking, with trails leading up to Kuelap (and its newly-minted cable-car) and a host of other fantastic archaeological ruins. Thousand-year-old walls and temples, ancient stone trails, the stunning funerary statues of Karaja and amazing graves of Revash, precariously placed and carved on the side of rocky cliffs as if by magic. Kuelap is surely the main reason you’ll want to head up to this lesser-visited and rather a remote area of Peru but the sheer concentration of stunning sites is what will entice you to stay just a few more days.
The lost city of Pachacamac, southeast of Lima, was said to be a thriving hub of activity by the time the Spaniards arrived. It was built nearly a thousand years before the Incas rose to prominence and added on by subsequent cultures, leaving behind a layered legacy of several civilizations. Sacred pyramids, temples and graves give this expansive complex air of importance, perhaps defying its initial impression which may seem barren and inconsequential. Yet the history of Pachacamac is fascinating as is the long list of ancient and lesser-known cultures who built upon the original plan and expanded it. If you’re in the company of a guide who can fill in the gaps, these glorious ruins will reveal their secrets and the gorgeous views afforded from its most elevated spots will splendidly complement your visit. Arguably the easiest day-trip destination you could take from LAnima, Pachacamac is the epitome of the lost city treasure inPeru, one that’s “hidden in plain sight”.
Without any doubts, Machu Picchu is a wonder of the world that no first-time visitor to the country can miss! Yet for those who want to explore further, and deeper, the lost cities ofPeru offer a stunning option for a whirlwind historical tour de force.
Laura Pattara writes for Viva Expeditions with a special love for all things Latin America. She had guided overland tours across the continent, reached Machu Picchu five times on foot, and even dressed up as a giant toucan for Carnaval. With a degree in languages and two decades of global travel experience behind her, Laura has a long-standing love for the Andes, soaring condors, and a truly delicious empanada.