Yeah, but this query doesn't use a subquery, but a JOIN. Does this still not work on MySQL? I would be surprised. In any case, I'm looking forward to doing this MySQL-specific logic in the MySQL adapter soon.