Untitled query #76734

SQL

#USE arwiki_p;
#SELECT DISTINCT CONCAT('# [[:File:', p.page_title, ']]'), i.il_from, d.page_title #GROUP_CONCAT(i.il_from_namespace ORDER BY i.il_from_namespace SEPARATOR ', ')
#SELECT  CONCAT('# [[:File:', p.page_title, ']]'), GROUP_CONCAT(i.il_from_namespace SEPARATOR ', ')
SELECT  CONCAT('[[:File:', p.page_title, ']]'), GROUP_CONCAT('[[',d.page_title,']]' SEPARATOR ' and ')
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 d ON i.il_from = d.page_id 
WHERE c.cl_to = "Semua_media_bukan_bebas" #"Fail_Wikipedia_bukan_bebas_kekurangan_pautan_masuk_rencana"
#AND page_is_redirect=0
##AND NOT EXISTS(
##SELECT * FROM categorylinks 
##WHERE page_id=cl_from 
##  AND (cl_to 'Semua_media_bebas'
##  OR cl_to 'Fail_Wikipedia_bukan_bebas_dengan_pautan_masuk_sah')) # Should not be in this - it is the category for files allready with a link
#AND i.il_from_namespace = 2 #Userpages
AND i.il_from_namespace != 0 #Articles
#AND i.il_from_namespace != 100 #Portals ?
AND r.rd_from IS NULL
GROUP BY p.page_title
ORDER BY p.page_title ASC;
SQL

Checking query status...
