Wikimedia Commons recognised photographers

SQL

USE commonswiki_p;
SELECT log_user_text, COUNT(log_id)#rev_user_text, COUNT(rev_id), user_editcount
FROM logging_userindex
#FROM revision_userindex
#JOIN user
#ON rev_user = user_id
#WHERE rev_parent_id = 0
WHERE log_type = 'upload'
AND log_user IN (
  SELECT DISTINCT(rev_user)
  FROM revision_userindex
  JOIN categorylinks
  ON rev_page = cl_from
  AND rev_parent_id = 0
  AND ( cl_to = 'Valued_images_sorted_by_promotion_date'
    OR cl_to = 'Quality_images'
    OR cl_to = 'Featured_pictures_on_Wikimedia_Commons' )
)
GROUP BY log_user;

SQL

Checking query status...