Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save imjakechapman/4507481 to your computer and use it in GitHub Desktop.
Save imjakechapman/4507481 to your computer and use it in GitHub Desktop.
Find the number of Members that have entries.
{exp:query sql="
SELECT count(*) AS num_members
FROM exp_members m
JOIN exp_channel_titles t on t.author_id = m.member_id
Where channel_id='CHANNEL_ID_HERE'"}
{num_members}
{/exp:query}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment