Files on commons with diff name in use (te.wiki)

Fork of Non-free files used outside articles (vi.wiki) by MGA73

This query is marked as a draft This query has been published by MGA73.

SQL

#USE viwiki_p;
SELECT DISTINCT CONCAT('# [[:File:', p.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 = "All_Wikipedia_files_with_the_same_name_on_Wikimedia_Commons" #"All_Wikipedia_files_with_a_different_name_on_Wikimedia_Commons"
AND i.il_from_namespace #!= 0 #Articles
#AND i.il_from_namespace != 100 #Portals ?
AND r.rd_from IS NULL
ORDER BY p.page_title ASC;

SQL

Checking query status...