Iswiki media with only one template

SQL

use iswiki_p;
select page_title from page
where page_namespace = 6
and page_id not in (
	select tl_from from templatelinks where tl_title in ('Bókakápa', 'Bygging-listaverk', 'CC-by-2.5', 'CC-by-nc', 'Dvd hulstur', 'GFDL', 'Hljóðdæmi', 'Hljómplata', 'Leikjahulstur', 'Leikskrá', 'Leyfi-rétthafa', 'Listaverk', 'Mynd úr fréttatilkynningu', 'Óhöfundaréttvarið', 'PD-Egin', 'PD-ineligible', 'PD-Italia', 'Sanngjörn notkun', 'Skjáskot', 'Veggspjald', 'Vhs hulstur', 'Vörumerki')
)
and page_id not in (
  select cl_from from categorylinks where cl_to = "Wikipedia:Ófullnægjandi_upplýsingar_um_skrá"
)  
limit 200
SQL

Checking query status...
