To ask the obvious question here - can you GROUP by the group_id (and perhaps id) - it would help with streaming