Skip to content

Instantly share code, notes, and snippets.

@madrobby

madrobby/gist:29443

Created November 26, 2008 16:51
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 madrobby/29443 to your computer and use it in GitHub Desktop.
Save madrobby/29443 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
sqlite> SELECT * FROM ENTRIES_TAGS WHERE TAG_ID IN (58, 59);
140|58
141|59
142|58
142|59
sqlite> SELECT DISTINCT ENTRIES.ID FROM ENTRIES INNER JOIN ENTRIES_TAGS ON (ENTRIES.ID = ENTRIES_TAGS.ENTRY_ID) WHERE ENTRIES_TAGS.TAG_ID = 59 INTERSECT SELECT DISTINCT ENTRIES.ID FROM ENTRIES INNER JOIN ENTRIES_TAGS ON (ENTRIES.ID = ENTRIES_TAGS.ENTRY_ID) WHERE ENTRIES_TAGS.TAG_ID = 58;
142
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment