Туристическое агентство Sorger
+421 2 21 02 57 57
остается в Словакии

Гостевые

Найти ваше пребывание

Цена за человека / ночь только
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`
© 2019 CA SORGER - Правила и условия - Контакт | Все права защищены.