Last modified: 2014-01-03 15:37:28 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-39. Summary: the list of creator Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: zeyi He <wikipediathinker@googlemail.com> Date: Sat, 06 Sep 2008 16:20:09 ------------------------------------------------------------------------------- I want the list of creator, in which, we have all fegistered users who have created a new article. The columns in this table are username, the number of created article, the number of edit. Is that possible? thanks a lot!!!
------------------------------------------------------------------------------- From: Autocracy <jeff@storyinmemo.com> Date: Thu, 11 Sep 2008 14:15:05 ------------------------------------------------------------------------------- Yes it is _possible_, but it's also a REALLY long query. In fact, it is so disgustingly long that I previously suggested it be handled by means of a separate table where that information is inserted by a trigger. The short answer is: I don't think you can get this information.
------------------------------------------------------------------------------- From: zeyi He <wikipediathinker@googlemail.com> Date: Thu, 18 Sep 2008 21:48:33 ------------------------------------------------------------------------------- hi, i found the qury here, https://jira.toolserver.org/browse/DBQ-3. so may i ask is it possible to run some like this with the number of edit as well? thanks.
------------------------------------------------------------------------------- From: Bryan Tong Minh <bryan@tools.wikimedia.de> Date: Fri, 26 Sep 2008 09:31:27 ------------------------------------------------------------------------------- Should be something like: SELECT lr_user, COUNT(lr_title) AS lr_creation_count, lr_editcount AS user_editcount FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user FROM page, revision WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page = page_id GROUP BY rev_page) AS lowest_revision, user WHERE lr_user = user_name GROUP BY lr_user HAVING lr_creation_count > 5 ORDER BY lr_creation_count DESC; For which wiki would you like it?
------------------------------------------------------------------------------- From: zeyi He <wikipediathinker@googlemail.com> Date: Sun, 28 Sep 2008 15:59:47 ------------------------------------------------------------------------------- English Wiki? thanks very much! Is that possible you give me a date and time when you finish this query? I need them for reference, thanks.
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Fri, 20 Mar 2009 18:19:19 ------------------------------------------------------------------------------- Running query now in screen. > SELECT lr_user, COUNT(lr_title) AS lr_creation_count, user_editcount AS lr_editcount FROM (SELECT page_title AS lr_title, MIN(rev_id) AS lr_rev_id, rev_user_text AS lr_user FROM page, revision WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_page = page_id GROUP BY rev_page) AS lowest_revision JOIN user ON lr_user = user_name GROUP BY lr_user HAVING lr_creation_count > 0 ORDER BY lr_creation_count DESC;
------------------------------------------------------------------------------- From: MZMcBride <mzmcbride@gmail.com> Date: Sat, 21 Mar 2009 05:34:45 ------------------------------------------------------------------------------- Query finished. Available at http://toolserver.org/~mzmcbride/dbq/dbq-39.txt.gz Data as of Saturday, March 21, 2009 4:48 (UTC). Please open a new issue for further queries.
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: (none) CC list: b@mzmcbride.com, Bryan.TongMinh@Gmail.com, bugzilla@storyinmemo.com