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 |