Some non-free files used in articles about people

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

Finds some non-free files which are used in at least one article about a living person. Non-free photos of living people usually violate [[WP:NFCC#1]]. Mostly finds paintings by living painters, so the query isn't very useful. Similar to http://quarry.wmflabs.org/query/2639 but returns file names instead of article titles and selects non-free files differently.

SQL

SELECT DISTINCT i.page_title FROM page a
INNER JOIN categorylinks ca ON ca.cl_from = a.page_id AND ca.cl_to = 'Living_people'
INNER JOIN imagelinks il ON il.il_from = a.page_id AND il.il_from_namespace = 0
INNER JOIN page i ON i.page_title = il.il_to AND i.page_namespace = 6
INNER JOIN categorylinks ci ON ci.cl_from = i.page_id AND ci.cl_to = 'Non-free_files_uploaded_as_object_of_commentary'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...