You can dissect the entire query for starters to confirm where the issue is coming from.

Run each dissected query to confirm the problematic one.

If you are suspecting a particular subquery then run that query alone from the database and confirm the number of rows returned.