$dow = @mysql_query("SELECT rating_item_id, rating_type, rating_datestamp, COUNT(rating_datestamp) as kiekbalsavo, COUNT(rating_datestamp) / 3 + AVG(rating_vote) as viso, AVG(rating_vote) as vidurkis from ".DB_RATINGS." WHERE rating_type='F' group by rating_item_id order by viso DESC LIMIT 0,100");

 

$n = 0;

while ($q = @mysql_fetch_array($dow))

{

$n++;

$rating_item_id = $q['rating_item_id'];

$vidurkis = round($q['vidurkis'], 2);

$kiekbalsavo = $q['kiekbalsavo'];

 

$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat = '1' AND download_submit = '0' AND download_id = '$rating_item_id' LIMIT 15");