Wikidata - table - page_props - describe, sample data

SQL

use wikidatawiki_p; 

describe page_props;
SELECT * FROM page_props LIMIT 50;
SELECT * FROM page_props WHERE pp_page = 133; #page_id of item Q5
SELECT pp_propname, COUNT(*) FROM page_props GROUP BY pp_propname;
SELECT pp_value, COUNT(*) As ct_of_items_with_this_number_of_sitelinks FROM page_props WHERE pp_propname="wb-sitelinks" GROUP BY pp_value;
SELECT pp_value, COUNT(*) As ct_of_items_with_this_number_of_claims FROM page_props WHERE pp_propname="wb-claims" GROUP BY pp_value;
SELECT COUNT(*) FROM page_props WHERE pp_propname="wb-claims";
SELECT COUNT(*) FROM page_props WHERE pp_propname="wb-sitelinks";
SELECT page_title, page_namespace, pp_value, "item with 148 claims" AS What FROM page_props, page WHERE pp_sortkey = 148 AND pp_propname="wb-claims" AND page_id = pp_page
SQL

Checking query status...
