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=38
WHERE metier_id IN ('650','256') AND metier_id IN ('220','245','247','248','254','256','258','386','387','390','455','573','629','631','633','635','636','637','639','644','646','649','650','829','830','833','836','837','838','839','840','841','842','843','844','845','872','873') GROUP BY metier_id
Unknown column 'x_metier_id' in 'on clause'