Photos by Wikimedia Commons recognised photographers

Fork of Photos by Wikimedia Commons recognised photographers by Nemo bis

This query is marked as a draft This query has been published by Nemo bis.

SQL

USE commonswiki_p;
SELECT distinct(i.img_name)
FROM image i
JOIN categorylinks d
ON page_id = d.cl_from
AND d.cl_to LIKE "CC-BY%"
JOIN templatelinks
ON page_id = tl_from
AND tl_title = 'Own'
WHERE i.img_width*i.img_height > 10000000
AND i.img_media_type = 'BITMAP'
AND img_user IN ( SELECT distinct(img_user)
FROM image
JOIN page
ON page_title = img_name
JOIN categorylinks c
ON page_id = c.cl_from
AND ( c.cl_to = 'Valued_images_sorted_by_promotion_date'
    OR c.cl_to = 'Quality_images'
    OR c.cl_to = 'Featured_pictures_on_Wikimedia_Commons' )
)
LIMIT 2500;

SQL

Checking query status...