changed query for requestid in-progress count to use a UNION instead of OR so that it makes use of indexes