SELECT `reference_id`, COUNT(*) AS CountOf ,u.name FROM user_reference ur inner join users u on u.id=ur.reference_id GROUP BY `reference_id` HAVING COUNT(*)>1 ORDER by CountOf DESC LIMIT 50 kendi gerçek isimlerini ver