https://bugzilla.wikimedia.org/show_bug.cgi?id=59362

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Liangent <liang...@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;

-- 
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

Reply via email to