madrobby (owner)

Revisions

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

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