Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 34]
Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 35]
中央大学多摩キャンパス検索結果
(default) 41 queries took 60 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` = '中央大学_多摩キャンパス'111
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` = 159 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` = 159 AND `MSchoolCampus`.`url` = '多摩キャンパス'110
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` = (159)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` = (159)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` = 159 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` = (231)110
32SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` = (1710) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`2252251
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 (110940, 112051, 113197, 113240, 113368, 113412, 113457, 113712, 113911, 113938, 113940, 114235, 114238, 114239, 114311, 114368, 114370, 114637, 114895, 114909, 114919, 114921, 114949, 114957, 114967, 114969, 114972, 114998, 115102, 115113, 115187, 115192, 115370, 115434, 115472, 115645, 115650, 115880, 115910, 116099, 116297, 116299, 116364, 116368, 116432, 116625, 118765, 118918, 119090, 163944, 163975, 164048, 164070, 164071, 165933, 170397, 176775, 176796, 176808, 219736, 219781, 219828, 219846, 219855, 219857, 219858, 220106, 220453, 223014, 223022, 223047, 223048, 223067, 223157, 225389, 272178, 272200, 287501, 288007, 288162, 299056, 299088, 299484, 299592, 299656, 306867, 316270, 321673, 323756, 323928, 337614, 337671, 337848, 337852, 351952, 352430, 352438, 352473, 352531, 366070, 420824, 445198, 474664, 474776, 474807, 474829, 489682, 503252, 506276, 506280, 506286, 506288, 506291, 506297, 506299, 506300, 506304, 506306, 506307, 506850, 506857, 507116, 507117, 507118, 507119, 507120, 507121, 507122, 507498, 507499, 507500, 507532, 507719, 507725, 508797, 508800, 508801, 508803, 508806, 508808, 508816, 508818, 508825, 508827, 508852, 508861, 509304, 509305, 509306, 509307, 509308, 515834, 515875, 515880, 515891, 516029, 516093, 516101, 516156, 516191, 516195, 516206, 516208, 516209, 516210, 516221, 516243, 516318, 516368, 516451, 516467, 516471, 516481, 516497, 516563, 516611, 516621, 516631, 516666, 516668, 516707, 516721, 516739, 516743, 516749, 516757, 516764, 516770, 516806, 516818, 516822, 516829, 516833, 516836, 516844, 516846, 516853, 516859, 516885, 516925, 516932, 516958, 517020, 517085, 517089, 517101, 517109, 517116, 517123, 521668, 521674, 521692, 521698, 521699, 521858, 521864, 521918, 521933, 522050, 527220, 528066, 528193, 528216, 528281, 549673)1121
34SELECT `MPropertyBuildingStation`.`m_property_building_id` FROM `fudosan`.`app_m_property_building_stations` AS `MPropertyBuildingStation` WHERE `MPropertyBuildingStation`.`m_area_station_id` = (1710) GROUP BY `MPropertyBuildingStation`.`m_property_building_id`2252251
35SELECT `MPropertyBuilding`.`id` FROM `fudosan`.`app_m_property_buildings` AS `MPropertyBuilding` WHERE `MPropertyBuilding`.`id` IN (110940, 112051, 113197, 113240, 113368, 113412, 113457, 113712, 113911, 113938, 113940, 114235, 114238, 114239, 114311, 114368, 114370, 114637, 114895, 114909, 114919, 114921, 114949, 114957, 114967, 114969, 114972, 114998, 115102, 115113, 115187, 115192, 115370, 115434, 115472, 115645, 115650, 115880, 115910, 116099, 116297, 116299, 116364, 116368, 116432, 116625, 118765, 118918, 119090, 163944, 163975, 164048, 164070, 164071, 165933, 170397, 176775, 176796, 176808, 219736, 219781, 219828, 219846, 219855, 219857, 219858, 220106, 220453, 223014, 223022, 223047, 223048, 223067, 223157, 225389, 272178, 272200, 287501, 288007, 288162, 299056, 299088, 299484, 299592, 299656, 306867, 316270, 321673, 323756, 323928, 337614, 337671, 337848, 337852, 351952, 352430, 352438, 352473, 352531, 366070, 420824, 445198, 474664, 474776, 474807, 474829, 489682, 503252, 506276, 506280, 506286, 506288, 506291, 506297, 506299, 506300, 506304, 506306, 506307, 506850, 506857, 507116, 507117, 507118, 507119, 507120, 507121, 507122, 507498, 507499, 507500, 507532, 507719, 507725, 508797, 508800, 508801, 508803, 508806, 508808, 508816, 508818, 508825, 508827, 508852, 508861, 509304, 509305, 509306, 509307, 509308, 515834, 515875, 515880, 515891, 516029, 516093, 516101, 516156, 516191, 516195, 516206, 516208, 516209, 516210, 516221, 516243, 516318, 516368, 516451, 516467, 516471, 516481, 516497, 516563, 516611, 516621, 516631, 516666, 516668, 516707, 516721, 516739, 516743, 516749, 516757, 516764, 516770, 516806, 516818, 516822, 516829, 516833, 516836, 516844, 516846, 516853, 516859, 516885, 516925, 516932, 516958, 517020, 517085, 517089, 517101, 517109, 517116, 517123, 521668, 521674, 521692, 521698, 521699, 521858, 521864, 521918, 521933, 522050, 527220, 528066, 528193, 528216, 528281, 549673)2252252
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 (110940, 112051, 113197, 113240, 113368, 113412, 113457, 113712, 113911, 113938, 113940, 114235, 114238, 114239, 114311, 114368, 114370, 114637, 114895, 114909, 114919, 114921, 114949, 114957, 114967, 114969, 114972, 114998, 115102, 115113, 115187, 115192, 115370, 115434, 115472, 115645, 115650, 115880, 115910, 116099, 116297, 116299, 116364, 116368, 116432, 116625, 118765, 118918, 119090, 163944, 163975, 164048, 164070, 164071, 165933, 170397, 176775, 176796, 176808, 219736, 219781, 219828, 219846, 219855, 219857, 219858, 220106, 220453, 223014, 223022, 223047, 223048, 223067, 223157, 225389, 272178, 272200, 287501, 288007, 288162, 299056, 299088, 299484, 299592, 299656, 306867, 316270, 321673, 323756, 323928, 337614, 337671, 337848, 337852, 351952, 352430, 352438, 352473, 352531, 366070, 420824, 445198, 474664, 474776, 474807, 474829, 489682, 503252, 506276, 506280, 506286, 506288, 506291, 506297, 506299, 506300, 506304, 506306, 506307, 506850, 506857, 507116, 507117, 507118, 507119, 507120, 507121, 507122, 507498, 507499, 507500, 507532, 507719, 507725, 508797, 508800, 508801, 508803, 508806, 508808, 508816, 508818, 508825, 508827, 508852, 508861, 509304, 509305, 509306, 509307, 509308, 515834, 515875, 515880, 515891, 516029, 516093, 516101, 516156, 516191, 516195, 516206, 516208, 516209, 516210, 516221, 516243, 516318, 516368, 516451, 516467, 516471, 516481, 516497, 516563, 516611, 516621, 516631, 516666, 516668, 516707, 516721, 516739, 516743, 516749, 516757, 516764, 516770, 516806, 516818, 516822, 516829, 516833, 516836, 516844, 516846, 516853, 516859, 516885, 516925, 516932, 516958, 517020, 517085, 517089, 517101, 517109, 517116, 517123, 521668, 521674, 521692, 521698, 521699, 521858, 521864, 521918, 521933, 522050, 527220, 528066, 528193, 528216, 528281, 549673)) AND (`PropertyInformation`.`year_of_completion` >= 2015) AND (exists (SELECT PropertyInformationFeature.property_information_id FROM `fudosan`.`app_property_information_features` AS `PropertyInformationFeature` WHERE `PropertyInformationFeature`.`m_property_feature_id` IN (42, 69) AND `PropertyInformation`.`id` = `PropertyInformationFeature`.`property_information_id` GROUP BY `PropertyInformationFeature`.`property_information_id` having count(`PropertyInformationFeature`.`property_information_id`) = 2))) ORDER BY `PropertyInformation`.`order` desc LIMIT 200028
37SELECT `MPropertyFeature`.`name` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`id` IN (42, 69)220
38SELECT `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
39SELECT `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)2572571
40SELECT `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
41SELECT `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