Boîtes gadget

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