[support] using drupal in mysql without subquery

[Drupal Indonesia]

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.