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