select COUNT(V_CIR_ITEM_MAXCHECKOUT.BIB_NO),V_CIR_ITEM_MAXCHECKOUT.ITEM_NO,V_CIR_ITEM_MAXCHECKOUT.TITLE from V_CIR_ITEM_MAXCHECKOUT where 1=1 



and rownum<=20000
and trunc(CHKOUT_DATETIME) between to_date('01/01/2022','dd/mm/yyyy') and to_date('29/04/2022','dd/mm/yyyy')
and TITLE not like '%[kit]%' or TITLE not like '%[Adapter]%'
group by V_CIR_ITEM_MAXCHECKOUT.ITEM_NO,V_CIR_ITEM_MAXCHECKOUT.TITLE
order by COUNT(V_CIR_ITEM_MAXCHECKOUT.BIB_NO) desc