select count(id) from users where id not in (select x.Own...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

select count(id) from users where id not in (select x.OwnerUserId from (select OwnerUserId from posts, users where (posts.OwnerUserId=users.id) and (posts.posttypeid=1) group by OwnerUserId having count(posts.id)>=1) as x)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results