blogtngquery
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | blogtngquery [2009/11/06 17:03] (current) – created andi | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | <code sql> | ||
+ | |||
+ | SELECT DISTINCT A.pid | ||
+ | FROM tags C, entries A LEFT JOIN comments B ON A.pid = B.pid | ||
+ | WHERE A.blog IN (' | ||
+ | AND A.pid = C.pid | ||
+ | AND ( | ||
+ | C.tag = ' | ||
+ | C.tag = ' | ||
+ | | ||
+ | | ||
+ | ) | ||
+ | |||
+ | </ |
blogtngquery.txt · Last modified: 2009/11/06 17:03 by andi