Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Wikidata items with identical label and description
by
Matěj Suchánek
This query is marked as a draft
This query has been published
by
FShbib
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT CONCAT('Q', Lwbit.wbit_item_id) AS item_id, wbxl_language, (SELECT wbx_text FROM wbt_text WHERE wbx_id = wbxl_text_id) AS text FROM wbt_item_terms AS Lwbit JOIN wbt_term_in_lang AS Lwbtl ON Lwbtl.wbtl_id = Lwbit.wbit_term_in_lang_id JOIN wbt_type AS Ly ON Ly.wby_id = Lwbtl.wbtl_type_id JOIN wbt_item_terms AS Dwbit ON Dwbit.wbit_item_id = Lwbit.wbit_item_id JOIN wbt_term_in_lang AS Dwbtl ON Dwbtl.wbtl_id = Dwbit.wbit_term_in_lang_id JOIN wbt_type AS Dy ON Dy.wby_id = Dwbtl.wbtl_type_id JOIN wbt_text_in_lang ON wbxl_id = Dwbtl.wbtl_text_in_lang_id #JOIN wbt_text ON wbx_id = wbxl_text_id WHERE Ly.wby_name = 'label' AND Dy.wby_name = 'description' AND Lwbtl.wbtl_text_in_lang_id = Dwbtl.wbtl_text_in_lang_id AND wbxl_language = 'ar' LIMIT 2500;
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...