| 0.0053 |
SELECT `m_property_main`.*, `m_property`.`name` AS `p_name`
FROM `m_property_main`
JOIN m_property ON m_property.property_main_id = m_property_main.id AND m_property.property_main_id != 1188 AND ((m_property.status = "募集中" AND m_property.type_category = "賃貸") OR (m_property.status = "販売中" AND m_property.type_category = "購入")) AND m_property.room_count IS NOT NULL AND m_property.room_count > 0 AND ((m_property.rent_price > 0 AND m_property.type_category = "賃貸") OR (m_property.sell_price > 0 AND m_property.type_category = "購入"))
WHERE `m_property_main`.`deleted_at` IS NULL
AND concat(m_property_main.name, m_property_main.search_name) LIKE '%プラウド赤坂氷川町%' ESCAPE '!'
AND `m_property`.`deleted_at` IS NULL
GROUP BY `m_property_main`.`id`
ORDER BY `m_property_main`.`search_sell_possible` DESC, `m_property_main`.`search_sell_case` DESC
LIMIT 10
|
| 0.0037 |
SELECT `m_property_main`.*, `m_property`.`name` AS `p_name`
FROM `m_property_main`
JOIN m_property ON m_property.property_main_id = m_property_main.id AND m_property.property_main_id != 1188 AND ((m_property.status = "募集中" AND m_property.type_category = "賃貸") OR (m_property.status = "販売中" AND m_property.type_category = "購入")) AND m_property.room_count IS NOT NULL AND m_property.room_count > 0 AND ((m_property.rent_price > 0 AND m_property.type_category = "賃貸") OR (m_property.sell_price > 0 AND m_property.type_category = "購入"))
WHERE `m_property_main`.`deleted_at` IS NULL
AND concat(m_property_main.name, m_property_main.search_name) LIKE '%プラウド赤坂氷川町%' ESCAPE '!'
AND `m_property`.`deleted_at` IS NULL
GROUP BY `m_property_main`.`id`
ORDER BY `m_property_main`.`search_sell_possible` DESC, `m_property_main`.`search_sell_case` DESC
|
| 0.0015 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%六本木%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%赤坂%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%虎ノ門%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%表参道%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%原宿%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%青山%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%麻布%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%広尾%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%恵比寿%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%目黒%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%白金%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%高輪%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13109
AND `m_property_main`.`address` LIKE '%五反田%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13109
AND `m_property_main`.`address` LIKE '%御殿山%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%三田%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%芝%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%浜松町%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%渋谷%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%松濤%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%南平台%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%代官山%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%青葉台%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%中目黒%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%代々木上原%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%代々木公園%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%駒場%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%代沢%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%下北沢%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%池尻%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%三宿%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%三軒茶屋%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13104
AND `m_property_main`.`address` LIKE '%新宿%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%代々木%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13113
AND `m_property_main`.`address` LIKE '%千駄ヶ谷%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%飯田橋%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%九段下%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%番町%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13104
AND `m_property_main`.`address` LIKE '%四谷%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13104
AND `m_property_main`.`address` LIKE '%市ヶ谷%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13104
AND `m_property_main`.`address` LIKE '%神楽坂%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13116
AND `m_property_main`.`address` LIKE '%目白%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13116
AND `m_property_main`.`address` LIKE '%池袋%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13105
AND `m_property_main`.`address` LIKE '%護国寺%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13105
AND `m_property_main`.`address` LIKE '%本駒込%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13105
AND `m_property_main`.`address` LIKE '%白山%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13105
AND `m_property_main`.`address` LIKE '%千石%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%自由が丘%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13111
AND `m_property_main`.`address` LIKE '%田園調布%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%碑文谷%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0015 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%八雲%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13110
AND `m_property_main`.`address` LIKE '%柿の木坂%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%二子玉川%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%上野毛%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%深沢%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%駒沢%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%用賀%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%桜新町%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%弦巻%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 14133
AND `m_property_main`.`address` LIKE '%武蔵小杉%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13102
AND `m_property_main`.`address` LIKE '%月島%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13102
AND `m_property_main`.`address` LIKE '%勝どき%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13102
AND `m_property_main`.`address` LIKE '%晴海%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13108
AND `m_property_main`.`address` LIKE '%豊洲%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13108
AND `m_property_main`.`address` LIKE '%有明%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%汐留%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%芝浦%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13103
AND `m_property_main`.`address` LIKE '%港南%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13102
AND `m_property_main`.`address` LIKE '%銀座%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13102
AND `m_property_main`.`address` LIKE '%日本橋%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%丸の内%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%神田%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%お茶の水%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13101
AND `m_property_main`.`address` LIKE '%秋葉原%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13203
AND `m_property_main`.`address` LIKE '%吉祥寺%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13115
AND `m_property_main`.`address` LIKE '%荻窪%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13115
AND `m_property_main`.`address` LIKE '%浜田山%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13115
AND `m_property_main`.`address` LIKE '%永福%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%桜上水%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%成城%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13112
AND `m_property_main`.`address` LIKE '%経堂%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13215
AND `m_property_main`.`address` LIKE '%国立%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13204
AND `m_property_main`.`address` LIKE '%三鷹%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0013 |
SELECT COUNT(*) as match_count
FROM `m_property_main`
INNER JOIN `m_property` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`city` = 13114
AND `m_property_main`.`address` LIKE '%中野%' ESCAPE '!'
AND `m_property_main`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`status` = '募集中'
|
| 0.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0001 |
SELECT `t_ranking`.*
FROM `t_ranking`
JOIN `m_property` ON `m_property`.`id` = `t_ranking`.`property_id`
WHERE `m_property`.`status` != '引渡済'
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
AND `t_ranking`.`year` = '2025'
AND `t_ranking`.`month` = '04'
ORDER BY `ranking` ASC
LIMIT 4
|
| 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.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.0002 |
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.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.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.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
|
