[Xenon]

hmm, it doesn't look wrong, seems everything is ok, but you should make it better readable:
also the lastpost < time() - 0 is not needed...

PHP Code:

<?
$threads = $DB_site->fetch_array($DB_site->query("SELECT COUNT(*) as total FROM thread WHERE forumid IN (143,162,161,163,145,153,164,155,167,158,165,166,127)"));
echo number_format($threads[total]);
?>

and yes, it's just counting the thread ammount, not the replies,