Non-free files used outside articles (lvwiki)

SQL

USE lvwiki_p;


select now();

SELECT concat("[[:Attēls:",REPLACE(p.page_title, '_', ' '),"]]"), p2.page_namespace, p2.page_title
#CONCAT('* [[:Attēls:',page_title,']]')
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
INNER JOIN (imagelinks i LEFT JOIN redirect r ON i.il_from = r.rd_from) ON p.page_title = i.il_to
INNER JOIN page p2 ON p2.page_id = i.il_from
WHERE c.cl_to IN ("Aizsargāti_attēli", "Aizsargāti_logo", "Aizsargātas_pastmarkas",
"Aizsargāti_filmu_plakāti", "Aizsargāti_grāmatu_vāki",
"Aizsargāti_skaņas_faili", "Albuma_vāka_attēli", "Pastmarkas")
AND i.il_from_namespace != 0 and (p2.page_title not like "Kopienas%" and p2.page_title not like "Vai_tu%") and i.il_from_namespace!=2
AND r.rd_from IS NULL
SQL

Checking query status...
