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"."ParentID", "BlogTree_versions"."Name", "BlogTree_versions"."InheritSideBar", "BlogTree_versions"."LandingPageFreshness", "BlogTree_versions"."SideBarID", "HomePage_versions"."ActivateLink", CASE WHEN "SiteTree_versions"."ClassName" IN ('HomePage') THEN "HomePage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('BoardMembersPage') THEN "BoardMembersPage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('ExOfficioPage') THEN "ExOfficioPage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('ExecutiveBoardMembersPage') THEN "ExecutiveBoardMembersPage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('GetToKnowPage') THEN "GetToKnowPage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('ProjectPage') THEN "ProjectPage_versions"."PhotoID" WHEN "SiteTree_versions"."ClassName" IN ('SafetyTipsPage') THEN "SafetyTipsPage_versions"."PhotoID" ELSE NULL END AS "PhotoID", "HomePage_versions"."MainImageLinkID", "ErrorPage_versions"."ErrorCode", "RedirectorPage_versions"."RedirectionType", "RedirectorPage_versions"."ExternalURL", "RedirectorPage_versions"."LinkToID", "VirtualPage_versions"."VersionID", "VirtualPage_versions"."CopyContentFromID", "BlogHolder_versions"."TrackBacksEnabled", "BlogHolder_versions"."AllowCustomAuthors", "BlogHolder_versions"."OwnerID", CASE WHEN "SiteTree_versions"."ClassName" IN ('BlogEntry') THEN "BlogEntry_versions"."Date" WHEN "SiteTree_versions"."ClassName" IN ('GetToKnowPage') THEN "GetToKnowPage_versions"."Date" WHEN "SiteTree_versions"."ClassName" IN ('SafetyTipsPage') THEN "SafetyTipsPage_versions"."Date" ELSE NULL END AS "Date", "BlogEntry_versions"."Author", "BlogEntry_versions"."Tags", "ImageGalleryPage_versions"."SortBy", "ImageGalleryPage_versions"."GalleryUI", "ImageGalleryPage_versions"."CoverImageWidth", "ImageGalleryPage_versions"."CoverImageHeight", "ImageGalleryPage_versions"."ThumbnailSize", "ImageGalleryPage_versions"."MediumSize", "ImageGalleryPage_versions"."Square", "ImageGalleryPage_versions"."NormalSize", "ImageGalleryPage_versions"."NormalHeight", "ImageGalleryPage_versions"."MediaPerPage", "ImageGalleryPage_versions"."UploadLimit", "ImageGalleryPage_versions"."RootFolderID", "BoardMembersPage_versions"."CompanyName", "BoardMembersPage_versions"."CompanyTitle", "BoardMembersPage_versions"."CompanyTitle2", "BoardMembersPage_versions"."CompanyURL", "Donate_versions"."ByCreditCard", "Donate_versions"."ByMail", "DonatePageUnrestricted_versions"."FiveDollarSingleUnrsctd", "DonatePageUnrestricted_versions"."FiveDollarMultipleUnrsctd", "DonatePageUnrestricted_versions"."TenDollarSingleUnrsctd", "DonatePageUnrestricted_versions"."TenDollarMultipleUnrsctd", "DonatePageUnrestricted_versions"."TwentyFiveDollarSingleUnrsctd", "DonatePageUnrestricted_versions"."TwentyFiveDollarMultipleUnrsctd", "DonatePageUnrestricted_versions"."FiftyDollarSingleUnrsctd", "DonatePageUnrestricted_versions"."FiftyDollarMultipleUnrsctd", "DonatePageUnrestricted_versions"."HundredDollarSingleUnrsctd", "DonatePageUnrestricted_versions"."HundredDollarMultipleUnrsctd", "ExOfficioPage_versions"."ExOfficioCompanyName", "ExOfficioPage_versions"."ExOfficioCompanyTitle", "ExOfficioPage_versions"."ExOfficioCompanyTitle2", "ExOfficioPage_versions"."ExOfficioCompanyURL", "ExecutiveBoardMembersPage_versions"."ExecutiveBoardTitle", "ExecutiveBoardMembersPage_versions"."ExecutiveCompanyName", "ExecutiveBoardMembersPage_versions"."ExecutiveCompanyTitle", "ExecutiveBoardMembersPage_versions"."ExecutiveCompanyTitle2", "ExecutiveBoardMembersPage_versions"."ExecutiveCompanyURL", "GetToKnowPage_versions"."Unit", "GetToKnowPage_versions"."Unit2", "GetToKnowPage_versions"."Rank", "PlatinumSponsorPage_versions"."PlatinumSummary", "ProjectPage_versions"."FiveDollarImage", "ProjectPage_versions"."FiveDollarSingle", "ProjectPage_versions"."FiveDollarMultiple", "ProjectPage_versions"."TenDollarImage", "ProjectPage_versions"."TenDollarSingle", "ProjectPage_versions"."TenDollarMultiple", "ProjectPage_versions"."TwentyFiveDollarImage", "ProjectPage_versions"."TwentyFiveDollarSingle", "ProjectPage_versions"."TwentyFiveDollarMultiple", "ProjectPage_versions"."FiftyDollarImage", "ProjectPage_versions"."FiftyDollarSingle", "ProjectPage_versions"."FiftyDollarMultiple", "ProjectPage_versions"."HundredDollarImage", "ProjectPage_versions"."HundredDollarSingle", "ProjectPage_versions"."HundredDollarMultiple", "ProjectPage_versions"."ItemOneName", "ProjectPage_versions"."ItemOneAmount", "ProjectPage_versions"."ItemOneSingleDonation", "ProjectPage_versions"."ItemOneMultiDonation", "ProjectPage_versions"."ItemTwoName", "ProjectPage_versions"."ItemTwoAmount", "ProjectPage_versions"."ItemTwoSingleDonation", "ProjectPage_versions"."ItemTwoMultiDonation", "ProjectPage_versions"."ItemThreeName", "ProjectPage_versions"."ItemThreeAmount", "ProjectPage_versions"."ItemThreeSingleDonation", "ProjectPage_versions"."ItemThreeMultiDonation", "ProjectPage_versions"."ItemFourName", "ProjectPage_versions"."ItemFourAmount", "ProjectPage_versions"."ItemFourSingleDonation", "ProjectPage_versions"."ItemFourMultiDonation", "ProjectPage_versions"."ImageCaption", "UserDefinedForm_versions"."SubmitButtonText", "UserDefinedForm_versions"."OnCompleteMessage", "UserDefinedForm_versions"."ShowClearButton", "UserDefinedForm_versions"."DisableSaveSubmissions", "LargeDonateFormPage_versions"."GeneralButtontoPaypal", "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 "BlogTree_versions" ON "BlogTree_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "BlogTree_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "HomePage_versions" ON "HomePage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "HomePage_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 "BlogHolder_versions" ON "BlogHolder_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "BlogHolder_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "BlogEntry_versions" ON "BlogEntry_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "BlogEntry_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "ImageGalleryPage_versions" ON "ImageGalleryPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "ImageGalleryPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "BoardMembersPage_versions" ON "BoardMembersPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "BoardMembersPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "Donate_versions" ON "Donate_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "Donate_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "DonatePageUnrestricted_versions" ON "DonatePageUnrestricted_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "DonatePageUnrestricted_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "ExOfficioPage_versions" ON "ExOfficioPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "ExOfficioPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "ExecutiveBoardMembersPage_versions" ON "ExecutiveBoardMembersPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "ExecutiveBoardMembersPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "GetToKnowPage_versions" ON "GetToKnowPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "GetToKnowPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "PlatinumSponsorPage_versions" ON "PlatinumSponsorPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "PlatinumSponsorPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "ProjectPage_versions" ON "ProjectPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "ProjectPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "SafetyTipsPage_versions" ON "SafetyTipsPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "SafetyTipsPage_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "UserDefinedForm_versions" ON "UserDefinedForm_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "UserDefinedForm_versions"."Version" = "SiteTree_versions"."Version" LEFT JOIN "LargeDonateFormPage_versions" ON "LargeDonateFormPage_versions"."RecordID" = "SiteTree_versions"."RecordID" AND "LargeDonateFormPage_versions"."Version" = "SiteTree_versions"."Version" WHERE ("SiteTree_versions"."RecordID" = 163) ORDER BY "SiteTree_versions"."Version" DESC LIMIT 1
2010-10-20 18:13:37
2011-12-28 17:59:04
photogallery
Photo Gallery
Photo Gallery
1
1
0
7
0
0
Saved (update)
Inherit
Inherit
25
0.9
2
163
163
1
14
14
Line 920 in /nfs/c08/h02/mnt/122788/domains/phillypolicefoundation.org/html/sapphire/core/model/Versioned.php
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 }