select count(*), batch_id from tlog group by batch_id having count(*) > 1000 order by count(*) ;