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

Reply via email to