SQL
AخA
SELECT page_namespace, page_title, page_latest, lt_title, lt_namespace
FROM templatelinks
JOIN linktarget ON tl_target_id = lt_id
JOIN page ON page_id = tl_from
WHERE tl_from_namespace IN (0, 6, 14)
AND NOT EXISTS (SELECT 1 FROM page WHERE page_title = lt_title AND page_namespace = lt_namespace)
AND lt_title NOT LIKE '%.jpg'
AND lt_title NOT LIKE '%.JPG'
AND lt_title NOT LIKE '%.jpeg'
AND lt_title NOT LIKE '%.ogv'
AND lt_title NOT LIKE '%.png'
AND lt_title NOT LIKE '%.svg'
AND lt_title NOT LIKE '%.SVG'
ORDER BY page_latest DESC;
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.