Italiano errore : select m1.*,t.lingua,t.pub,t.nome from (menu as m1 left join testomenu as t on (t.id_padre=m1.id and t.lingua=1)) where t.pub=1 order by padre,ordine