Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 34]
Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 35]
東京大学駒場キャンパス検索結果
(default) 81 queries took 607 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MAreaDistrict`.`id`, `MAreaDistrict`.`name` FROM `fudosan`.`app_m_area_districts` AS `MAreaDistrict` WHERE `MAreaDistrict`.`is_disabled` = '0' AND `MAreaDistrict`.`is_deleted` = '0'660
2SELECT `MAreaPrefecture`.`id`, `MAreaPrefecture`.`name` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14)550
3SELECT `MAreaCity`.`id`, `MAreaCity`.`name` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`is_disabled` = '0' AND `MAreaCity`.`is_deleted` = '0'2572570
4SELECT `MAreaLine`.`id`, `MAreaLine`.`name` FROM `fudosan`.`app_m_area_lines` AS `MAreaLine` WHERE `MAreaLine`.`is_disabled` = '0' AND `MAreaLine`.`is_deleted` = '0'1321320
5SELECT `MPropertyRentalType`.`id`, `MPropertyRentalType`.`name` FROM `fudosan`.`app_m_property_rental_types` AS `MPropertyRentalType` WHERE `MPropertyRentalType`.`is_disabled` = '0' AND `MPropertyRentalType`.`is_deleted` = '0'220
6SELECT `MPropertyContractType`.`id`, `MPropertyContractType`.`name` FROM `fudosan`.`app_m_property_contract_types` AS `MPropertyContractType` WHERE `MPropertyContractType`.`is_disabled` = '0' AND `MPropertyContractType`.`is_deleted` = '0'550
7SELECT `MPropertyBuildingType`.`id`, `MPropertyBuildingType`.`name` FROM `fudosan`.`app_m_property_building_types` AS `MPropertyBuildingType` WHERE `MPropertyBuildingType`.`is_disabled` = '0' AND `MPropertyBuildingType`.`is_deleted` = '0'440
8SELECT `MPropertyBuildingStructure`.`id`, `MPropertyBuildingStructure`.`name` FROM `fudosan`.`app_m_property_building_structures` AS `MPropertyBuildingStructure` WHERE `MPropertyBuildingStructure`.`is_disabled` = '0' AND `MPropertyBuildingStructure`.`is_deleted` = '0'660
9SELECT `MPropertyInformationModelType`.`id`, `MPropertyInformationModelType`.`name` FROM `fudosan`.`app_m_property_information_model_types` AS `MPropertyInformationModelType` WHERE `MPropertyInformationModelType`.`is_disabled` = '0' AND `MPropertyInformationModelType`.`is_deleted` = '0'10100
10SELECT `MPropertyStatus`.`id`, `MPropertyStatus`.`name` FROM `fudosan`.`app_m_property_statuses` AS `MPropertyStatus` WHERE `MPropertyStatus`.`is_disabled` = '0' AND `MPropertyStatus`.`is_deleted` = '0'330
11SELECT `MPropertyFeatureCategory`.`id`, `MPropertyFeatureCategory`.`name`, `MPropertyFeatureCategory`.`order`, `MPropertyFeatureCategory`.`is_disabled`, `MPropertyFeatureCategory`.`is_deleted`, `MPropertyFeatureCategory`.`created`, `MPropertyFeatureCategory`.`modified` FROM `fudosan`.`app_m_property_feature_categories` AS `MPropertyFeatureCategory` WHERE `MPropertyFeatureCategory`.`id` > 1 ORDER BY `MPropertyFeatureCategory`.`id` asc10100
12SELECT `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`m_property_feature_category_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)75750
13SELECT `MInquiryDial`.`id`, `MInquiryDial`.`name`, `MInquiryDial`.`display_name`, `MInquiryDial`.`order`, `MInquiryDial`.`is_disabled`, `MInquiryDial`.`is_deleted`, `MInquiryDial`.`created`, `MInquiryDial`.`modified` FROM `fudosan`.`app_m_inquiry_dials` AS `MInquiryDial` WHERE `MInquiryDial`.`is_disabled` = '0' AND `MInquiryDial`.`is_deleted` = '0' AND `MInquiryDial`.`id` = 30 LIMIT 1000
14SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14) AND `MAreaPrefecture`.`url` = '東京大学_駒場キャンパス'110
15SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`is_disabled` = '0' AND `MAreaCity`.`is_deleted` = '0' AND `MAreaCity`.`url` = '東京大学_駒場キャンパス'110
16SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_towns` AS `MAreaTown` WHERE `MAreaTown`.`is_disabled` = '0' AND `MAreaTown`.`is_deleted` = '0' AND `MAreaTown`.`url` = '東京大学_駒場キャンパス'110
17SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_stations` AS `MAreaStation` WHERE `MAreaStation`.`is_disabled` = '0' AND `MAreaStation`.`is_deleted` = '0' AND `MAreaStation`.`url` = '東京大学_駒場キャンパス'111
18SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` WHERE `MSchoolUniversity`.`is_disabled` = '0' AND `MSchoolUniversity`.`is_deleted` = '0' AND `MSchoolUniversity`.`url` = '東京大学'111
19SELECT `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` WHERE `MSchoolUniversity`.`is_disabled` = '0' AND `MSchoolUniversity`.`is_deleted` = '0' AND `MSchoolUniversity`.`url` = '東京大学' LIMIT 1110
20SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` WHERE `MSchoolCampus`.`is_disabled` = '0' AND `MSchoolCampus`.`is_deleted` = '0' AND `MSchoolCampus`.`m_school_university_id` = 1 AND `MSchoolCampus`.`url` = '駒場キャンパス'111
21SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14) AND `MAreaPrefecture`.`url` = '東京大学_駒場キャンパス'110
22SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`is_disabled` = '0' AND `MAreaCity`.`is_deleted` = '0' AND `MAreaCity`.`url` = '東京大学_駒場キャンパス'110
23SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_area_stations` AS `MAreaStation` WHERE `MAreaStation`.`is_disabled` = '0' AND `MAreaStation`.`is_deleted` = '0' AND `MAreaStation`.`url` = '東京大学_駒場キャンパス'111
24SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` WHERE `MSchoolUniversity`.`is_disabled` = '0' AND `MSchoolUniversity`.`is_deleted` = '0' AND `MSchoolUniversity`.`url` = '東京大学'110
25SELECT `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` WHERE `MSchoolUniversity`.`is_disabled` = '0' AND `MSchoolUniversity`.`is_deleted` = '0' AND `MSchoolUniversity`.`url` = '東京大学' LIMIT 1110
26SELECT COUNT(*) AS `count` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` WHERE `MSchoolCampus`.`is_disabled` = '0' AND `MSchoolCampus`.`is_deleted` = '0' AND `MSchoolCampus`.`m_school_university_id` = 1 AND `MSchoolCampus`.`url` = '駒場キャンパス'111
27SELECT `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` WHERE `MSchoolUniversity`.`is_disabled` = '0' AND `MSchoolUniversity`.`is_deleted` = '0' AND `MSchoolUniversity`.`url` = '東京大学' LIMIT 1110
28SELECT `MSchoolCampus`.`id`, `MSchoolCampus`.`name`, `MSchoolCampus`.`pronunciation_of_name`, `MSchoolCampus`.`address`, `MSchoolCampus`.`latitude`, `MSchoolCampus`.`longitude`, `MSchoolCampus`.`order`, `MSchoolCampus`.`url`, `MSchoolCampus`.`is_disabled`, `MSchoolCampus`.`is_deleted`, `MSchoolCampus`.`m_area_prefecture_id`, `MSchoolCampus`.`m_area_city_id`, `MSchoolCampus`.`m_school_university_id`, `MSchoolCampus`.`created`, `MSchoolCampus`.`modified` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` WHERE `MSchoolCampus`.`m_school_university_id` = (1)441
29SELECT `MSchoolDepartment`.`id`, `MSchoolDepartment`.`name`, `MSchoolDepartment`.`order`, `MSchoolDepartment`.`url`, `MSchoolDepartment`.`is_disabled`, `MSchoolDepartment`.`is_deleted`, `MSchoolDepartment`.`m_school_university_id`, `MSchoolDepartment`.`created`, `MSchoolDepartment`.`modified` FROM `fudosan`.`app_m_school_departments` AS `MSchoolDepartment` WHERE `MSchoolDepartment`.`m_school_university_id` = (1)110
30SELECT `MSchoolCampus`.`id`, `MSchoolCampus`.`name`, `MSchoolCampus`.`pronunciation_of_name`, `MSchoolCampus`.`address`, `MSchoolCampus`.`latitude`, `MSchoolCampus`.`longitude`, `MSchoolCampus`.`order`, `MSchoolCampus`.`url`, `MSchoolCampus`.`is_disabled`, `MSchoolCampus`.`is_deleted`, `MSchoolCampus`.`m_area_prefecture_id`, `MSchoolCampus`.`m_area_city_id`, `MSchoolCampus`.`m_school_university_id`, `MSchoolCampus`.`created`, `MSchoolCampus`.`modified`, `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` LEFT JOIN `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` ON (`MSchoolCampus`.`m_school_university_id` = `MSchoolUniversity`.`id`) WHERE `MSchoolCampus`.`is_disabled` = '0' AND `MSchoolCampus`.`is_deleted` = '0' AND `MSchoolCampus`.`m_school_university_id` = 1 AND `MSchoolCampus`.`url` = '駒場キャンパス' LIMIT 1110
31SELECT `MSchoolCampusStation`.`m_area_station_id` FROM `fudosan`.`app_m_school_campus_stations` AS `MSchoolCampusStation` WHERE `MSchoolCampusStation`.`m_school_campus_id` = (2)330
32SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` IN (1323, 1322, 1324) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`2083208324
33SELECT COUNT(*) AS `count` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` WHERE `PropertyInformation`.`approval_for_publish` = '1' AND `PropertyInformation`.`is_disabled` = '0' AND `PropertyInformation`.`m_property_building_id` IN (15109, 15121, 15243, 15329, 15671, 15677, 15730, 15807, 15847, 16088, 16452, 19271, 19333, 19526, 19528, 19582, 19645, 19916, 19963, 20086, 20305, 20525, 20817, 20840, 20876, 20972, 21242, 22272, 22293, 23025, 23264, 23294, 23343, 23580, 23663, 23867, 23883, 24043, 24112, 24154, 24163, 24236, 24246, 24268, 24313, 24437, 24531, 24533, 24592, 24634, 24657, 24698, 24758, 24767, 24848, 24858, 24864, 24889, 25048, 25142, 25184, 25195, 25275, 25379, 25443, 25447, 25457, 25458, 25464, 25473, 25477, 25533, 25553, 25690, 25844, 25932, 25971, 26003, 26073, 26129, 26153, 26274, 26321, 26380, 26450, 26472, 26482, 26484, 26496, 26587, 26793, 26795, 26896, 26927, 26935, 26944, 26974, 26984, 27011, 36888, 36915, 36994, 37068, 37079, 37103, 37115, 37125, 37141, 37179, 37196, 37226, 37233, 37242, 37261, 37302, 37698, 37712, 37731, 37909, 37992, 37999, 38056, 38090, 38154, 38851, 38919, 38960, 38969, 39044, 39192, 39342, 39554, 39559, 39958, 40329, 40435, 40470, 40486, 40501, 40513, 40562, 40603, 40613, 40693, 40694, 40772, 40977, 41137, 41372, 41406, 41625, 41742, 41828, 41912, 41921, 41923, 41953, 41966, 42473, 42499, 42503, 42560, 43185, 43391, 43398, 43846, 44188, 44405, 44495, 44591, 44860, 45445, 45593, 45649, 45742, 46008, 46064, 46075, 46424, 47538, 47745, 47824, 47832, 47850, 48245, 48338, 48365, 48385, 48397, 48408, 48468, 48592, 48599, 48611, 48671, 48682, 48700, 48712, 48736, 48835, 49047, 49050, 49072, 49079, 49110, 49119, 49155, 49195, 49197, 49226, 49239, 49255, 49284, 49314, 49332, 49373, 49492, 49607, 49608, 49655, 49681, 49725, 49781, 49816, 49843, 50036, 50105, 50116, 50119, 50121, 50150, 50230, 50283, 50287, 50306, 50352, 50367, 50420, 50495, 50526, 50540, 50564, 50584, 50586, 50604, 50653, 50664, 50736, 50799, 50812, 50833, 50837, 50867, 50893, 50927, 50988, 51088, 51094, 51098, 51121, 51187, 51210, 51233, 51307, 51312, 51328, 51334, 51603, 51635, 51646, 51660, 51681, 51710, 51726, 51761, 51817, 51940, 52038, 52195, 52269, 52382, 52415, 52480, 52494, 52562, 52577, 52615, 52645, 52654, 52702, 52707, 52711, 52713, 52743, 53005, 53087, 53108, 53140, 53168, 53180, 53261, 53386, 53478, 53626, 53842, 53903, 53965, 53997, 54069, 54113, 54128, 54177, 54241, 54273, 54304, 54308, 54343, 54372, 54385, 54418, 54451, 54462, 54475, 54483, 54491, 54535, 54564, 54567, 54640, 54676, 54734, 54752, 54796, 54804, 54885, 54886, 54895, 54989, 55049, 55093, 55233, 55399, 55419, 55469, 55481, 55647, 55652, 55754, 55791, 55841, 55901, 55912, 55971, 56183, 56217, 56276, 56488, 56515, 56538, 56566, 56567, 56569, 56652, 56736, 56807, 56864, 56869, 56870, 56923, 56932, 57053, 57057, 57125, 57141, 57149, 57303, 57376, 57447, 57452, 57479, 57517, 57736, 57792, 57874, 57916, 57936, 57978, 58039, 58047, 58068, 58078, 58083, 58086, 58101, 58309, 58330, 58338, 58410, 58463, 58576, 58610, 58615, 58720, 58740, 58751, 58756, 58761, 58789, 58845, 58857, 58898, 58929, 58938, 58959, 58977, 58983, 59034, 59052, 59100, 59198, 59257, 59262, 59296, 59390, 59396, 59462, 59555, 59582, 59592, 59609, 59752, 60039, 60138, 60238, 60438, 60641, 60745, 61528, 61642, 63474, 64279, 64672, 73202, 87706, 101016, 126715, 126821, 137430, 137921, 138003, 138291, 138292, 138331, 138517, 138523, 138589, 138609, 138699, 138801, 138860, 138978, 139046, 139049, 139086, 139118, 139302, 139324, 139346, 139388, 139394, 139398, 139410, 139426, 139454, 139459, 139472, 139476, 139480, 139514, 139549, 139578, 139581, 139585, 139612, 139620, 139637, 139679, 139812, 139839, 139855, 139888, 139900, 139932, 139953, 139973, 139979, 139981, 139982, 139985, 139988, 139990, 139997, 140007, 140009, 140020, 140035, 140040, 140042, 140044, 140065, 140074, 140084, 140087, 140092, 140181, 140182, 140183, 140227, 140242, 140248, 140254, 140277, 140283, 140303, 140310, 140317, 140319, 140322, 140366, 140393, 140417, 140426, 140427, 140432, 140433, 140437, 140439, 140442, 140459, 140462, 140464, 140472, 140509, 140511, 140514, 140520, 140523, 140545, 140562, 140567, 140600, 140617, 140625, 140716, 140745, 140755, 140864, 140899, 141090, 141123, 141175, 141192, 141193, 141210, 141216, 141228, 141232, 141304, 141589, 141594, 141595, 141607, 141654, 141720, 141740, 141755, 141790, 141825, 141827, 141893, 141988, 141992, 142002, 142019, 142027, 142069, 142071, 142072, 142074, 142096, 142100, 142115, 142142, 142359, 142361, 142409, 142414, 142461, 142462, 142463, 142479, 142480, 142493, 142514, 142519, 142623, 142641, 142644, 153414, 153440, 153516, 153600, 153627, 153659, 153758, 153865, 153930, 153942, 153993, 154004, 154016, 154023, 154033, 154040, 154061, 154072, 154083, 154095, 154118, 154121, 154200, 154258, 154269, 154275, 154296, 154338, 154386, 154422, 154436, 154441, 154455, 154467, 154468, 154529, 154530, 154533, 154575, 154652, 154749, 154810, 154852, 154872, 154884, 154928, 154943, 154970, 154971, 154976, 155056, 155071, 155100, 155148, 155161, 155171, 155195, 155198, 155204, 155226, 155229, 155235, 155251, 155265, 155272, 155288, 155297, 155317, 155321, 155323, 155327, 155340, 155341, 155342, 155344, 155345, 155346, 155348, 155350, 155351, 155359, 155362, 155364, 155389, 155427, 155430, 155445, 155452, 155460, 155484, 155503, 155521, 155535, 155540, 155569, 155579, 155585, 155654, 155655, 155736, 155813, 155815, 156004, 156007, 156017, 156080, 156086, 156102, 156107, 156110, 156117, 156121, 156137, 156139, 156215, 156216, 156229, 156289, 156291, 156296, 156302, 156303, 156334, 156345, 156762, 156806, 156828, 156928, 156937, 156965, 156991, 157004, 157028, 157030, 157033, 157036, 157045, 157050, 157084, 157097, 157099, 157118, 157122, 157137, 157184, 157198, 157203, 157208, 157210, 157215, 157228, 157277, 157323, 157338, 157384, 157385, 157425, 157441, 157462, 157526, 157549, 157561, 157581, 157620, 157622, 157655, 157706, 157758, 157767, 157774, 157787, 157788, 157852, 157865, 157923, 157962, 158018, 158100, 158118, 158160, 158169, 158177, 158337, 158346, 158348, 158353, 158365, 158374, 158454, 158460, 158586, 173716, 173746, 173771, 173800, 173815, 173816, 173831, 173848, 173867, 173868, 173889, 173901, 173919, 173929, 173930, 173931, 173934, 173941, 173946, 173953, 173955, 173961, 174033, 174129, 174139, 174157, 174159, 174164, 174169, 174171, 174186, 174190, 174252, 174263, 174268, 174311, 174320, 174329, 174335, 174336, 174337, 174342, 174361, 174363, 174367, 174389, 174409, 174415, 174436, 186977, 187068, 187071, 187161, 187186, 187221, 187282, 187338, 187410, 187420, 187442, 187458, 187485, 187541, 187552, 187553, 187583, 187599, 187637, 187699, 187717, 187751, 187763, 187803, 187811, 187825, 187858, 187889, 187944, 187955, 187961, 187981, 187998, 188044, 188080, 188177, 188211, 188216, 188230, 188231, 188236, 197554, 197584, 197593, 197634, 197636, 197637, 197665, 197670, 197672, 197727, 197766, 197798, 197808, 197827, 197828, 197834, 197835, 197837, 197856, 197860, 197883, 197908, 197916, 197919, 197967, 197969, 197984, 198011, 198030, 198090, 198170, 198201, 198244, 198414, 198713, 198751, 198853, 198867, 198911, 198958, 198968, 199387, 199468, 203146, 203157, 203172, 203173, 203183, 203185, 203195, 203196, 203198, 203210, 203231, 203248, 203249, 203280, 203281, 203313, 203316, 203327, 203341, 203342, 203499, 203504, 206866, 211030, 211036, 211062, 211064, 211070, 211074, 211109, 211114, 218697, 218709, 218843, 218883, 218961, 218973, 218974, 219004, 219107, 219164, 219170, 219223, 219243, 219272, 219357, 219379, 219429, 219436, 219540, 219555, 219564, 219566, 219598, 219645, 219669, 219697, 219707, 250590, 250621, 250703, 250738, 250943, 251031, 251044, 251186, 251320, 251478, 251484, 251516, 251770, 252058, 252083, 252087, 252088, 252089, 252113, 252215, 252238, 252292, 252302, 252559, 252650, 252653, 252868, 252927, 252945, 252947, 253096, 253115, 253174, 253184, 253618, 253650, 253986, 254038, 254074, 254158, 263260, 263267, 263868, 263904, 264448, 264708, 265223, 265353, 265359, 265770, 265810, 265925, 266096, 266120, 266142, 266164, 266206, 266264, 266490, 266508, 266509, 266520, 266551, 266568, 266592, 266610, 282884, 282925, 282928, 283067, 283123, 283124, 283159, 283160, 283206, 283295, 283304, 283316, 283336, 283393, 283394, 283403, 283431, 283449, 283457, 283466, 283770, 283814, 283856, 283857, 283871, 283881, 283910, 283927, 283930, 283933, 283936, 283938, 283939, 283946, 283947, 283950, 283954, 283955, 283956, 283967, 283969, 283970, 283974, 283975, 283977, 283980, 287881, 288295, 288444, 288704, 288706, 288729, 288870, 288952, 288971, 289331, 289376, 289422, 289588, 289616, 289711, 289732, 289839, 289986, 290003, 290113, 290218, 290250, 290290, 290324, 290326, 290344, 290351, 290520, 290617, 290704, 290801, 290871, 290894, 290941, 290973, 290976, 291039, 297029, 297049, 297122, 297133, 297229, 297250, 297256, 297268, 297296, 297299, 297344, 297351, 297650, 297657, 297662, 297750, 297759, 297793, 297832, 297836, 297843, 301824, 301853, 302004, 302022, 302042, 302049, 302052, 302090, 302160, 302206, 302230, 302275, 302278, 302293, 302342, 302449, 302526, 302616, 302656, 302695, 305390, 305408, 305469, 305485, 305487, 305513, 305520, 305529, 305550, 305563, 305583, 305594, 305598, 308212, 308451, 308456, 308469, 308470, 308518, 308555, 308638, 308644, 308657, 308682, 308704, 308710, 308715, 308716, 308758, 308842, 308883, 313337, 313363, 313391, 313418, 313445, 313447, 313463, 313519, 313545, 313557, 313576, 313578, 313621, 313910, 313914, 313916, 313922, 313923, 313931, 313936, 321471, 321476, 321484, 321501, 321504, 321507, 321512, 321521, 321552, 321558, 321560, 321577, 321593, 321595, 321600, 321608, 321614, 321630, 321654, 321888, 322093, 322157, 322167, 322235, 322375, 322515, 322602, 324251, 324628, 324779, 324880, 324977, 325263, 325351, 325661, 325681, 325855, 325901, 326005, 326084, 326123, 326124, 326177, 326358, 326647, 326649, 326992, 326993, 327070, 327116, 327352, 327353, 327361, 327375, 327487, 327493, 327544, 327556, 327558, 327575, 327626, 327698, 327719, 327721, 327750, 327768, 327772, 329215, 329231, 330189, 330453, 330595, 330621, 330677, 330688, 331089, 331145, 331222, 331259, 331267, 331285, 331317, 331376, 331382, 331609, 331636, 331639, 331645, 331749, 331762, 331833, 331882, 331968, 332019, 332593, 332610, 332620, 332675, 332680, 332691, 332860, 333040, 333650, 333670, 333871, 334484, 334654, 334777, 335636, 335702, 335748, 335813, 335928, 335956, 336060, 336084, 336142, 336143, 336152, 336164, 336194, 336200, 336222, 336224, 336233, 336242, 336244, 336247, 336259, 336261, 336306, 343528, 349660, 349905, 350024, 350115, 350133, 350310, 350351, 350380, 350382, 350523, 350799, 350800, 350882, 350894, 350896, 350914, 350982, 351052, 351076, 351150, 351162, 351195, 351279, 351297, 351329, 351351, 351366, 351412, 351417, 351425, 351426, 351432, 351448, 351452, 356905, 357011, 357083, 357181, 357211, 357234, 357544, 357583, 357613, 357684, 357748, 357770, 357816, 357828, 357829, 357830, 358040, 359112, 359220, 359222, 359286, 359366, 359380, 359390, 359419, 359452, 359458, 359504, 359558, 359593, 359607, 359657, 359667, 359672, 359700, 359705, 359744, 359804, 359890, 359911, 360007, 360038, 360135, 360147, 360260, 360295, 360385, 360544, 360674, 360757, 360866, 360870, 363651, 363673, 363684, 363689, 363995, 364640, 364664, 364683, 364717, 364738, 364774, 364799, 364810, 364826, 364831, 364837, 364838, 364844, 364845, 364858, 364901, 364902, 364937, 365021, 365059, 365093, 365125, 365127, 365146, 365151, 365162, 365200, 365201, 365203, 365242, 365295, 365297, 365331, 365345, 365350, 365368, 365392, 365454, 365470, 365492, 365515, 365525, 365534, 365553, 365575, 377670, 377699, 377715, 377720, 377751, 377761, 377861, 377867, 377869, 377871, 377892, 377997, 378002, 378029, 378118, 378148, 378230, 378371, 378583, 378588, 378611, 378679, 378681, 378691, 378710, 378725, 378909, 379004, 379297, 379308, 379372, 379396, 379401, 379405, 379411, 379458, 379477, 379486, 379505, 379513, 379514, 379516, 379620, 379659, 379714, 398083, 398086, 398141, 398146, 398246, 398254, 398343, 398389, 398409, 398466, 398473, 398480, 398527, 398546, 398611, 398622, 398624, 398650, 398693, 398716, 398727, 398757, 398760, 398774, 398844, 398846, 398851, 399068, 399188, 399227, 399296, 399353, 399391, 399512, 399533, 399542, 399560, 399601, 399619, 399686, 399778, 399786, 399807, 399812, 399834, 399843, 399913, 399939, 399949, 399950, 399953, 400006, 400008, 400009, 400014, 400036, 400070, 400096, 400098, 400103, 400118, 400174, 400178, 400315, 400317, 400327, 400354, 400379, 400403, 400410, 400452, 400468, 400469, 400479, 400504, 400537, 400547, 400583, 400640, 400660, 400725, 400746, 400751, 400770, 400788, 400817, 400841, 400843, 400859, 400869, 400878, 400883, 400904, 413569, 413577, 413692, 413704, 413724, 413802, 413813, 413836, 413892, 413957, 413958, 414037, 414050, 414063, 414064, 414066, 415244, 415623, 415639, 415733, 415818, 415826, 415901, 416751, 416823, 416972, 417122, 417126, 417195, 417243, 417380, 417385, 417456, 417560, 417563, 417564, 417581, 417610, 417703, 417722, 417809, 417833, 417852, 417884, 417932, 418256, 418425, 418434, 418528, 418575, 418606, 418664, 418674, 418740, 418821, 418855, 418908, 419010, 419030, 419054, 419093, 419109, 419124, 419159, 419162, 419201, 419215, 419216, 419230, 419234, 428323, 428327, 428616, 428629, 428686, 428716, 428746, 428770, 429375, 429380, 429390, 429391, 429393, 429394, 429396, 429397, 429400, 429420, 429421, 429466, 429475, 429641, 429657, 429664, 429671, 429679, 429680, 429690, 429736, 429768, 429787, 429964, 429969, 429983, 429996, 430005, 430071, 430096, 430104, 430126, 430154, 430175, 430360, 430364, 430502, 430609, 430627, 430662, 430681, 430789, 430795, 430842, 430846, 430849, 430850, 430871, 430877, 430899, 439790, 439805, 439896, 440124, 440170, 440194, 440221, 440225, 440226, 440273, 442959, 448578, 448684, 448786, 449325, 449401, 449681, 449765, 449886, 449889, 450151, 450234, 450314, 450338, 450340, 450459, 450467, 450530, 450570, 450701, 450776, 450793, 454783, 454789, 454838, 454904, 454951, 454954, 455000, 455037, 455049, 455094, 455183, 457338, 458368, 458399, 458404, 458410, 458576, 458667, 458906, 458953, 459000, 459121, 459123, 466743, 466777, 466779, 466852, 466900, 466901, 466950, 467036, 467052, 467112, 467113, 467122, 467140, 467151, 467160, 467172, 467173, 469904, 470162, 470187, 470191, 470193, 470252, 470271, 470302, 470414, 470428, 470455, 470526, 470573, 470630, 470802, 470833, 470835, 470842, 470868, 470884, 470885, 470886, 470887, 470905, 470970, 471089, 471115, 471150, 471165, 471184, 471195, 471240, 471381, 471385, 471497, 471505, 471515, 471682, 471683, 471720, 471757, 471861, 471944, 471974, 471989, 471992, 472041, 472056, 472141, 472203, 472205, 472292, 472293, 472350, 472399, 472415, 472418, 472431, 472432, 472445, 472452, 472486, 472495, 472514, 472527, 483601, 483662, 483681, 483684, 483692, 483734, 483803, 483837, 483873, 483877, 483886, 483890, 483899, 483943, 484003, 484006, 484030, 484053, 484094, 484461, 484486, 484663, 485016, 485096, 485344, 485500, 485512, 485630, 485637, 485833, 485908, 486179, 486386, 486422, 486505, 486692, 486711, 486780, 486891, 486919, 487189, 487213, 487286, 487326, 487390, 487458, 487459, 487558, 487601, 487609, 487613, 487622, 497310, 497445, 497457, 497506, 497607, 497630, 497645, 497647, 498349, 498363, 498403, 498491, 498560, 498594, 498620, 498926, 498931, 499139, 499216, 499267, 499277, 499310, 499407, 499409, 499488, 499511, 499661, 499697, 499823, 499837, 499963, 502857, 502947, 502948, 503051, 503884, 503999, 504015, 504763, 504766, 504768, 504773, 504775, 504778, 505254, 505543, 506092, 506093, 506097, 506098, 506099, 506100, 506105, 507168, 507169, 507170, 507171, 507173, 507175, 507233, 507347, 507349, 507443, 507510, 507513, 507516, 508094, 509270, 522881, 522900, 522905, 522929, 522953, 522975, 522984, 523001, 523039, 523085, 523106, 523126, 523156, 523179, 523195, 523201, 523207, 523211, 523219, 523221, 523282, 523287, 523325, 523332, 523336, 523342, 523347, 523427, 523451, 523460, 523462, 523480, 523508, 523532, 523546, 523559, 523588, 523603, 523606, 523634, 523644, 523652, 523658, 523704, 523717, 523727, 523743, 523778, 523792, 523852, 523854, 523856, 523912, 548046, 548528, 548575, 548576, 548892, 549733, 549770, 549804)11156
34SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` IN (1323, 1322, 1324) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`208320835
35SELECT `MPropertyBuilding`.`id` FROM `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` WHERE `MPropertyBuilding`.`id` IN (15109, 15121, 15243, 15329, 15671, 15677, 15730, 15807, 15847, 16088, 16452, 19271, 19333, 19526, 19528, 19582, 19645, 19916, 19963, 20086, 20305, 20525, 20817, 20840, 20876, 20972, 21242, 22272, 22293, 23025, 23264, 23294, 23343, 23580, 23663, 23867, 23883, 24043, 24112, 24154, 24163, 24236, 24246, 24268, 24313, 24437, 24531, 24533, 24592, 24634, 24657, 24698, 24758, 24767, 24848, 24858, 24864, 24889, 25048, 25142, 25184, 25195, 25275, 25379, 25443, 25447, 25457, 25458, 25464, 25473, 25477, 25533, 25553, 25690, 25844, 25932, 25971, 26003, 26073, 26129, 26153, 26274, 26321, 26380, 26450, 26472, 26482, 26484, 26496, 26587, 26793, 26795, 26896, 26927, 26935, 26944, 26974, 26984, 27011, 36888, 36915, 36994, 37068, 37079, 37103, 37115, 37125, 37141, 37179, 37196, 37226, 37233, 37242, 37261, 37302, 37698, 37712, 37731, 37909, 37992, 37999, 38056, 38090, 38154, 38851, 38919, 38960, 38969, 39044, 39192, 39342, 39554, 39559, 39958, 40329, 40435, 40470, 40486, 40501, 40513, 40562, 40603, 40613, 40693, 40694, 40772, 40977, 41137, 41372, 41406, 41625, 41742, 41828, 41912, 41921, 41923, 41953, 41966, 42473, 42499, 42503, 42560, 43185, 43391, 43398, 43846, 44188, 44405, 44495, 44591, 44860, 45445, 45593, 45649, 45742, 46008, 46064, 46075, 46424, 47538, 47745, 47824, 47832, 47850, 48245, 48338, 48365, 48385, 48397, 48408, 48468, 48592, 48599, 48611, 48671, 48682, 48700, 48712, 48736, 48835, 49047, 49050, 49072, 49079, 49110, 49119, 49155, 49195, 49197, 49226, 49239, 49255, 49284, 49314, 49332, 49373, 49492, 49607, 49608, 49655, 49681, 49725, 49781, 49816, 49843, 50036, 50105, 50116, 50119, 50121, 50150, 50230, 50283, 50287, 50306, 50352, 50367, 50420, 50495, 50526, 50540, 50564, 50584, 50586, 50604, 50653, 50664, 50736, 50799, 50812, 50833, 50837, 50867, 50893, 50927, 50988, 51088, 51094, 51098, 51121, 51187, 51210, 51233, 51307, 51312, 51328, 51334, 51603, 51635, 51646, 51660, 51681, 51710, 51726, 51761, 51817, 51940, 52038, 52195, 52269, 52382, 52415, 52480, 52494, 52562, 52577, 52615, 52645, 52654, 52702, 52707, 52711, 52713, 52743, 53005, 53087, 53108, 53140, 53168, 53180, 53261, 53386, 53478, 53626, 53842, 53903, 53965, 53997, 54069, 54113, 54128, 54177, 54241, 54273, 54304, 54308, 54343, 54372, 54385, 54418, 54451, 54462, 54475, 54483, 54491, 54535, 54564, 54567, 54640, 54676, 54734, 54752, 54796, 54804, 54885, 54886, 54895, 54989, 55049, 55093, 55233, 55399, 55419, 55469, 55481, 55647, 55652, 55754, 55791, 55841, 55901, 55912, 55971, 56183, 56217, 56276, 56488, 56515, 56538, 56566, 56567, 56569, 56652, 56736, 56807, 56864, 56869, 56870, 56923, 56932, 57053, 57057, 57125, 57141, 57149, 57303, 57376, 57447, 57452, 57479, 57517, 57736, 57792, 57874, 57916, 57936, 57978, 58039, 58047, 58068, 58078, 58083, 58086, 58101, 58309, 58330, 58338, 58410, 58463, 58576, 58610, 58615, 58720, 58740, 58751, 58756, 58761, 58789, 58845, 58857, 58898, 58929, 58938, 58959, 58977, 58983, 59034, 59052, 59100, 59198, 59257, 59262, 59296, 59390, 59396, 59462, 59555, 59582, 59592, 59609, 59752, 60039, 60138, 60238, 60438, 60641, 60745, 61528, 61642, 63474, 64279, 64672, 73202, 87706, 101016, 126715, 126821, 137430, 137921, 138003, 138291, 138292, 138331, 138517, 138523, 138589, 138609, 138699, 138801, 138860, 138978, 139046, 139049, 139086, 139118, 139302, 139324, 139346, 139388, 139394, 139398, 139410, 139426, 139454, 139459, 139472, 139476, 139480, 139514, 139549, 139578, 139581, 139585, 139612, 139620, 139637, 139679, 139812, 139839, 139855, 139888, 139900, 139932, 139953, 139973, 139979, 139981, 139982, 139985, 139988, 139990, 139997, 140007, 140009, 140020, 140035, 140040, 140042, 140044, 140065, 140074, 140084, 140087, 140092, 140181, 140182, 140183, 140227, 140242, 140248, 140254, 140277, 140283, 140303, 140310, 140317, 140319, 140322, 140366, 140393, 140417, 140426, 140427, 140432, 140433, 140437, 140439, 140442, 140459, 140462, 140464, 140472, 140509, 140511, 140514, 140520, 140523, 140545, 140562, 140567, 140600, 140617, 140625, 140716, 140745, 140755, 140864, 140899, 141090, 141123, 141175, 141192, 141193, 141210, 141216, 141228, 141232, 141304, 141589, 141594, 141595, 141607, 141654, 141720, 141740, 141755, 141790, 141825, 141827, 141893, 141988, 141992, 142002, 142019, 142027, 142069, 142071, 142072, 142074, 142096, 142100, 142115, 142142, 142359, 142361, 142409, 142414, 142461, 142462, 142463, 142479, 142480, 142493, 142514, 142519, 142623, 142641, 142644, 153414, 153440, 153516, 153600, 153627, 153659, 153758, 153865, 153930, 153942, 153993, 154004, 154016, 154023, 154033, 154040, 154061, 154072, 154083, 154095, 154118, 154121, 154200, 154258, 154269, 154275, 154296, 154338, 154386, 154422, 154436, 154441, 154455, 154467, 154468, 154529, 154530, 154533, 154575, 154652, 154749, 154810, 154852, 154872, 154884, 154928, 154943, 154970, 154971, 154976, 155056, 155071, 155100, 155148, 155161, 155171, 155195, 155198, 155204, 155226, 155229, 155235, 155251, 155265, 155272, 155288, 155297, 155317, 155321, 155323, 155327, 155340, 155341, 155342, 155344, 155345, 155346, 155348, 155350, 155351, 155359, 155362, 155364, 155389, 155427, 155430, 155445, 155452, 155460, 155484, 155503, 155521, 155535, 155540, 155569, 155579, 155585, 155654, 155655, 155736, 155813, 155815, 156004, 156007, 156017, 156080, 156086, 156102, 156107, 156110, 156117, 156121, 156137, 156139, 156215, 156216, 156229, 156289, 156291, 156296, 156302, 156303, 156334, 156345, 156762, 156806, 156828, 156928, 156937, 156965, 156991, 157004, 157028, 157030, 157033, 157036, 157045, 157050, 157084, 157097, 157099, 157118, 157122, 157137, 157184, 157198, 157203, 157208, 157210, 157215, 157228, 157277, 157323, 157338, 157384, 157385, 157425, 157441, 157462, 157526, 157549, 157561, 157581, 157620, 157622, 157655, 157706, 157758, 157767, 157774, 157787, 157788, 157852, 157865, 157923, 157962, 158018, 158100, 158118, 158160, 158169, 158177, 158337, 158346, 158348, 158353, 158365, 158374, 158454, 158460, 158586, 173716, 173746, 173771, 173800, 173815, 173816, 173831, 173848, 173867, 173868, 173889, 173901, 173919, 173929, 173930, 173931, 173934, 173941, 173946, 173953, 173955, 173961, 174033, 174129, 174139, 174157, 174159, 174164, 174169, 174171, 174186, 174190, 174252, 174263, 174268, 174311, 174320, 174329, 174335, 174336, 174337, 174342, 174361, 174363, 174367, 174389, 174409, 174415, 174436, 186977, 187068, 187071, 187161, 187186, 187221, 187282, 187338, 187410, 187420, 187442, 187458, 187485, 187541, 187552, 187553, 187583, 187599, 187637, 187699, 187717, 187751, 187763, 187803, 187811, 187825, 187858, 187889, 187944, 187955, 187961, 187981, 187998, 188044, 188080, 188177, 188211, 188216, 188230, 188231, 188236, 197554, 197584, 197593, 197634, 197636, 197637, 197665, 197670, 197672, 197727, 197766, 197798, 197808, 197827, 197828, 197834, 197835, 197837, 197856, 197860, 197883, 197908, 197916, 197919, 197967, 197969, 197984, 198011, 198030, 198090, 198170, 198201, 198244, 198414, 198713, 198751, 198853, 198867, 198911, 198958, 198968, 199387, 199468, 203146, 203157, 203172, 203173, 203183, 203185, 203195, 203196, 203198, 203210, 203231, 203248, 203249, 203280, 203281, 203313, 203316, 203327, 203341, 203342, 203499, 203504, 206866, 211030, 211036, 211062, 211064, 211070, 211074, 211109, 211114, 218697, 218709, 218843, 218883, 218961, 218973, 218974, 219004, 219107, 219164, 219170, 219223, 219243, 219272, 219357, 219379, 219429, 219436, 219540, 219555, 219564, 219566, 219598, 219645, 219669, 219697, 219707, 250590, 250621, 250703, 250738, 250943, 251031, 251044, 251186, 251320, 251478, 251484, 251516, 251770, 252058, 252083, 252087, 252088, 252089, 252113, 252215, 252238, 252292, 252302, 252559, 252650, 252653, 252868, 252927, 252945, 252947, 253096, 253115, 253174, 253184, 253618, 253650, 253986, 254038, 254074, 254158, 263260, 263267, 263868, 263904, 264448, 264708, 265223, 265353, 265359, 265770, 265810, 265925, 266096, 266120, 266142, 266164, 266206, 266264, 266490, 266508, 266509, 266520, 266551, 266568, 266592, 266610, 282884, 282925, 282928, 283067, 283123, 283124, 283159, 283160, 283206, 283295, 283304, 283316, 283336, 283393, 283394, 283403, 283431, 283449, 283457, 283466, 283770, 283814, 283856, 283857, 283871, 283881, 283910, 283927, 283930, 283933, 283936, 283938, 283939, 283946, 283947, 283950, 283954, 283955, 283956, 283967, 283969, 283970, 283974, 283975, 283977, 283980, 287881, 288295, 288444, 288704, 288706, 288729, 288870, 288952, 288971, 289331, 289376, 289422, 289588, 289616, 289711, 289732, 289839, 289986, 290003, 290113, 290218, 290250, 290290, 290324, 290326, 290344, 290351, 290520, 290617, 290704, 290801, 290871, 290894, 290941, 290973, 290976, 291039, 297029, 297049, 297122, 297133, 297229, 297250, 297256, 297268, 297296, 297299, 297344, 297351, 297650, 297657, 297662, 297750, 297759, 297793, 297832, 297836, 297843, 301824, 301853, 302004, 302022, 302042, 302049, 302052, 302090, 302160, 302206, 302230, 302275, 302278, 302293, 302342, 302449, 302526, 302616, 302656, 302695, 305390, 305408, 305469, 305485, 305487, 305513, 305520, 305529, 305550, 305563, 305583, 305594, 305598, 308212, 308451, 308456, 308469, 308470, 308518, 308555, 308638, 308644, 308657, 308682, 308704, 308710, 308715, 308716, 308758, 308842, 308883, 313337, 313363, 313391, 313418, 313445, 313447, 313463, 313519, 313545, 313557, 313576, 313578, 313621, 313910, 313914, 313916, 313922, 313923, 313931, 313936, 321471, 321476, 321484, 321501, 321504, 321507, 321512, 321521, 321552, 321558, 321560, 321577, 321593, 321595, 321600, 321608, 321614, 321630, 321654, 321888, 322093, 322157, 322167, 322235, 322375, 322515, 322602, 324251, 324628, 324779, 324880, 324977, 325263, 325351, 325661, 325681, 325855, 325901, 326005, 326084, 326123, 326124, 326177, 326358, 326647, 326649, 326992, 326993, 327070, 327116, 327352, 327353, 327361, 327375, 327487, 327493, 327544, 327556, 327558, 327575, 327626, 327698, 327719, 327721, 327750, 327768, 327772, 329215, 329231, 330189, 330453, 330595, 330621, 330677, 330688, 331089, 331145, 331222, 331259, 331267, 331285, 331317, 331376, 331382, 331609, 331636, 331639, 331645, 331749, 331762, 331833, 331882, 331968, 332019, 332593, 332610, 332620, 332675, 332680, 332691, 332860, 333040, 333650, 333670, 333871, 334484, 334654, 334777, 335636, 335702, 335748, 335813, 335928, 335956, 336060, 336084, 336142, 336143, 336152, 336164, 336194, 336200, 336222, 336224, 336233, 336242, 336244, 336247, 336259, 336261, 336306, 343528, 349660, 349905, 350024, 350115, 350133, 350310, 350351, 350380, 350382, 350523, 350799, 350800, 350882, 350894, 350896, 350914, 350982, 351052, 351076, 351150, 351162, 351195, 351279, 351297, 351329, 351351, 351366, 351412, 351417, 351425, 351426, 351432, 351448, 351452, 356905, 357011, 357083, 357181, 357211, 357234, 357544, 357583, 357613, 357684, 357748, 357770, 357816, 357828, 357829, 357830, 358040, 359112, 359220, 359222, 359286, 359366, 359380, 359390, 359419, 359452, 359458, 359504, 359558, 359593, 359607, 359657, 359667, 359672, 359700, 359705, 359744, 359804, 359890, 359911, 360007, 360038, 360135, 360147, 360260, 360295, 360385, 360544, 360674, 360757, 360866, 360870, 363651, 363673, 363684, 363689, 363995, 364640, 364664, 364683, 364717, 364738, 364774, 364799, 364810, 364826, 364831, 364837, 364838, 364844, 364845, 364858, 364901, 364902, 364937, 365021, 365059, 365093, 365125, 365127, 365146, 365151, 365162, 365200, 365201, 365203, 365242, 365295, 365297, 365331, 365345, 365350, 365368, 365392, 365454, 365470, 365492, 365515, 365525, 365534, 365553, 365575, 377670, 377699, 377715, 377720, 377751, 377761, 377861, 377867, 377869, 377871, 377892, 377997, 378002, 378029, 378118, 378148, 378230, 378371, 378583, 378588, 378611, 378679, 378681, 378691, 378710, 378725, 378909, 379004, 379297, 379308, 379372, 379396, 379401, 379405, 379411, 379458, 379477, 379486, 379505, 379513, 379514, 379516, 379620, 379659, 379714, 398083, 398086, 398141, 398146, 398246, 398254, 398343, 398389, 398409, 398466, 398473, 398480, 398527, 398546, 398611, 398622, 398624, 398650, 398693, 398716, 398727, 398757, 398760, 398774, 398844, 398846, 398851, 399068, 399188, 399227, 399296, 399353, 399391, 399512, 399533, 399542, 399560, 399601, 399619, 399686, 399778, 399786, 399807, 399812, 399834, 399843, 399913, 399939, 399949, 399950, 399953, 400006, 400008, 400009, 400014, 400036, 400070, 400096, 400098, 400103, 400118, 400174, 400178, 400315, 400317, 400327, 400354, 400379, 400403, 400410, 400452, 400468, 400469, 400479, 400504, 400537, 400547, 400583, 400640, 400660, 400725, 400746, 400751, 400770, 400788, 400817, 400841, 400843, 400859, 400869, 400878, 400883, 400904, 413569, 413577, 413692, 413704, 413724, 413802, 413813, 413836, 413892, 413957, 413958, 414037, 414050, 414063, 414064, 414066, 415244, 415623, 415639, 415733, 415818, 415826, 415901, 416751, 416823, 416972, 417122, 417126, 417195, 417243, 417380, 417385, 417456, 417560, 417563, 417564, 417581, 417610, 417703, 417722, 417809, 417833, 417852, 417884, 417932, 418256, 418425, 418434, 418528, 418575, 418606, 418664, 418674, 418740, 418821, 418855, 418908, 419010, 419030, 419054, 419093, 419109, 419124, 419159, 419162, 419201, 419215, 419216, 419230, 419234, 428323, 428327, 428616, 428629, 428686, 428716, 428746, 428770, 429375, 429380, 429390, 429391, 429393, 429394, 429396, 429397, 429400, 429420, 429421, 429466, 429475, 429641, 429657, 429664, 429671, 429679, 429680, 429690, 429736, 429768, 429787, 429964, 429969, 429983, 429996, 430005, 430071, 430096, 430104, 430126, 430154, 430175, 430360, 430364, 430502, 430609, 430627, 430662, 430681, 430789, 430795, 430842, 430846, 430849, 430850, 430871, 430877, 430899, 439790, 439805, 439896, 440124, 440170, 440194, 440221, 440225, 440226, 440273, 442959, 448578, 448684, 448786, 449325, 449401, 449681, 449765, 449886, 449889, 450151, 450234, 450314, 450338, 450340, 450459, 450467, 450530, 450570, 450701, 450776, 450793, 454783, 454789, 454838, 454904, 454951, 454954, 455000, 455037, 455049, 455094, 455183, 457338, 458368, 458399, 458404, 458410, 458576, 458667, 458906, 458953, 459000, 459121, 459123, 466743, 466777, 466779, 466852, 466900, 466901, 466950, 467036, 467052, 467112, 467113, 467122, 467140, 467151, 467160, 467172, 467173, 469904, 470162, 470187, 470191, 470193, 470252, 470271, 470302, 470414, 470428, 470455, 470526, 470573, 470630, 470802, 470833, 470835, 470842, 470868, 470884, 470885, 470886, 470887, 470905, 470970, 471089, 471115, 471150, 471165, 471184, 471195, 471240, 471381, 471385, 471497, 471505, 471515, 471682, 471683, 471720, 471757, 471861, 471944, 471974, 471989, 471992, 472041, 472056, 472141, 472203, 472205, 472292, 472293, 472350, 472399, 472415, 472418, 472431, 472432, 472445, 472452, 472486, 472495, 472514, 472527, 483601, 483662, 483681, 483684, 483692, 483734, 483803, 483837, 483873, 483877, 483886, 483890, 483899, 483943, 484003, 484006, 484030, 484053, 484094, 484461, 484486, 484663, 485016, 485096, 485344, 485500, 485512, 485630, 485637, 485833, 485908, 486179, 486386, 486422, 486505, 486692, 486711, 486780, 486891, 486919, 487189, 487213, 487286, 487326, 487390, 487458, 487459, 487558, 487601, 487609, 487613, 487622, 497310, 497445, 497457, 497506, 497607, 497630, 497645, 497647, 498349, 498363, 498403, 498491, 498560, 498594, 498620, 498926, 498931, 499139, 499216, 499267, 499277, 499310, 499407, 499409, 499488, 499511, 499661, 499697, 499823, 499837, 499963, 502857, 502947, 502948, 503051, 503884, 503999, 504015, 504763, 504766, 504768, 504773, 504775, 504778, 505254, 505543, 506092, 506093, 506097, 506098, 506099, 506100, 506105, 507168, 507169, 507170, 507171, 507173, 507175, 507233, 507347, 507349, 507443, 507510, 507513, 507516, 508094, 509270, 522881, 522900, 522905, 522929, 522953, 522975, 522984, 523001, 523039, 523085, 523106, 523126, 523156, 523179, 523195, 523201, 523207, 523211, 523219, 523221, 523282, 523287, 523325, 523332, 523336, 523342, 523347, 523427, 523451, 523460, 523462, 523480, 523508, 523532, 523546, 523559, 523588, 523603, 523606, 523634, 523644, 523652, 523658, 523704, 523717, 523727, 523743, 523778, 523792, 523852, 523854, 523856, 523912, 548046, 548528, 548575, 548576, 548892, 549733, 549770, 549804)2083208313
36SELECT `PropertyInformation`.`id`, `PropertyInformation`.`name`, `PropertyInformation`.`pronunciation_of_name`, `PropertyInformation`.`unique_key`, `PropertyInformation`.`order`, `PropertyInformation`.`url`, `PropertyInformation`.`room_number`, `PropertyInformation`.`start_date`, `PropertyInformation`.`update_date`, `PropertyInformation`.`end_date`, `PropertyInformation`.`move_on_same_day`, `PropertyInformation`.`moving_date`, `PropertyInformation`.`leaving_date`, `PropertyInformation`.`rent`, `PropertyInformation`.`security_deposit`, `PropertyInformation`.`sinking_security_deposit`, `PropertyInformation`.`key_money`, `PropertyInformation`.`addon_key_money`, `PropertyInformation`.`deposit`, `PropertyInformation`.`premium`, `PropertyInformation`.`maintenance_fee`, `PropertyInformation`.`common_area_fee`, `PropertyInformation`.`commission`, `PropertyInformation`.`cost_note`, `PropertyInformation`.`renewal_fee`, `PropertyInformation`.`renewable`, `PropertyInformation`.`termination_note`, `PropertyInformation`.`ad`, `PropertyInformation`.`reward_note`, `PropertyInformation`.`free_rent`, `PropertyInformation`.`require_insurance`, `PropertyInformation`.`insuarance_note`, `PropertyInformation`.`require_guarantee`, `PropertyInformation`.`guarantee_note`, `PropertyInformation`.`duration_of_contract`, `PropertyInformation`.`amenities`, `PropertyInformation`.`comments`, `PropertyInformation`.`floor_space`, `PropertyInformation`.`space_note`, `PropertyInformation`.`number_of_floors`, `PropertyInformation`.`direction`, `PropertyInformation`.`m_property_information_model_type_id`, `PropertyInformation`.`model_type_note`, `PropertyInformation`.`reform_note`, `PropertyInformation`.`drawing_file`, `PropertyInformation`.`text_for_search`, `PropertyInformation`.`note`, `PropertyInformation`.`has_owner`, `PropertyInformation`.`postal_code`, `PropertyInformation`.`address`, `PropertyInformation`.`latitude`, `PropertyInformation`.`longitude`, `PropertyInformation`.`year_of_completion`, `PropertyInformation`.`month_of_completion`, `PropertyInformation`.`land_space`, `PropertyInformation`.`total_number_of_floors`, `PropertyInformation`.`total_number_of_households`, `PropertyInformation`.`parking`, `PropertyInformation`.`parking_available`, `PropertyInformation`.`parking_note`, `PropertyInformation`.`walk_for`, `PropertyInformation`.`access_note`, `PropertyInformation`.`nearby_train_route`, `PropertyInformation`.`nearby_train_station`, `PropertyInformation`.`surrounding_note`, `PropertyInformation`.`key_open_text`, `PropertyInformation`.`key_location_address`, `PropertyInformation`.`approval_for_publish`, `PropertyInformation`.`approval_for_use_image`, `PropertyInformation`.`reproduce_type_id`, `PropertyInformation`.`is_disabled`, `PropertyInformation`.`is_deleted`, `PropertyInformation`.`client_like_count`, `PropertyInformation`.`image_count`, `PropertyInformation`.`display_image_count`, `PropertyInformation`.`account_information_id`, `PropertyInformation`.`m_property_status_id`, `PropertyInformation`.`m_property_rental_type_id`, `PropertyInformation`.`m_property_owner_contract_type_id`, `PropertyInformation`.`m_area_district_id`, `PropertyInformation`.`m_area_prefecture_id`, `PropertyInformation`.`m_area_city_id`, `PropertyInformation`.`m_area_town_id`, `PropertyInformation`.`m_area_region_id`, `PropertyInformation`.`m_owner_id`, `PropertyInformation`.`m_property_building_id`, `PropertyInformation`.`m_property_building_type_id`, `PropertyInformation`.`m_property_building_structure_id`, `PropertyInformation`.`m_property_resource_id`, `PropertyInformation`.`created`, `PropertyInformation`.`modified`, `MPropertyBuilding`.`id`, `MPropertyBuilding`.`name`, `MPropertyBuilding`.`pronunciation_of_name`, `MPropertyBuilding`.`unique_key`, `MPropertyBuilding`.`order`, `MPropertyBuilding`.`url`, `MPropertyBuilding`.`postal_code`, `MPropertyBuilding`.`address`, `MPropertyBuilding`.`latitude`, `MPropertyBuilding`.`longitude`, `MPropertyBuilding`.`year_of_completion`, `MPropertyBuilding`.`month_of_completion`, `MPropertyBuilding`.`land_space`, `MPropertyBuilding`.`floor_space`, `MPropertyBuilding`.`total_number_of_floors`, `MPropertyBuilding`.`total_number_of_households`, `MPropertyBuilding`.`parking`, `MPropertyBuilding`.`parking_available`, `MPropertyBuilding`.`parking_note`, `MPropertyBuilding`.`building_coverage_ratio`, `MPropertyBuilding`.`floor_area_ratio`, `MPropertyBuilding`.`walk_for`, `MPropertyBuilding`.`access_note`, `MPropertyBuilding`.`nearby_train_route`, `MPropertyBuilding`.`nearby_train_station`, `MPropertyBuilding`.`surrounding_note`, `MPropertyBuilding`.`approval_for_publish`, `MPropertyBuilding`.`approval_for_use_image`, `MPropertyBuilding`.`is_disabled`, `MPropertyBuilding`.`is_deleted`, `MPropertyBuilding`.`account_information_id`, `MPropertyBuilding`.`property_information_count`, `MPropertyBuilding`.`m_property_empty_information_count`, `MPropertyBuilding`.`m_area_district_id`, `MPropertyBuilding`.`m_area_prefecture_id`, `MPropertyBuilding`.`m_area_city_id`, `MPropertyBuilding`.`m_area_town_id`, `MPropertyBuilding`.`m_area_region_id`, `MPropertyBuilding`.`m_owner_id`, `MPropertyBuilding`.`m_property_building_type_id`, `MPropertyBuilding`.`m_property_building_structure_id`, `MPropertyBuilding`.`m_property_resource_id`, `MPropertyBuilding`.`created`, `MPropertyBuilding`.`modified` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` LEFT JOIN `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` ON (`PropertyInformation`.`m_property_building_id` = `MPropertyBuilding`.`id`) WHERE `PropertyInformation`.`approval_for_publish` = '1' AND `PropertyInformation`.`is_disabled` = '0' AND ((`PropertyInformation`.`m_property_building_id` IN (15109, 15121, 15243, 15329, 15671, 15677, 15730, 15807, 15847, 16088, 16452, 19271, 19333, 19526, 19528, 19582, 19645, 19916, 19963, 20086, 20305, 20525, 20817, 20840, 20876, 20972, 21242, 22272, 22293, 23025, 23264, 23294, 23343, 23580, 23663, 23867, 23883, 24043, 24112, 24154, 24163, 24236, 24246, 24268, 24313, 24437, 24531, 24533, 24592, 24634, 24657, 24698, 24758, 24767, 24848, 24858, 24864, 24889, 25048, 25142, 25184, 25195, 25275, 25379, 25443, 25447, 25457, 25458, 25464, 25473, 25477, 25533, 25553, 25690, 25844, 25932, 25971, 26003, 26073, 26129, 26153, 26274, 26321, 26380, 26450, 26472, 26482, 26484, 26496, 26587, 26793, 26795, 26896, 26927, 26935, 26944, 26974, 26984, 27011, 36888, 36915, 36994, 37068, 37079, 37103, 37115, 37125, 37141, 37179, 37196, 37226, 37233, 37242, 37261, 37302, 37698, 37712, 37731, 37909, 37992, 37999, 38056, 38090, 38154, 38851, 38919, 38960, 38969, 39044, 39192, 39342, 39554, 39559, 39958, 40329, 40435, 40470, 40486, 40501, 40513, 40562, 40603, 40613, 40693, 40694, 40772, 40977, 41137, 41372, 41406, 41625, 41742, 41828, 41912, 41921, 41923, 41953, 41966, 42473, 42499, 42503, 42560, 43185, 43391, 43398, 43846, 44188, 44405, 44495, 44591, 44860, 45445, 45593, 45649, 45742, 46008, 46064, 46075, 46424, 47538, 47745, 47824, 47832, 47850, 48245, 48338, 48365, 48385, 48397, 48408, 48468, 48592, 48599, 48611, 48671, 48682, 48700, 48712, 48736, 48835, 49047, 49050, 49072, 49079, 49110, 49119, 49155, 49195, 49197, 49226, 49239, 49255, 49284, 49314, 49332, 49373, 49492, 49607, 49608, 49655, 49681, 49725, 49781, 49816, 49843, 50036, 50105, 50116, 50119, 50121, 50150, 50230, 50283, 50287, 50306, 50352, 50367, 50420, 50495, 50526, 50540, 50564, 50584, 50586, 50604, 50653, 50664, 50736, 50799, 50812, 50833, 50837, 50867, 50893, 50927, 50988, 51088, 51094, 51098, 51121, 51187, 51210, 51233, 51307, 51312, 51328, 51334, 51603, 51635, 51646, 51660, 51681, 51710, 51726, 51761, 51817, 51940, 52038, 52195, 52269, 52382, 52415, 52480, 52494, 52562, 52577, 52615, 52645, 52654, 52702, 52707, 52711, 52713, 52743, 53005, 53087, 53108, 53140, 53168, 53180, 53261, 53386, 53478, 53626, 53842, 53903, 53965, 53997, 54069, 54113, 54128, 54177, 54241, 54273, 54304, 54308, 54343, 54372, 54385, 54418, 54451, 54462, 54475, 54483, 54491, 54535, 54564, 54567, 54640, 54676, 54734, 54752, 54796, 54804, 54885, 54886, 54895, 54989, 55049, 55093, 55233, 55399, 55419, 55469, 55481, 55647, 55652, 55754, 55791, 55841, 55901, 55912, 55971, 56183, 56217, 56276, 56488, 56515, 56538, 56566, 56567, 56569, 56652, 56736, 56807, 56864, 56869, 56870, 56923, 56932, 57053, 57057, 57125, 57141, 57149, 57303, 57376, 57447, 57452, 57479, 57517, 57736, 57792, 57874, 57916, 57936, 57978, 58039, 58047, 58068, 58078, 58083, 58086, 58101, 58309, 58330, 58338, 58410, 58463, 58576, 58610, 58615, 58720, 58740, 58751, 58756, 58761, 58789, 58845, 58857, 58898, 58929, 58938, 58959, 58977, 58983, 59034, 59052, 59100, 59198, 59257, 59262, 59296, 59390, 59396, 59462, 59555, 59582, 59592, 59609, 59752, 60039, 60138, 60238, 60438, 60641, 60745, 61528, 61642, 63474, 64279, 64672, 73202, 87706, 101016, 126715, 126821, 137430, 137921, 138003, 138291, 138292, 138331, 138517, 138523, 138589, 138609, 138699, 138801, 138860, 138978, 139046, 139049, 139086, 139118, 139302, 139324, 139346, 139388, 139394, 139398, 139410, 139426, 139454, 139459, 139472, 139476, 139480, 139514, 139549, 139578, 139581, 139585, 139612, 139620, 139637, 139679, 139812, 139839, 139855, 139888, 139900, 139932, 139953, 139973, 139979, 139981, 139982, 139985, 139988, 139990, 139997, 140007, 140009, 140020, 140035, 140040, 140042, 140044, 140065, 140074, 140084, 140087, 140092, 140181, 140182, 140183, 140227, 140242, 140248, 140254, 140277, 140283, 140303, 140310, 140317, 140319, 140322, 140366, 140393, 140417, 140426, 140427, 140432, 140433, 140437, 140439, 140442, 140459, 140462, 140464, 140472, 140509, 140511, 140514, 140520, 140523, 140545, 140562, 140567, 140600, 140617, 140625, 140716, 140745, 140755, 140864, 140899, 141090, 141123, 141175, 141192, 141193, 141210, 141216, 141228, 141232, 141304, 141589, 141594, 141595, 141607, 141654, 141720, 141740, 141755, 141790, 141825, 141827, 141893, 141988, 141992, 142002, 142019, 142027, 142069, 142071, 142072, 142074, 142096, 142100, 142115, 142142, 142359, 142361, 142409, 142414, 142461, 142462, 142463, 142479, 142480, 142493, 142514, 142519, 142623, 142641, 142644, 153414, 153440, 153516, 153600, 153627, 153659, 153758, 153865, 153930, 153942, 153993, 154004, 154016, 154023, 154033, 154040, 154061, 154072, 154083, 154095, 154118, 154121, 154200, 154258, 154269, 154275, 154296, 154338, 154386, 154422, 154436, 154441, 154455, 154467, 154468, 154529, 154530, 154533, 154575, 154652, 154749, 154810, 154852, 154872, 154884, 154928, 154943, 154970, 154971, 154976, 155056, 155071, 155100, 155148, 155161, 155171, 155195, 155198, 155204, 155226, 155229, 155235, 155251, 155265, 155272, 155288, 155297, 155317, 155321, 155323, 155327, 155340, 155341, 155342, 155344, 155345, 155346, 155348, 155350, 155351, 155359, 155362, 155364, 155389, 155427, 155430, 155445, 155452, 155460, 155484, 155503, 155521, 155535, 155540, 155569, 155579, 155585, 155654, 155655, 155736, 155813, 155815, 156004, 156007, 156017, 156080, 156086, 156102, 156107, 156110, 156117, 156121, 156137, 156139, 156215, 156216, 156229, 156289, 156291, 156296, 156302, 156303, 156334, 156345, 156762, 156806, 156828, 156928, 156937, 156965, 156991, 157004, 157028, 157030, 157033, 157036, 157045, 157050, 157084, 157097, 157099, 157118, 157122, 157137, 157184, 157198, 157203, 157208, 157210, 157215, 157228, 157277, 157323, 157338, 157384, 157385, 157425, 157441, 157462, 157526, 157549, 157561, 157581, 157620, 157622, 157655, 157706, 157758, 157767, 157774, 157787, 157788, 157852, 157865, 157923, 157962, 158018, 158100, 158118, 158160, 158169, 158177, 158337, 158346, 158348, 158353, 158365, 158374, 158454, 158460, 158586, 173716, 173746, 173771, 173800, 173815, 173816, 173831, 173848, 173867, 173868, 173889, 173901, 173919, 173929, 173930, 173931, 173934, 173941, 173946, 173953, 173955, 173961, 174033, 174129, 174139, 174157, 174159, 174164, 174169, 174171, 174186, 174190, 174252, 174263, 174268, 174311, 174320, 174329, 174335, 174336, 174337, 174342, 174361, 174363, 174367, 174389, 174409, 174415, 174436, 186977, 187068, 187071, 187161, 187186, 187221, 187282, 187338, 187410, 187420, 187442, 187458, 187485, 187541, 187552, 187553, 187583, 187599, 187637, 187699, 187717, 187751, 187763, 187803, 187811, 187825, 187858, 187889, 187944, 187955, 187961, 187981, 187998, 188044, 188080, 188177, 188211, 188216, 188230, 188231, 188236, 197554, 197584, 197593, 197634, 197636, 197637, 197665, 197670, 197672, 197727, 197766, 197798, 197808, 197827, 197828, 197834, 197835, 197837, 197856, 197860, 197883, 197908, 197916, 197919, 197967, 197969, 197984, 198011, 198030, 198090, 198170, 198201, 198244, 198414, 198713, 198751, 198853, 198867, 198911, 198958, 198968, 199387, 199468, 203146, 203157, 203172, 203173, 203183, 203185, 203195, 203196, 203198, 203210, 203231, 203248, 203249, 203280, 203281, 203313, 203316, 203327, 203341, 203342, 203499, 203504, 206866, 211030, 211036, 211062, 211064, 211070, 211074, 211109, 211114, 218697, 218709, 218843, 218883, 218961, 218973, 218974, 219004, 219107, 219164, 219170, 219223, 219243, 219272, 219357, 219379, 219429, 219436, 219540, 219555, 219564, 219566, 219598, 219645, 219669, 219697, 219707, 250590, 250621, 250703, 250738, 250943, 251031, 251044, 251186, 251320, 251478, 251484, 251516, 251770, 252058, 252083, 252087, 252088, 252089, 252113, 252215, 252238, 252292, 252302, 252559, 252650, 252653, 252868, 252927, 252945, 252947, 253096, 253115, 253174, 253184, 253618, 253650, 253986, 254038, 254074, 254158, 263260, 263267, 263868, 263904, 264448, 264708, 265223, 265353, 265359, 265770, 265810, 265925, 266096, 266120, 266142, 266164, 266206, 266264, 266490, 266508, 266509, 266520, 266551, 266568, 266592, 266610, 282884, 282925, 282928, 283067, 283123, 283124, 283159, 283160, 283206, 283295, 283304, 283316, 283336, 283393, 283394, 283403, 283431, 283449, 283457, 283466, 283770, 283814, 283856, 283857, 283871, 283881, 283910, 283927, 283930, 283933, 283936, 283938, 283939, 283946, 283947, 283950, 283954, 283955, 283956, 283967, 283969, 283970, 283974, 283975, 283977, 283980, 287881, 288295, 288444, 288704, 288706, 288729, 288870, 288952, 288971, 289331, 289376, 289422, 289588, 289616, 289711, 289732, 289839, 289986, 290003, 290113, 290218, 290250, 290290, 290324, 290326, 290344, 290351, 290520, 290617, 290704, 290801, 290871, 290894, 290941, 290973, 290976, 291039, 297029, 297049, 297122, 297133, 297229, 297250, 297256, 297268, 297296, 297299, 297344, 297351, 297650, 297657, 297662, 297750, 297759, 297793, 297832, 297836, 297843, 301824, 301853, 302004, 302022, 302042, 302049, 302052, 302090, 302160, 302206, 302230, 302275, 302278, 302293, 302342, 302449, 302526, 302616, 302656, 302695, 305390, 305408, 305469, 305485, 305487, 305513, 305520, 305529, 305550, 305563, 305583, 305594, 305598, 308212, 308451, 308456, 308469, 308470, 308518, 308555, 308638, 308644, 308657, 308682, 308704, 308710, 308715, 308716, 308758, 308842, 308883, 313337, 313363, 313391, 313418, 313445, 313447, 313463, 313519, 313545, 313557, 313576, 313578, 313621, 313910, 313914, 313916, 313922, 313923, 313931, 313936, 321471, 321476, 321484, 321501, 321504, 321507, 321512, 321521, 321552, 321558, 321560, 321577, 321593, 321595, 321600, 321608, 321614, 321630, 321654, 321888, 322093, 322157, 322167, 322235, 322375, 322515, 322602, 324251, 324628, 324779, 324880, 324977, 325263, 325351, 325661, 325681, 325855, 325901, 326005, 326084, 326123, 326124, 326177, 326358, 326647, 326649, 326992, 326993, 327070, 327116, 327352, 327353, 327361, 327375, 327487, 327493, 327544, 327556, 327558, 327575, 327626, 327698, 327719, 327721, 327750, 327768, 327772, 329215, 329231, 330189, 330453, 330595, 330621, 330677, 330688, 331089, 331145, 331222, 331259, 331267, 331285, 331317, 331376, 331382, 331609, 331636, 331639, 331645, 331749, 331762, 331833, 331882, 331968, 332019, 332593, 332610, 332620, 332675, 332680, 332691, 332860, 333040, 333650, 333670, 333871, 334484, 334654, 334777, 335636, 335702, 335748, 335813, 335928, 335956, 336060, 336084, 336142, 336143, 336152, 336164, 336194, 336200, 336222, 336224, 336233, 336242, 336244, 336247, 336259, 336261, 336306, 343528, 349660, 349905, 350024, 350115, 350133, 350310, 350351, 350380, 350382, 350523, 350799, 350800, 350882, 350894, 350896, 350914, 350982, 351052, 351076, 351150, 351162, 351195, 351279, 351297, 351329, 351351, 351366, 351412, 351417, 351425, 351426, 351432, 351448, 351452, 356905, 357011, 357083, 357181, 357211, 357234, 357544, 357583, 357613, 357684, 357748, 357770, 357816, 357828, 357829, 357830, 358040, 359112, 359220, 359222, 359286, 359366, 359380, 359390, 359419, 359452, 359458, 359504, 359558, 359593, 359607, 359657, 359667, 359672, 359700, 359705, 359744, 359804, 359890, 359911, 360007, 360038, 360135, 360147, 360260, 360295, 360385, 360544, 360674, 360757, 360866, 360870, 363651, 363673, 363684, 363689, 363995, 364640, 364664, 364683, 364717, 364738, 364774, 364799, 364810, 364826, 364831, 364837, 364838, 364844, 364845, 364858, 364901, 364902, 364937, 365021, 365059, 365093, 365125, 365127, 365146, 365151, 365162, 365200, 365201, 365203, 365242, 365295, 365297, 365331, 365345, 365350, 365368, 365392, 365454, 365470, 365492, 365515, 365525, 365534, 365553, 365575, 377670, 377699, 377715, 377720, 377751, 377761, 377861, 377867, 377869, 377871, 377892, 377997, 378002, 378029, 378118, 378148, 378230, 378371, 378583, 378588, 378611, 378679, 378681, 378691, 378710, 378725, 378909, 379004, 379297, 379308, 379372, 379396, 379401, 379405, 379411, 379458, 379477, 379486, 379505, 379513, 379514, 379516, 379620, 379659, 379714, 398083, 398086, 398141, 398146, 398246, 398254, 398343, 398389, 398409, 398466, 398473, 398480, 398527, 398546, 398611, 398622, 398624, 398650, 398693, 398716, 398727, 398757, 398760, 398774, 398844, 398846, 398851, 399068, 399188, 399227, 399296, 399353, 399391, 399512, 399533, 399542, 399560, 399601, 399619, 399686, 399778, 399786, 399807, 399812, 399834, 399843, 399913, 399939, 399949, 399950, 399953, 400006, 400008, 400009, 400014, 400036, 400070, 400096, 400098, 400103, 400118, 400174, 400178, 400315, 400317, 400327, 400354, 400379, 400403, 400410, 400452, 400468, 400469, 400479, 400504, 400537, 400547, 400583, 400640, 400660, 400725, 400746, 400751, 400770, 400788, 400817, 400841, 400843, 400859, 400869, 400878, 400883, 400904, 413569, 413577, 413692, 413704, 413724, 413802, 413813, 413836, 413892, 413957, 413958, 414037, 414050, 414063, 414064, 414066, 415244, 415623, 415639, 415733, 415818, 415826, 415901, 416751, 416823, 416972, 417122, 417126, 417195, 417243, 417380, 417385, 417456, 417560, 417563, 417564, 417581, 417610, 417703, 417722, 417809, 417833, 417852, 417884, 417932, 418256, 418425, 418434, 418528, 418575, 418606, 418664, 418674, 418740, 418821, 418855, 418908, 419010, 419030, 419054, 419093, 419109, 419124, 419159, 419162, 419201, 419215, 419216, 419230, 419234, 428323, 428327, 428616, 428629, 428686, 428716, 428746, 428770, 429375, 429380, 429390, 429391, 429393, 429394, 429396, 429397, 429400, 429420, 429421, 429466, 429475, 429641, 429657, 429664, 429671, 429679, 429680, 429690, 429736, 429768, 429787, 429964, 429969, 429983, 429996, 430005, 430071, 430096, 430104, 430126, 430154, 430175, 430360, 430364, 430502, 430609, 430627, 430662, 430681, 430789, 430795, 430842, 430846, 430849, 430850, 430871, 430877, 430899, 439790, 439805, 439896, 440124, 440170, 440194, 440221, 440225, 440226, 440273, 442959, 448578, 448684, 448786, 449325, 449401, 449681, 449765, 449886, 449889, 450151, 450234, 450314, 450338, 450340, 450459, 450467, 450530, 450570, 450701, 450776, 450793, 454783, 454789, 454838, 454904, 454951, 454954, 455000, 455037, 455049, 455094, 455183, 457338, 458368, 458399, 458404, 458410, 458576, 458667, 458906, 458953, 459000, 459121, 459123, 466743, 466777, 466779, 466852, 466900, 466901, 466950, 467036, 467052, 467112, 467113, 467122, 467140, 467151, 467160, 467172, 467173, 469904, 470162, 470187, 470191, 470193, 470252, 470271, 470302, 470414, 470428, 470455, 470526, 470573, 470630, 470802, 470833, 470835, 470842, 470868, 470884, 470885, 470886, 470887, 470905, 470970, 471089, 471115, 471150, 471165, 471184, 471195, 471240, 471381, 471385, 471497, 471505, 471515, 471682, 471683, 471720, 471757, 471861, 471944, 471974, 471989, 471992, 472041, 472056, 472141, 472203, 472205, 472292, 472293, 472350, 472399, 472415, 472418, 472431, 472432, 472445, 472452, 472486, 472495, 472514, 472527, 483601, 483662, 483681, 483684, 483692, 483734, 483803, 483837, 483873, 483877, 483886, 483890, 483899, 483943, 484003, 484006, 484030, 484053, 484094, 484461, 484486, 484663, 485016, 485096, 485344, 485500, 485512, 485630, 485637, 485833, 485908, 486179, 486386, 486422, 486505, 486692, 486711, 486780, 486891, 486919, 487189, 487213, 487286, 487326, 487390, 487458, 487459, 487558, 487601, 487609, 487613, 487622, 497310, 497445, 497457, 497506, 497607, 497630, 497645, 497647, 498349, 498363, 498403, 498491, 498560, 498594, 498620, 498926, 498931, 499139, 499216, 499267, 499277, 499310, 499407, 499409, 499488, 499511, 499661, 499697, 499823, 499837, 499963, 502857, 502947, 502948, 503051, 503884, 503999, 504015, 504763, 504766, 504768, 504773, 504775, 504778, 505254, 505543, 506092, 506093, 506097, 506098, 506099, 506100, 506105, 507168, 507169, 507170, 507171, 507173, 507175, 507233, 507347, 507349, 507443, 507510, 507513, 507516, 508094, 509270, 522881, 522900, 522905, 522929, 522953, 522975, 522984, 523001, 523039, 523085, 523106, 523126, 523156, 523179, 523195, 523201, 523207, 523211, 523219, 523221, 523282, 523287, 523325, 523332, 523336, 523342, 523347, 523427, 523451, 523460, 523462, 523480, 523508, 523532, 523546, 523559, 523588, 523603, 523606, 523634, 523644, 523652, 523658, 523704, 523717, 523727, 523743, 523778, 523792, 523852, 523854, 523856, 523912, 548046, 548528, 548575, 548576, 548892, 549733, 549770, 549804)) AND (`PropertyInformation`.`year_of_completion` >= 1990)) ORDER BY `PropertyInformation`.`order` desc LIMIT 202020254
37SELECT COUNT(*) AS `count` FROM `fudosan`.`app_property_informations` AS `PropertyInformation` LEFT JOIN `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` ON (`PropertyInformation`.`m_property_building_id` = `MPropertyBuilding`.`id`) WHERE `PropertyInformation`.`approval_for_publish` = '1' AND `PropertyInformation`.`is_disabled` = '0' AND ((`PropertyInformation`.`m_property_building_id` IN (15109, 15121, 15243, 15329, 15671, 15677, 15730, 15807, 15847, 16088, 16452, 19271, 19333, 19526, 19528, 19582, 19645, 19916, 19963, 20086, 20305, 20525, 20817, 20840, 20876, 20972, 21242, 22272, 22293, 23025, 23264, 23294, 23343, 23580, 23663, 23867, 23883, 24043, 24112, 24154, 24163, 24236, 24246, 24268, 24313, 24437, 24531, 24533, 24592, 24634, 24657, 24698, 24758, 24767, 24848, 24858, 24864, 24889, 25048, 25142, 25184, 25195, 25275, 25379, 25443, 25447, 25457, 25458, 25464, 25473, 25477, 25533, 25553, 25690, 25844, 25932, 25971, 26003, 26073, 26129, 26153, 26274, 26321, 26380, 26450, 26472, 26482, 26484, 26496, 26587, 26793, 26795, 26896, 26927, 26935, 26944, 26974, 26984, 27011, 36888, 36915, 36994, 37068, 37079, 37103, 37115, 37125, 37141, 37179, 37196, 37226, 37233, 37242, 37261, 37302, 37698, 37712, 37731, 37909, 37992, 37999, 38056, 38090, 38154, 38851, 38919, 38960, 38969, 39044, 39192, 39342, 39554, 39559, 39958, 40329, 40435, 40470, 40486, 40501, 40513, 40562, 40603, 40613, 40693, 40694, 40772, 40977, 41137, 41372, 41406, 41625, 41742, 41828, 41912, 41921, 41923, 41953, 41966, 42473, 42499, 42503, 42560, 43185, 43391, 43398, 43846, 44188, 44405, 44495, 44591, 44860, 45445, 45593, 45649, 45742, 46008, 46064, 46075, 46424, 47538, 47745, 47824, 47832, 47850, 48245, 48338, 48365, 48385, 48397, 48408, 48468, 48592, 48599, 48611, 48671, 48682, 48700, 48712, 48736, 48835, 49047, 49050, 49072, 49079, 49110, 49119, 49155, 49195, 49197, 49226, 49239, 49255, 49284, 49314, 49332, 49373, 49492, 49607, 49608, 49655, 49681, 49725, 49781, 49816, 49843, 50036, 50105, 50116, 50119, 50121, 50150, 50230, 50283, 50287, 50306, 50352, 50367, 50420, 50495, 50526, 50540, 50564, 50584, 50586, 50604, 50653, 50664, 50736, 50799, 50812, 50833, 50837, 50867, 50893, 50927, 50988, 51088, 51094, 51098, 51121, 51187, 51210, 51233, 51307, 51312, 51328, 51334, 51603, 51635, 51646, 51660, 51681, 51710, 51726, 51761, 51817, 51940, 52038, 52195, 52269, 52382, 52415, 52480, 52494, 52562, 52577, 52615, 52645, 52654, 52702, 52707, 52711, 52713, 52743, 53005, 53087, 53108, 53140, 53168, 53180, 53261, 53386, 53478, 53626, 53842, 53903, 53965, 53997, 54069, 54113, 54128, 54177, 54241, 54273, 54304, 54308, 54343, 54372, 54385, 54418, 54451, 54462, 54475, 54483, 54491, 54535, 54564, 54567, 54640, 54676, 54734, 54752, 54796, 54804, 54885, 54886, 54895, 54989, 55049, 55093, 55233, 55399, 55419, 55469, 55481, 55647, 55652, 55754, 55791, 55841, 55901, 55912, 55971, 56183, 56217, 56276, 56488, 56515, 56538, 56566, 56567, 56569, 56652, 56736, 56807, 56864, 56869, 56870, 56923, 56932, 57053, 57057, 57125, 57141, 57149, 57303, 57376, 57447, 57452, 57479, 57517, 57736, 57792, 57874, 57916, 57936, 57978, 58039, 58047, 58068, 58078, 58083, 58086, 58101, 58309, 58330, 58338, 58410, 58463, 58576, 58610, 58615, 58720, 58740, 58751, 58756, 58761, 58789, 58845, 58857, 58898, 58929, 58938, 58959, 58977, 58983, 59034, 59052, 59100, 59198, 59257, 59262, 59296, 59390, 59396, 59462, 59555, 59582, 59592, 59609, 59752, 60039, 60138, 60238, 60438, 60641, 60745, 61528, 61642, 63474, 64279, 64672, 73202, 87706, 101016, 126715, 126821, 137430, 137921, 138003, 138291, 138292, 138331, 138517, 138523, 138589, 138609, 138699, 138801, 138860, 138978, 139046, 139049, 139086, 139118, 139302, 139324, 139346, 139388, 139394, 139398, 139410, 139426, 139454, 139459, 139472, 139476, 139480, 139514, 139549, 139578, 139581, 139585, 139612, 139620, 139637, 139679, 139812, 139839, 139855, 139888, 139900, 139932, 139953, 139973, 139979, 139981, 139982, 139985, 139988, 139990, 139997, 140007, 140009, 140020, 140035, 140040, 140042, 140044, 140065, 140074, 140084, 140087, 140092, 140181, 140182, 140183, 140227, 140242, 140248, 140254, 140277, 140283, 140303, 140310, 140317, 140319, 140322, 140366, 140393, 140417, 140426, 140427, 140432, 140433, 140437, 140439, 140442, 140459, 140462, 140464, 140472, 140509, 140511, 140514, 140520, 140523, 140545, 140562, 140567, 140600, 140617, 140625, 140716, 140745, 140755, 140864, 140899, 141090, 141123, 141175, 141192, 141193, 141210, 141216, 141228, 141232, 141304, 141589, 141594, 141595, 141607, 141654, 141720, 141740, 141755, 141790, 141825, 141827, 141893, 141988, 141992, 142002, 142019, 142027, 142069, 142071, 142072, 142074, 142096, 142100, 142115, 142142, 142359, 142361, 142409, 142414, 142461, 142462, 142463, 142479, 142480, 142493, 142514, 142519, 142623, 142641, 142644, 153414, 153440, 153516, 153600, 153627, 153659, 153758, 153865, 153930, 153942, 153993, 154004, 154016, 154023, 154033, 154040, 154061, 154072, 154083, 154095, 154118, 154121, 154200, 154258, 154269, 154275, 154296, 154338, 154386, 154422, 154436, 154441, 154455, 154467, 154468, 154529, 154530, 154533, 154575, 154652, 154749, 154810, 154852, 154872, 154884, 154928, 154943, 154970, 154971, 154976, 155056, 155071, 155100, 155148, 155161, 155171, 155195, 155198, 155204, 155226, 155229, 155235, 155251, 155265, 155272, 155288, 155297, 155317, 155321, 155323, 155327, 155340, 155341, 155342, 155344, 155345, 155346, 155348, 155350, 155351, 155359, 155362, 155364, 155389, 155427, 155430, 155445, 155452, 155460, 155484, 155503, 155521, 155535, 155540, 155569, 155579, 155585, 155654, 155655, 155736, 155813, 155815, 156004, 156007, 156017, 156080, 156086, 156102, 156107, 156110, 156117, 156121, 156137, 156139, 156215, 156216, 156229, 156289, 156291, 156296, 156302, 156303, 156334, 156345, 156762, 156806, 156828, 156928, 156937, 156965, 156991, 157004, 157028, 157030, 157033, 157036, 157045, 157050, 157084, 157097, 157099, 157118, 157122, 157137, 157184, 157198, 157203, 157208, 157210, 157215, 157228, 157277, 157323, 157338, 157384, 157385, 157425, 157441, 157462, 157526, 157549, 157561, 157581, 157620, 157622, 157655, 157706, 157758, 157767, 157774, 157787, 157788, 157852, 157865, 157923, 157962, 158018, 158100, 158118, 158160, 158169, 158177, 158337, 158346, 158348, 158353, 158365, 158374, 158454, 158460, 158586, 173716, 173746, 173771, 173800, 173815, 173816, 173831, 173848, 173867, 173868, 173889, 173901, 173919, 173929, 173930, 173931, 173934, 173941, 173946, 173953, 173955, 173961, 174033, 174129, 174139, 174157, 174159, 174164, 174169, 174171, 174186, 174190, 174252, 174263, 174268, 174311, 174320, 174329, 174335, 174336, 174337, 174342, 174361, 174363, 174367, 174389, 174409, 174415, 174436, 186977, 187068, 187071, 187161, 187186, 187221, 187282, 187338, 187410, 187420, 187442, 187458, 187485, 187541, 187552, 187553, 187583, 187599, 187637, 187699, 187717, 187751, 187763, 187803, 187811, 187825, 187858, 187889, 187944, 187955, 187961, 187981, 187998, 188044, 188080, 188177, 188211, 188216, 188230, 188231, 188236, 197554, 197584, 197593, 197634, 197636, 197637, 197665, 197670, 197672, 197727, 197766, 197798, 197808, 197827, 197828, 197834, 197835, 197837, 197856, 197860, 197883, 197908, 197916, 197919, 197967, 197969, 197984, 198011, 198030, 198090, 198170, 198201, 198244, 198414, 198713, 198751, 198853, 198867, 198911, 198958, 198968, 199387, 199468, 203146, 203157, 203172, 203173, 203183, 203185, 203195, 203196, 203198, 203210, 203231, 203248, 203249, 203280, 203281, 203313, 203316, 203327, 203341, 203342, 203499, 203504, 206866, 211030, 211036, 211062, 211064, 211070, 211074, 211109, 211114, 218697, 218709, 218843, 218883, 218961, 218973, 218974, 219004, 219107, 219164, 219170, 219223, 219243, 219272, 219357, 219379, 219429, 219436, 219540, 219555, 219564, 219566, 219598, 219645, 219669, 219697, 219707, 250590, 250621, 250703, 250738, 250943, 251031, 251044, 251186, 251320, 251478, 251484, 251516, 251770, 252058, 252083, 252087, 252088, 252089, 252113, 252215, 252238, 252292, 252302, 252559, 252650, 252653, 252868, 252927, 252945, 252947, 253096, 253115, 253174, 253184, 253618, 253650, 253986, 254038, 254074, 254158, 263260, 263267, 263868, 263904, 264448, 264708, 265223, 265353, 265359, 265770, 265810, 265925, 266096, 266120, 266142, 266164, 266206, 266264, 266490, 266508, 266509, 266520, 266551, 266568, 266592, 266610, 282884, 282925, 282928, 283067, 283123, 283124, 283159, 283160, 283206, 283295, 283304, 283316, 283336, 283393, 283394, 283403, 283431, 283449, 283457, 283466, 283770, 283814, 283856, 283857, 283871, 283881, 283910, 283927, 283930, 283933, 283936, 283938, 283939, 283946, 283947, 283950, 283954, 283955, 283956, 283967, 283969, 283970, 283974, 283975, 283977, 283980, 287881, 288295, 288444, 288704, 288706, 288729, 288870, 288952, 288971, 289331, 289376, 289422, 289588, 289616, 289711, 289732, 289839, 289986, 290003, 290113, 290218, 290250, 290290, 290324, 290326, 290344, 290351, 290520, 290617, 290704, 290801, 290871, 290894, 290941, 290973, 290976, 291039, 297029, 297049, 297122, 297133, 297229, 297250, 297256, 297268, 297296, 297299, 297344, 297351, 297650, 297657, 297662, 297750, 297759, 297793, 297832, 297836, 297843, 301824, 301853, 302004, 302022, 302042, 302049, 302052, 302090, 302160, 302206, 302230, 302275, 302278, 302293, 302342, 302449, 302526, 302616, 302656, 302695, 305390, 305408, 305469, 305485, 305487, 305513, 305520, 305529, 305550, 305563, 305583, 305594, 305598, 308212, 308451, 308456, 308469, 308470, 308518, 308555, 308638, 308644, 308657, 308682, 308704, 308710, 308715, 308716, 308758, 308842, 308883, 313337, 313363, 313391, 313418, 313445, 313447, 313463, 313519, 313545, 313557, 313576, 313578, 313621, 313910, 313914, 313916, 313922, 313923, 313931, 313936, 321471, 321476, 321484, 321501, 321504, 321507, 321512, 321521, 321552, 321558, 321560, 321577, 321593, 321595, 321600, 321608, 321614, 321630, 321654, 321888, 322093, 322157, 322167, 322235, 322375, 322515, 322602, 324251, 324628, 324779, 324880, 324977, 325263, 325351, 325661, 325681, 325855, 325901, 326005, 326084, 326123, 326124, 326177, 326358, 326647, 326649, 326992, 326993, 327070, 327116, 327352, 327353, 327361, 327375, 327487, 327493, 327544, 327556, 327558, 327575, 327626, 327698, 327719, 327721, 327750, 327768, 327772, 329215, 329231, 330189, 330453, 330595, 330621, 330677, 330688, 331089, 331145, 331222, 331259, 331267, 331285, 331317, 331376, 331382, 331609, 331636, 331639, 331645, 331749, 331762, 331833, 331882, 331968, 332019, 332593, 332610, 332620, 332675, 332680, 332691, 332860, 333040, 333650, 333670, 333871, 334484, 334654, 334777, 335636, 335702, 335748, 335813, 335928, 335956, 336060, 336084, 336142, 336143, 336152, 336164, 336194, 336200, 336222, 336224, 336233, 336242, 336244, 336247, 336259, 336261, 336306, 343528, 349660, 349905, 350024, 350115, 350133, 350310, 350351, 350380, 350382, 350523, 350799, 350800, 350882, 350894, 350896, 350914, 350982, 351052, 351076, 351150, 351162, 351195, 351279, 351297, 351329, 351351, 351366, 351412, 351417, 351425, 351426, 351432, 351448, 351452, 356905, 357011, 357083, 357181, 357211, 357234, 357544, 357583, 357613, 357684, 357748, 357770, 357816, 357828, 357829, 357830, 358040, 359112, 359220, 359222, 359286, 359366, 359380, 359390, 359419, 359452, 359458, 359504, 359558, 359593, 359607, 359657, 359667, 359672, 359700, 359705, 359744, 359804, 359890, 359911, 360007, 360038, 360135, 360147, 360260, 360295, 360385, 360544, 360674, 360757, 360866, 360870, 363651, 363673, 363684, 363689, 363995, 364640, 364664, 364683, 364717, 364738, 364774, 364799, 364810, 364826, 364831, 364837, 364838, 364844, 364845, 364858, 364901, 364902, 364937, 365021, 365059, 365093, 365125, 365127, 365146, 365151, 365162, 365200, 365201, 365203, 365242, 365295, 365297, 365331, 365345, 365350, 365368, 365392, 365454, 365470, 365492, 365515, 365525, 365534, 365553, 365575, 377670, 377699, 377715, 377720, 377751, 377761, 377861, 377867, 377869, 377871, 377892, 377997, 378002, 378029, 378118, 378148, 378230, 378371, 378583, 378588, 378611, 378679, 378681, 378691, 378710, 378725, 378909, 379004, 379297, 379308, 379372, 379396, 379401, 379405, 379411, 379458, 379477, 379486, 379505, 379513, 379514, 379516, 379620, 379659, 379714, 398083, 398086, 398141, 398146, 398246, 398254, 398343, 398389, 398409, 398466, 398473, 398480, 398527, 398546, 398611, 398622, 398624, 398650, 398693, 398716, 398727, 398757, 398760, 398774, 398844, 398846, 398851, 399068, 399188, 399227, 399296, 399353, 399391, 399512, 399533, 399542, 399560, 399601, 399619, 399686, 399778, 399786, 399807, 399812, 399834, 399843, 399913, 399939, 399949, 399950, 399953, 400006, 400008, 400009, 400014, 400036, 400070, 400096, 400098, 400103, 400118, 400174, 400178, 400315, 400317, 400327, 400354, 400379, 400403, 400410, 400452, 400468, 400469, 400479, 400504, 400537, 400547, 400583, 400640, 400660, 400725, 400746, 400751, 400770, 400788, 400817, 400841, 400843, 400859, 400869, 400878, 400883, 400904, 413569, 413577, 413692, 413704, 413724, 413802, 413813, 413836, 413892, 413957, 413958, 414037, 414050, 414063, 414064, 414066, 415244, 415623, 415639, 415733, 415818, 415826, 415901, 416751, 416823, 416972, 417122, 417126, 417195, 417243, 417380, 417385, 417456, 417560, 417563, 417564, 417581, 417610, 417703, 417722, 417809, 417833, 417852, 417884, 417932, 418256, 418425, 418434, 418528, 418575, 418606, 418664, 418674, 418740, 418821, 418855, 418908, 419010, 419030, 419054, 419093, 419109, 419124, 419159, 419162, 419201, 419215, 419216, 419230, 419234, 428323, 428327, 428616, 428629, 428686, 428716, 428746, 428770, 429375, 429380, 429390, 429391, 429393, 429394, 429396, 429397, 429400, 429420, 429421, 429466, 429475, 429641, 429657, 429664, 429671, 429679, 429680, 429690, 429736, 429768, 429787, 429964, 429969, 429983, 429996, 430005, 430071, 430096, 430104, 430126, 430154, 430175, 430360, 430364, 430502, 430609, 430627, 430662, 430681, 430789, 430795, 430842, 430846, 430849, 430850, 430871, 430877, 430899, 439790, 439805, 439896, 440124, 440170, 440194, 440221, 440225, 440226, 440273, 442959, 448578, 448684, 448786, 449325, 449401, 449681, 449765, 449886, 449889, 450151, 450234, 450314, 450338, 450340, 450459, 450467, 450530, 450570, 450701, 450776, 450793, 454783, 454789, 454838, 454904, 454951, 454954, 455000, 455037, 455049, 455094, 455183, 457338, 458368, 458399, 458404, 458410, 458576, 458667, 458906, 458953, 459000, 459121, 459123, 466743, 466777, 466779, 466852, 466900, 466901, 466950, 467036, 467052, 467112, 467113, 467122, 467140, 467151, 467160, 467172, 467173, 469904, 470162, 470187, 470191, 470193, 470252, 470271, 470302, 470414, 470428, 470455, 470526, 470573, 470630, 470802, 470833, 470835, 470842, 470868, 470884, 470885, 470886, 470887, 470905, 470970, 471089, 471115, 471150, 471165, 471184, 471195, 471240, 471381, 471385, 471497, 471505, 471515, 471682, 471683, 471720, 471757, 471861, 471944, 471974, 471989, 471992, 472041, 472056, 472141, 472203, 472205, 472292, 472293, 472350, 472399, 472415, 472418, 472431, 472432, 472445, 472452, 472486, 472495, 472514, 472527, 483601, 483662, 483681, 483684, 483692, 483734, 483803, 483837, 483873, 483877, 483886, 483890, 483899, 483943, 484003, 484006, 484030, 484053, 484094, 484461, 484486, 484663, 485016, 485096, 485344, 485500, 485512, 485630, 485637, 485833, 485908, 486179, 486386, 486422, 486505, 486692, 486711, 486780, 486891, 486919, 487189, 487213, 487286, 487326, 487390, 487458, 487459, 487558, 487601, 487609, 487613, 487622, 497310, 497445, 497457, 497506, 497607, 497630, 497645, 497647, 498349, 498363, 498403, 498491, 498560, 498594, 498620, 498926, 498931, 499139, 499216, 499267, 499277, 499310, 499407, 499409, 499488, 499511, 499661, 499697, 499823, 499837, 499963, 502857, 502947, 502948, 503051, 503884, 503999, 504015, 504763, 504766, 504768, 504773, 504775, 504778, 505254, 505543, 506092, 506093, 506097, 506098, 506099, 506100, 506105, 507168, 507169, 507170, 507171, 507173, 507175, 507233, 507347, 507349, 507443, 507510, 507513, 507516, 508094, 509270, 522881, 522900, 522905, 522929, 522953, 522975, 522984, 523001, 523039, 523085, 523106, 523126, 523156, 523179, 523195, 523201, 523207, 523211, 523219, 523221, 523282, 523287, 523325, 523332, 523336, 523342, 523347, 523427, 523451, 523460, 523462, 523480, 523508, 523532, 523546, 523559, 523588, 523603, 523606, 523634, 523644, 523652, 523658, 523704, 523717, 523727, 523743, 523778, 523792, 523852, 523854, 523856, 523912, 548046, 548528, 548575, 548576, 548892, 549733, 549770, 549804)) AND (`PropertyInformation`.`year_of_completion` >= 1990))11124
38SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 507170 ORDER BY `MPropertyBuildingStation`.`id` asc111
39SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 507168 ORDER BY `MPropertyBuildingStation`.`id` asc330
40SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 506105 ORDER BY `MPropertyBuildingStation`.`id` asc330
41SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 498620 ORDER BY `MPropertyBuildingStation`.`id` asc330
42SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 173961 ORDER BY `MPropertyBuildingStation`.`id` asc110
43SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 506100 ORDER BY `MPropertyBuildingStation`.`id` asc331
44SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 506099 ORDER BY `MPropertyBuildingStation`.`id` asc330
45SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 506097 ORDER BY `MPropertyBuildingStation`.`id` asc331
46SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 504778 ORDER BY `MPropertyBuildingStation`.`id` asc330
47SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 504773 ORDER BY `MPropertyBuildingStation`.`id` asc330
48SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 155100 ORDER BY `MPropertyBuildingStation`.`id` asc330
49SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 416823 ORDER BY `MPropertyBuildingStation`.`id` asc331
50SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 357083 ORDER BY `MPropertyBuildingStation`.`id` asc330
51SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 50495 ORDER BY `MPropertyBuildingStation`.`id` asc330
52SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 288295 ORDER BY `MPropertyBuildingStation`.`id` asc330
53SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 174171 ORDER BY `MPropertyBuildingStation`.`id` asc330
54SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 156991 ORDER BY `MPropertyBuildingStation`.`id` asc110
55SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 49119 ORDER BY `MPropertyBuildingStation`.`id` asc330
56SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 40513 ORDER BY `MPropertyBuildingStation`.`id` asc330
57SELECT `MPropertyBuildingStation`.`id`, `MPropertyBuildingStation`.`m_property_building_id`, `MPropertyBuildingStation`.`m_area_station_id`, `MPropertyBuildingStation`.`walk_for`, `MPropertyBuildingStation`.`distance`, `MPropertyBuildingStation`.`created`, `MPropertyBuildingStation`.`modified`, `MAreaStation`.`id`, `MAreaStation`.`name`, `MAreaStation`.`pronunciation_of_name`, `MAreaStation`.`address`, `MAreaStation`.`latitude`, `MAreaStation`.`longitude`, `MAreaStation`.`order`, `MAreaStation`.`url`, `MAreaStation`.`is_disabled`, `MAreaStation`.`is_deleted`, `MAreaStation`.`m_area_prefecture_id`, `MAreaStation`.`m_area_city_id`, `MAreaStation`.`m_area_line_id`, `MAreaStation`.`created`, `MAreaStation`.`modified` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` LEFT JOIN `fudosan`.`app_m_area_stations` AS `MAreaStation` ON (`MPropertyBuildingStation`.`m_area_station_id` = `MAreaStation`.`id`) WHERE `MPropertyBuildingStation`.`m_property_building_id` = 548046 ORDER BY `MPropertyBuildingStation`.`id` asc220
58SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 895345 ORDER BY `PropertyInformationFeature`.`id` asc001
59SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 895343 ORDER BY `PropertyInformationFeature`.`id` asc18181
60SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894040 ORDER BY `PropertyInformationFeature`.`id` asc21211
61SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894035 ORDER BY `PropertyInformationFeature`.`id` asc10101
62SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894033 ORDER BY `PropertyInformationFeature`.`id` asc15151
63SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894031 ORDER BY `PropertyInformationFeature`.`id` asc10101
64SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894030 ORDER BY `PropertyInformationFeature`.`id` asc11111
65SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 894028 ORDER BY `PropertyInformationFeature`.`id` asc771
66SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 892470 ORDER BY `PropertyInformationFeature`.`id` asc17171
67SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 892464 ORDER BY `PropertyInformationFeature`.`id` asc13131
68SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 856363 ORDER BY `PropertyInformationFeature`.`id` asc12121
69SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 723814 ORDER BY `PropertyInformationFeature`.`id` asc12122
70SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 613988 ORDER BY `PropertyInformationFeature`.`id` asc11111
71SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 558237 ORDER BY `PropertyInformationFeature`.`id` asc991
72SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 488991 ORDER BY `PropertyInformationFeature`.`id` asc881
73SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 302380 ORDER BY `PropertyInformationFeature`.`id` asc881
74SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 250885 ORDER BY `PropertyInformationFeature`.`id` asc331
75SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 62700 ORDER BY `PropertyInformationFeature`.`id` asc19191
76SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 51764 ORDER BY `PropertyInformationFeature`.`id` asc991
77SELECT `PropertyInformationFeature`.`id`, `PropertyInformationFeature`.`property_information_id`, `PropertyInformationFeature`.`m_property_feature_id`, `PropertyInformationFeature`.`is_deleted`, `PropertyInformationFeature`.`created`, `PropertyInformationFeature`.`modified`, `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` LEFT JOIN `fudosan`.`app_m_property_features` AS `MPropertyFeature` ON (`PropertyInformationFeature`.`m_property_feature_id` = `MPropertyFeature`.`id`) WHERE `PropertyInformationFeature`.`property_information_id` = 964136 ORDER BY `PropertyInformationFeature`.`id` asc881
78SELECT `MAreaPrefecture`.`id`, `MAreaPrefecture`.`name`, `MAreaPrefecture`.`c_name`, `MAreaPrefecture`.`e_name`, `MAreaPrefecture`.`order`, `MAreaPrefecture`.`url`, `MAreaPrefecture`.`is_disabled`, `MAreaPrefecture`.`is_deleted`, `MAreaPrefecture`.`m_area_city_count`, `MAreaPrefecture`.`m_area_district_id`, `MAreaPrefecture`.`created`, `MAreaPrefecture`.`modified`, `MAreaDistrict`.`id`, `MAreaDistrict`.`name`, `MAreaDistrict`.`order`, `MAreaDistrict`.`url`, `MAreaDistrict`.`is_disabled`, `MAreaDistrict`.`is_deleted`, `MAreaDistrict`.`m_area_prefecture_count`, `MAreaDistrict`.`created`, `MAreaDistrict`.`modified` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` LEFT JOIN `fudosan`.`app_m_area_districts` AS `MAreaDistrict` ON (`MAreaPrefecture`.`m_area_district_id` = `MAreaDistrict`.`id`) WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14)550
79SELECT `MAreaCity`.`id`, `MAreaCity`.`name`, `MAreaCity`.`c_name`, `MAreaCity`.`order`, `MAreaCity`.`url`, `MAreaCity`.`is_disabled`, `MAreaCity`.`is_deleted`, `MAreaCity`.`m_area_town_count`, `MAreaCity`.`m_area_prefecture_id`, `MAreaCity`.`created`, `MAreaCity`.`modified` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`m_area_prefecture_id` IN (8, 11, 12, 13, 14)2572570
80SELECT `MPropertyFeatureCategory`.`id`, `MPropertyFeatureCategory`.`name`, `MPropertyFeatureCategory`.`order`, `MPropertyFeatureCategory`.`is_disabled`, `MPropertyFeatureCategory`.`is_deleted`, `MPropertyFeatureCategory`.`created`, `MPropertyFeatureCategory`.`modified` FROM `fudosan`.`app_m_property_feature_categories` AS `MPropertyFeatureCategory` WHERE `MPropertyFeatureCategory`.`id` > 1 ORDER BY `MPropertyFeatureCategory`.`id` asc10100
81SELECT `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`m_property_feature_category_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)75750