SQL( SELECT m_basic.article_cd, m_basic.sel_article_class, m_basic.sel_article_item, m_basic.article_name, m_basic.sel_business_class, m_basic.rent, m_basic.management_costs, m_basic.guaranty_money, m_basic.sel_guaranty_money, m_basic.recompense, m_basic.sel_recompense_type, m_basic.deposit, m_basic.sel_deposit_type, m_basic.cancel_contact_fee, m_basic.location1, m_basic.location2, m_basic.location3, m_basic.rail_road_name, m_basic.station_name, m_basic.bus_taking_train_time, m_basic.foot_time, m_basic.sel_building_structure, m_basic.number_of_ground_upper_rank, m_basic.basement_number_of_floors, m_basic.location_floor, m_basic.number_of_room, m_basic.sel_plan_of_house_type, m_basic.sel_balcony_direction, m_basic.sel_number_of_j_years_to_build, m_basic.number_of_years_to_build_year, m_basic.number_of_years_to_build_month, m_basic.ridge_general_number_of_houses, m_basic.sel_parking_lot_class, m_basic.parking_lot_monthly_basis_rate, m_basic.sw_facility, m_basic.sel_present_situation, m_basic.sel_delivery_moving_into_day_cs, m_basic.delivery_moving_into_date_year, m_basic.delivery_moving_into_date_month, m_basic.sel_delivery_moving_into_day_ss, m_basic.layout_image_name, m_basic.map_image_name, m_basic.photo_image_name, m_extend.article_cd, m_extend.exist_flg, m_extend.sending_ex_id, m_extend.first_time_exhibition_day, m_extend.last_update_day, m_extend.article_name_kana, m_extend.manufacturer_name, m_extend.manufacturer_phone_number, m_extend.permi_message, m_extend.update_charges, m_extend.sel_update_charges, m_extend.time_for_renewal, m_extend.house_premium, m_extend.house_insurance_period, m_extend.zip_cd, m_extend.prefecture_cd, m_extend.rail_road_cd, m_extend.station_cd, m_extend.bus_stop_name, m_extend.occupation_area, m_extend.balcony_area, m_extend.sel_room_type1, m_extend.area_of_room1, m_extend.sel_room_type2, m_extend.area_of_room2, m_extend.sel_room_type3, m_extend.area_of_room3, m_extend.sel_room_type4, m_extend.area_of_room4, m_extend.sel_room_type5, m_extend.area_of_room5, m_extend.sel_room_type6, m_extend.area_of_room6, m_extend.sel_room_type7, m_extend.area_of_room7, m_extend.sel_room_type8, m_extend.area_of_room8, m_extend.sel_room_type9, m_extend.area_of_room9, m_extend.sel_room_type10, m_extend.area_of_room10, m_extend.layout_remarks, m_extend.sw_facility_ex, m_extend.sw_condition, m_extend.elementary_school_name, m_extend.distance_to_elementary_school, m_extend.junior_high_school_name, m_extend.distance_to_junior_high_school, m_extend.distance_to_convenience_store, m_extend.distance_to_super, m_extend.distance_to_polyclinic, m_extend.photo_image_name1, m_extend.photo_image_name2, m_extend.photo_image_name3, m_extend.sel_manager_class, m_extend.photo_image_comments1, m_extend.photo_image_comments2, m_extend.photo_image_comments3, m_extend.parking_deposit, m_extend.sel_open_web_class, m_extend.open_web_date_from, m_extend.open_web_date_to, m_extend.sel_open_user_class, m_extend.sel_open_outside_class, m_extend.room_number, m_extend.water_rate, m_extend.rail_road_cd2, m_extend.station_cd2, m_extend.bus_stop_name2, m_extend.rail_road_name2, m_extend.station_name2, m_extend.bus_taking_train_time2, m_extend.foot_time2, m_extend.rail_road_cd3, m_extend.station_cd3, m_extend.bus_stop_name3, m_extend.rail_road_name3, m_extend.station_name3, m_extend.bus_taking_train_time3, m_extend.foot_time3, m_extend.sel_cancel_contact_fee_type, m_extend.estate_check_date, m_extend.floor_image_name1, m_extend.area_cd, m_extend.sel_not_move_in_class, m_extend.search_number_of_years_to_build, m_extend.web_comments, m_extend.photo_image_name4, m_extend.photo_image_name5, m_extend.photo_image_name6, m_extend.photo_image_name7, m_extend.photo_image_name8, m_extend.photo_image_name9, m_extend.photo_image_comments4, m_extend.photo_image_comments5, m_extend.photo_image_comments6, m_extend.photo_image_comments7, m_extend.photo_image_comments8, m_extend.photo_image_comments9, m_extend.sel_mark_class, m_extend.sel_guide_class, m_extend.town_due, m_extend.facility_remarks, m_extend.sel_parking_deposit_type, m_extend.high_school_name, m_extend.distance_to_high_school, m_extend.university_name, m_extend.distance_to_university, m_extend.sel_url_class1, m_extend.url1, m_extend.url_comments1, m_extend.sel_url_class2, m_extend.url2, m_extend.url_comments2, m_extend.sel_url_class3, m_extend.url3, m_extend.url_comments3, m_extend.convenience_store_name, m_extend.convenience_store_name2, m_extend.distance_to_convenience_store2, m_extend.sel_fixed_leased_house, m_extend.contract_term_year, m_extend.contract_term_months, m_extend.fixed_leased_house_term_year, m_extend.fixed_leased_house_term_month, m_extend.fixed_leased_house_term_day, m_extend.sel_commit_apply_insurance, m_extend.sw_panorama_use_flg, m_extend.sel_major_secondhand_article, m_extend.update_commission_charges, m_extend.latitude_msec_for_sync, m_extend.longitude_msec_for_sync, m_extend.distance_to_parking, m_extend.last_detail_update_day, m_extend.sel_lower_ground_floor, m_extend.sel_open_web_mapping_point, m_extend.sel_open_web_article_name, m_extend.sel_specific_high_quality, m_extend.photo_image_name10, m_extend.photo_image_name11, m_extend.photo_image_name12, m_extend.photo_image_name13, m_extend.photo_image_name14, m_extend.photo_image_name15, m_extend.photo_image_name16, m_extend.photo_image_name17, m_extend.photo_image_name18, m_extend.photo_image_name19, m_extend.photo_image_name20, m_extend.photo_image_name21, m_extend.photo_image_name22, m_extend.photo_image_name23, m_extend.photo_image_name24, m_extend.photo_image_name25, m_extend.photo_image_name26, m_extend.photo_image_name27, m_extend.photo_image_name28, m_extend.photo_image_name29, m_extend.photo_image_name30, m_extend.photo_image_name31, m_extend.photo_image_name32, m_extend.photo_image_name33, m_extend.photo_image_name34, m_extend.photo_image_name35, m_extend.photo_image_name36, m_extend.photo_image_comments10, m_extend.photo_image_comments11, m_extend.photo_image_comments12, m_extend.photo_image_comments13, m_extend.photo_image_comments14, m_extend.photo_image_comments15, m_extend.photo_image_comments16, m_extend.photo_image_comments17, m_extend.photo_image_comments18, m_extend.photo_image_comments19, m_extend.photo_image_comments20, m_extend.photo_image_comments21, m_extend.photo_image_comments22, m_extend.photo_image_comments23, m_extend.photo_image_comments24, m_extend.photo_image_comments25, m_extend.photo_image_comments26, m_extend.photo_image_comments27, m_extend.photo_image_comments28, m_extend.photo_image_comments29, m_extend.photo_image_comments30, m_extend.photo_image_comments31, m_extend.photo_image_comments32, m_extend.photo_image_comments33, m_extend.photo_image_comments34, m_extend.photo_image_comments35, m_extend.photo_image_comments36, m_extend.photo_image_comments37, m_extend.sel_photo_image_category, m_extend.sel_photo_image_category1, m_extend.sel_photo_image_category2, m_extend.sel_photo_image_category3, m_extend.sel_photo_image_category4, m_extend.sel_photo_image_category5, m_extend.sel_photo_image_category6, m_extend.sel_photo_image_category7, m_extend.sel_photo_image_category8, m_extend.sel_photo_image_category9, m_extend.sel_photo_image_category10, m_extend.sel_photo_image_category11, m_extend.sel_photo_image_category12, m_extend.sel_photo_image_category13, m_extend.sel_photo_image_category14, m_extend.sel_photo_image_category15, m_extend.sel_photo_image_category16, m_extend.sel_photo_image_category17, m_extend.sel_photo_image_category18, m_extend.sel_photo_image_category19, m_extend.sel_photo_image_category27, m_extend.sel_photo_image_category28, m_extend.sel_photo_image_category29, m_extend.sel_photo_image_category30, m_extend.sel_photo_image_category31, m_extend.sel_photo_image_category32, m_extend.sel_photo_image_category33, m_extend.sel_photo_image_category34, m_extend.sel_photo_image_category35, m_extend.sel_photo_image_category36, m_extend.supermarket_name, m_extend.polyclinic_name, m_extend.parking_remarks, m_extend.sel_base_update_charges, m_extend.key_exchange_cost, m_extend.specific_amount_burden_lower_limit, m_extend.specific_amount_burden_upper_limit, m_extend.sel_specific_fee_variation_class, m_extend.specific_fee_gradient_type_rate_of_climb, m_extend.specific_period_of_rent_subsidy, m_extend.specific_terms_and_conditions_remarks, m_extend.sel_use_surety_company_rent_class, m_extend.surety_company_rent_name, m_extend.surety_company_rent_fee, m_extend.renovation_completion_year, m_extend.renovation_completion_month, m_extend.renovation_content, m_extend.first_time_another_system_data_import_day, m_extend.sel_artilce_remarks_priority FROM m_basic join m_extend using(article_cd) WHERE exist_flg != false and sending_ex_id = 10606 and sel_article_class = 6 and ( sel_present_situation != 1 or ( sel_present_situation = 1 and sel_delivery_moving_into_day_cs = 2 ) or ( sel_present_situation = 1 and sel_delivery_moving_into_day_cs = 3 and (case when delivery_moving_into_date_year is null then 0 else delivery_moving_into_date_year end) > 2018) or ( sel_present_situation = 1 and sel_delivery_moving_into_day_cs = 3 and (case when delivery_moving_into_date_year is null then 0 else delivery_moving_into_date_year end) = 2018 and (case when delivery_moving_into_date_month is null then 0 else delivery_moving_into_date_month end) >= 10 ) ) and (sel_open_web_class = 2 or (sel_open_web_class = 3 and open_web_date_from < now() and open_web_date_to > now() )) AND (building_cd = ) ORDER BY m_basic.rent, m_basic.management_costs, m_basic.article_cd LIMIT 20 OFFSET 140;)の実行に失敗 : ERROR: syntax error at or near ")" LINE 299: AND (building_cd = ) ^ 賃貸|ご紹介物件の一覧|株式会社 関 西 建 物
■ ご紹介物件の一覧
ご紹介物件の一覧
 
ご紹介物件0件中0件を表示
前ページ
 



  申し訳ございません。只今ご案内可能な物件はございません。



 
ご紹介物件0件中0件を表示
前ページ