Boîtes gadget

Résultat Côtes d'Arey

SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur FROM usca_champ_jour AS champ_jour, usca_champ_equipe AS dom, usca_champ_equipe AS ext, usca_champ_match as champ_match, usca_champ_club AS cldom, usca_champ_club AS clext WHERE champ_jour.id_champ =267 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 usca_champ_jour, usca_champ_match WHERE usca_champ_jour.id=usca_champ_match.id_journee and buts_dom is not NULL and usca_champ_jour.id_champ=267)
1146: Table 'vienneanbois.usca_champ_jour' doesn't exist

Erreur dans la requête de la table 27
SELECT cldom.nom hôte, CONCAT(buts_dom,' - ',buts_ext ) score,clext.nom visiteur FROM usca_champ_jour AS champ_jour, usca_champ_equipe AS dom, usca_champ_equipe AS ext, usca_champ_match as champ_match, usca_champ_club AS cldom, usca_champ_club AS clext WHERE champ_jour.id_champ =267 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 usca_champ_jour, usca_champ_match WHERE usca_champ_jour.id=usca_champ_match.id_journee and buts_dom is not NULL and usca_champ_jour.id_champ=267)
1146: Table 'vienneanbois.usca_champ_jour' doesn't exist