mp2.2 DAB pages including unnecessary template

SQL

USE fawiki_p;
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 "ابهام‌زدائی"
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;
SQL

Checking query status...
