SQL
AخA
USE fawiki_p;
SELECT CONCAT ('# [[',page_title,']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT LIKE "(%"
AND page_title LIKE "%(%"
AND page_id NOT IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
AND MID(page_title,1,LOCATE('(',page_title)-2) NOT IN (
SELECT pp_propname
FROM page_props
WHERE pp_propname = 'disambiguation')
AND CONCAT(MID(page_title,1,LOCATE('(',page_title)-2),'_(ابهام•زدایی)') NOT IN (
SELECT pp_propname
FROM page_props
WHERE pp_propname = 'disambiguation')
AND count(page_title)>3
ORDER BY page_title
limit 100;
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.