Exploring Wikidata

SQL

use wikidatawiki_p;
-- show tables;
-- select * from page where page_id = 2039804;
-- select * from pagelinks where pl_namespace = 120 and pl_title = 'P1566' and pl_from = 2039804;
-- Once the entity is known (e.g. Q2113430) we can use this query to get its localized name, if available
-- select * from wb_terms where term_entity_id = '2113430' and term_language = 'en'
/*
wb_changes
wb_changes_dispatch
wb_changes_subscription
wb_id_counters
wb_items_per_site
wb_property_info
wb_terms
wbc_entity_usage
wbqc_constraints
wbs_propertypairs
*/
select * from wbs_propertypairs where pid1 = 1566 limit 10
SQL

Checking query status...
