How to Find unverified account ?

[Ranjan]

Hi there,

How can I find and export those client who doesn't complete email verification?

[leemahoney3]

Probably best using an SQL query in the database, e.g.

select * from tblclients where email_verified = 0;