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