SELECT`s1`.`title`,`s1`.`description`,`s1`.`contacts`
FROM `spec` AS `s1`
LEFT JOIN (
SELECT `contacts`, COUNT(`contacts`) AS `count`
FROM `spec`
GROUP BY `contacts`) AS `s2` USING (`contacts`)
WHERE STATUS='' ORDER BY id DESC;

set group_concat_max_len=1024*20;
SELECT`s1`.`title`,title2, `s1`.`contacts`, count, id
FROM `spec` AS `s1`
LEFT JOIN (
SELECT `contacts`, COUNT(`contacts`) AS `count`, GROUP_CONCAT(`title` SEPARATOR  '\n--') as title2
FROM `spec` WHERE STATUS='' 
GROUP BY `contacts`) AS `s2` USING (`contacts`)
WHERE STATUS='' and id>17800
 group by `contacts` ORDER BY count DESC;