I have a site that deals exclusively with user generated content.
After a few years, the users table is getting to a stage where it can probably be pruned of folk who have registered but not actually submitted any content.
What query would I run to show the users who have zero posts?
I thought something like
select id from craft_users where id not in (select distinct authorId from craft_entries) would do it.
distinct query certainly returns 1020 rows where we actually have around 1800 users.