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

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

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