Untitled query #51076

SQL

USE trwiki_p;
SELECT DISTINCT CONCAT('* [[',page_title,']]') AS  "Maddeler", il_to, tl_title
FROM page
RIGHT JOIN templatelinks ON tl_from = page_id
JOIN categorylinks ON cl_from = page_id
JOIN imagelinks ON il_from = page_id
	WHERE cl_to = "Türkçe_Vikipedi_üzerindeki_resmi_Vikiveriden_farklı_olan_maddeler"
#   WHERE tl_namespace = 10 
#	AND tl_title RLIKE"film" 
#	AND cl_to = "Türkçe_Vikipedi_üzerindeki_resmi_Vikiveriden_farklı_olan_maddeler"
    AND cl_to = LIKE 'film'
    AND (NOT EXISTS(
 		SELECT * FROM commonswiki_p.imagelinks
 		WHERE commonswiki_p.imagelinks.il_from = page_id))
	AND page_namespace = 0
ORDER BY page_title
limit 50;
SQL

Checking query status...
