Last modified: 2014-01-03 15:59:52 UTC
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)
------------------------------------------------------------------------------- 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