Ошибка при запросе. Отладочная информация: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?order=4 AND property_visible='1' ORDER BY property_price asc , property_hot des' at line 8 SELECT property_id, property_descr_ru as descr, property_name, property_price_new As property_price_new, property_price, property_price_from as price_from, IFNULL( ec.enumdata_name, '€') AS currency, p.property_bathroom, property_hot AS hot,
CONCAT( l.location_name_ru, IF(l.parent_id <> 0 , CONCAT(' / ', (SELECT location_name_ru FROM location WHERE location_id = l.parent_id) ), '')) AS location_name,
t.property_type_name_ru AS type_name, LOWER(t.property_type_name_en) AS path, p.property_rooms, p.property_sqm, (SELECT CONCAT(property_id, '/s', gallery_image) as gallery_image FROM gallery g WHERE g.property_id = p.property_id AND gallery_visible =1 ORDER BY gallery_weight LIMIT 0 , 1) as image, CONCAT( '#', IF(property_status=1, 'S', 'R'),property_code) as id_long, property_title_ru AS title, property_status, property_option AS opt, em.enumdata_name AS market FROM `property` p
LEFT JOIN location l ON p.location_id = l.location_id
LEFT JOIN city c ON p.city_id = c.city_id
LEFT JOIN property_type t ON p.property_type_id = t.property_type_id
LEFT JOIN enumdata ec ON p.property_currency = ec.enumdata_id and ec.enum_id=5
LEFT JOIN enumdata em ON p.property_market = em.enumdata_id and em.enum_id=1 WHERE property_visible=1 AND p.property_market=9?order=4 AND property_visible='1' ORDER BY property_price asc , property_hot desc, property_code desc, property_id desc
Вкладываем в строительство | Holiday Homes - Агентство недвижимости
