Photos by Wikimedia Commons recognised photographers

Fork of 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 image j
ON i.img_user = j.img_user
AND i.img_width*i.img_height > 5000000
AND i.img_media_type = 'BITMAP'
JOIN page
ON page_title = j.img_name
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'
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 100000;

SQL

Checking query status...