[Bug 59360] DBQ-109 List of Portuguese Wikibooks users with 100+ edits, with number of edits and pages created (main namespace) and date of first edit
https://bugzilla.wikimedia.org/show_bug.cgi?id=59360 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: h...@online.de CC list: h...@online.de -- 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 59360] DBQ-109 List of Portuguese Wikibooks users with 100+ edits, with number of edits and pages created (main namespace) and date of first edit
https://bugzilla.wikimedia.org/show_bug.cgi?id=59360 --- Comment #4 from Bugzilla Bug Importer (valhallasw) --- --- From: Helder.wiki Date: Wed, 29 Dec 2010 23:25:18 --- Thanks you again! I wish you a happy new year =) -- 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 59360] DBQ-109 List of Portuguese Wikibooks users with 100+ edits, with number of edits and pages created (main namespace) and date of first edit
https://bugzilla.wikimedia.org/show_bug.cgi?id=59360 --- Comment #1 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Mon, 27 Dec 2010 15:04:55 --- SQL: SELECT user_data.user, user_data.edits, user_data.first_edit, creations.count as creation_count FROM (SELECT COUNT(*) as count, user FROM (SELECT rev_user_text as user FROM page INNER JOIN revision ON page.page_id = revision.rev_page WHERE page.page_namespace = 0 AND page.page_is_redirect = 0 GROUP BY revision.rev_page) as tmp GROUP BY tmp.user) as creations INNER JOIN (SELECT revision.rev_user_text as user, COUNT(revision.rev_id) as edits, min(rev_timestamp) as first_edit FROM revision INNER JOIN page ON revision.rev_page = page.page_id WHERE page.page_namespace = 0 AND revision.rev_deleted = 0 GROUP BY revision.rev_user_text) as user_data ON user_data.user = creations.user WHERE edits > 100 GROUP by user_data.user; Result: http://toolserver.org/~hoo/dbq/dbq-109.txt (as list) http://toolserver.org/~hoo/dbq/dbq-109_wiki.txt (as wiki table) -- 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 59360] DBQ-109 List of Portuguese Wikibooks users with 100+ edits, with number of edits and pages created (main namespace) and date of first edit
https://bugzilla.wikimedia.org/show_bug.cgi?id=59360 --- Comment #2 from Bugzilla Bug Importer (valhallasw) --- --- From: Helder.wiki Date: Mon, 27 Dec 2010 19:43:36 --- Thank you very much! Just for curiosity: how long a query like this takes to be accomplished? Would it be feasible to extend the list to "edits > 50" instead of "edits > 100"? If so, could you please generate such a list sorted by number of edits? (when you have the time) -- 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 59360] DBQ-109 List of Portuguese Wikibooks users with 100+ edits, with number of edits and pages created (main namespace) and date of first edit
https://bugzilla.wikimedia.org/show_bug.cgi?id=59360 --- Comment #3 from Bugzilla Bug Importer (valhallasw) --- --- From: Hoo man Date: Tue, 28 Dec 2010 00:13:50 --- On such a "small" database like the ptwikibooks one it runs in a few seconds (about 4 seconds on ptwikibooks). So here are the extended results: http://toolserver.org/~hoo/dbq/dbq-109_2.txt (plain text) http://toolserver.org/~hoo/dbq/dbq-109_2_wiki.txt (wiki markup) -- 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
