select distinct notice_id, niveau_biblio, caddie_content.caddie_id, caddie_content.flag from caddie_content JOIN etagere_caddie ON caddie_content.caddie_id=etagere_caddie.caddie_id JOIN notices ON notice_id=object_id ,notice_statut WHERE etagere_id=9 and statut=id_notice_statut and ((notice_visible_opac=1 and notice_visible_opac_abon=0)) ORDER BY responsability_notice,index_serie, tnvol, index_sew