Last modified: 2014-01-03 15:56:32 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-111. Summary: Talkpages edited with only 1 author (excluding bots from count) Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Liangent <liangent@gmail.com> ------------------------------------------------------------------------------- From: Krinkle <krinklemail@gmail.com> Date: Fri, 17 Dec 2010 17:59:48 ------------------------------------------------------------------------------- for some statistics: A list of all talkpages created or created with edits afterwards by a single author. Accounts with a botflag should not be included, so talkpages created and/or edited solely by bots should not be in the list. But talkpages created and/or edited by 1 person and (one or more) bots-accounts should indeed be included in the list. Any talkpage edited by multiple non-bots ofcourse not. For the current project, this is only for nl.wikipedia.org (nlwiki_p) Please include the query as well so it can easlily be re-ran in the future for this or another wiki.
------------------------------------------------------------------------------- From: Liangent <liangent@gmail.com> Date: Tue, 21 Dec 2010 07:08:11 ------------------------------------------------------------------------------- Does this include talk pages which are redirects? There're lots of redirects in results.
------------------------------------------------------------------------------- From: Liangent <liangent@gmail.com> Date: Tue, 21 Dec 2010 07:18:20 ------------------------------------------------------------------------------- See http://toolserver.org/~liangent/-/dbq/111/with_redirects.txt for results with redirects. SQL is: select page_title from page where page_namespace=1 and (select count(distinct rev_user_text) from revision where rev_page=page_id and not exists (select * from user_groups where ug_user=rev_user and ug_group='bot'))=1; Note that the first line is the column name and no namespace prefix is used in the file.
------------------------------------------------------------------------------- From: Liangent <liangent@gmail.com> Date: Tue, 21 Dec 2010 07:20:13 ------------------------------------------------------------------------------- Also http://toolserver.org/~liangent/-/dbq/111/without_redirects.txt SQL: select page_title from page where page_is_redirect=0 and page_namespace=1 and (select count(distinct rev_user_text) from revision where rev_page=page_id and not exists (select * from user_groups where ug_user=rev_user and ug_group='bot'))=1;
------------------------------------------------------------------------------- From: Krinkle <krinklemail@gmail.com> Date: Mon, 27 Dec 2010 04:15:16 ------------------------------------------------------------------------------- Thanks a lot for both queries. This has been a great help in identifying what so far was a mystery. I'll rerun this query on my account periodically on request for the wikis this tool is for.
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: liangent@gmail.com CC list: liangent@gmail.com, krinklemail@gmail.com