SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT
wbit_item_id as id,
wby_name as type,
wbxl_language as... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('https://www.wikidata.org/wiki/Q', wbit_item_id) AS item,... |
1 year ago |
SELECT CONCAT('Q', wbit_item_id) as Item, wbx_text as text
FROM... |
1 year ago |
SELECT wbit_item_id, wbx_text, page_latest
FROM wbt_item_terms
JOIN... |
1 year ago |
SELECT CONCAT('Q', wbit_item_id), wbxl_language, wbx_text, page_latest
FROM... |
1 year ago |
SELECT CONCAT('Q', wbit_item_id), wbxl_language, wbx_text, page_latest
FROM... |
1 year ago |
USE wikidatawiki_p;
SELECT CONCAT('Q',wbit_item_id)
FROM wbt_item_terms
JOIN... |
1 year ago |
USE wikidatawiki_p;
SELECT CONCAT(IF(term_entity_type = "item", "Q", "P"),... |
1 year ago |