The Collection value from your inner sub query has exceeded the system limits.

Try with lesser value and re-execute the query.

Also you can match the records on both tables to sort the issues.