[support] using drupal in mysql without subquery

In Drupal installation that using MySQL without subquery support, what is the right sql statement for this query? ------------------------------------------------------------------ SELECT count(u.name) FROM {users} u WHERE u.uid IN (SELECT uid from {node} n where type='blog') ------------------------------------------------------------------ Above query is show number of users who whas written Blog.