| 0.0004 |
SELECT *
FROM `m_property`
WHERE `m_property`.`id` = '273'
|
| 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.0001 |
SELECT *
FROM `m_property_main`
WHERE `m_property_main`.`id` = '122'
|
| 0.0005 |
SELECT *
FROM `t_view_count`
WHERE `property_id` = '273'
AND `date` = '2025-08-02'
|
| 0.0003 |
INSERT INTO `t_view_count` (`property_id`, `view_count`, `date`, `created_type`, `created_by`, `created_at`) VALUES ('273', 1, '2025-08-02', 'system', 0, '2025-08-02 22:59:16')
|
| 0.0003 |
SELECT *
FROM `m_property`
WHERE `m_property`.`id` = '273'
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`public_flag` = 1
|
| 0.0001 |
SELECT *
FROM `m_property_main`
WHERE `m_property_main`.`deleted_at` IS NULL
AND `m_property_main`.`id` = '122'
|
| 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.0181 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0183 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_2'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0133 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_3'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_4'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_5'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_6'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_7'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0111 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_8'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_9'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_10'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_11'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_12'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_13'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_14'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_15'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_16'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_17'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_18'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0111 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_19'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_20'
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.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_22'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_23'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_24'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_25'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_26'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_27'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_28'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_29'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_30'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_31'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_32'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_33'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0116 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_34'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_35'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_36'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_37'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0119 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_38'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0115 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_39'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_40'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0115 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_41'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0112 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_42'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_43'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0115 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_44'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0113 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_45'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0115 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_46'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_47'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0121 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_48'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0117 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_49'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0120 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_50'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0131 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_51'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0128 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_52'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0127 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_53'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0128 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_54'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0124 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_55'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0129 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_56'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0136 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_57'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0137 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_58'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0150 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_59'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0111 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_60'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_61'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_62'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_63'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_64'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_65'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_66'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_67'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_68'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_69'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0108 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_70'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_71'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_72'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_73'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_74'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_75'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0108 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_76'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_77'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_78'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_79'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0108 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_80'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0110 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_81'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_82'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0109 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_83'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_84'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0113 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_85'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_86'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0115 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_87'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0120 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_88'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0132 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_89'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0123 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_90'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0123 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_91'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_92'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0117 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_93'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_94'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_95'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0141 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_96'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0139 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_97'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0127 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_98'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0114 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '273'
AND `type` = 'property'
AND `name` = 'img_99'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property_main`
WHERE `id` = '122'
AND `deleted_at` IS NULL
|
| 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_railway_line`
WHERE `line_cd` = ''
|
| 0.0000 |
SELECT *
FROM `m_area_prefecture`
WHERE `code` = '13'
|
| 0.0000 |
SELECT *
FROM `m_area_city`
WHERE `code` = '13103'
|
| 0.0186 |
SELECT *
FROM `r_property_category`
WHERE `property_id` = '273'
AND `deleted_at` IS NULL
|
| 0.0002 |
SELECT *
FROM `t_file_path`
WHERE `type` = 'property'
AND `search_id` = '273'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_file_path`
WHERE `type` = 'property'
AND `search_id` = '273'
AND `deleted_at` IS NULL
|
| 0.0006 |
SELECT *
FROM `m_property`
WHERE `type_category` = '購入'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `id` != '273'
AND `status` = '引渡済'
AND `property_main_id` = '122'
ORDER BY `floor_count` ASC
|
| 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` = '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.0004 |
SELECT *
FROM `m_property`
WHERE `type_category` = '賃貸'
AND `deleted_at` IS NULL
AND `public_flag` = 1
AND `id` != '273'
AND `property_main_id` = '122'
AND `status` = '契約済'
ORDER BY `floor_count` ASC
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '2537'
AND `type` = 'property'
AND `name` = 'img_21'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0030 |
SELECT `m_property`.*
FROM `m_property`
JOIN `m_property_main` ON `m_property`.`property_main_id` = `m_property_main`.`id`
WHERE `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`type_category` = '購入'
AND `m_property`.`status` != '引渡済'
AND `m_property_main`.`city` = 13103
AND `m_property`.`occupation_area` >= 70.95
AND `m_property`.`occupation_area` <= 90.95
ORDER BY RAND()
LIMIT 10
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '877'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property_main`
WHERE `id` = '877'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '226'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '226'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '152'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '152'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1197'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1197'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1257'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1257'
AND `deleted_at` IS NULL
|
| 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_property_main`
WHERE `id` = '189'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '422'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '422'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1257'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1257'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '438'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '438'
AND `deleted_at` IS NULL
|
| 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_property_main`
WHERE `id` = '108'
AND `deleted_at` IS NULL
|
| 0.0025 |
SELECT `m_property`.*
FROM `m_property`
JOIN `m_property_main` ON `m_property`.`property_main_id` = `m_property_main`.`id`
WHERE `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`status` != '引渡済'
AND `m_property_main`.`city` = 13103
AND `m_property`.`occupation_area` >= 70.95
AND `m_property`.`occupation_area` <= 90.95
ORDER BY RAND()
LIMIT 10
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '955'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '955'
AND `deleted_at` IS NULL
|
| 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.0001 |
SELECT *
FROM `m_property_main`
WHERE `id` = '131'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1051'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0001 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1051'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '571'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '571'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1396'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1396'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1257'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1257'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '584'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '584'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '110'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '110'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '1376'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '1376'
AND `deleted_at` IS NULL
|
| 0.0000 |
SELECT *
FROM `t_img_path`
WHERE `search_id` = '165'
AND `type` = 'property_main'
AND `name` = 'img_1'
AND `deleted_at` IS NULL
ORDER BY `updated_at` DESC
|
| 0.0000 |
SELECT *
FROM `m_property_main`
WHERE `id` = '165'
AND `deleted_at` IS NULL
|
| 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` = '07'
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.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '虎ノ門'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '虎ノ門'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '表参道'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '表参道'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '原宿'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '原宿'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '麻布'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '麻布'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '広尾'
AND `m_property`.`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.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '五反田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '御殿山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '御殿山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三田'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '芝'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜松町'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜松町'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '渋谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '渋谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '松濤'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '松濤'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '南平台'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '南平台'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代官山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代官山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青葉台'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '青葉台'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中目黒'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '中目黒'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木上原'
AND `m_property`.`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.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.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '三軒茶屋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '新宿'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '新宿'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '代々木'
AND `m_property`.`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.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '四谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '四谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '市ヶ谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '市ヶ谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神楽坂'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神楽坂'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目白'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '目白'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池袋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '池袋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '護国寺'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '護国寺'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '本駒込'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '本駒込'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '白山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千石'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '千石'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '自由が丘'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '自由が丘'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '田園調布'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '田園調布'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '碑文谷'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '碑文谷'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '八雲'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '八雲'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '柿の木坂'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '柿の木坂'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '二子玉川'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '二子玉川'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '上野毛'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '上野毛'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '深沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '深沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒沢'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '駒沢'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '用賀'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '用賀'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜新町'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜新町'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '弦巻'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '弦巻'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '武蔵小杉'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '武蔵小杉'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '月島'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '月島'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '勝どき'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.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.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '有明'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '汐留'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '汐留'
AND `m_property`.`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.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '日本橋'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '日本橋'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '丸の内'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '丸の内'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神田'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '神田'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = 'お茶の水'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = 'お茶の水'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '秋葉原'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '秋葉原'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '吉祥寺'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '吉祥寺'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '荻窪'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '荻窪'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜田山'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '浜田山'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '永福'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '永福'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜上水'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '桜上水'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0000 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '成城'
AND `m_property`.`type_category` = '購入'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.0001 |
SELECT `m_property`.*
FROM `m_property`
INNER JOIN `m_property_main` ON `m_property_main`.`id` = `m_property`.`property_main_id`
WHERE `m_property_main`.`popular_area` = '成城'
AND `m_property`.`type_category` = '賃貸'
AND `m_property`.`public_flag` = 1
AND `m_property`.`deleted_at` IS NULL
AND `m_property_main`.`deleted_at` IS NULL
|
| 0.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
|
