use wikidatawiki_p;
select
concat("Q", wbit_item_id) as item,
... |
9 months ago |
SELECT wbx_text
#SELECT DISTINCT CONCAT('Q', wbt_item_terms.wbit_item_id)... |
9 months ago |
SELECT wbx_text
#SELECT DISTINCT CONCAT('Q', wbt_item_terms.wbit_item_id)... |
9 months ago |
SELECT wbx_text
#SELECT DISTINCT CONCAT('Q', wbt_item_terms.wbit_item_id)... |
9 months ago |
SELECT wbt_text
#SELECT DISTINCT CONCAT('Q', wbt_item_terms.wbit_item_id)... |
9 months ago |
SELECT DISTINCT CONCAT('http://www.wikidata.org/entity/Q',... |
9 months ago |
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_title LIKE... |
9 months ago |
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_title LIKE... |
9 months ago |
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_title LIKE... |
9 months ago |
SELECT CONCAT (page_title)
FROM page
WHERE page_namespace = 0
AND page_title... |
9 months ago |
SELECT CONCAT ("category talk:",page_title)
FROM page
WHERE page_namespace =... |
9 months ago |