DAB pages including template other than DAB and Wiktionary

SQL

USE fawiki_p;
SELECT DISTINCT concat('#[[',page_title,']]')
FROM page JOIN templatelinks ON page_id=tl_from
WHERE page_is_redirect=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 "گرداننده_رده"
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 "رده_همسنگ_نه"

AND tl_title != "ابهام‌زدایی-جغرافیا"
ORDER BY page_title;
SQL

Checking query status...
