كود:
Query: SELECT COUNT(*) AS `count` FROM `properties` AS `Property` LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `districts` AS `District` ON (`Property`.`district_id` = `District`.`id`) LEFT JOIN `ptypes` AS `Ptype` ON (`Property`.`ptype_id` = `Ptype`.`id`) WHERE `Property`.`available` = 1 AND `Property`.`country_id` = 17 AND `Property`.`city_id` = تحميل AND `Property`.`ptype_id` = 4 AND `Property`.`buy` = 0
Query: SELECT `Property`.`id`, `Property`.`user_id`, `Property`.`ptype_id`, `Property`.`district_id`, `Property`.`district`, `Property`.`buy`, `Property`.`parea`, `Property`.`price`, `Property`.`curr_id`, `Property`.`available`, `Property`.`address`, `Property`.`title`, `Property`.`body`, `Property`.`country_id`, `Property`.`city_id`, `Property`.`status`, `Property`.`allowreplies`, `Property`.`longitude`, `Property`.`latitude`, `Property`.`zoom`, `Property`.`created`, `Property`.`modified`, `Property`.`expdate`, `Property`.`roomsnu`, `Property`.`bathrooms`, `Property`.`apts`, `Property`.`buildyear`, `Property`.`views_count`, `Property`.`photos_count`, `Property`.`comments_count`, `Property`.`fixed`, `Property`.`admin_id`, `Property`.`admin_date`, `Property`.`dailyrent`, `Property`.`weeklyrent`, `Property`.`monthlyrent`, `Property`.`yearlyrent`, `User`.`id`, `User`.`username`, `User`.`slogan`, `Country`.`id`, `Country`.`countryname`, `Country`.`properties_count`, `Country`.`publishedproperties_count`, `Country`.`currency`, `Country`.`currency_short`, `Country`.`country_code`, `City`.`id`, `City`.`country_id`, `City`.`cityname`, `City`.`properties_count`, `City`.`publishedproperties_count`, `City`.`longitude`, `City`.`latitude`, `City`.`zoom`, `City`.`fixed`, `City`.`created`, `City`.`modified`, `District`.`id`, `District`.`country_id`, `District`.`city_id`, `District`.`districtname`, `District`.`latitude`, `District`.`longitude`, `District`.`zoom`, `District`.`properties_count`, `District`.`publishedproperties_count`, `District`.`created`, `District`.`modified`, `Ptype`.`id`, `Ptype`.`type`, `Ptype`.`properties_count`, `Ptype`.`publishedproperties_count` FROM `properties` AS `Property` LEFT JOIN `users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `districts` AS `District` ON (`Property`.`district_id` = `District`.`id`) LEFT JOIN `ptypes` AS `Ptype` ON (`Property`.`ptype_id` = `Ptype`.`id`) WHERE `Property`.`available` = 1 AND `Property`.`country_id` = 17 AND `Property`.`city_id` = تحميل AND `Property`.`ptype_id` = 4 AND `Property`.`buy` = 0 ORDER BY `Property`.`created` DESC LIMIT 10
ترتيب حسب: <آخر تعديل> <تاريخ الإنشاء> <السعر> <المساحة>
إظهار/إخفاء ملخص الشقق