Penzióny Slovenský raj

SELECT c.city_region, count(distinct(o.object_id)) as rownums FROM `object` AS `o` LEFT JOIN `object_join` AS `j` ON j.object_id = o.object_id LEFT JOIN `object_hotel` AS `h` ON o.object_id = h.object_id LEFT JOIN `cities` AS `c` ON c.city_id = o.object_city LEFT JOIN `object_join` AS `lj` ON o.object_id = lj.object_id GROUP BY `c`.`city_region`