XF 1.2 User Cleanup - Search on Joined Date and Last Activity Date being the same

[toy4x4]

Anyone seen a add-on to search for users that have the same joined date and last activity date?

I have several hundred accounts that are registered and look to be bot created that I need a quick way to search for them.

 

[Jake Bunce]

Run this query on your database using a program like phpmyadmin:

SELECT *
FROM xf_user
WHERE register_date = last_activity;