SELECT DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]'),tl_title

FROM page JOIN templatelinks ON page_id=tl_from

WHERE page_is_redirect=0

AND page_namespace=0

AND tl_namespace = 10

AND page_id IN (

  SELECT pp_page

  FROM page_props

  WHERE pp_propname = 'disambiguation'

)

​

AND page_title NOT LIKE "%نصف•النهار%"

AND page_title NOT LIKE "%مدار%درجه%"

​

AND tl_title NOT LIKE "ابهام•زدایی"

AND tl_title NOT LIKE "Category_handler"

AND tl_title NOT LIKE "Dmbox"

AND tl_title NOT LIKE "Main_other"

AND tl_title NOT LIKE "PAGENAMEBASE"

AND tl_title NOT LIKE "Str_rep"

AND tl_title NOT LIKE "Title_disambig_text"

AND tl_title NOT LIKE "Title_without_disambig"

AND tl_title NOT LIKE "Trim"

AND tl_title NOT LIKE "ابهام•زدایی/رده"

AND tl_title NOT LIKE "جعبه_ابهام•زدایی"

AND tl_title NOT LIKE "گرداننده_رده"

AND tl_title NOT LIKE "Dmbox/styles.css"

AND tl_title NOT LIKE "اصلاح"

AND tl_title NOT LIKE "اگر_خالی"

​

​

AND tl_title NOT LIKE "ابهام•زدائی"

AND tl_title NOT LIKE "ابهامزدایی"

AND tl_title NOT LIKE "ابهام_زدایی"

AND tl_title NOT LIKE "ابهام•زدایی_نام"

AND tl_title NOT LIKE "ابهام•زدایی_جغرافیا"

AND tl_title NOT LIKE "ابهام_زدایی-جغرافیا"

AND tl_title NOT LIKE "ابهام•زدایی_اعداد"

​

​

​

AND tl_title NOT LIKE "ویکی•واژه"

AND tl_title NOT LIKE "Side_box"

AND tl_title NOT LIKE "Sister"

AND tl_title NOT LIKE "پروژه_خواهر"

AND tl_title NOT LIKE "Wiktionary"

​

AND tl_title NOT LIKE "رده_همسنگ_نه"

AND tl_title NOT LIKE "فهرست_مطالب_چپ"

​

AND tl_title NOT LIKE "Column-count"

AND tl_title NOT LIKE "Div_col"

AND tl_title NOT LIKE "Div_col_end"

​

AND tl_title NOT LIKE "ابهام•زدایی_فرودگاه"

AND tl_title NOT LIKE "Ifempty"

AND tl_title NOT LIKE "If_empty"

​

AND tl_title NOT LIKE "Dablink"

​

AND tl_title NOT LIKE "کوچک"

AND tl_title NOT LIKE "آغاز_کوچک"

AND tl_title NOT LIKE "پایان_کوچک"

AND tl_title NOT LIKE "اشتباه_نشود"

AND tl_title NOT LIKE "%چندستون%"

AND tl_title NOT LIKE "%چر%"

AND tl_title NOT LIKE "%رچ%"

AND tl_title NOT LIKE "%پیوند_ابهام•زدایی%"

AND tl_title NOT LIKE "%برای%"

​

​

ORDER BY tl_title;