user warning: 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 'AND b.field_prop_search_city_value='' GROUP BY a.nid ORDER BY b.field_prop' at line 5 query: SELECT a.nid, b.field_prop_name_ru_value, b.field_prop_search_value, b.field_prop_address_value, b.field_prop_search_city_value, b.field_prop_house_number_value, c.field_prop_images_fid, b.field_prop_price_sale_value, b.field_prop_square_value, b.field_prop_land_area_value, b.field_prop_rooms_number_value, b.field_prop_floor_value, b.field_prop_floor_count_value, b.field_prop_square_house_value FROM `node` a LEFT JOIN `content_type_prop` b on a.vid = b.vid LEFT JOIN `content_field_prop_images` c on a.vid = c.vid WHERE a.type='prop' AND a.nid !=99147 AND b.field_prop_public_value=1 AND b.field_prop_type_value='' AND b.field_prop_price_sale_value<= AND b.field_prop_search_city_value='' GROUP BY a.nid ORDER BY b.field_prop_price_sale_value DESC LIMIT 0, 10 in /home/httpd/vhosts/akcent.pro/httpdocs/sites/all/themes/akcent/templates/node-prop.tpl.php on line 1231.