Process Halted!
Error:db::query() failed.ERROR MESSAGE IS: Failed to run Query: select distinct property.property_id, property.id, property.date, property.active1, property.exp_date, property.monthly_price, property.yearly_price, property.deposit, property.thumb, property.title, property.featured, property.member_id, property.country, property.state, property.city, property.bedrooms, property.bathrooms, property.stories, property.floor, property.living_area, property.living_area_unit, property.lot_size, property.lot_size_unit, property.ecommercial, property.status_new, property.sold, p_type.name as type_name, p_envirement.name as envirement_name, member.first_name, member.last_name from property inner join p_type on property.type=p_type.group_id inner join p_envirement on property.envirement=p_envirement.group_id inner join member on property.member_id=member.member_id where 1=1 and property.sale_rent='2' and property.active1='1' and property.lang='2' and property.type='34' and p_type.lang='2' and p_envirement.lang='2' order by 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 '' at line 36