TO VIEW GROUP STANDINGS SELECT A GROUP FROM THE DROPDOWN:
--Select Group--
SELECT group_id, Concat(round_name,' - ',group_name) AS GroupName , group_summary FROM df_competition_groups G INNER JOIN df_comp_group_lang L ON G.competition_group_id=L.group_id INNER JOIN df_competition_rounds R ON G.competition_round_id = R.competition_round_id INNER JOIN df_comp_round_lang RL ON R.competition_round_id = RL.round_id INNER JOIN df_competition_seasons SES ON R.competition_season_id = SES.competition_season_id INNER JOIN df_competition COM ON SES.competition_id = COM.competition_id WHERE COM.competition_id = 1 AND SES.status = 1 AND L.lang_id =1 AND RL.lang_id = 1 ORDER BY R.rnd_order, G.grp_order
Stage 1 - Group A
Stage 1 - Group B
Stage 1 - Group C
Stage 1 - Group D
Stage 1 - Group E
Stage 2 - Group F
Stage 2 - Group G
Stage 2 - Group H
Final Stage - Group A
Final Stage - Group B
Final Stage - Semi Final
Final Stage - Third Place Play Off
Final Stage - Final
UPCOMING MATCHES
View all Upcoming Matches
Pld
W
D
L
GF
GA
GD
Pts
GROUP SUMMARY