0002: SHOW DATABASES LIKE 'vivaexp\_silverstripe\_ss5'
0.0002s
0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW'
0.0004s
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.0005s
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.0002s
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-14 12:43:21')
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 "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0013: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0003s
0014: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0015: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0016: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0002s
0017: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0018: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0019: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ShowInMenus" = ?)
AND ("SiteTree_Live"."ParentID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0003s
0020: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0021: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ParentID" <> "SiteTree_Live"."ID")
AND ("SiteTree_Live"."ParentID" = ?)
AND ("SiteTree_Live"."ShowInMenus" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
0.0002s
0022: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" INNER JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ParentID" = ?)
AND (("SiteTree_Live"."ID" != ? OR "SiteTree_Live"."ID" IS NULL))
AND ("SiteTree_Live"."ShowInMenus" = ?)
AND ("PublishDate" < '2025-08-14 12:43:21')
ORDER BY "SiteTree_Live"."Sort" ASC
0.0011s
0023: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0024: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0025: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0026: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0027: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited")
FROM "SiteTree_Live"
0.0001s
0028: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count"
FROM "SiteTree_Live"
0.0001s
0029: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0030: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0031: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0032: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0033: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0034: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0035: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourRegion_Live"."ImportKey", "VivaTourRegion_Live"."MapLatitude", "VivaTourRegion_Live"."MapLongitude", "VivaTourRegion_Live"."MapZoom", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ParentID" = ?)
AND ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0004s
0036: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0002s
0037: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0038: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
ORDER BY "VivaTourCategoryObject_Live"."SortOrder" ASC
0.0008s
0039: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0040: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0041: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0003s
0042: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0043: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0044: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live"
WHERE ("VivaTourCategoryObject_Live"."ParentID" <> "VivaTourCategoryObject_Live"."ID")
AND ("VivaTourCategoryObject_Live"."ParentID" = ?)
0.0002s
0045: SELECT DISTINCT "VivaTourCategoryObject_Live"."ClassName", "VivaTourCategoryObject_Live"."LastEdited", "VivaTourCategoryObject_Live"."Created", "VivaTourCategoryObject_Live"."Version", "VivaTourCategoryObject_Live"."SidebarBoxMainText", "VivaTourCategoryObject_Live"."Name", "VivaTourCategoryObject_Live"."DisplayLabel", "VivaTourCategoryObject_Live"."NavigationLabel", "VivaTourCategoryObject_Live"."CustomSubtitle", "VivaTourCategoryObject_Live"."Slug", "VivaTourCategoryObject_Live"."Intro", "VivaTourCategoryObject_Live"."Description", "VivaTourCategoryObject_Live"."SpecialBarText", "VivaTourCategoryObject_Live"."MetaTitle", "VivaTourCategoryObject_Live"."MetaDescription", "VivaTourCategoryObject_Live"."TrustPilotTag", "VivaTourCategoryObject_Live"."SortOrder", "VivaTourCategoryObject_Live"."FeaturedToursHeader", "VivaTourCategoryObject_Live"."SidebarBoxPrimaryCallToActionLinkID", "VivaTourCategoryObject_Live"."SidebarBoxBackgroundImageID", "VivaTourCategoryObject_Live"."ParentID", "VivaTourCategoryObject_Live"."SpecialBarCallToActionLinkID", "VivaTourStyle_Live"."ImportKey", "VivaTourStyle_Live"."HideOnHolder", "VivaTourStyle_Live"."HideOnTour", "VivaTourStyle_Live"."HideStyle", "VivaTourStyle_Live"."StyleIcon", "VivaTourStyle_Live"."RegionAgnosticIntro", "VivaTourStyle_Live"."RegionAgnosticDescription", "VivaTourCategoryObject_Live"."ID",
CASE WHEN "VivaTourCategoryObject_Live"."ClassName" IS NOT NULL THEN "VivaTourCategoryObject_Live"."ClassName"
ELSE 'VivaTourCategoryObject' END AS "RecordClassName"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0005s
0046: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0047: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourRegion_Live" ON "VivaTourRegion_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0048: SELECT DISTINCT MAX("VivaTourCategoryObject_Live"."LastEdited")
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0049: SELECT DISTINCT count(DISTINCT "VivaTourCategoryObject_Live"."ID") AS "Count"
FROM "VivaTourCategoryObject_Live" LEFT JOIN "VivaTourStyle_Live" ON "VivaTourStyle_Live"."ID" = "VivaTourCategoryObject_Live"."ID"
WHERE ("VivaTourCategoryObject_Live"."ClassName" IN (?))
0.0001s
0050: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "ContactPage_Live"."MainContactEmail", "ContactPage_Live"."MainContactSkype", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "ContactPage_Live" ON "ContactPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0004s
0051: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0052: SELECT DISTINCT "BlogCategory"."ClassName", "BlogCategory"."LastEdited", "BlogCategory"."Created", "BlogCategory"."Title", "BlogCategory"."URLSegment", "BlogCategory"."BlogID", "BlogCategory"."ID",
CASE WHEN "BlogCategory"."ClassName" IS NOT NULL THEN "BlogCategory"."ClassName"
ELSE 'SilverStripe\\Blog\\Model\\BlogCategory' END AS "RecordClassName"
FROM "BlogCategory" INNER JOIN "BlogPost_Categories" ON "BlogPost_Categories"."BlogCategoryID" = "BlogCategory"."ID"
WHERE ("BlogPost_Categories"."BlogPostID" = ?)
LIMIT 1
0.0002s
0053: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0054: SELECT DISTINCT "StaffMember"."ClassName", "StaffMember"."LastEdited", "StaffMember"."Created", "StaffMember"."FirstName", "StaffMember"."Surname", "StaffMember"."Position", "StaffMember"."Email", "StaffMember"."Description", "StaffMember"."SortOrder", "StaffMember"."ProfileImageID", "StaffMember"."BannerImageID", "StaffMember"."ID",
CASE WHEN "StaffMember"."ClassName" IS NOT NULL THEN "StaffMember"."ClassName"
ELSE 'StaffMember' END AS "RecordClassName"
FROM "StaffMember"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
0.0001s
0055: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0056: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."Flag", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "Image_Live"."FocusPointWidth", "Image_Live"."FocusPointHeight", "File_Live"."ID",
CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName"
ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName"
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID"
WHERE ("File_Live"."ID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))
ORDER BY "File_Live"."Name" ASC
LIMIT 1
0.0002s
0057: SELECT DISTINCT "Member"."ClassName", "Member"."LastEdited", "Member"."Created", "Member"."URLSegment", "Member"."BlogProfileSummary", "Member"."FirstName", "Member"."Surname", "Member"."Email", "Member"."TempIDHash", "Member"."TempIDExpired", "Member"."Password", "Member"."AutoLoginHash", "Member"."AutoLoginExpired", "Member"."PasswordEncryption", "Member"."Salt", "Member"."PasswordExpiry", "Member"."LockedOutUntil", "Member"."Locale", "Member"."FailedLoginCount", "Member"."BlogProfileImageID", "Member"."StaffProfileID", "Member"."ID",
CASE WHEN "Member"."ClassName" IS NOT NULL THEN "Member"."ClassName"
ELSE 'SilverStripe\\Security\\Member' END AS "RecordClassName"
FROM "Member" INNER JOIN "BlogPost_Authors" ON "BlogPost_Authors"."MemberID" = "Member"."ID"
WHERE ("BlogPost_Authors"."BlogPostID" = ?)
ORDER BY "Member"."Surname" ASC, "Member"."FirstName" ASC
LIMIT 1
0.0003s
0058: SELECT CASE WHEN EXISTS(SELECT *
FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" INNER JOIN "BlogPost_Images" ON "BlogPost_Images"."ImageID" = "File_Live"."ID"
WHERE ("BlogPost_Images"."BlogPostID" = ?)
AND ("File_Live"."ClassName" IN (?, ?, ?, ?))) THEN 1 ELSE 0 END
0.0002s
0059: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0003s
0060: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0061: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0062: SELECT DISTINCT MAX("VivaDataObjectAsPage_Live"."LastEdited")
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0063: SELECT DISTINCT MAX("VivaStaticSpecial"."LastEdited")
FROM "VivaStaticSpecial"
0.0001s
0064: SELECT DISTINCT count(DISTINCT "VivaDataObjectAsPage_Live"."ID") AS "Count"
FROM "VivaDataObjectAsPage_Live" LEFT JOIN "VivaTour_Live" ON "VivaTour_Live"."ID" = "VivaDataObjectAsPage_Live"."ID"
WHERE ("VivaDataObjectAsPage_Live"."ClassName" IN (?))
0.0002s
0065: SELECT DISTINCT "StaffMember"."ClassName", "StaffMember"."LastEdited", "StaffMember"."Created", "StaffMember"."FirstName", "StaffMember"."Surname", "StaffMember"."Position", "StaffMember"."Email", "StaffMember"."Description", "StaffMember"."SortOrder", "StaffMember"."ProfileImageID", "StaffMember"."BannerImageID", "StaffMember"."ID",
CASE WHEN "StaffMember"."ClassName" IS NOT NULL THEN "StaffMember"."ClassName"
ELSE 'StaffMember' END AS "RecordClassName"
FROM "StaffMember"
WHERE ("StaffMember"."ID" = ?)
LIMIT 1
0.0001s
0066: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ClassName" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0067: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "Page_Live"."PreviewImageID", "VivaPage_Live"."PageHeader", "VivaPage_Live"."NewsletterPopupToShow", "VivaPage_Live"."HeroImageID", "OurStoryPage_Live"."Subtitle", "OurStoryPage_Live"."Tagline", "OurStoryPage_Live"."OperationsText", "OurStoryPage_Live"."PersonalisedItinerariesText", "OurStoryPage_Live"."LittleThingsTitle", "OurStoryPage_Live"."LittleThingsText", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "VivaPage_Live" ON "VivaPage_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "OurStoryPage_Live" ON "OurStoryPage_Live"."ID" = "SiteTree_Live"."ID"
WHERE ("SiteTree_Live"."ClassName" IN (?))
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0068: SELECT "Version" FROM "SiteTree" WHERE "ID" = ?
0.0001s
0069: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0070: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0071: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
0072: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."FocusKeyword", "SiteTree"."MetaKeywords", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."FacebookTitle", "SiteTree"."FacebookDescription", "SiteTree"."TwitterTitle", "SiteTree"."TwitterDescription", "SiteTree"."MetaRobotsFollow", "SiteTree"."MetaRobotsIndex", "SiteTree"."CanonicalURL", "SiteTree"."TrackingCodes", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."FacebookImageID", "SiteTree"."TwitterImageID", "SiteTree"."MetaTitleTemplateID", "SiteTree"."ParentID", "SiteTree"."ID",
CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree"
WHERE ("SiteTree"."ID" = ?)
ORDER BY "SiteTree"."Sort" ASC
LIMIT 1
0.0005s
0073: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0005s
0074: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."FocusKeyword", "SiteTree_Live"."MetaKeywords", "SiteTree_Live"."MetaTitle", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."FacebookTitle", "SiteTree_Live"."FacebookDescription", "SiteTree_Live"."TwitterTitle", "SiteTree_Live"."TwitterDescription", "SiteTree_Live"."MetaRobotsFollow", "SiteTree_Live"."MetaRobotsIndex", "SiteTree_Live"."CanonicalURL", "SiteTree_Live"."TrackingCodes", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."FacebookImageID", "SiteTree_Live"."TwitterImageID", "SiteTree_Live"."MetaTitleTemplateID", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID",
CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName"
ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName"
FROM "SiteTree_Live"
WHERE ("SiteTree_Live"."ID" = ?)
ORDER BY "SiteTree_Live"."Sort" ASC
LIMIT 1
0.0002s
The weirdest wildlife in the Galapagos Islands | Viva Expeditions
We’re not saying that the unique creatures of the Galapagos are a bunch of weirdos but, to be brutally honest, they really are. Between the waltzing bird, the cannibal crab, the freediving lizard and the turtle that takes the intermittent dieting fad to epic levels, the issue isn’t finding bizarre wildlife on your Galapagos tour…the issue is finding ones that seem totally ordinary!
Your challenge, if you wish to accept it, is to pack your bags, head on over to South America on a whirlwind wildlife-spotting tour and come meet some of the world’s most distinctive, confounding and awe-inspiring animals.
The weirdest wildlife on the Galapagos Islands? That’s just what happens when nature is left to evolve to her own beat.
The master of its domain, the Marine Iguana lives as contentedly on land as it does out at sea, the only lizard on earth that takes to swimming so naturally. Diving to depths of 30m, marine iguanas survive by holding their breath underwater, an impressive feat they can keep up for up to 30 minutes at a time! Stranger still, they have the ability to extract salt from sea water, which they expel – rather speedily – from glands located right next to their nostrils. These guys sneeze salt! What’s really amazing about these aquatic lizards, however, is the fact that they can shrink and grow in size depending on the climate and availability of food, a stunning and very unique adaptation to El Nino which scientists have only recently discovered.
Iguana in the Galapagos
Blue-footed Boobies
It is often said that every group needs a clown and, in the case of the Galapagos wildlife, that honour befalls the dude with the blue floppy feet. This adorable bird with the cute name is one of the Galapagos’ most beloved creatures, its sweet waddle and ever-startled expression making it seem more like a satirical caricature than an actual animal. Used to shelter chicks in the first few weeks of life, the wide, floppy, bright blue feet of the Booby are an essential tool for courtship, being waved around in a waltz-like dance that is beyond gorgeous to see. Witnessing this mesmerizing courtship display is one of the most rewarding wildlife spotting experiences you can have on a Galapagos cruise. Interestingly enough, the name Booby derives from the Spanish’ bobo’ – which means clown – a most apt wildlife name if ever there was one.
Blue-footed Boobies
Sally Lightfoot Crabs
This cunning scavenger feeds on whatever it can find (sounds eerily familiar), including ticks which stubbornly hang on to marine iguanas and even devouring fellow crabs, both dead and alive (at least I draw the line at ticks and live crabs though, to be honest). The greedy guts of the Galapagos are not unique to these islands – they can also be spotted along the Central and South American western coastline – yet here they play a pivotal role in the ecosystem, keeping it clean and waste-free. Agile, swift and beautifully tinted, they are among the most photogenic subjects you’ll discover on your Galapagos cruise.
Mother Nature’s most colourful waste disposal units!
Sally Lightfoot Crabs
Hammerhead Sharks
It may look like it’s been hit in the snout with a ginormous hammer – part of the reason it makes such a great character in animated movies – yet this comical creature is one of the most formidable hunters of the Galapagos seas. A cunning and lightning-fast predator, the hammerhead shark has the ability to see both below and above itself thanks to its wide-set eyes so it’s an animal that’s impossible to sneak up to. Luckily, they are docile and not known to attack humans and are the main drawcard for SCUBA divers on Galapagos cruises. They’re also particularly rewarding to see in the Galapagos because they congregate in tremendous numbers here, up to 100 individuals, something that only occurs in a few rare places on earth. For divers and snorkellers, this makes for a Galapagos wildlife-spotting extravaganza.
Hammerhead Sharks
Giant Tortoise
If the Galapagos can be said to have a King in its jungle (or rather, its volcanic rocky outcrops) than the Giant Tortoise would have to be it. Living to a staggering age of 100 years on average (the highest of any vertebrate on the planet) the magnificent Giant Tortoise is the poster child of these incredibly unique islands. Aside from age and size (they can grow up to 1,5m in height and weigh as much as 230kg) its most impressive superpower is the ability to go without food or water for 12 whole months. During the days when whaling was so prolific in this region, this made them a very desirable food source for seafaring visitors and is the primary reason they are now endangered. So many were taken on board as live food that certain islands have been left devoid of their specific breed. In total, the Galapagos is thought to have been home to 18 very distinct species of Giant Tortoises yet, nowadays, only 14 remain.
Giant Tortoise
Galapagos Wildlife Conservation Initiatives
This outstanding archipelago may have been a hub for pirates and whalers in years gone by but today the Galapagos are fervently protected – and so are all the weirdest creatures who thrive on their nutrient-rich waters. Wildlife conservation initiatives in the Galapagos are not only comprehensive but also ever-growing, many involved with protecting the weakest species, the ones most at risk from imported predators such as rats – believed to have been carried over via ships in the 18th century.
For Galapagos cruise passengers on wildlife-spotting trips, restrictions apply as to when and where they can make landfall, how many guests can disembark on an island at any given time, and which islands they are allowed to visit. This is nothing new here, the Galapagos comprising a protected national park that’s considered the world’s primordial responsible-tourism destination – conservation initiatives have been in place here for almost half a century, long before the term ‘eco-tourism’ ever became mainstream. We hope the Ecuadorian Government continues to strive to keep these islands pristine and unspoiled and we’ll certainly continue to operate following the strictest regulations for tourism operators. It’s the very least the weirdest wildlife on the Galapagos Islands deserve.
Galapagos Islands
The best way to see wildlife in the Galapagos
Given the number of islands, their distance and the above-mentioned restrictions, the best way to see wildlife on the Galapagos is on dedicated wildlife-spotting cruises. Small ship cruising here affords the best of it all: less time travelling (as most sailing is done at night), more time on land and more time SCUBA diving and snorkelling in search of the fascinating marine life for which this place is legendary. We also offer a few excellent island-based tours (if you’re not a cruising fan) and although your wildlife-spotting experiences will not be as comprehensive, lodge-based stays (whereby you take day trips out to nearby islands) are still immensely rewarding.
Because as we love to say: even just a single day in the Galapagos is better than 100 days anywhere else on earth.
As always, we’re here to answer any question you may have. If a Galapagos wildlife-spotting cruise is on your bucket-list, make TODAY the day you do something about it! Contact us, right here.
Laura Pattara
Laura Pattara writes for Viva Expeditions with a special love for all things Latin America. She had guided overland tours across the continent, reached Machu Picchu five times on foot, and even dressed up as a giant toucan for Carnaval. With a degree in languages and two decades of global travel experience behind her, Laura has a long-standing love for the Andes, soaring condors, and a truly delicious empanada.