DB ERROR

=============================================================================
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_longest from championship where cs_index = ) - 1 and gdi_tar = 1 and gdi_shot_result = 1 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_longest 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_longest 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_longest from championship wh' at line 1
Mysql Error Num : 1064
=============================================================================