Perhaps I'm just missing something obvious since it's late, but how can this query be made to work in MySQL 4.0 (i.e. how can I take the subqueries out of ...