wikidata tables /tests/

SQL

USE wikidatawiki_p;/*
show tables;
SHOW COLUMNS FROM page;
SHOW COLUMNS FROM pagelinks;*/
#select * from page join pagelinks ON page_id = pl_from where page_title = "Q9698821" 
/*select page_title from page
	JOIN pagelinks on pl_from_namespace = 0
		and pl_title = "Q4167836"#CONCAT("Q",epp_entity_id) 
        where page_title in
(select CONCAT("Q",ips_item_id) from wb_items_per_site where ips_site_id is null)*/
/*
        join wb_items_per_site on page_title = CONCAT("Q",ips_item_id)
        where ips_site_id is null*/
/*select page_title from page#CONCAT("Q",epp_entity_id) 
        where page_title in
(select CONCAT("Q",ips_item_id) from wb_items_per_site where ips_site_id is null)
limit 10*/
#select * from wb_items_per_site where ips_item_id = "9698821" 
select * from
wikidatawiki_p.pagelinks wdpl where wdpl.pl_title = 'Q21672098' limit 10
/*
select ips_item_id, ips_site_page from wb_items_per_site 
where ips_site_id = "rowiki" and ips_site_page like "Format:Demografia/%"

*/
#SHOW COLUMNS FROM wb_items_per_site;
#SHOW COLUMNS FROM langlinks;
SQL

Checking query status...
