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
SELECT CONCAT ('# [[',enp.page_title,']][[:en:',enll.ll_title,']]') FROM enwiki_p.page AS enp RIGHT JOIN enwiki_p.page_props AS enpp ON enp.page_id = enpp.pp_page RIGHT JOIN enwiki_p.langlinks AS enll ON enp.page_id = enll.ll_from WHERE enp.page_namespace = 0 AND enp.page_is_redirect = 0 AND enpp.pp_propname = 'disambiguation' AND enll.ll_lang = "fa" AND REPLACE(enll.ll_title, ' ', '_') NOT IN ( # enwiki disambig titles SELECT fap.page_title FROM fawiki_p.page AS fap RIGHT JOIN fawiki_p.page_props AS fapp ON fap.page_id = fapp.pp_page WHERE fap.page_namespace = 0 AND fap.page_is_redirect = 0 AND fapp.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...