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 ('# [[',fap.page_title,']][[:en:',fall.ll_title,']]'),fall.ll_from FROM fawiki_p.page AS fap RIGHT JOIN fawiki_p.langlinks AS fall ON fap.page_id = fall.ll_from WHERE fap.page_namespace = 14 AND fap.page_is_redirect = 0 AND fap.page_title LIKE "روستا%" AND fap.page_title LIKE "روستاهای_شهرستان_زنجان" AND fall.ll_lang = "en" /*AND REPLACE(fall.ll_title, ' ', '_') IN ( # enwiki disambig titles SELECT enp.page_title FROM enwiki_p.page AS enp WHERE enp.page_namespace = 14 AND enp.page_is_redirect = 0 AND enp.page_title LIKE "%Populated%" )*/ ORDER BY fap.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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...