i found this on conquer forums..
Quote:
And tell them I found my DBs and scrolls doing this:
SELECT name,COUNT(*) AS DBScrolls,last_login FROM cq_item LEFT JOIN cq_user ON cq_item.player_id = cq_user.id WHERE type=720028 GROUP BY name ORDER BY name
or:
SELECT name,COUNT(*) AS DBs,last_login FROM cq_item LEFT JOIN cq_user ON cq_item.player_id = cq_user.id WHERE type=1088000 GROUP BY name ORDER BY name
|