Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 34]
Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 35]
明治大学駿河台キャンパス検索結果
(default) 56 queries took 144 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` = 270 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` = 270 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` = (270)442
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` = (270)000
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` = 270 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` = (407)330
32SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` IN (795, 903, 847) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`2992992
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 (24941, 24962, 24963, 24970, 24976, 24993, 24996, 25005, 25010, 25026, 25030, 25255, 25265, 25270, 25281, 25286, 25400, 28034, 28038, 28040, 28050, 28234, 28240, 28246, 28252, 28255, 28270, 28275, 28302, 28420, 28501, 28507, 28663, 28670, 28672, 28685, 28735, 28763, 28794, 28803, 28805, 44254, 44270, 126836, 148963, 148964, 148968, 148972, 148973, 148975, 148981, 148988, 148992, 149003, 149007, 149008, 149009, 149031, 149042, 149046, 149048, 149050, 149052, 149058, 149066, 149068, 149070, 149077, 149080, 149081, 149082, 149088, 149095, 149096, 149101, 149103, 149105, 149112, 149114, 149123, 149157, 149158, 149162, 149163, 149173, 149174, 149180, 149192, 170190, 170198, 170202, 170204, 170206, 170211, 170213, 170224, 170227, 170229, 170231, 170234, 172393, 172492, 172722, 199530, 199531, 199533, 199534, 199538, 199540, 199554, 199556, 199570, 207348, 245839, 245841, 245843, 245844, 245851, 245853, 245854, 245857, 245869, 245875, 245876, 245887, 245889, 245905, 245906, 245909, 281936, 281952, 281975, 295808, 296629, 304222, 304226, 304227, 304296, 304325, 304328, 311766, 311774, 311804, 311818, 311819, 311821, 314572, 319391, 319393, 319466, 329169, 329249, 329272, 329286, 329288, 329314, 329316, 329317, 329356, 329373, 329384, 334064, 334126, 345801, 345815, 345829, 345831, 345844, 345925, 354672, 354704, 354749, 354848, 354866, 354882, 355463, 355465, 355468, 355483, 375042, 375099, 375107, 375128, 375187, 375191, 375202, 375228, 375236, 376833, 376856, 395046, 395062, 395073, 395084, 395119, 395122, 395128, 395130, 395655, 396008, 411537, 411559, 411577, 412432, 426731, 426744, 426774, 426783, 426786, 437587, 437588, 437593, 437603, 437604, 437640, 437642, 448392, 448414, 448421, 448431, 448447, 448457, 448465, 448476, 448557, 452150, 464889, 464891, 464901, 464909, 464920, 464929, 465026, 465516, 465525, 480350, 480351, 480353, 480356, 480372, 480376, 480385, 480389, 480393, 480395, 480402, 480403, 480653, 495312, 495334, 497213, 497284, 497300, 497355, 497377, 497380, 497387, 497395, 497424, 497439, 503570, 503701, 504030, 504035, 505173, 505634, 505636, 505641, 505651, 505652, 505653, 505660, 506567, 506586, 506589, 506656, 507967, 509424, 509432, 509435, 509438, 509450, 509461, 509468, 509473, 509476, 509481, 509483, 509484, 509486, 509487, 511752, 511791, 511805, 511867, 512072, 548062, 548483, 548647)1118
34SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` IN (795, 903, 847) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`2992991
35SELECT `MPropertyBuilding`.`id` FROM `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` WHERE `MPropertyBuilding`.`id` IN (24941, 24962, 24963, 24970, 24976, 24993, 24996, 25005, 25010, 25026, 25030, 25255, 25265, 25270, 25281, 25286, 25400, 28034, 28038, 28040, 28050, 28234, 28240, 28246, 28252, 28255, 28270, 28275, 28302, 28420, 28501, 28507, 28663, 28670, 28672, 28685, 28735, 28763, 28794, 28803, 28805, 44254, 44270, 126836, 148963, 148964, 148968, 148972, 148973, 148975, 148981, 148988, 148992, 149003, 149007, 149008, 149009, 149031, 149042, 149046, 149048, 149050, 149052, 149058, 149066, 149068, 149070, 149077, 149080, 149081, 149082, 149088, 149095, 149096, 149101, 149103, 149105, 149112, 149114, 149123, 149157, 149158, 149162, 149163, 149173, 149174, 149180, 149192, 170190, 170198, 170202, 170204, 170206, 170211, 170213, 170224, 170227, 170229, 170231, 170234, 172393, 172492, 172722, 199530, 199531, 199533, 199534, 199538, 199540, 199554, 199556, 199570, 207348, 245839, 245841, 245843, 245844, 245851, 245853, 245854, 245857, 245869, 245875, 245876, 245887, 245889, 245905, 245906, 245909, 281936, 281952, 281975, 295808, 296629, 304222, 304226, 304227, 304296, 304325, 304328, 311766, 311774, 311804, 311818, 311819, 311821, 314572, 319391, 319393, 319466, 329169, 329249, 329272, 329286, 329288, 329314, 329316, 329317, 329356, 329373, 329384, 334064, 334126, 345801, 345815, 345829, 345831, 345844, 345925, 354672, 354704, 354749, 354848, 354866, 354882, 355463, 355465, 355468, 355483, 375042, 375099, 375107, 375128, 375187, 375191, 375202, 375228, 375236, 376833, 376856, 395046, 395062, 395073, 395084, 395119, 395122, 395128, 395130, 395655, 396008, 411537, 411559, 411577, 412432, 426731, 426744, 426774, 426783, 426786, 437587, 437588, 437593, 437603, 437604, 437640, 437642, 448392, 448414, 448421, 448431, 448447, 448457, 448465, 448476, 448557, 452150, 464889, 464891, 464901, 464909, 464920, 464929, 465026, 465516, 465525, 480350, 480351, 480353, 480356, 480372, 480376, 480385, 480389, 480393, 480395, 480402, 480403, 480653, 495312, 495334, 497213, 497284, 497300, 497355, 497377, 497380, 497387, 497395, 497424, 497439, 503570, 503701, 504030, 504035, 505173, 505634, 505636, 505641, 505651, 505652, 505653, 505660, 506567, 506586, 506589, 506656, 507967, 509424, 509432, 509435, 509438, 509450, 509461, 509468, 509473, 509476, 509481, 509483, 509484, 509486, 509487, 511752, 511791, 511805, 511867, 512072, 548062, 548483, 548647)2992991
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 (24941, 24962, 24963, 24970, 24976, 24993, 24996, 25005, 25010, 25026, 25030, 25255, 25265, 25270, 25281, 25286, 25400, 28034, 28038, 28040, 28050, 28234, 28240, 28246, 28252, 28255, 28270, 28275, 28302, 28420, 28501, 28507, 28663, 28670, 28672, 28685, 28735, 28763, 28794, 28803, 28805, 44254, 44270, 126836, 148963, 148964, 148968, 148972, 148973, 148975, 148981, 148988, 148992, 149003, 149007, 149008, 149009, 149031, 149042, 149046, 149048, 149050, 149052, 149058, 149066, 149068, 149070, 149077, 149080, 149081, 149082, 149088, 149095, 149096, 149101, 149103, 149105, 149112, 149114, 149123, 149157, 149158, 149162, 149163, 149173, 149174, 149180, 149192, 170190, 170198, 170202, 170204, 170206, 170211, 170213, 170224, 170227, 170229, 170231, 170234, 172393, 172492, 172722, 199530, 199531, 199533, 199534, 199538, 199540, 199554, 199556, 199570, 207348, 245839, 245841, 245843, 245844, 245851, 245853, 245854, 245857, 245869, 245875, 245876, 245887, 245889, 245905, 245906, 245909, 281936, 281952, 281975, 295808, 296629, 304222, 304226, 304227, 304296, 304325, 304328, 311766, 311774, 311804, 311818, 311819, 311821, 314572, 319391, 319393, 319466, 329169, 329249, 329272, 329286, 329288, 329314, 329316, 329317, 329356, 329373, 329384, 334064, 334126, 345801, 345815, 345829, 345831, 345844, 345925, 354672, 354704, 354749, 354848, 354866, 354882, 355463, 355465, 355468, 355483, 375042, 375099, 375107, 375128, 375187, 375191, 375202, 375228, 375236, 376833, 376856, 395046, 395062, 395073, 395084, 395119, 395122, 395128, 395130, 395655, 396008, 411537, 411559, 411577, 412432, 426731, 426744, 426774, 426783, 426786, 437587, 437588, 437593, 437603, 437604, 437640, 437642, 448392, 448414, 448421, 448431, 448447, 448457, 448465, 448476, 448557, 452150, 464889, 464891, 464901, 464909, 464920, 464929, 465026, 465516, 465525, 480350, 480351, 480353, 480356, 480372, 480376, 480385, 480389, 480393, 480395, 480402, 480403, 480653, 495312, 495334, 497213, 497284, 497300, 497355, 497377, 497380, 497387, 497395, 497424, 497439, 503570, 503701, 504030, 504035, 505173, 505634, 505636, 505641, 505651, 505652, 505653, 505660, 506567, 506586, 506589, 506656, 507967, 509424, 509432, 509435, 509438, 509450, 509461, 509468, 509473, 509476, 509481, 509483, 509484, 509486, 509487, 511752, 511791, 511805, 511867, 512072, 548062, 548483, 548647)) AND (`PropertyInformation`.`year_of_completion` >= 2005) AND (exists (SELECT PropertyInformationFeature.property_information_id FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` WHERE `PropertyInformationFeature`.`m_property_feature_id` IN (29, 42, 69) AND `PropertyInformation`.`id` = `PropertyInformationFeature`.`property_information_id` GROUP BY `PropertyInformationFeature`.`property_information_id` having count(`PropertyInformationFeature`.`property_information_id`) = 3))) ORDER BY `PropertyInformation`.`order` desc LIMIT 207774
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 (24941, 24962, 24963, 24970, 24976, 24993, 24996, 25005, 25010, 25026, 25030, 25255, 25265, 25270, 25281, 25286, 25400, 28034, 28038, 28040, 28050, 28234, 28240, 28246, 28252, 28255, 28270, 28275, 28302, 28420, 28501, 28507, 28663, 28670, 28672, 28685, 28735, 28763, 28794, 28803, 28805, 44254, 44270, 126836, 148963, 148964, 148968, 148972, 148973, 148975, 148981, 148988, 148992, 149003, 149007, 149008, 149009, 149031, 149042, 149046, 149048, 149050, 149052, 149058, 149066, 149068, 149070, 149077, 149080, 149081, 149082, 149088, 149095, 149096, 149101, 149103, 149105, 149112, 149114, 149123, 149157, 149158, 149162, 149163, 149173, 149174, 149180, 149192, 170190, 170198, 170202, 170204, 170206, 170211, 170213, 170224, 170227, 170229, 170231, 170234, 172393, 172492, 172722, 199530, 199531, 199533, 199534, 199538, 199540, 199554, 199556, 199570, 207348, 245839, 245841, 245843, 245844, 245851, 245853, 245854, 245857, 245869, 245875, 245876, 245887, 245889, 245905, 245906, 245909, 281936, 281952, 281975, 295808, 296629, 304222, 304226, 304227, 304296, 304325, 304328, 311766, 311774, 311804, 311818, 311819, 311821, 314572, 319391, 319393, 319466, 329169, 329249, 329272, 329286, 329288, 329314, 329316, 329317, 329356, 329373, 329384, 334064, 334126, 345801, 345815, 345829, 345831, 345844, 345925, 354672, 354704, 354749, 354848, 354866, 354882, 355463, 355465, 355468, 355483, 375042, 375099, 375107, 375128, 375187, 375191, 375202, 375228, 375236, 376833, 376856, 395046, 395062, 395073, 395084, 395119, 395122, 395128, 395130, 395655, 396008, 411537, 411559, 411577, 412432, 426731, 426744, 426774, 426783, 426786, 437587, 437588, 437593, 437603, 437604, 437640, 437642, 448392, 448414, 448421, 448431, 448447, 448457, 448465, 448476, 448557, 452150, 464889, 464891, 464901, 464909, 464920, 464929, 465026, 465516, 465525, 480350, 480351, 480353, 480356, 480372, 480376, 480385, 480389, 480393, 480395, 480402, 480403, 480653, 495312, 495334, 497213, 497284, 497300, 497355, 497377, 497380, 497387, 497395, 497424, 497439, 503570, 503701, 504030, 504035, 505173, 505634, 505636, 505641, 505651, 505652, 505653, 505660, 506567, 506586, 506589, 506656, 507967, 509424, 509432, 509435, 509438, 509450, 509461, 509468, 509473, 509476, 509481, 509483, 509484, 509486, 509487, 511752, 511791, 511805, 511867, 512072, 548062, 548483, 548647)) AND (`PropertyInformation`.`year_of_completion` >= 2005) AND (exists (SELECT PropertyInformationFeature.property_information_id FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` WHERE `PropertyInformationFeature`.`m_property_feature_id` IN (29, 42, 69) AND `PropertyInformation`.`id` = `PropertyInformationFeature`.`property_information_id` GROUP BY `PropertyInformationFeature`.`property_information_id` having count(`PropertyInformationFeature`.`property_information_id`) = 3)))1118
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` = 149066 ORDER BY `MPropertyBuildingStation`.`id` asc221
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` = 170224 ORDER BY `MPropertyBuildingStation`.`id` asc331
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` = 149095 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` = 170229 ORDER BY `MPropertyBuildingStation`.`id` asc331
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` = 437642 ORDER BY `MPropertyBuildingStation`.`id` asc330
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` = 497300 ORDER BY `MPropertyBuildingStation`.`id` asc3312
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` = 497387 ORDER BY `MPropertyBuildingStation`.`id` asc331
45SELECT `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` = 234489 ORDER BY `PropertyInformationFeature`.`id` asc26261
46SELECT `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` = 286997 ORDER BY `PropertyInformationFeature`.`id` asc26261
47SELECT `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` = 287008 ORDER BY `PropertyInformationFeature`.`id` asc25251
48SELECT `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` = 287009 ORDER BY `PropertyInformationFeature`.`id` asc26261
49SELECT `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` = 764345 ORDER BY `PropertyInformationFeature`.`id` asc25251
50SELECT `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` = 880245 ORDER BY `PropertyInformationFeature`.`id` asc20201
51SELECT `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` = 880391 ORDER BY `PropertyInformationFeature`.`id` asc11111
52SELECT `MPropertyFeature`.`name` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`id` IN (29, 42, 69)330
53SELECT `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
54SELECT `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
55SELECT `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
56SELECT `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