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