Résultat Vienne
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 =310
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=310)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist
Erreur dans la requête de la table 25
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 =310
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=310)
1146: Table 'vienneanbois.csv_champ_jour' doesn't exist