SQL
AخA
USE cswiki_p;
SELECT z.page_title, pl_title FROM pagelinks
LEFT JOIN page AS na ON na.page_title = pl_title AND na.page_namespace = pl_namespace
LEFT JOIN page AS z ON z.page_id = pl_from
WHERE na.page_title IS NULL
AND pl_namespace <> 6
AND pl_from_namespace = 0
AND (
pl_title LIKE "%.jpg" OR
pl_title LIKE "%.JPG" OR
pl_title LIKE "%.jpeg" OR
pl_title LIKE "%.JPEG" OR
pl_title LIKE "%.svg" OR
pl_title LIKE "%.SVG"
)
ORDER BY z.page_title, pl_title;
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.