} else {

$resulte = dbquery("

SELECT tf.forum_id, tt.thread_id, tt.thread_subject, COUNT(tp.post_id) as count_posts

FROM ".$db_prefix."forums tf

INNER JOIN ".$db_prefix."threads tt USING(forum_id)

INNER JOIN ".$db_prefix."posts tp USING(thread_id)

WHERE forum_access<='".iUSER."'

GROUP BY thread_id

ORDER BY count_posts DESC, thread_lastpost DESC

[color=red]LIMIT 10[/color]

");

if (dbrows($resulte) != 0) {

echo "<table width='100%' cellpadding='0' cellspacing='0'>\n";

while($datae = dbarray($resulte)) {

$itemsubjectt = trimlink($datae['thread_subject'], 17);

echo "<tr>\n<td align='left'> - <a href='".FORUM."viewthread.php?forum_id=".$datae['forum_id']."&thread_id=".$datae['thread_id']."' class='side'>$itemsubjectt</a></td>

<td align='right' >[".($datae['count_posts']-1)."]</td>\n</tr>\n";ect</a><br>\n";ct</a><br>\n"; align='right'



class='side-small'>[".($data['count_posts']-1)."]</td>\n</tr>\n";



} }

echo "</table>\n";

echo "</td>