INSERT INTO procs set name='Suppression des traces de valeurs qui ne sont plus utilisées dans les champs perso', requete='DELETE FROM notices_custom_values WHERE notices_custom_champ=6 AND notices_custom_integer NOT IN (SELECT notices_custom_list_value FROM notices_custom_lists WHERE notices_custom_champ=6); 
DELETE FROM notices_custom_values WHERE notices_custom_champ=1 AND notices_custom_integer NOT IN (SELECT notices_custom_list_value FROM notices_custom_lists WHERE notices_custom_champ=1);
DELETE FROM notices_custom_values WHERE notices_custom_champ=2 AND notices_custom_integer NOT IN (SELECT notices_custom_list_value FROM notices_custom_lists WHERE notices_custom_champ=2);
DELETE FROM notices_custom_values WHERE notices_custom_champ=7 AND notices_custom_integer NOT IN (SELECT notices_custom_list_value FROM notices_custom_lists WHERE notices_custom_champ=7);
DELETE FROM notices_custom_values WHERE notices_custom_champ=3 AND notices_custom_integer NOT IN (SELECT notices_custom_list_value FROM notices_custom_lists WHERE notices_custom_champ=3)', comment='Ne traite que les champs persos 1,2,3,6 et 7 de la base BRETAGNE', autorisations='1', parameters=''