- $
- €
- ₴
![](/files/region/_s.png)
- Выезд:
-
Проезд: включен
- Тип номера:
- Питание:
- В стоимость входит:
- В стоимость не входит:
(063) 55 678 99
Mysql Error!Catched error 40642000: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') WHERE tb.active='1' AND tb...' at line 45 in /home/apistrav/public_html/protected/modules/product/ProductController.php on line 122. Query: 'SELECT tb.id, seasons.name as seasons_name, tb.price, tb.from, tb.transit, tb.nights, tb.hotel, tb.hotel_star, tb.url, tb.date, tb.date2, tb2.name, COUNT(DISTINCT tb3.id) as vote_count, /*CONCAT_WS(',', GROUP_CONCAT(DISTINCT tb7.region_id),GROUP_CONCAT(DISTINCT tb7.name),GROUP_CONCAT(DISTINCT tb6.name)) AS all_ids*/ GROUP_CONCAT(DISTINCT tb6.name ORDER BY tb5.product_id ASC SEPARATOR ',') as region_city, GROUP_CONCAT(DISTINCT tb7.name ORDER BY tb5.product_id ASC SEPARATOR ',') as region_country, GROUP_CONCAT(DISTINCT tb7.region_id ORDER BY tb5.product_id ASC SEPARATOR ',') as region_ids, GROUP_CONCAT(DISTINCT tb4.status_id ORDER BY tb4.product_id ASC SEPARATOR ',') as status_id FROM product tb LEFT JOIN ru_product tb2 ON tb2.product_id=tb.id LEFT JOIN ru_seasons seasons ON seasons.seasons_id=tb.seasons_id LEFT JOIN votes tb3 ON tb3.member_id=tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id LEFT JOIN product_region_set tb5 ON tb5.product_id=tb.id LEFT JOIN ru_region tb6 ON tb6.region_id=tb5.city_id LEFT JOIN ru_region tb7 ON tb7.region_id=tb5.country_id LEFT JOIN product_region_set tb_r ON tb_r.product_id=tb.id AND ( tb_r.country_id=) WHERE tb.active='1' AND tb_r.country_id IS NOT NULL AND tb.id <> GROUP BY tb.id ORDER BY tb.sort ASC, tb.id DESC'
(063) 55 678 99