HomeTheON锦标赛世界锦标赛

上一届比赛 TheON Master 700 World ChampionShip 年大会 下一届比赛

select a.*,b.mb_id,b.mb_nick,b.mb_9,(a.play_count + d.total_play_count) as all_play_count from championship_ing_shot a left outer join g4_member b on a.user_idx=b.mb_no left join tbuser_play_record_info c on a.game_idx=c.game_guid and a.user_idx=c.user_guid left outer join championship_ing_shot d on a.championship_idx=d.championship_idx and d.round_idx='1' and a.user_idx=d.user_idx where a.championship_idx = '368' and a.round_idx = '2' and a.join_confirm > 0 and level_grade = '1' order by a.shot asc, all_play_count desc, (c.score_hole10+c.score_hole11+c.score_hole12+c.score_hole13+c.score_hole14+c.score_hole15+c.score_hole16+c.score_hole17+c.score_hole18) asc, (c.score_hole18+c.score_hole17+c.score_hole16+c.score_hole15+c.score_hole14+c.score_hole13) asc, (c.score_hole18+c.score_hole17+c.score_hole16) asc, c.score_hole18 asc, c.score_hole17 asc, c.score_hole16 asc,c.score_hole15 asc,c.score_hole14 asc, c.score_hole13 asc,c.score_hole12 asc,c.score_hole11 asc,c.score_hole10 asc,c.score_hole9 asc,c.score_hole8 asc,c.score_hole7 asc,c.score_hole6 asc, c.score_hole5 asc,c.score_hole4 asc,c.score_hole3 asc,c.score_hole2 asc,c.score_hole1 asc limit 0, 20

1052 : Column 'level_grade' in where clause is ambiguous

error file : /theongc_china/wc_use/w_use_shot_2r.php