Web browser: ---
            Bug ID: 59022
           Summary: REPORTS-59 Create a query: list of Wiki loves
                    Monuments uploaders
           Product: Tool Labs tools
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: Unprioritized
         Component: tsreports
    Classification: Unclassified
   Mobile Platform: ---

This issue was converted from
Summary: Create a query: list of Wiki loves Monuments uploaders
Issue type: New Feature - A new feature of the product, which has yet to be
Priority: Minor
Status: Closed
Assignee: Merlijn van Deen <>

From: Merlijn van Deen <>
Date: Fri, 03 Sep 2010 20:50:32

to tsreports. Example output is at Query
is as follows:

/* Make a list of WLM uploaders */  
connect commonswiki_p commonswiki-p.db;  
SELECT CONCAT('*[[User:', img_user_text,'|', img_user_text, ']] - ',
COUNT(img_user_text)) FROM image  
JOIN page ON img_name=page_title  
JOIN categorylinks ON page_id=cl_from  
page_namespace=6 AND   
page_is_redirect=0 AND  
GROUP BY img_user_text  
ORDER BY COUNT(img_user_text) DESC;

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

Reply via email to