[MediaWiki-l] SQL query

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[MediaWiki-l] SQL query

Markus
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