Self–linking pages through redirect

SQL

SELECT DISTINCT concat ('# [[',fawiki_p.page_title,']]')#, il_to
FROM fawiki_p.page JOIN fawiki_p.imagelinks ON fawiki_p.page_id = fawiki_p.il_from
LEFT JOIN fawiki_p.page_props ON fawiki_p.pp_page = fawiki_p.page_id
WHERE fawiki_p.page_namespace = 0
AND fawiki_p.pp_propname = 'disambiguation'
AND fawiki_p.il_to <> "Disambig_gray_RTL.svg" # {{ابهام‌زدایی}}
AND fawiki_p.il_to <> "Earthmap1000x500compac.jpg" # {{Location map-line|lon=؟؟؟}}
AND fawiki_p.il_to <> "Commons-logo.svg" # {{انبار-رده|؟؟؟}}
AND fawiki_p.il_to <> "WPanthroponymy.svg" # {{نام خانوادگی}} or {{نام کوچک}}
AND fawiki_p.il_to <> "Question_book-new.svg" # {{منبع}}
AND fawiki_p.il_to <> "Wiktionary-logo-en.svg" # {{ویکی‌واژه|؟؟؟}}
AND fawiki_p.il_to <> "Wikiquote-logo.svg" # {{ویکی‌گفتاورد|؟؟؟}}

AND fawiki_p.il_to <> "Edit-clear.svg" # {{تمیزکاری|؟؟؟}}
AND fawiki_p.il_to <> "Flag_of_" # {{پرچم|؟؟؟}}
AND fawiki_p.il_to <> "Question_book.svg" # {{بهبود منبع}}
AND fawiki_p.il_to <> "Wikiquote-logo.svg" # {{ویکی‌گفتاورد|؟؟؟}}
AND fawiki_p.il_to <> "Wikiquote-logo.svg" # {{ویکی‌گفتاورد|؟؟؟}}

AND (
  EXISTS(
    SELECT null
    FROM fawiki_p.image
    WHERE fawiki_p.img_name = il_to
  )OR EXISTS(
    SELECT null
    FROM commonswiki_p.page
    WHERE commonswiki_p.page_title = fawiki_p.il_to
    AND commonswiki_p.page_namespace = 6
    )
)
ORDER BY commonswiki_p.page_title;
SQL

Checking query status...
