SELECT DISTINCT listeDiffusionid
FROM listregistration 
GROUP BY listeDiffusionid, personneId 
HAVING COUNT(*) > 1
ORDER BY listeDiffusionid ASC;

DELETE FROM listregistration WHERE id NOT IN ( SELECT MIN(id) FROM listregistration GROUP BY listeDiffusionid, personneId );

SELECT * FROM votre_table WHERE listeDiffusion = 7806 AND personneId = 17113467;

SELECT personneId, COUNT(*) 
FROM listregistration 
WHERE listeDiffusionid = 7806 
GROUP BY personneId 
HAVING COUNT(*) > 1;

DELETE FROM listregistration WHERE listeDiffusionid = 7806 AND id NOT IN ( SELECT MIN(id) FROM listregistration WHERE listeDiffusionid = 7806 GROUP BY personneId );

SELECT rc.constraint_name, kcu.column_name AS foreign_key_column, ccu.table_name AS referenced_table, ccu.column_name AS referenced_column, rc.update_rule, rc.delete_rule FROM information_schema.referential_constraints rc JOIN information_schema.key_column_usage kcu ON rc.constraint_name = kcu.constraint_name JOIN information_schema.constraint_column_usage ccu ON rc.constraint_name = ccu.constraint_name WHERE rc.constraint_name = 'segmentlistregistration_listregistration_fk';

ALTER TABLE segmentlistregistration
ADD CONSTRAINT segmentlistregistration_listregistration_fk
FOREIGN KEY (listregistrationid) -- Remplacez par le nom réel de la colonne
REFERENCES listregistration(id) -- Remplacez par les noms réels
ON DELETE CASCADE
ON UPDATE NO ACTION; -- Ou utilisez la règle que vous avez identifiée

DELETE FROM listregistration 
WHERE id NOT IN (
    SELECT MIN(id)
    FROM listregistration
    GROUP BY listeDiffusionid, personneId
);