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

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

XenForo moderator
Staff member
Run this query on your database using a program like phpmyadmin:

FROM xf_user
WHERE register_date = last_activity;