---

Debug (Versioned::get_latest_version() in line 918 of Versioned.php)

SELECT "SiteTree_versions"."ClassName", "SiteTree_versions"."Created", "SiteTree_versions"."LastEdited", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaTitle", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."MetaKeywords", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."HomepageForDomain", "SiteTree_versions"."ProvideComments", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."Status", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."ToDo", "SiteTree_versions"."Version", "SiteTree_versions"."Priority", "SiteTree_versions"."Locale", "SiteTree_versions"."ParentID", "Page_versions"."HeaderContent", "Page_versions"."ShowSponsores", "Page_versions"."ShowInHeadMenu", "Page_versions"."HeaderImageID", "Gallery_versions"."ParentFolderID", CASE WHEN "SiteTree_versions"."ClassName" IN ('News') THEN "News_versions"."Datum" WHEN "SiteTree_versions"."ClassName" IN ('PresseArtikel') THEN "PresseArtikel_versions"."Datum" ELSE NULL END AS "Datum", "News_versions"."Saison", CASE WHEN "SiteTree_versions"."ClassName" IN ('News') THEN "News_versions"."Kategorie" WHEN "SiteTree_versions"."ClassName" IN ('PresseArtikel') THEN "PresseArtikel_versions"."Kategorie" ELSE NULL END AS "Kategorie", "Page2col_versions"."ExtraContent", "Page2col_versions"."Orientation", "Page2col_versions"."Colsize", "PresseArtikel_versions"."Subline", "PresseArtikel_versions"."Medium", "PresseArtikel_versions"."Link", "PresseArtikel_versions"."ArtikelPhotoID", "TeamGroup_versions"."GroupType", "ErrorPage_versions"."ErrorCode", "RedirectorPage_versions"."RedirectionType", "RedirectorPage_versions"."ExternalURL", "RedirectorPage_versions"."LinkToID", "VirtualPage_versions"."VersionID", "VirtualPage_versions"."CopyContentFromID", "Sponsor_versions"."Sponsortype", CASE WHEN "SiteTree_versions"."ClassName" IN ('Sponsor') THEN "Sponsor_versions"."Homepage" WHEN "SiteTree_versions"."ClassName" IN ('Event') THEN "Event_versions"."Homepage" ELSE NULL END AS "Homepage", "Sponsor_versions"."ImageID", CASE WHEN "SiteTree_versions"."ClassName" IN ('Event') THEN "Event_versions"."NewsTags" WHEN "SiteTree_versions"."ClassName" IN ('Rennwagen') THEN "Rennwagen_versions"."NewsTags" ELSE NULL END AS "NewsTags", "Event_versions"."Ort", "Event_versions"."Rennstrecke", "YoutubeGallery_versions"."Method", "YoutubeGallery_versions"."User", "YoutubeGallery_versions"."Query", "YoutubeGallery_versions"."CategoryTag", "YoutubeGallery_versions"."Playlist", "YoutubeGallery_versions"."PerPage", "YoutubeGallery_versions"."ShowVideoInPopup", "YoutubeGallery_versions"."Sortby", "Rennwagen_versions"."SizeL", "Rennwagen_versions"."SizeB", "Rennwagen_versions"."SizeH", "Rennwagen_versions"."Motor", "Rennwagen_versions"."Hubraum", "Rennwagen_versions"."Gemischaufbereitung", "Rennwagen_versions"."Motorsteuerung", "Rennwagen_versions"."Upm", "Rennwagen_versions"."Nennleistung", "Rennwagen_versions"."Nennleistung_upm", "Rennwagen_versions"."Nennleistung_info", "Rennwagen_versions"."Drehmoment", "Rennwagen_versions"."Drehmoment_upm", "Rennwagen_versions"."Differential", "Rennwagen_versions"."Uebersetzung_von", "Rennwagen_versions"."Uebersetzung_auf", "Rennwagen_versions"."Chassis", "Rennwagen_versions"."Leergewicht", "Rennwagen_versions"."Radstand", "Rennwagen_versions"."Spurweite_vorne", "Rennwagen_versions"."Spurweite_hinten", "Rennwagen_versions"."Radaufhaengung", "Rennwagen_versions"."Daempfer", "Rennwagen_versions"."Felgen", "Rennwagen_versions"."Bremsen", "Rennwagen_versions"."Elektronik", "Rennwagen_versions"."Besonderheiten", "SiteTree_versions"."ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."Version", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID", "SiteTree_versions"."RecordID" AS "ID" FROM "SiteTree_versions" LEFT JOIN "Page_versions" ON "Page_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Page_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Gallery_versions" ON "Gallery_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Gallery_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "News_versions" ON "News_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "News_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Page2col_versions" ON "Page2col_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Page2col_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "PresseArtikel_versions" ON "PresseArtikel_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "PresseArtikel_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "TeamGroup_versions" ON "TeamGroup_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "TeamGroup_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "ErrorPage_versions" ON "ErrorPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "ErrorPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "RedirectorPage_versions" ON "RedirectorPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "RedirectorPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "VirtualPage_versions" ON "VirtualPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "VirtualPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Sponsor_versions" ON "Sponsor_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Sponsor_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Event_versions" ON "Event_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Event_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "YoutubeGallery_versions" ON "YoutubeGallery_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "YoutubeGallery_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Rennwagen_versions" ON "Rennwagen_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Rennwagen_versions"."Version" = "SiteTree_versions"."Version" WHERE ("SiteTree_versions"."RecordID" = 212) AND ("SiteTree_versions"."Locale" = 'de_DE') ORDER BY "SiteTree_versions"."Version" DESC LIMIT 1

---

Debug (Versioned::get_latest_version() in line 919 of Versioned.php)

• ClassName =

• Created =

  2011-03-07 12:16:45

• LastEdited =

  2011-03-07 12:21:49

• URLSegment =

  metzgerei-georg-specht

• Title =

  Metzgerei Georg Specht

• MenuTitle =

• Content =

• MetaTitle =

• MetaDescription =

• MetaKeywords =

• ExtraMeta =

• ShowInMenus =

  1

• ShowInSearch =

  1

• HomepageForDomain =

• ProvideComments =

  0

• Sort =

  44

• HasBrokenFile =

  0

• HasBrokenLink =

  0

• Status =

  Saved (update)

• ReportClass =

• CanViewType =

  Inherit

• CanEditType =

  Inherit

• ToDo =

• Version =

  2

• Priority =

  0.9

• Locale =

  de_DE

• ParentID =

  26

• HeaderContent =

• ShowSponsores =

  1

• ShowInHeadMenu =

  0

• HeaderImageID =

  0

• ParentFolderID =

• Datum =

• Saison =

• Kategorie =

• ExtraContent =

• Orientation =

• Colsize =

• Subline =

• Medium =

• Link =

• ArtikelPhotoID =

• GroupType =

• ErrorCode =

• RedirectionType =

• ExternalURL =

• LinkToID =

• VersionID =

• CopyContentFromID =

• Sponsortype =

• Homepage =

• ImageID =

• NewsTags =

• Ort =

• Rennstrecke =

• Method =

• User =

• Query =

• CategoryTag =

• Playlist =

• PerPage =

• ShowVideoInPopup =

• Sortby =

• SizeL =

• SizeB =

• SizeH =

• Motor =

• Hubraum =

• Gemischaufbereitung =

• Motorsteuerung =

• Upm =

• Nennleistung =

• Nennleistung_upm =

• Nennleistung_info =

• Drehmoment =

• Drehmoment_upm =

• Differential =

• Uebersetzung_von =

• Uebersetzung_auf =

• Chassis =

• Leergewicht =

• Radstand =

• Spurweite_vorne =

• Spurweite_hinten =

• Radaufhaengung =

• Daempfer =

• Felgen =

• Bremsen =

• Elektronik =

• Besonderheiten =

• ID =

  212

• RecordClassName =

• RecordID =

  212

• WasPublished =

  1

• AuthorID =

  2

• PublisherID =

  2

911 		$query = singleton($class)->buildVersionSQL("\"{$baseTable}\".\"RecordID\" = $id", "\"{$baseTable}\".\"Version\" DESC");
912 		$query->limit = 1;
913 		$record = $query->execute()->record();
914 		if(!$record) return;
915 		
916 		$className = $record['ClassName'];
917 		if(!$className) {
918 			Debug::show($query->sql());
919 			Debug::show($record);
920 			user_error("Versioned::get_version: Couldn't get $class.$id", E_USER_ERROR);
921 		}
922 
923 		Versioned::set_reading_mode($oldMode);
924 
925 		return new $className($record);
926 	}