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
LEFT JOIN commonswiki_p.imagelinks ON commonswiki_p.imagelinks.il_from = page_id
	WHERE tl_namespace = 10
#   WHERE  
	AND tl_title RLIKE"film" 
	AND cl_to = "Türkçe_Vikipedi_üzerindeki_resmi_Vikiveriden_farklı_olan_maddeler"
    AND cl_to = RLIKE"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...
