SELECT `properties`.* FROM `properties` LEFT JOIN `property_details` `D` ON `properties`.`property_id` = `D`.`property_id` LEFT JOIN `property_features` ON `properties`.`property_id` = `property_features`.`property_id` LEFT JOIN `house_types` `HT` ON `property_features`.`bedrooms` = `HT`.`type_id` LEFT JOIN `property_features2` `f2` ON `properties`.`property_id` = `f2`.`property_id` LEFT JOIN `property_structures` `S` ON `properties`.`property_id` = `S`.`property_id` LEFT JOIN `property_costs` `PC` ON `properties`.`property_id` = `PC`.`property_id` LEFT JOIN `property_location` `PL` ON `properties`.`property_id` = `PL`.`property_id` LEFT JOIN `cities` `C` ON `PL`.`city_id` = `C`.`id` LEFT JOIN `localities` `L` ON `PL`.`locality` = `L`.`location_id` LEFT JOIN `property_area` `A` ON `properties`.`property_id` = `A`.`property_id` LEFT JOIN `property_types` `T` ON `properties`.`type_id` = `T`.`type_id` LEFT JOIN `transaction_types` `tt` ON `properties`.`transaction_type` = `tt`.`type_id` LEFT JOIN `furnishing` `F` ON `properties`.`furnished` = `F`.`furnishing_id` LEFT JOIN `user` `U` ON `properties`.`created_by` = `U`.`id` LEFT JOIN `user_contacts` `Uc` ON `U`.`id` = `Uc`.`user_id` LEFT JOIN `transaction_types_sub` `stt` ON `properties`.`sub_transaction_type` = `stt`.`stt_id` LEFT JOIN `property_contacts` `pCont` ON `properties`.`property_id` = `pCont`.`property_id` WHERE (`properties`.`visibility`=1) AND (`properties`.`availability`=1) AND (`L`.`location_id`='33') AND (`properties`.`status`=1) AND (`properties`.`status` != 13) AND (`properties`.`visibility` != 0) AND (`properties`.`availability` != 0) GROUP BY `properties`.`property_id` ORDER BY `properties`.`created_at` DESC