HOME >
| 기 간 | ~ (준비중) | 코 스 | 코스소개 |
|---|---|---|---|
| 대회명 | 매장위치 | ||
| 대회방식 | 날 씨 | ||
| 그 린 | 바 람 | ||
| 컨시드 | m | 멀리건 수 | 회 |
| 난이도 | 티 위치 | 남자 : 여자 : | |
| 대회내용 | |||
| 시상정보 |
1위 상금 : 0원 2위 상금 : 0원 3위 상금 : 0원 4 - 10위 상금 : 0원 니어핀 상금 : 0원 롱기스트 상금 : 0원 홀인원 상금 : 0원 |
||
| 유의사항 | |||
=============================================================================
Mysql_Query : select count(*) as cnt from gameplayerinfo inner join morning_bmain_gamedetailinfo on gpi_mac_address = gdi_mac_address and gpi_start_date = gdi_start_date and gpi_start_time = gdi_start_time and gpi_member_id = gdi_member_id where gpi_competition_no = and gpi_game_state = 1 and gdi_hole_no = (select cs_nearpin from championship where cs_index = ) - 1 and gdi_tar = 1 and gdi_shot_result in (3, 8) and (gdi_mac_address, gdi_start_date, gdi_start_time, gdi_player_no, gdi_player_name) IN (select distinct gri_mac_address, gri_start_date, gri_start_time, gri_player_no, gri_player_name from gameplayerinfo inner join gameresultinfo on gpi_mac_address = gri_mac_address and gpi_start_date = gri_start_date and gpi_start_time = gri_start_time and gpi_player_no = gri_player_no and gpi_player_name = gri_player_name where gpi_competition_no = and gri_hole_no = (select cs_nearpin from championship where cs_index = ) - 1 and gri_tar <= (select hi_par from morning_holeinfo where hi_course_name = (select cs_ccname from championship where cs_index = ) and hi_hole_no = (select cs_nearpin from championship where cs_index = )))
Mysql_Error : 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 gpi_game_state = 1 and gdi_hole_no = (select cs_nearpin from championship wh' at line 1
Mysql Error Num : 1064
=============================================================================