|
Ranking |
Nickname |
grades |
Use Store |
Round day |
|
select a.*,b.mb_id,b.mb_nick,b.mb_9,c.system_type,c.winner_handicap,c.shot,a.nature_check from championship_round_result a
left outer join g4_member b on a.user_idx=b.mb_no
left join championship_ing_shot c on a.game_idx=c.game_idx and a.user_idx=c.user_idx
where (a.championship_idx = '80' and a.round_num = '1') and a.cutoff_confirm = '1' and sex = '1' order by a.rank limit 0, 20
1052 : Column 'sex' in where clause is ambiguous
error file : /theongc_eng_2021/wc_use/c_use_shot_1r.php