[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

--- Comment #5 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Clemens rot...@uni-hildesheim.de
Date: Thu, 07 Jun 2012 09:34:28
---

That looks great, thank you!

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Betacommand phoenixoverr...@gmail.com
Date: Mon, 04 Jun 2012 12:18:59
---

How is excellent or good quality determined and flagged?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Clemens rot...@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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Hoo man h...@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)

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #6 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---

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: h...@online.de
CC list: h...@online.de, phoenixoverr...@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59467] DBQ-186 List of good and excellent articles with the number of edits of the german Wikipedia

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59467

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
wmf.bugconver...@gmail.com ---
---
From: Clemens rot...@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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l