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
XXN
.
+ /18461
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT CONCAT('Q',term_entity_id) as item, /*term_language,*/ term_text FROM wb_terms JOIN page on CONCAT('Q',term_entity_id) = page_title JOIN (SELECT * FROM pagelinks WHERE pl_title = "Q4167410" AND pl_from_namespace = 0) AS total ON page_id = total.pl_from WHERE term_type = 'description' AND term_language = 'fa'#'uk' AND term_text like "\u"#"Категорії"#RLIKE '.+\\s{2,}.+'#= "город в Италии" AND term_entity_type = 'item' #ORDER BY term_language, term_entity_id, term_text; /**//* SELECT CONCAT('Q', w2.term_entity_id) as item, w1.term_text as label#, CONCAT('"', w2.term_text, '"') as descr, # GROUP_CONCAT(w1.term_text separator ' *, ') as alias, # CURRENT_DATE from wb_terms w2 join wb_terms w1 on w2.term_entity_id = w1.term_entity_id WHERE w2.term_entity_type = 'item' # AND w2.term_language = 'en' # AND w2.term_type = 'description'#'label' # 'description', 'alias' # AND w2.term_text = "Wikimedia category"#Wikimedia template" #like "%политики"#RLIKE '^dorp {2,}'like "%(dezambiguizare)" and (w1.term_entity_type = 'item' AND w1.term_language = 'en' AND w1.term_type = 'description' AND w1.term_text = "Категорії") GROUP BY w2.term_entity_id#w2.term_text, w2.term_entity_id limit 10100*/
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...