https://bugzilla.wikimedia.org/show_bug.cgi?id=59383
Web browser: ---
Bug ID: 59383
Summary: DBQ-128 List of articles by number of edits (first
1000) in he.wiki
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: Unprioritized
Component: Database Queries
Assignee: wmf.bugconver...@gmail.com
Reporter: wmf.bugconver...@gmail.com
Classification: Unclassified
Mobile Platform: ---
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 <h...@online.de>
-------------------------------------------------------------------------------
From: Netanel_H <neta...@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)
--
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
