Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Saeidpourbabak
.
Toggle Highlighting
SQL
USE fawiki_p; ( SELECT pl_title,page_title,concat(page_title,'_(ابهامزدایی)') FROM pagelinks JOIN page ON pl_namespace=page_namespace AND pl_title=page_title JOIN redirect ON page_id=rd_from WHERE pl_from_namespace=0 AND pl_namespace=0 AND page_is_redirect=1 AND pl_from IN ( SELECT page_id FROM page WHERE REPLACE(page_title,'_',' ') LIKE "مشهد") AND rd_title IN ( SELECT page_title FROM page WHERE page_id IN ( SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation')) AND page_title<>'محلول_درصدی_(ابهامزدایی)' ) UNION ( SELECT pl_title,page_title,concat(page_title,'_(ابهامزدایی)') FROM pagelinks JOIN page ON pl_namespace=page_namespace AND pl_title=page_title WHERE pl_from_namespace=0 AND pl_namespace=0 AND page_is_redirect=0 AND pl_from IN ( SELECT page_id FROM page as pg WHERE REPLACE(pg.page_title,'_',' ') LIKE "مشهد") AND pl_title<>concat(pg.page_title,'_(ابهامزدایی)') AND page_id IN ( SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation') );
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...