Mysql подзапрос?

SELECT `s1`.`id`, `s1`.`city`, `s1`.`contacts`, `s2`.`count`
    FROM `spec` AS `s1`
        LEFT JOIN (SELECT `contacts`, COUNT(`contacts`) AS `count` 
                       FROM `spec` 
                       GROUP BY `contacts`) 
            AS `s2` USING (`contacts`)

select id,city, contacts,
(SELECT count(*) FROM spec s1 WHERE s1.contacts = s.contacts) as cnt
 from spec s
GROUP BY id,city, contacts