select *, payst.nom as pays2, provincest.nom as province2 from succursales inner join provincest on (provincest.fk_province=succursales.province and provincest.fk_langue=) inner join payst on (payst.fk_pays=succursales.pays and payst.fk_langue=) WHERE 1=1