テニススクール、テニスクラブやテニスコート、レンタルコートを探すなら、全国約4000件のテニス施設を網羅したテニス365で。
tennis365.net
HOME → テニスコート予約・検索TOP → テニス施設ガイドTOP → しぼりこみ検索(兵庫県/)
お問合せ ヘルプデスク
 ※必須項目を選択してください。
兵庫県

市・区など(★選択必須)

※複数選択はCtrlボタンを押しながら選択
設備など(複数選択可)
フリーワード検索 (地名、施設名、最寄り駅など)

[ select ypage_id, biz_type_school, biz_type_club, biz_type_court, biz_type_accommodation, biz_type_other, biz_type_coach, indicate_flg, indicate_sort_key, if( contract_type = 10 and (contract_premium_start_date <= '2021-04-15' and contract_premium_end_date >= '2021-04-15'), 10, if( contract_type = 20 and (contract_basic_start_date <= '2021-04-15' and contract_basic_end_date >= '2021-04-15'),20,30)) as contract_type, contract_premium_start_date, contract_premium_end_date, contract_basic_start_date, contract_basic_end_date, management_type, name_kanji, name_kana, zip_cd, pref_cd, city_id, city, address_1, address_2, tel_no, hp_no, fax_no, business_hour, regular_holiday, parking_existence, parking_capacity, access_info, hp_url, email_address, credit_card_available, credit_card_names, premium_text, comment_text, picture_path_list, picture_path_detail_1, picture_caption_detail_1, picture_path_detail_2, picture_caption_detail_2, picture_path_detail_3, picture_caption_detail_3, picture_path_detail_4, picture_caption_detail_4, record_update_date, facility_court_night_game_existence, facility_court_number_indoor_omni, facility_court_number_openair_omni, facility_court_number_indoor_hard, facility_court_number_openair_hard, facility_court_number_indoor_clay, facility_court_number_openair_clay, facility_court_number_indoor_carpet, facility_court_number_openair_carpet, facility_court_number_indoor_other, facility_court_number_openair_other, facility_court_name_indoor_other, facility_court_name_openair_other, facility_court_rental_existence, facility_court_rental_price, facility_membership_existence, facility_membership_price, facility_school_existence, facility_school_price, facility_clubhouse_existence, facility_vending_machine_existence, facility_day_nursery_existence, facility_shower_existence, facility_rental_racket_existence, facility_rental_shoes_existence, facility_rental_ball_existence, facility_auto_tennis_existence, facility_training_wall_existence, facility_info, accommodation_type, accommodation_party_plan_existence, accommodation_party_plan_info, accommodation_tennnis_pack_existence, accommodation_tennnis_pack_info, accommodation_check_in, accommodation_check_out, accommodation_bath_existence, accommodation_tv_existence, accommodation_vtr_existence, accommodation_refrigerator_existence, accommodation_shampoo_existence, accommodation_soap_existence, accommodation_towel_existence, accommodation_coin_laundry_existence, accommodation_drier_existence, accommodation_bathrobe_existence, accommodation_shaver_existence, accommodation_toothbrush_existence, accommodation_washlet_existence, accommodation_comb_existence, accommodation_zubon_pressor_existence, accommodation_water_heater_existence, accommodation_safe_existence, accommodation_tea_existence, accommodation_internet_existence, accommodation_info, accommodation_neighboring_recreations, coach_birthday, coach_gender, coach_nickname, coach_dominant_hand, coach_belonging, coach_tennis_career, coach_coaching_career, coach_qualification, coach_record, coach_interest, control_auth_id, control_latitude, control_longitude, control_school_transfer_existence, control_school_transfer_url, control_coart_reserve_existence, control_coart_reserve_url, closed_group_info, closed_person_in_charge, closed_comment_1, closed_comment_2, closed_comment_3, DATE_FORMAT(update_Timestamp,'%Y%m%d%H%i%s') as update_Timestamp, DATE_FORMAT(regist_Timestamp,'%Y%m%d%H%i%s') as regist_Timestamp from ypage_info where and pref_cd = 28 and contract_type = 10 and indicate_flg=1 order by contract_type, indicate_sort_key, record_update_date desc, management_type, name_kana limit 0, 10 ] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pref_cd = 28 and contract_type = 10 and indicate_flg=1
お得情報一覧
おすすめテニス施設
ページの先頭へ