SELECT count and list

SELECT DISTINCT `source` AS distinct_sites, COUNT( * ) , link
FROM `table`
GROUP BY source
ORDER BY COUNT( * ) DESC
LIMIT 0 , 30

Отблагодарить можно через форму справа "Donate" ... )

To reward you via the form on the right "Donate" ... )

:)