INSERT INTO profile_job (id, uid, jobid, email, pub, email_pub, description)
SELECT e.entrid, e.uid, j.id, e.email, e.pub, e.email_pub,
CONCAT_WS(', ', IF(e.poste = '', NULL, e.poste), IF(e.fonction = 0, NULL, f.fonction_fr),
IF(e.ss_secteur IS NULL , IF(e.secteur IS NULL, NULL, s.label), ss.label))
INSERT INTO profile_job (id, uid, jobid, email, pub, email_pub, description)
SELECT e.entrid, e.uid, j.id, e.email, e.pub, e.email_pub,
CONCAT_WS(', ', IF(e.poste = '', NULL, e.poste), IF(e.fonction = 0, NULL, f.fonction_fr),
IF(e.ss_secteur IS NULL , IF(e.secteur IS NULL, NULL, s.label), ss.label))