ok hab's rausgefunden:
PHP-Code:
$abfrage = "select url,count(*) as menge from tabelle group by url order by menge desc limit 0, 10";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_array($ergebnis)) {
echo $row[url];
echo " - ";
echo $row[menge];
echo "
";