$result = dbquery("SELECT tn.*, tu.user_id,user_name ,COUNT(comment_item_id) AS news_comments







FROM fusion_news tn







LEFT JOIN fusion_users tu ON tn.news_name=tu.user_id







LEFT JOIN fusion_comments ON news_id=comment_item_id AND comment_type='N'







GROUP BY news_id







ORDER BY news_comments DESC LIMIT 0,5");







$rows = dbrows($result);







if ($rows != 0) {







while ($row = mysql_fetch_array($result))







{







echo "<right><table width='100%'>















<tr><td width='40%'></td><td width='60%'>







<img src='".THEME."images/bullet.gif' alt=''>







<a href='".BASEDIR."news.php?readmore=".$row['news_id']."'>".trimlink($row['news_subject'], 35)."</a> (".$row['news_comments'].")<br>







</td></tr></table></right>";