This query is marked as a draft This query has been published by Saeidpourbabak.

SQL

x
 
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 "ابهامزدایی_فرودگاه"
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 LIKE "آوا"
#AND tl_title LIKE "به_انگلیسی"
/*AND (
  tl_title LIKE "به_فرانسوی"
  OR tl_title LIKE "به_آلمانی"
  OR tl_title LIKE "به_عربی"
  OR tl_title LIKE "به_روسی"
  OR tl_title LIKE "به_اسپانیایی"
  OR tl_title LIKE "به_اسپانیایی"
  )*/
#AND tl_title NOT LIKE "آوا"
#AND page_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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...