I ended up just dropping all pages in the database where page_title did not have a corrisponding username in user
Select *
From page
Where (Select user_name from user) Not In page_title
AND (page_namspace = 2 or page_namespace = 3)
Hello,
I need some assistance with deleting User and User Talk pages for all the users who are not registered.
Eg. I deleted about 50 users out of the database of our site and now would like to remove all of their User and User Talk Pages is there an easy way to do this?
Thanks.
You can use a bot like pywikibot, or use the nukePage.php maintenance script. You can easily generate a list of pages to delete using a spreadsheet and some formulas.
I ended up just dropping all pages in the database where page_title did not have a corrisponding username in user
