SQL
x
use fawiki_p;
select REPLACE(concat('بحث:',page_title),'_',' ')
from redirect r
left join page p
on rd_from = page_id
where page_namespace = 0
and exists (
select null
from redirect
left join page
on rd_from = page_id
where page_namespace = 1
and page_title = p.page_title
and rd_title <> r.rd_title
)
AND r.rd_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;
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.