openside("name");

$wynik = dbquery("SELECT news_id, news_subject, news_datestamp,

(SELECT AVG(rating_vote) FROM ".DB_RATINGS." r WHERE (r.rating_item_id=n.news_id) AND rating_type='N') AS ile,

(SELECT COUNT(rating_id) FROM ".DB_RATINGS." r WHERE (r.rating_item_id=n.news_id) AND rating_type='N') AS liczba

FROM ".DB_NEWS." n WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'

ORDER BY ile DESC, liczba DESC, news_datestamp DESC LIMIT 5");





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

if(dbrows($wynik) > 0) {    

  

while($r = dbarray($wynik))    

{ 

echo "<tr><td class='small'>".THEME_BULLET." <a href='".BASEDIR."news.php?readmore=".$r['news_id']."'>".trimlink($r['news_subject'], 30)."</a></td><td align='right' class='small'>".number_format($r['ile'], 2)."</td></tr>";

}

}

echo "<tr><td colspan='2' class='small' align='right'>".THEME_BULLET." <a href='".BASEDIR."top_news.php'>Wiecej</a></td></tr>



</table>";

closeside();