Query to find out deactivated users

[avdhesh]

Can you please help me build a query to find all userid in user table which are deactivated
OR
users who have disabled "Receive Email from Administrators" option.

Actually I want to generate a mailing list and want to remove these users from the list.

[Lats]

This will select user who have opted to receive admin emails - best to run in phpmyadmin and export the results to your newletter app.

SELECT
    username,
    email
FROM
    user
WHERE
    (options &16)
ORDER BY
    username

To delete the rest who didn't select to receive admin emails, create a new usergroup and run this query...

UPDATE
    user
SET
    usergroupid = [COLOR=blue]X
[/COLOR]WHERE NOT (options &16)

Change X to the new usergroupid, then prune the users in that usergroup.

[avdhesh]

Thanks

Many a thanks Lats, It worked.

[Lats]

Excellent news - thanks for letting me know.

[LEARNER29]

This will select user who have opted to receive admin emails - best to run in phpmyadmin and export the results to your newletter app.

SELECT
    username,
    email
FROM
    user
WHERE
    (options &16)
ORDER BY
    username

To delete the rest who didn't select to receive admin emails, create a new usergroup and run this query...

UPDATE
    user
SET
    usergroupid = [COLOR=blue]X[/COLOR]
WHERE NOT (options &16)

Change X to the new usergroupid, then prune the users in that usergroup.

thank you. this answered my question.