Untitled query #20365

SQL

/*
USE trwiki_p;
#SELECT p.page_title
#SELECT CONCAT('[[Dosya:',p.page_title,'|100px]]') as Dosya
SELECT CONCAT('Dosya:',p.page_title) as Dosya
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to
WHERE c.cl_to IN ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri")
AND i.il_from IS NULL
AND p.page_namespace = 6

Paņemt distinct files

SELECT CONCAT('#[[:Dosya:',p.page_title,']]') as Dosya
Completely unused files:
*/
USE trwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to
WHERE c.cl_to = "Tüm_adil_kullanım_dosyaları"
AND i.il_from IS NULL
AND p.page_namespace = 6
/*
maybe used in other namespaces:

USE trwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to AND i.il_from_namespace = 0
WHERE c.cl_to = "Tüm_adil_kullanım_dosyaları"
AND i.il_from IS NULL
AND p.page_namespace = 6

Tagged as non-free:

USE trwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c1 ON p.page_id = c1.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to AND i.il_from_namespace = 0
LEFT JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "All_orphaned_non-free_use_Wikipedia_files"
WHERE c1.cl_to = "All_non-free_media"
AND i.il_from IS NULL
AND c2.cl_from IS NULL
AND p.page_namespace = 6
*/
SQL

Checking query status...
