Skip to content

Instantly share code, notes, and snippets.

@ashleygwilliams

ashleygwilliams/gist:4e44b237dc95fbd32a1b

Created August 20, 2015 17:14
Show Gist options
  • Save ashleygwilliams/4e44b237dc95fbd32a1b to your computer and use it in GitHub Desktop.
Save ashleygwilliams/4e44b237dc95fbd32a1b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT * FROM projects INNER JOIN pages ON pages.project_id = projects
s INNER JOIN count(elements) AS element_count ON elements.page_id = pages.id WHERE element_count > 5;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment