https://bugzilla.wikimedia.org/show_bug.cgi?id=60921
Web browser: ---
Bug ID: 60921
Summary: Major patrollers list
Product: Tool Labs tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tsreports
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
Existing query (Erwin85):
SELECT count(1) as count, user_name
FROM nlwiki_p.logging
LEFT JOIN nlwiki_p.user
ON log_user = user_id
WHERE log_type = 'patrol'
AND NOT EXISTS (SELECT 1 FROM nlwiki_p.user_groups
WHERE ug_user = user_id
AND ug_group = 'bot')
GROUP BY log_user
ORDER BY count DESC LIMIT 50;"
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
