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 distinct page_title from page
	JOIN pagelinks on pl_from_namespace = 0
		and pl_title = "Q4167836"#CONCAT("Q",epp_entity_id) 
        where page_title =
(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*/
limit 50
#select * from wb_items_per_site where ips_item_id = "9698821" 
#SHOW COLUMNS FROM wb_items_per_site;
#SHOW COLUMNS FROM langlinks;
SQL

Checking query status...
