.......... - Quarry

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 "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 "Dablink"

#AND page_title LIKE "شارل"

AND tl_title LIKE "%به_%"



#AND tl_title NOT LIKE "آوا"


#AND tl_title 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 "ابهام‌زدایی_جغرافیا" NOT IN (
  SELECT tl_title
  FROM templatelinks
  WHERE page_id=tl_from
)*/
ORDER BY tl_title;
SQL

Checking query status...
