133:
SELECT DISTINCT *
FROM _shared_old.t_emploi_metier
JOIN _shared_old.t_domaines_professionnelles ON metier_domaine_id=met_id
LEFT OUTER JOIN _edition.x_theme_metier ON x_metier_id=metier_id
LEFT OUTER JOIN _edition.t_theme ON theme_id=x_entite_id AND theme_place=41
WHERE metier_id IN ('629','837','646','647','248') AND metier_id IN ('76','95','198','220','242','244','245','247','248','249','254','256','257','258','266','267','286','291','307','314','386','387','390','391','432','440','443','450','451','452','453','455','456','629','631','633','635','636','637','639','644','646','649','650','662','829','830','833','836','837','838','839','840','841','842','843','844','845','847','848','849','850','851','852','853','854','855','856','857','858','864','873','3964','3965','3966','5297','5723') GROUP BY metier_id
Unknown column 'x_metier_id' in 'on clause'