Refs #6786 My whole point was not  to GROUP BY in the inner query as it's slow to group BY before LIMITing