Unable to get member's info via my sql

[hipgirl]

Hi,

I'm trying to get the mailing list by running the script below:

SELECT
userid,
username,
email,
joindate
FROM
user
WHERE
(options &16)
and usergroupid<>8
and userid > 22481

I worked fine until recently. the script only returns 81 records but the newest member id is 24790.

I checked the table "user" and new records are not saved there.

Please let me know which table I need to use.

Thanks.

Michelle