Never mind. I got it. Strange; I swear I tried it before and it didn't work. Must have had a typeo. Here's the final query if you're interested: http://stikked.com/view/86105 Adding "AND even.even_id=meev.meev_even_id" to the sub-query is what did it.