
Signature Mexico
Explore the highlights of Mexico City, pyramids of the sun & moon, Xochimilco floating gardens, Merida, Chichen Itza & Caribbean beach stay!
0001: SET sql_mode = ? 0.0002s
0002: SHOW DATABASES LIKE 'vivaexp\_silverstripe\_ss5' 0.0002s
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.0004s
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.0002s
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.0001s
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-26 21:24:01') 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.0002s
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 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
0013: 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
0014: 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
0015: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" 0.0001s
0016: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" 0.0002s
0017: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" 0.0001s
0018: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" 0.0002s
0019: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" 0.0001s
0020: 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.0007s
0021: 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
0022: 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
0023: 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
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.0005s
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 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
0028: 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
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", "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.0006s
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", "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
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", "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
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", "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
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", "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.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", "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.0002s
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", "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
0037: 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
0038: 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
0039: 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
0040: 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
0041: 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
0042: 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.0003s
0043: 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.0004s
0044: 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.0004s
0045: 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.0003s
0046: SELECT DISTINCT "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" INNER JOIN "BlogPost_FeaturedTours" ON "BlogPost_FeaturedTours"."VivaTourID" = "VivaDataObjectAsPage_Live"."ID" WHERE ("BlogPost_FeaturedTours"."BlogPostID" = ?) AND ("VivaTour_Live"."Hidden" = ?) AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?)) ORDER BY "VivaTour_Live"."SortOrder" ASC 0.0006s
0047: 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"."ID" = ?) AND ("VivaTourCategoryObject_Live"."ClassName" IN (?)) LIMIT 1 0.0664s
0048: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count" FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID" INNER JOIN "VivaTourRegion_FeaturedTours" ON "VivaTourRegion_FeaturedTours"."VivaTourID" = "VivaDataObjectAsPage_Live"."ID" WHERE ("VivaTourRegion_FeaturedTours"."VivaTourRegionID" = ?) AND ("VivaTour_Live"."Hidden" = ?) AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?)) 0.0003s
0049: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count" FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID" INNER JOIN "VivaTourRegion_FeaturedTours" ON "VivaTourRegion_FeaturedTours"."VivaTourID" = "VivaDataObjectAsPage_Live"."ID" WHERE ("VivaTourRegion_FeaturedTours"."VivaTourRegionID" = ?) AND ("VivaTour_Live"."Hidden" = ?) AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?)) 0.0003s
0050: SELECT DISTINCT "VivaTourRegion_FeaturedTours"."FeaturedSortOrder", "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" INNER JOIN "VivaTourRegion_FeaturedTours" ON "VivaTourRegion_FeaturedTours"."VivaTourID" = "VivaDataObjectAsPage_Live"."ID" WHERE ("VivaTourRegion_FeaturedTours"."VivaTourRegionID" = ?) AND ("VivaTour_Live"."Hidden" = ?) AND ("VivaDataObjectAsPage_Live"."ClassName" IN (?)) ORDER BY "VivaTour_Live"."SortOrder" ASC 0.0006s
0051: 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
0052: 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.0007s
0053: 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
0054: 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
0055: 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
0056: 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
0057: 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
0058: 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.0004s
0059: 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
0060: 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.0003s
0061: 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.0007s
0062: 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
0063: 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.0004s
0064: 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
0065: 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.0005s
0066: 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.0003s
0067: 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.0005s
0068: 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.0777s
0069: 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
0070: 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
0071: 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.0006s
0072: 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
0073: 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
0074: 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.0003s
0075: 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
0076: 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.0003s
0077: 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
0078: 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
0079: 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.0005s
0080: 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
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", "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.0005s
0082: 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
0083: 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.0003s
0084: 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
0085: 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.0005s
0086: 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
0087: 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
0088: 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
0089: 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
0090: 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
0091: 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
0092: 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
0093: 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
0094: 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
0095: 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
0096: 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
0097: 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
0098: 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
0099: 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.0004s
0100: 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.0005s
0101: 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.0005s
0102: 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
0103: 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
0104: 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.0007s
0105: 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.0006s
0106: SELECT CASE WHEN EXISTS(SELECT * FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT 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"."ClassName" IN (?)) AND ("PublishDate" < '2025-08-26 21:24:02') LIMIT 4) THEN 1 ELSE 0 END 0.0003s
0107: SELECT "BlogCategory"."Title" FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID" WHERE ("BlogPost_Categories"."BlogPostID" = ?) 0.0002s
0108: SELECT "BlogCategory"."Title" FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID" WHERE ("BlogPost_Categories"."BlogPostID" = ?) 0.0001s
0109: SELECT "BlogCategory"."Title" FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID" WHERE ("BlogPost_Categories"."BlogPostID" = ?) 0.0007s
0110: 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
0111: 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.0056s
0112: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0002s
0113: 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
0114: 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
0115: 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
0116: 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.0737s
0117: 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
0118: 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
| 1 November 2022
With credit to Tara SutherlandMexico is a great place to visit throughout the year, since it has many amazing attractions and a rich history. But the annual Dia de los Muertos celebration is one of the most popular times of year to visit Mexico, as visitors flock to Mexican cities to partake in the festivities.
If you’re planning on travelling to Mexico during Dia de los Muertos, we recommend booking well in advance.
> Read more: When is the best time to visit Mexico?
The Day of the Dead, or Dia de los Muertos, is a Mexican celebration celebrated on the 1st and 2nd of November. Family members who have died are remembered through ofrendas (offerings) created by loved ones.
At midnight on November 1st, the celebration officially begins with Dia de los Angelitos (Day of the tiny angels), a time when the souls of all deceased children are said to be reunited with their loved ones for a full day.
The commemorations for adults who have passed away begins at midnight on the second of November. The public celebration of Dia de Muertos culminates the following day. Calaveras (skeletons) are a popular costume choice for recent years' celebrations, as citizens of participating cities gather for street parades.
Marigold flowers, pictures of the deceased, and the deceased's preferred foods and beverages are commonplace on these altars. It is thought that the deceased will be able to sense the prayers, smell the delicacies, and participate in the celebrations thanks to the offerings.
Day of the Dead is an unusual celebration of both life and death. It is definitely not a time of mourning, it is a time of fond memories - Mexicans like to celebrate death with joy and humour - this is not to say they do not feel sadness, it is just not the time for this.
During Day of the Dead celebrations, you'll see calaveras (sugar skulls) everywhere. There is typically a smile on the skulls as though to poke fun at mortality. Candies made of sugar, clay ornaments, and, perhaps most notably, painted faces all fall into this category.
Dia de los muertos is celebrated all around Mexico, but Oaxaca and Mexico City are particularly well-known for their carnival-esque parades that are popular with visitors. Mexico City in particular hosts the largest parade in Mexico, with a different theme each year.
The big parades and costumes are actually a relatively new addition to Dia de los Muertos celebrations - traditionally it was simply about remembering and honouring the dead. Families would go to the gravesites of loved ones, clean them, and even spend the night of the celebration at the cemetery, eating and drinking, perhaps singing and playing the guitar. The thinking behind it is the belief that the souls of those passed come back to earth on this night to visit their loved ones, so by celebrating in this way, families are in a sense spending time with those who have passed.
> Read More: Top 10 things to do in Mexico City
It should come as no surprise that Mexicans prepare a wide variety of dishes specifically for the day of the dead, since this celebration centres around offering deceased loved ones their favourite foods and drinks.
Traditional Day of the Dead foods include a hearty bowl of Sopa Azteca - a spicy tortilla soup, and Day of the Dead bread (pan de muertos), a sort of sugary sweet bun covered with bone-shaped bread embellishments decorating the top.
Oaxacan specialty, Mole Negro is also traditionally prepared during Dia de los Muertos, and the recipe for this richly-flavoured sauce is notoriously difficult to find outside of a family's vault.
> Read More: The best foods to try in Latin America
The centrepiece of Dia de los Muertos celebrations for the Mexican people is the Ofrenda, which consists of various gifts presented to deceased family members. The table is covered with a vividly coloured cloth, covered with pictures and mementoes of the deceased.
You will find the ofrendas in public spaces now, but most Mexicans will make individual ones in their own homes. Families in Mexico City will turn a table into an ofrenda, decorated with marigolds, candy skulls, photos of family that have passed, including family dogs and cats, and they will put those family members' favourite foods and drinks out on the table too, even including dog chow for the family pets.
If you don't want to miss out on this unique experience you should book your trip as soon as possible since it can get very busy during these days.
It is also a perfect opportunity to stick around for a bit longer and explore Mexico and its many highlights such as Teotihuacan or Chichen Itza and Playa del Carmen on our Signature Mexico Tour.
Explore the highlights of Mexico City, pyramids of the sun & moon, Xochimilco floating gardens, Merida, Chichen Itza & Caribbean beach stay!
Dive into the cuisine & culture of this UNESCO World Heritage city. Explore lively markets, local delicacies, and magnificent archaeological sites.
Signature Tours: Refined, Simplified, Perfected
Premium itineraries carefully crafted by destination experts. Take in the very best of South America and Central America, with highly-rated hotels and exclusive authentic experiences.
Discover iconic culture rich cities, charming towns, ancient Mayan ruins, local traditions and fantastic food as you explore Mexico in depth.