INSERT ignore INTO responsability (responsability_author, responsability_notice, responsability_type, responsability_fonction) 
SELECT 
r2.responsability_author, num_notice, r2.responsability_type, r2.responsability_fonction 
FROM notices_relations JOIN responsability r2 ON linked_notice = r2.responsability_notice where linked_notice IN (CADDIE(NOTI))