INSERT INTO caddie_procs set type='SELECT', name='S 3.4. Notices sans exemplaires (sauf périodiques, documents électroniques et notices filles)', requete='SELECT notice_id as object_id, \'NOTI\' as object_type FROM notices left join exemplaires on notice_id=expl_notice left join notices_relations on notice_id=num_notice WHERE expl_notice is null and num_notice is null and niveau_biblio=\'m\' and niveau_hierar=\'0\' and typdoc!=\'l\'', comment='', autorisations='1', parameters=''