improved query for progress global