Готелі
Згідно рейтингу Турправда
Ошибка базы данных WordPress: [Unknown column '2C2' in 'where clause']SELECT count(*) FROM odev_catalog_hotel WHERE resort_post_id = 1015486 AND stars IN (1%2C2%2C3%2C4%2C5)
Ошибка базы данных WordPress: [Unknown column '2C2' in 'where clause']SELECT odev_catalog_hotel.*,
ifnull(offers.uah, '') as min_price_uah,
offers.offer_id as min_price_offer_id,
country_posts.post_title as country, country_posts.post_name as country_slug,
resort_posts.post_title as resort, resort_posts.post_name as resort_slug,
hotel_posts.post_title as name, hotel_posts.post_name as hotel_slug
FROM odev_catalog_hotel LEFT JOIN odev_catalog_offer offers ON otpusk_id = offers.hotel_id LEFT JOIN hlys_posts hotel_posts ON post_id = hotel_posts.ID LEFT JOIN hlys_posts country_posts ON country_post_id = country_posts.ID LEFT JOIN hlys_posts resort_posts ON resort_post_id = resort_posts.ID WHERE resort_post_id = 1015486 AND stars IN (1%2C2%2C3%2C4%2C5) ORDER BY turpravda_rate DESC, min_price_uah ASC LIMIT 0, 48
