Commons talk:List of users by the number of Quality images uploaded

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

Quarry

use commonswiki_p;
 SELECT img_user_text AS uploader, COUNT(page_title) AS pictures
  FROM image, page, categorylinks 
  WHERE page.page_id=categorylinks.cl_from 
      AND image.img_name = page.page_title
      AND .categorylinks.cl_to = "Quality_images"
          GROUP BY uploader
  ORDER BY pictures DESC;