 |
|
|
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 = '8025' 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/wc_use/c_use_shot_1r.php
> 챔피언쉽 > 클럽 챔피언쉽