$id = (int)$_GET['id'];
$forums = SqlQuery("
SELECT
f.*,
".UserFields("u").",
".($login?"r.date rdate,":'')."
t.title ttitle,
c.id cid,
c.order corder,
c.title ctitle
FROM
forums f
LEFT JOIN
users u ON u.id=f.lastthreaduser
LEFT JOIN
categories c ON c.id=f.cat
LEFT JOIN
threads t ON t.id=f.lastthreadid
".($login?"LEFT JOIN forumsread r ON r.id=f.id AND r.userid={$myuserid} ":'')."
".($id ? "
WHERE f.cat={$id}
" : "")."
ORDER BY c.order, c.id, f.id
");