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.