$sqlx = mysql_query("SELECT s.*, u.user_name, COUNT(*) AS sonuc FROM yazilar AS s
LEFT JOIN uyeler AS u ON u.user_id=s.yazarid WHERE durum='1' GROUP by yazarid ORDER BY sonuc DESC LIMIT 10");

$ii = 0;
while ($row = mysql_fetch_array($sqlx)){
$ii++;
echo "#".$ii." : ".$row['user_name']." Toplam (".$row['sonuc'].") Sayfa Ekledi<br />";
}