10 most recently active forum threads |
SELECT t.tid, t.fid, t.subject, t.lastpost, t.views
FROM oteil_xmb_threads as t,oteil_xmb_forums as f
WHERE f.fid = t.fid AND (f.userlist = '' AND f.private = '')
ORDER BY t.lastpost desc, t.views desc LIMIT 0, 10Table 'htw721.oteil_xmb_threads' doesn't exist |
|
|