How to make a mysql selection with the calculation of the number of unique values?

Question

css

Unable to add unique c.catalog_id count to this query

$contacts = $dbh->prepare("
SELECT r.title AS region_title, 
c.title,
c.region_id, 
c.id, 
c.catalog_id, 
c.address, 
c.phone, 
c.email, 
c.website, 
c.category_title, 
c.subcategory_title, 
c.subcategory_id, 
c.manufacturer 
  FROM contacts AS c 
  LEFT 
  JOIN regions AS r 
    ON c.region_id = r.id 
 WHERE manufacturer = 1 
   AND region_id IN (".implode(',', $regions).") 
   AND subcategory_id IN (".implode(',', $categories).")
");
$contacts->execute();
$contacts->fetchAll(PDO::FETCH_GROUP);

ps contact list should be grouped by region_title:

array() {
  ["Хабаровск"]=>
  array() {
    contact1
    contact2
    ...
  },
  ["Чебоксары"]=>
  array() {
    contact3
    contact4
    ...
  }
}

Answer 1

waited for loading seconds 20
closed nafik
don't make such a hover effect

Answer 2

count () as ct group by ... having ct > 1