SELECT DISTINCTROW T0.tag, COUNT(B.bId) AS bCount FROM sc_bookmarks AS B, sc_tags AS T0, sc_tags AS T1 WHERE B.bId = T0.bId AND B.bPost = "Y" AND B.bStatus = 0 AND T1.bId = B.bId AND T1.tag = "demands" AND T0.tag <> "demands" AND LEFT(T0.tag, 7) <> "system:" GROUP BY T0.tag ORDER BY bCount DESC, T0.tag
LIMIT 10 in /home/admin/domains/racehome.net/public_html/includes/db/mysql4.php on line 390