Classement Côtes d'Arey

SELECT @rownum:=@rownum+1 Cla, t.* FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts FROM usca_champ_clmt_memo WHERE ID_CHAMP=267 ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.usca_champ_clmt_memo' doesn't exist

Erreur dans la requête de la table 24
SELECT @rownum:=@rownum+1 Cla, t.* FROM (SELECT @rownum:=0) r,(SELECT DISTINCT NOM as Club ,POINTS as Pts FROM usca_champ_clmt_memo WHERE ID_CHAMP=267 ORDER BY POINTS DESC, DIFF DESC, BUTSPOUR DESC , BUTSCONTRE ASC, NOM) t
1146: Table 'vienneanbois.usca_champ_clmt_memo' doesn't exist