Commons talk:List of users by the number of Quality images uploaded
Jump to navigation
Jump to search
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;