How about doing what hrishy suggested for subquery #2?