Query: Select properties.id, properties.property_type, properties.highlight, properties.property_mode, properties.property_user_role, properties.property_category, properties.state, properties.city, properties.locality, properties.plot_area, properties.plot_area_type, properties.land_area, properties.land_area_type, properties.bedrooms, properties.property_price, properties.posted_date, localities.id, localities.locality, propertycommissiondetails.company_commission , propertycommissiondetails.agent_commission from properties left join localities on properties.locality = localities.id LEFT JOIN propertycommissiondetails ON properties.id = propertycommissiondetails.`property_id` where 1 AND properties.property_type = 'sale' AND status != 'no' order by posted_date DESC LIMIT -20, 20
Warning: SQL Error: 1064: 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 '-20, 20' at line 1 in /home2/valuepro/public_html/kulttech/cake/libs/model/datasources/dbo_source.php on line 440