Skip to content

Instantly share code, notes, and snippets.

@ss23

ss23/buggy.sql

Created August 8, 2013 07:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ss23/6182397 to your computer and use it in GitHub Desktop.
Save ss23/6182397 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
buggy.sql
SELECT DISTINCT "SiteTree_Live"."ClassName"
FROM "SiteTree_Live"
LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("ClassName" = 'Page') AND ("SiteTree_Live"."ClassName" IN ('Page','XmlPage','AnalysisXmlPage','SiteXmlPage','GoogleMapPage','ArchivePage','AtoZPage','EventsPage','HomePage','MapPage','NewsListPage','NewsPage','NoticeListPage','NoticePage','RSSFeedsInPage','SiteMap','Tier1LandingPage','Tier2LandingPage','Tier3LandingPage','CemeteryPage','RatesPage','RSSReportPage','SilentOnePage','ErrorPage','RedirectorPage','VirtualPage','PaymentPage','UserDefinedForm','EverythingEmailUserDefinedForm','ReferrerForm'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment