[Bug 59362] DBQ-111 Talkpages edited with only 1 author (excluding bots from count)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59362 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Krinkle 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. -- 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
[Bug 59362] DBQ-111 Talkpages edited with only 1 author (excluding bots from count)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59362 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Liangent Date: Tue, 21 Dec 2010 07:08:11 --- Does this include talk pages which are redirects? There're lots of redirects in results. -- 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
[Bug 59362] DBQ-111 Talkpages edited with only 1 author (excluding bots from count)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59362 Bugzilla Bug Importer (valhallasw) changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #5 from Bugzilla Bug Importer (valhallasw) --- 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: liang...@gmail.com CC list: liang...@gmail.com, krinklem...@gmail.com -- 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
[Bug 59362] DBQ-111 Talkpages edited with only 1 author (excluding bots from count)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59362 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Liangent 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
[Bug 59362] DBQ-111 Talkpages edited with only 1 author (excluding bots from count)
https://bugzilla.wikimedia.org/show_bug.cgi?id=59362 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Liangent 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