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: valhall...@arctus.nl
          Reporter: valhall...@arctus.nl
    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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to