Last modified: 2014-01-03 16:10:50 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-186. Summary: List of good and excellent articles with the number of edits of the german Wikipedia Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Clemens <rothcl@uni-hildesheim.de> Date: Mon, 04 Jun 2012 11:29:20 ------------------------------------------------------------------------------- Hi Guys, Basically I need two lists that contain all the articles of the german wikipedia that were assigend either excellent or good quality (one list with excellent and the other with good articles.) The following information should be included: * Name of the article * date of the first edit * total # of edits of the given article Thank you in advance for your help! Best, Clemens
------------------------------------------------------------------------------- From: Clemens <rothcl@uni-hildesheim.de> Date: Mon, 04 Jun 2012 11:31:32 ------------------------------------------------------------------------------- Forgot that: The format could be either a csv or sql file - depending on whats easier for you.
------------------------------------------------------------------------------- From: Betacommand <phoenixoverride@gmail.com> Date: Mon, 04 Jun 2012 12:18:59 ------------------------------------------------------------------------------- How is excellent or good quality determined and flagged?
------------------------------------------------------------------------------- From: Clemens <rothcl@uni-hildesheim.de> Date: Mon, 04 Jun 2012 12:31:30 ------------------------------------------------------------------------------- What what I actually meant were the featured and good articles (german equivalent is "exzellent" and "lesenswert"). I just found out that they are categorized under "Wikipedia:Exzellent" and "Wikipedia:Lesenswert". That means I need two lists, one with articles of the category "Wikipedia:Exzellent" and one with the articles of the category "Wikipedia:Lesenswert".
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Wed, 06 Jun 2012 14:28:54 ------------------------------------------------------------------------------- Ok, so here we go: SQL: SELECT /* SLOW_OK */ page_title, MIN(rev_timestamp), COUNT(*) FROM categorylinks INNER JOIN page ON page_id = cl_from INNER JOIN revision ON rev_page = page_id WHERE cl_to = 'Wikipedia:Exzellent' AND page_namespace = 0 GROUP BY page_title; (replace Wikipedia:Exzellent with Wikipedia:Lesenswert for the other list) Results: http://toolserver.org/~hoo/dbq/dbq-186_0.txt (Exzellent, MySQL dump) http://toolserver.org/~hoo/dbq/dbq-186_1.txt (Lesenswert, MySQL dump)
------------------------------------------------------------------------------- From: Clemens <rothcl@uni-hildesheim.de> Date: Thu, 07 Jun 2012 09:34:28 ------------------------------------------------------------------------------- That looks great, thank you!
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: hoo@online.de, phoenixoverride@gmail.com
