Clean Up Users - Delete Users with no ads
I would really love to know this. Is there a way to go into WP
multisite admin, display users, and have it show ad count beside users? I have been looking into this for so long. Basically, I would like to delete any user with no ad posting what so ever. If I go into each site individually. I can see the user and post amount. However, the users main profile still is in the main site as I am using multisite user management. I would need to do this with admin panel of multisite under users. PLEASE HELP...
OR USE THE DATABASE OPTION BELOW
- - - Updated - - -
What would the code be to execute this in Phpmyadmin to remove users with no ads ( not post ) I have this code, but it only gets rid of users with no post
DELETE FROM wp_users WHERE ID NOT IN (SELECT DISTINCT post_author FROM wp_posts)
Can one of you Classipress people provide a code for which I can clean up my site please from users with no ad listings. Anyone that has 0 ads. I am not sure what the tables would be for the removal of users with ads and their meta data,