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.