Invalid query: 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 o.right_column = 1 ORDER BY o.property_id ASC' at line 23
Whole query: SELECT DISTINCT o.development_id, o.property_id, o.hide_plot, IF(o.price > 0,o.price, p.price) AS price, IF(o.new_price > 0, o.new_price, p.price) AS new_price, o.text_1, o.text_2, d.area, d.title AS development_title, d.devid AS development_url, p.proptypeid AS property_type_url, p.plotnumber, pt.bedrooms FROM special_offers AS o INNER JOIN developments AS d ON o.development_id = d.id LEFT JOIN properties AS p ON o.property_id = p.propid LEFT JOIN property_types AS pt ON p.proptypeid = pt.proptypeid WHERE 1 AND o.development_id = AND o.right_column = 1 ORDER BY o.property_id ASC