| SELECT wbtl_text_in_lang_id FROM wbt_term_in_lang LIMIT 100 |
3 years ago |
| SELECT CONCAT("Q", term_entity_id) AS wikidata_id, term_language, term_text,... |
3 years ago |
| SELECT CONCAT("Q", term_entity_id) AS wikidata_id, term_language, term_text,... |
3 years ago |
| DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id) AS wikidata_id,... |
3 years ago |
| DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id) AS wikidata_id,... |
3 years ago |
| USE wikidatawiki_p;
DESCRIBE wb_terms;
SELECT CONCAT("Q", term_entity_id)... |
3 years ago |
| select * from wbt_item_terms LIMIT 100
|
3 years ago |
| select * from wb_id_counters LIMIT 100
|
3 years ago |
| select * from wb_items_per_site where ips_item_id = 5 and ips_site_id = 'enwiki'
|
3 years ago |
| select * from wb_items_per_site where ips_item_id = 213706 and ips_site_id =... |
3 years ago |
| select * from wb_items_per_site where ips_item_id = 213706
|
3 years ago |
| use enwiki_p;
select * from wb_items_per_site where ips_item_id = 213706
|
3 years ago |
| select * from wb_items_per_site where ips_item_id = 213706
|
3 years ago |
| SELECT DISTINCT pi_info FROM wb_property_info LIMIT 100
|
3 years ago |
| SELECT DISTINCT wby_name FROM wbt_type LIMIT 100
|
3 years ago |
| SELECT DISTINCT wbpt_property_id FROM wbt_property_terms LIMIT 100
|
3 years ago |
| SELECT wbpt_id, wbpt_property_id FROM wbt_property_terms LIMIT 100
|
3 years ago |
| SELECT wbpt_id FROM wbt_property_terms LIMIT 100
|
3 years ago |
| SELECT wbpt_id FROM wbt_property_terms WHERE wbpt_property_id = 5 LIMIT 100
|
3 years ago |
| SELECT COUNT(pp_value) FROM page_props WHERE pp_value = 5
|
3 years ago |
| SELECT COUNT(pp_value) FROM page_props WHERE pp_value = Q5
|
3 years ago |
| SELECT COUNT(pp_value) FROM page_props WHERE pp_value = 'Q5'
|
3 years ago |
| SELECT COUNT(pp_value) FROM page_props WHERE page_value = 'Q5'
|
3 years ago |
| SELECT COUNT(page_title) FROM page WHERE page_value = 'Q5'
|
3 years ago |
| SELECT COUNT(pp_value) FROM page WHERE pp_value = 'Q5'
|
3 years ago |
| SELECT COUNT(*) FROM page WHERE pp_value = 'Q5'
|
3 years ago |
| USE wikidatawiki_p;
SELECT COUNT(*) FROM page WHERE pp_value = 'Q5'
|
3 years ago |
| USE wikidatawiki_p;
SELECT COUNT(pp_page) FROM page WHERE pp_value = 'Q5'
|
3 years ago |
| USE wikidatawiki_p;
SELECT COUNT(pp_page) FROM page WHERE pp_value = Q5
|
3 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, CONCAT("Q",ips_item_id),... |
3 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, CONCAT("Q",ips_item_id),... |
3 years ago |
| USE wikidatawiki_p;
SELECT ips_item_id, CONCAT("Q",ips_item_id),... |
3 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Laf",... |
3 years ago |
| USE wikidatawiki_p;
SELECT CONCAT("Q",ips_item_id), "Laf",... |
3 years ago |
| use wikidatawiki_p;
SELECT * FROM page_props
WHERE pp_page = '6103848'; |
3 years ago |
