Does anyone know the recommendation on using subqueries in drupal modules? Since they're not supported before mysql 4.1 I'm not sure if it's something that should be avoided, or is ok as long as it's noted...