SELECT DISTINCT concat ('# [[',page_title,']]')#, il_to

FROM page JOIN imagelinks ON page_id = il_from

LEFT JOIN page_props ON pp_page = page_id

WHERE page_namespace = 0

AND pp_propname = 'disambiguation'

AND il_to <> "Disambig_gray_RTL.svg" # {{ابهام•زدایی}}

AND il_to <> "Earthmap1000x500compac.jpg" # {{Location map-line|lon=؟؟؟}}

AND il_to <> "Commons-logo.svg" # {{انبار-رده|؟؟؟}}

AND il_to <> "WPanthroponymy.svg" # {{نام خانوادگی}} or {{نام کوچک}}

AND il_to <> "Question_book-new.svg" # {{منبع}}

AND il_to <> "Wiktionary-logo-en.svg" # {{ویکی•واژه|؟؟؟}}

AND il_to <> "Wikiquote-logo.svg" # {{ویکی•گفتاورد|؟؟؟}}

​

AND il_to <> "Edit-clear.svg" # {{تمیزکاری|؟؟؟}}

AND il_to <> "Flag_of_" # {{پرچم|؟؟؟}}

AND il_to <> "Question_book.svg" # {{بهبود منبع}}

AND il_to <> "Wikiquote-logo.svg" # {{ویکی•گفتاورد|؟؟؟}}

AND il_to <> "Wikiquote-logo.svg" # {{ویکی•گفتاورد|؟؟؟}}

​

AND (

  EXISTS(

    SELECT null

    FROM image

    WHERE img_name = il_to

  )OR EXISTS(

    SELECT null

    FROM commonswiki_p.page

    WHERE page_title = il_to

    AND page_namespace = 6

    )

)

ORDER BY page_title;