Fork of
Untitled query #29748
by ShakespeareFan00
This query is marked as a draft
This query has been published
by ShakespeareFan00.
SQL
x
USE enwiki_p;
SELECT p.page_latest, p.page_id, p.page_len, CONCAT("File:",p.page_title) as page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'Files_with_no_machine-readable_source'
LEFT JOIN categorylinks c2 ON cnot.cl_from = p.page_id AND cnot.cl_to
IN ('All_non-free_media',
'Redirects_from_moves',
)
LEFT JOIN templatelinks t ON t.tl_from = p.page_id
AND t.tl_namespace = 10
AND t.tl_title IN (
# Also exclude various deletion processes:
'Information'
)
WHERE t.tl_from IS NULL
AND cnot.cl_from IS NULL
AND p.page_namespace = 6
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.