You are here: ListManager Programmer's Guide > Common SQL Queries > How many users on list xxx

How many users are on list xxx

To determine how many users are subscribed to a particular list, simply query the members_table:

select count(*) from members_ where list_ = 'jazztalk' and MemberType_ = 'normal'

If you want to know the breakdown of members by type, on a list:

select MemberType_, count(*) from members_ where list_ = 'jazztalk' group by MemberType_

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608

Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259

Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST