Edgars2007's testing area - links to orphan articles

SQL

USE lvwiki_p;
SELECT DISTINCT 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
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 p.page_title not like "Kopienas%" and p.page_title not like "Vai_tu%" and i.il_from_namespace!=2
AND r.rd_from IS NULL

SQL

Checking query status...