The individual criteria filters that make up the problem query run fast on their own, but the combination of all of these different criteria filters is causing the slowness. The current architecture of RE7 query builds all of the query critteria into the same SQL statement (in the backend), which multiplies the amount of rows that need to be looked at and causes SQL server to bog down.
1. Split the queries up, and bring them through Queue to refresh them
2. Wait for the query to complete