Select id,batch_no,scan_clean_final_status,branch,receipt_no,receipt_year from receipt_mp_indexing_batch where completed='1' and (pdf_generate_date is null or (pdf_generate_date is not null and rejection_date > pdf_generate_date and allowed_date is not null)) and (process_id='4' or process_id='1' or process_id='2' or process_id='3' or process_id='0' or process_id='5') and (error='0' or error='1' or error='2') order by pdf_generate_date,indexing_com_date desc0