Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
719 views
in Plugins by

WITHOUT LAST LOGIN 

I'm using this query

select id, user_login, user_nicename, user_email, user_registered from wp_users where id NOT IN (select userid from qa_userevents)

Is this every user who has never commented nor asked nor answered in Q2A?

WITH LAST LOGIN

or the more complete version, with the Last Login plugin contemplated

select id, user_login, user_nicename, user_email, user_registered from wp_users where id NOT IN (select user_id from wp_usermeta where meta_key = 'wp-last-login') AND id NOT IN (select userid from qa_userevents)

This seems to tell me every user who has never logged in and has never posted nor commented (because I installed the Last Login plugin late). Is this a correct interpretation?

 

Q2A version: 1.6.1

Please log in or register to answer this question.

...