Yes, it is a red herring for sure; using a limit without a sort in a sub-query is always an issue.