INSERT INTO caddie_procs set type='SELECT', name='S 0.1. Articles de périodiques en double', requete='SELECT \'NOTI\' AS object_type, a.notice_id AS object_id, b.bulletin_id AS BULLETIN, concat(a.tit1,a.tit2,a.tit3,a.tit4,a.npages) as TITRES, count(concat(a.tit1,a.tit2,a.tit3,a.tit4)) FROM bulletins AS b, notices AS a, analysis AS c WHERE c.analysis_bulletin = b.bulletin_id AND a.notice_id = c.analysis_notice GROUP BY BULLETIN, TITRES HAVING count(concat(a.tit1,a.tit2,a.tit3,a.tit4,a.npages))>1', comment='Sélection des doublons pour suppression', autorisations='1', parameters=''