4 Oct
2006
4 Oct
'06
3:24 a.m.
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.