I'm not sure how to fix that, I would recomend tring to rewrite the query without a subquery. It may even be easier to simply break it up into two queries, or construct some sort of view from the sub query, that way you simply join on the view instead of using the subquery.