optimized query for attendees with rates