clemens (owner)

Revisions

gist: 79825 Download_button fork
public
Public Clone URL: git://gist.github.com/79825.git
Embed All Files: show embed
SQL #
raw 
1
2
3
4
5
6
7
8

SELECT * FROM locations
WHERE (
  SELECT COUNT(*) FROM taggings
  WHERE tag_id IN (
    SELECT tags.id FROM tags
    WHERE tags.name = 'Bar' OR tags.name = 'Restaurant'
  ) AND taggable_type = 'Location' AND taggable_id = locations.id
) > 1