Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Snævar
.
Toggle Highlighting
SQL
use iswiki_p; SELECT page_title FROM page, image WHERE page.page_namespace = 6 AND page.page_title = image.img_name AND page_id NOT IN ( SELECT tl_from FROM templatelinks WHERE tl_title IN ('Sanngjörn notkun', 'Hljómplata', 'Vörumerki', 'Bókakápa', 'Bygging-listaverk', 'Dvd hulstur') OUTER JOIN tl_from FROM templatelinks WHERE tl_title IN ('Hljóðdæmi', 'Leikjahulstur', 'Leikskrá', 'Leyfi-rétthafa', 'Listaverk', 'Mynd úr fréttatilkynningu') OUTER JOIN tl_from FROM templatelinks WHERE tl_title IN ('Skjáskot', 'Veggspjald', 'Vhs hulstur', 'CC-by-2.5', 'CC-by-nc', 'GFDL') OUTER JOIN tl_from FROM templatelinks WHERE tl_title IN ('Óhöfundaréttvarið', 'PD-Egin', 'PD-Italia') ) ORDER BY page_title LIMIT 100;
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
.
Checking query status...