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