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
Meno25
.
https://quarry.wmflabs.org/query/1255
Toggle Highlighting
SQL
SELECT CONCAT('Q',wbit_item_id), concat("Darz"), CONCAT('"','قالب بتاع ويكيميديا','"') FROM wbt_item_terms JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id JOIN wbt_type ON wbtl_type_id = wby_id JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id JOIN wbt_text ON wbxl_text_id = wbx_id JOIN page ON page_namespace = 0 AND CONCAT('Q', wbit_item_id) = page_title WHERE wby_name = 'description' AND wbxl_language = 'arz' #AND LENGTH(wbx_text) = 1 #AND wbx_text LIKE "ويكيبيديا:قوالب" #AND wbx_text NOT RLIKE "\p{Han}" AND wbx_text IN ( 'ويكيبيديا:قوالب' ) limit 23100;
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...