error! SELECT * FROM allproperties where is_service_apartment and ((is_for_sale and selling_price) or (is_for_lease and rent_price)) and is_published order by last_update_date%20desc limit 0,5