SELECT * , count( iki.ad ) AS c FROM `bir` LEFT JOIN iki ON bir.ad = iki.ad GROUP BY iki.ad ORDER BY c DESC