lklk11lklkSelect id,branch,batch_no,process_id,batch_generated_dt,anr_no,anr_year from mp_indexing_batch where clean_file_dt is not null and (clean_fl_pdf_gen_dt is null or (clean_fl_pdf_gen_dt is not null and rescan_date>clean_fl_pdf_gen_dt))