SQL
AخA
USE fawiki_p;
SELECT DISTINCT CONCAT ('# [[',page_title,']]')
FROM page
INNER JOIN categorylinks
WHERE cl_from = page_id
AND cl_to NOT LIKE '%ابهام%'
AND page_namespace = 0
AND page_is_redirect = 0
AND page_title IN (
SELECT page_title
FROM page
WHERE page_id IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation')
)
GROUP BY page_title
ORDER BY page_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.