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

$wynik = dbquery("SELECT d.*, (SELECT COUNT(download_id) FROM ".$db_prefix."downloads r WHERE r.download_cat=d.download_cat_id) AS ile 

FROM ".$db_prefix."download_cats d WHERE ".groupaccess('download_cat_access')." ORDER BY ile DESC LIMIT 20");



if(dbrows($wynik) > 0) {      

while($r = dbarray($wynik))    

{ 

echo "<tr>

<td class='small'><img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR."downloads.php?cat_id=".$r['download_cat_id']."'>".$r['download_cat_name']."</a></td>

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

</tr>";

}

}

echo "</table>";