0.0002 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_1' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0003 |
SELECT * FROM `m_property_main` WHERE `m_property_main`.`id` = '1205' AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT * FROM `m_property_main` WHERE `m_property_main`.`id` = '1205'
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_1' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_2' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_3' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_4' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_5' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_6' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_7' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_8' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_9' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_10' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '1205' AND `type` = 'property_main' AND `name` = 'img_11' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0001 |
SELECT * FROM `m_area_railway_line` WHERE `line_cd` = '99301'
|
0.0001 |
SELECT * FROM `m_area_railway_station` WHERE `station_cd` = '9930122'
|
0.0000 |
SELECT * FROM `m_area_prefecture` WHERE `code` = '13'
|
0.0000 |
SELECT * FROM `m_area_city` WHERE `code` = '13103'
|
0.0000 |
SELECT * FROM `r_property_category` WHERE `property_id` = '1205' AND `deleted_at` IS NULL
|
0.0002 |
SELECT * FROM `m_property` WHERE `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `status` NOT IN('引渡済') AND `m_property`.`property_main_id` = '1205'
|
0.0001 |
SELECT * FROM `m_property` WHERE `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `status` NOT IN('契約済') AND `m_property`.`property_main_id` = '1205'
|
0.0001 |
SELECT * FROM `m_property` WHERE `type_category` = '購入' AND `deleted_at` IS NULL AND `public_flag` = 1 AND `property_main_id` = '1205' AND `status` NOT IN('引渡済') ORDER BY `floor_count` ASC
|
0.0000 |
SELECT * FROM `t_img_path` WHERE `search_id` = '2003' AND `type` = 'property' AND `name` = 'img_21' AND `deleted_at` IS NULL ORDER BY `updated_at` DESC
|
0.0001 |
SELECT * FROM `m_property` WHERE `type_category` = '購入' AND `deleted_at` IS NULL AND `public_flag` = 1 AND `property_main_id` = '1205' AND `status` = '引渡済' ORDER BY `floor_count` ASC
|
0.0001 |
SELECT * FROM `m_property` WHERE `type_category` = '賃貸' AND `deleted_at` IS NULL AND `public_flag` = 1 AND `property_main_id` = '1205' AND `status` NOT IN('契約済') ORDER BY `floor_count` ASC
|
0.0001 |
SELECT * FROM `m_property` WHERE `type_category` = '賃貸' AND `deleted_at` IS NULL AND `public_flag` = 1 AND `property_main_id` = '1205' AND `status` = '契約済' ORDER BY `floor_count` ASC
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '六本木' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '六本木' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '赤坂' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '赤坂' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '虎ノ門' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '虎ノ門' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '表参道' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '表参道' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '原宿' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '原宿' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '青山' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '青山' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '麻布' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '麻布' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '広尾' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '広尾' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '恵比寿' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '恵比寿' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '目黒' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '目黒' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '白金' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '白金' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '高輪' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '高輪' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '五反田' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '五反田' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '御殿山' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '御殿山' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三田' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三田' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '芝' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '芝' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '浜松町' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '浜松町' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '渋谷' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '渋谷' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '松濤' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '松濤' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '南平台' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '南平台' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代官山' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代官山' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '青葉台' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '青葉台' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '中目黒' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '中目黒' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木上原' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木上原' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木公園' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木公園' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '駒場' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '駒場' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代沢' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代沢' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '下北沢' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '下北沢' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '池尻' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '池尻' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三宿' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三宿' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三軒茶屋' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三軒茶屋' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '新宿' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '新宿' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '代々木' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '千駄ヶ谷' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '千駄ヶ谷' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '飯田橋' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '飯田橋' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '九段下' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '九段下' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '番町' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '番町' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '四谷' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '四谷' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '市ヶ谷' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '市ヶ谷' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '神楽坂' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '神楽坂' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '目白' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '目白' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '池袋' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '池袋' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '護国寺' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '護国寺' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '本駒込' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '本駒込' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '白山' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '白山' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '千石' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '千石' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '自由が丘' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '自由が丘' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '田園調布' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '田園調布' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '碑文谷' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '碑文谷' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '八雲' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '八雲' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '柿の木坂' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '柿の木坂' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '二子玉川' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '二子玉川' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '上野毛' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '上野毛' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '深沢' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '深沢' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '駒沢' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '駒沢' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '用賀' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '用賀' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '桜新町' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '桜新町' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '弦巻' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '弦巻' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '武蔵小杉' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '武蔵小杉' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '月島' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '月島' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '勝どき' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '勝どき' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '晴海' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '晴海' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '豊洲' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '豊洲' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '有明' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '有明' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '汐留' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '汐留' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '芝浦' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '芝浦' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '港南' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '港南' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '銀座' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '銀座' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '日本橋' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '日本橋' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '丸の内' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '丸の内' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '神田' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '神田' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = 'お茶の水' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = 'お茶の水' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '秋葉原' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '秋葉原' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '吉祥寺' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '吉祥寺' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '荻窪' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '荻窪' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '浜田山' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '浜田山' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '永福' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '永福' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '桜上水' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '桜上水' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '成城' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '成城' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '経堂' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '経堂' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '国立' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '国立' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三鷹' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0001 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '三鷹' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '中野' AND `m_property`.`type_category` = '購入' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|
0.0000 |
SELECT `m_property`.* FROM `m_property` INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id` WHERE `m_property_main`.`popular_area` = '中野' AND `m_property`.`type_category` = '賃貸' AND `m_property`.`public_flag` = 1 AND `m_property`.`deleted_at` IS NULL AND `m_property_main`.`deleted_at` IS NULL
|