Fork of
Files in Flickr images needing human review
by B
This query is marked as a draft
This query has been published
by B.
SQL
x
USE enwiki_p;
SELECT CONCAT('*[[:en:File:', Replace(p.page_title, '_', ' '), ']] ([[:en:', Replace(pg.page_title, '_', ' '), ']] - [[:en:Category:', c1.cl_to, ']])')
FROM page p
INNER JOIN imagelinks i ON p.page_title = i.il_to
INNER JOIN page pg ON pg.page_id = i.il_from
INNER JOIN categorylinks c1 ON i.il_from = c1.cl_from AND
((c1.cl_to LIKE '1923%' AND c1.cl_to <> '1923_births' AND c1.cl_to <> '1923_deaths')
OR (c1.cl_to LIKE '%1923'))
INNER JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "All_non-free_media"
WHERE c1.cl_to not like '%British%'
AND c1.cl_to not like '%Turkey%'
AND c1.cl_to not like '1923_establishments%'
AND c1.cl_to not like '%established_in_1923'
AND c1.cl_to not like '%_set_in_1923'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.