DBQ-128 List of articles by number of edits (first 1000) in he.wiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:59 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-128.
Summary: List of articles by number of edits (first 1000) in he.wiki
Issue type: Task - A task that needs to be done.
Priority: Minor
Status: Done
Assignee: Hoo man <hoo@online.de>

From: Netanel_H <netanel@gmx.com>

Date: Tue, 08 Mar 2011 16:40:39

May I ask for list of the 1000 most edited articles in he.wiki?
The SQL query code is:

select page_title, count(rev_page) from revision, page where
page_namespace=0 and page_id=rev_page group by rev_page
order by count(rev_page) DESC limit 0, 1000;

(code credit - Costello, http://he.wikipedia.org/wiki/%D7%9E%D7%A9%D7%AA%D7%9E%D7%A9:Costello/%D7%94%D7%93%D7%A4%D7%99%D7%9D_%D7%91%D7%A2%D7%9C%D7%99_%D7%9E%D7%A1%D7%A4%D7%A8_%D7%94%D7%A2%D7%A8%D7%99%D7%9B%D7%95%D7%AA_%D7%94%D7%92%D7%91%D7%95%D7%94_%D7%91%D7%99%D7%95%D7%AA%D7%A8)

Version: unspecified
Severity: minor

Details

Reference: bz59383

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:27 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59383.

JiraBugConverter created this task.Jan 3 2014, 3:59 PM

From: Hoo man <hoo@online.de>

Date: Thu, 10 Mar 2011 13:15:57

SQL:
see above
Result:
http://toolserver.org/~hoo/dbq/dbq-128.txt

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

DBQ-128 List of articles by number of edits (first 1000) in he.wikiClosed, ResolvedPublicActions