Page MenuHomePhabricator

DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia
Closed, ResolvedPublic

Description

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


Version: unspecified
Severity: major

Details

Reference
bz59467

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:33 AM
bzimport set Reference to bz59467.

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