Dear specialists, concerning a spam problem I would like to find "Good editors" :-)
How can I find by SQL request in the DB: Give me a list of all editors, who did build a new article or did one ore more edits in an existing article in a specific NameSpace (NS-#), output: user_ID, user_name, user_mail-adress (if there is one) Give me a list of all editors, who have got an edit of user-name=xy (a specific known user) in their user_page (NS-2) and/or their user_discussion_page (NS-3) output: user_ID, user_name, user_mail-adress (if there is one) or andersherunm: Give me a list of all pages in a specific NameSpce (NS-#), which are made or deited by a specific user_name output: user_ID, user_name, user_mail-adress (if there is one) Ho can I count the number of pages in a specific NameSpace? What is the correct SQL-request for this questions? Which tables we have to touch? I'm not a programmer, and I hope that I did express my question in an understandable form... Thanks for help, Markus PS: if you speak German, it would be more easy to correspond. _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
