A Database Error Occurred

Error Number: 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 ') ORDER BY `t10`.`partner_status` DESC' at line 12

SELECT `t1`.*, `t2`.`country_name`, `t3`.`state_name`, `t4`.`district_name`, `t5`.`city_name`, `t6`.`area_name`, `t7`.`property_type_display_name`, `t8`.`category_display_name`, `t9`.`name` as `plot_layout_type_name`, `t10`.`company_name`, `t10`.`partner_status` FROM `post_properties` as `t1` LEFT JOIN `countries` as `t2` ON `t1`.`country_id` = `t2`.`id` LEFT JOIN `states` as `t3` ON `t1`.`state_id` = `t3`.`id` LEFT JOIN `districts` as `t4` ON `t1`.`district_id` = `t4`.`id` LEFT JOIN `cities` as `t5` ON `t1`.`city_id` = `t5`.`id` LEFT JOIN `areas` as `t6` ON `t1`.`area_id` = `t6`.`id` LEFT JOIN `property_types` `t7` ON `t1`.`property_type_id`=`t7`.`id` LEFT JOIN `property_type_categories` `t8` ON `t1`.`property_type_category_id`=`t8`.`id` LEFT JOIN `property_layouts_types` `t9` ON `t1`.`plot_layout_type`=`t9`.`id` LEFT JOIN `developers` `t10` ON `t1`.`user_id`=`t10`.`id` WHERE `t1`.`status` = 1 AND `t1`.`published_status` = 1 AND `t1`.`plot_layout_type` IN () ORDER BY `t10`.`partner_status` DESC

Filename: modules/properties/models/Properties_model.php

Line Number: 273