SQL
x
(SELECT CONCAT ('# [[',REPLACE(page_title,'_',' '),']]')
FROM page
WHERE page_namespace=0
AND page_id IN (
SELECT el_from FROM externallinks
WHERE el_from IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation'
)
)
)
UNION
(
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 (tl_title LIKE "یادکرد%"
OR tl_title LIKE "پانویس"
OR tl_title LIKE "بدون_منبع"
OR tl_title LIKE "بهبود_منبع"
OR tl_title LIKE "مدرک"
)
);
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.