select count(arc_id) as Nombre from pret_archive left join bulletins on arc_expl_bulletin=bulletin_id left join notices on bulletin_notice=notice_id where arc_debut between "!!date1!!" and "!!date2!!" and code="!!cb!!"