CS Vienne
SELECT @rownum:=@rownum+1 Cla, t.*
FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts ,JOUES as J ,G ,N , P , BUTSPOUR Po, BUTSCONTRE Co, Diff GA
FROM csv_champ_clmt_memo
WHERE ID_CHAMP=304
ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.csv_champ_clmt_memo' doesn't exist
Error in table query 22
SELECT @rownum:=@rownum+1 Cla, t.*
FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts ,JOUES as J ,G ,N , P , BUTSPOUR Po, BUTSCONTRE Co, Diff GA
FROM csv_champ_clmt_memo
WHERE ID_CHAMP=304
ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.csv_champ_clmt_memo' doesn't exist
SELECT @rownum:=@rownum+1 Cla, t.*
FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts
FROM csv_champ_clmt_memo
WHERE ID_CHAMP=310
ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.csv_champ_clmt_memo' doesn't exist
Error in table query 23
SELECT @rownum:=@rownum+1 Cla, t.*
FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts
FROM csv_champ_clmt_memo
WHERE ID_CHAMP=310
ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.csv_champ_clmt_memo' doesn't exist
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM csv_champ_jour AS champ_jour, csv_champ_equipe AS dom, csv_champ_equipe AS ext, csv_champ_match as champ_match, csv_champ_club AS cldom, csv_champ_club AS clext
WHERE champ_jour.id_champ =304
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT max(numero) FROM csv_champ_jour, csv_champ_match WHERE csv_champ_jour.id=csv_champ_match.id_journee and buts_dom is not NULL and csv_champ_jour.id_champ=302)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist
Error in table query 29
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM csv_champ_jour AS champ_jour, csv_champ_equipe AS dom, csv_champ_equipe AS ext, csv_champ_match as champ_match, csv_champ_club AS cldom, csv_champ_club AS clext
WHERE champ_jour.id_champ =304
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT max(numero) FROM csv_champ_jour, csv_champ_match WHERE csv_champ_jour.id=csv_champ_match.id_journee and buts_dom is not NULL and csv_champ_jour.id_champ=302)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM csv_champ_jour AS champ_jour, csv_champ_equipe AS dom, csv_champ_equipe AS ext, csv_champ_match as champ_match, csv_champ_club AS cldom, csv_champ_club AS clext
WHERE champ_jour.id_champ =304
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT IFNULL(max(numero)+1,1) FROM csv_champ_jour, csv_champ_match WHERE csv_champ_jour.id=csv_champ_match.id_journee and buts_dom is not NULL and csv_champ_jour.id_champ=304)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist
Error in table query 30
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur
FROM csv_champ_jour AS champ_jour, csv_champ_equipe AS dom, csv_champ_equipe AS ext, csv_champ_match as champ_match, csv_champ_club AS cldom, csv_champ_club AS clext
WHERE champ_jour.id_champ =304
AND champ_match.id_equipe_dom = dom.id
AND champ_match.id_equipe_ext = ext.id
AND dom.id_club = cldom.id
AND ext.id_club = clext.id
AND champ_match.id_journee = champ_jour.id
AND cldom.nom != 'exempte'
AND clext.nom != 'exempte'
AND champ_jour.numero = (SELECT IFNULL(max(numero)+1,1) FROM csv_champ_jour, csv_champ_match WHERE csv_champ_jour.id=csv_champ_match.id_journee and buts_dom is not NULL and csv_champ_jour.id_champ=304)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist
La saison du CS Vienne 2018-2019
Calendrier complet de la saison du CS Vienne - la saison complète 2018-2019 du CS Vienne Rugby |