openside('Najwyżej oceniane');

$wynik = dbquery("SELECT *, (SELECT COUNT(rating_id) 

FROM ".$db_prefix."ratings c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS ile,

(SELECT ROUND(AVG(rating_vote), 2) FROM ".$db_prefix."ratings c WHERE c.rating_type='A' AND (c.rating_item_id = article_id)) AS srednia 

FROM ".$db_prefix."articles ORDER BY srednia DESC, ile DESC LIMIT 4"); 



echo "<table border='0' width='100%' class='small'>";

if(dbrows($wynik) > 0) {     

while($data = dbarray($wynik))    

{

$itemsubject = trimlink($data['article_subject'], 23);

echo "<tr>

<td class='small' rowspan='2'><img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."articles.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a></td>

<td align='right' class='small'>Oceniono: ".number_format($data['ile'])."</td>

</tr>

<tr>

<td align='right' class='small'>Średnia: ".number_format($data['srednia'], 2)."</td>

</tr>

<tr>

<td class='small' colspan='2'><hr></td></tr>"; 

}

} else {

echo "<tr><td class='small' colspan='2'>Brak artykułów</td></tr>"; 

} echo "</table>"; 

closeside();