133:<br>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 ('506','391','392','393','394','395','396','397','401','389','388','380','381','382','383','384','385','386','387','407','410','469','478','485','495','498','503','504','505','452','451','414','426','427','430','431','433','444','447','379','378','333','334','337','339','340','341','342','343','331','330','322','323','324','325','326','327','328','329','344','345','357','358','359','360','361','362','363','377','356','355','346','347','348','349','351','352','353','354','321','5344','3971','3972','3973','3974','3975','3977','3978','3984','3970','3969','848','856','861','864','873','3965','3966','3968','3985','3986','5309','5311','5314','5322','5326','5329','5330','5342','5301','5299','3987','3989','4000','4001','4002','4003','4004','4010','847','845','578','579','617','629','636','638','639','640','574','572','508','549','563','565','566','569','570','571','644','645','837','838','839','840','841','842','843','844','835','834','646','647','650','651','654','672','829','831','507','320','229','73','74','75','76','77','78','79','80','72','71','58','59','60','61','64','65','66','70','81','82','146','156','186','224','225','226','227','228','139','136','90','91','108','109','110','115','116','134','57','56','13','14','15','16','17','18','19','20','12','11','2','3','4','5','6','7','8','10','21','22','45','46','47','49','52','53','54','55','42','41','23','27','28','31','33','34','37','40','1','319','288','289','290','291','293','294','295','296','287','286','275','276','277','278','280','283','284','285','297','298','309','310','311','313','314','316','317','318','308','307','299','300','301','302','303','304','305','306','274','273','243','244','245','246','248','249','250','251','241','240','231','232','233','234','235','236','238','239','252','253','265','266','267','268','269','270','271','272','264','263','255','256','257','258','259','260','261','262','230') 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<br>Unknown column 'x_metier_id' in 'on clause'