Web browser: ---
            Bug ID: 59289
           Summary: DBQ-33 Salli contributions on
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Database Queries
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
Summary: Salli contributions on
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: (none)

From: Incola <>
Date: Wed, 30 Jul 2008 09:26:20

On we need a list of the contributions of a user that did a lot of
copyviol, for manually check them.  
I hope that isn't a problem. There is the query;

    SELECT CONCAT( "#[[", title, "]]
([";, title, "&action=history Cron] -
", number, ")" )
    FROM (
    SELECT page_title AS title, count( * ) AS number
    FROM page
    JOIN revision ON page_id = rev_page
    WHERE page_namespace = '0'
    AND rev_user_text LIKE "Salli"
    GROUP BY page_title
    ) AS pages
    ORDER BY number DESC ;

You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list

Reply via email to