| 0.0128 |
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 `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.0140 |
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 `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.0019 |
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` = 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.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` = 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.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0012 |
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.0012 |
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.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` = 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.0012 |
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.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0012 |
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.0000 |
SELECT COUNT(*) AS `numrows`
|
| 0.0012 |
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.0012 |
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.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.0012 |
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` = 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` = 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.0012 |
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.0012 |
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.0001 |
SELECT COUNT(*) AS `numrows`
|
| 0.0014 |
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.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` = 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.0012 |
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.0012 |
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.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '108'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28009'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800915'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800318'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0007 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '108'
ORDER BY `status` DESC
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '108'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2356'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '279'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2355'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '278'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2067'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '108'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2356'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '279'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2355'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '278'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2067'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '118'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '26001'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2600101'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '26003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2600301'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28008'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800801'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13113'
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '118'
ORDER BY `status` DESC
|
| 0.0108 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '118'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0113 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2140'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2099'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '118'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2140'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2099'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '122'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28009'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800916'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0005 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '122'
ORDER BY `status` DESC
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '122'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2433'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2118'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1911'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '280'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1509'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '282'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '281'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '808'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2040'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2678'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '122'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2433'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2118'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1911'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '280'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1509'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '282'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '281'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '808'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2040'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2678'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '131'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28009'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800910'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28004'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800406'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '131'
ORDER BY `status` DESC
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '131'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2740'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '289'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '131'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2740'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '289'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '140'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28009'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800915'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800317'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28009'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800916'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '140'
ORDER BY `status` DESC
|
| 0.0004 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '140'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '5388'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2434'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2482'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '293'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '292'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '291'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '311'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2154'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '140'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '5388'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2434'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2482'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '293'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '292'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '291'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '311'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2154'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '182'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '11302'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '1130227'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99301'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930121'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99303'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930306'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '182'
ORDER BY `status` DESC
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '182'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2750'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '182'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2750'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '187'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '11302'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '1130227'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99301'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930121'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99303'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930305'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '187'
ORDER BY `status` DESC
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '187'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2747'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '187'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2747'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '189'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '11302'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '1130228'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99311'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9931105'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99303'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930304'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '189'
ORDER BY `status` DESC
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '189'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '348'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '189'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '348'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '268'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800319'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '99301'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '9930124'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28005'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800516'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '268'
ORDER BY `status` DESC
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '268'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2731'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '268'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2731'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '271'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800322'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28003'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800317'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_line`
WHERE `line_cd` = '28001'
|
| 0.0000 |
SELECT *
FROM `m_area_railway_station`
WHERE `station_cd` = '2800114'
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '271'
ORDER BY `status` DESC
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '271'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2076'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `property_main_id` = '271'
ORDER BY `status` DESC, `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2076'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
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.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '麻布'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '麻布'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '広尾'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '広尾'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '恵比寿'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '恵比寿'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目黒'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目黒'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白金'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白金'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '高輪'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '高輪'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '五反田'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '五反田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '御殿山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '御殿山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三田'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜松町'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜松町'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '渋谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '渋谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '松濤'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '松濤'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '南平台'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '南平台'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代官山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代官山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青葉台'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青葉台'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中目黒'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中目黒'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木上原'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木上原'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木公園'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木公園'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒場'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒場'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '下北沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '下北沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池尻'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池尻'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三宿'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三宿'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三軒茶屋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三軒茶屋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '新宿'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '新宿'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千駄ヶ谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千駄ヶ谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '飯田橋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '飯田橋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '九段下'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '九段下'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '番町'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '番町'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '四谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '四谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '市ヶ谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '市ヶ谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神楽坂'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神楽坂'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目白'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目白'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池袋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池袋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '護国寺'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '護国寺'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '本駒込'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '本駒込'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千石'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千石'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '自由が丘'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '自由が丘'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '田園調布'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '田園調布'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '碑文谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '碑文谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '八雲'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '八雲'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '柿の木坂'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '柿の木坂'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '二子玉川'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '二子玉川'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '上野毛'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '上野毛'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '深沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '深沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '用賀'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '用賀'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜新町'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜新町'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '弦巻'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '弦巻'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '武蔵小杉'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '武蔵小杉'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '月島'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '月島'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '勝どき'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '勝どき'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '晴海'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '晴海'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '豊洲'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '豊洲'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '有明'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '有明'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '汐留'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '汐留'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝浦'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝浦'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '港南'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '港南'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '銀座'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '銀座'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '日本橋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '日本橋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '丸の内'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '丸の内'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神田'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = 'お茶の水'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = 'お茶の水'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '秋葉原'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '秋葉原'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '吉祥寺'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '吉祥寺'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '荻窪'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '荻窪'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜田山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜田山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '永福'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '永福'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜上水'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜上水'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '成城'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '成城'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '経堂'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '経堂'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '国立'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '国立'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三鷹'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三鷹'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中野'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中野'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
