$result = dbquery("SELECT a.*, (SELECT AVG(rating_vote)

   FROM ".$db_prefix."ratings r

   WHERE r.rating_type='A'

   AND (r.rating_item_id = a.article_id)) as 'ratcount'

   FROM ".$db_prefix."articles a ORDER BY ratcount DESC LIMIT 20

");



openside("<center>TOP 20");

echo"<table border=0 cellspacing=1 cellpadding=0 width='100%' class'tbl-border'><tr><td class='tbl2'>OCENA</td><td class='tbl2'><center>AKADEMIK</td></tr>";

while ($data = dbarray($result)) {

   echo "<tr><td width='1%' class='tbl2'><center>";

   echo round($data['ratcount'],2)." </td><td class='tbl2'><a href='readarticle.php?article_id=".$data['article_id']."'>".trimlink($data['article_subject'], 150)."</a></td></tr>";

}

echo"</table>";

closeside();