rework queries for 24 hour soak