Media needing categories: uploaders with most images

SQL

use commonswiki_p;
SELECT concat("[[Special:ListFiles/",img_user_text, "]]") AS username, COUNT(image.img_name) AS files_count, image.img_name, user_editcount as edits
    FROM image
    WHERE image.img_name IN (SELECT page_title FROM page
      JOIN categorylinks ON cl_from = page_id
      WHERE cl_to = "All_media_needing_categories_as_of_2012"       
                             OR cl_to = "All_media_needing_categories_as_of_2013" 
                             OR cl_to = "All_media_needing_categories_as_of_2014" 
                             OR cl_to = "All_media_needing_categories_as_of_2015" 
                             OR cl_to = "All_media_needing_categories_as_of_2016" 
      AND page_namespace = 6)
GROUP BY img_user_text 
      JOIN user ON img_user_text = user_name
ORDER BY files_count DESC
LIMIT 1000;
SQL

Checking query status...
