Query Run
SELECT wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT wbit_item_id as id, wby_name as type, wbxl_language as... 2 years ago
SELECT i.wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT i.wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT i.wbit_item_id as id, # wby_name as type, # wbxl_language as... 2 years ago
SELECT wbit_item_id as id, wby_name as type, wbxl_language as... 2 years ago
SELECT wbit_item_id as id, wby_name as type, wbxl_language as... 2 years ago
SELECT wbpt_property_id as id, wby_name as type, wbxl_language as... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbx_text -- use CONCAT('P',... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbx_text -- use CONCAT('P',... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbx_text -- use CONCAT('P',... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbx_text -- use CONCAT('P',... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbx_text -- use CONCAT('P',... 2 years ago
SELECT wbx_text AS label, # t2.term_text AS aliases, CONCAT('Q',... 2 years ago
SELECT CONCAT('Q', wbit_item_id), wbxl_language, wby_name, wbx_text -- use... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, # t2.term_text AS... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, # t2.term_text AS... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, t2.term_text AS... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, t2.term_text AS... 2 years ago
# List of Korean names and their aliases # FIXME: include names without any... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, # t2.term_text AS... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, # t2.term_text AS... 2 years ago
use wikidatawiki_p; SELECT t1.term_text AS label, t2.term_text AS... 2 years ago