Untitled query #6133

SQL

USE itwikivoyage_p;
SELECT page_title AS page, pp_value AS item
	FROM (SELECT * FROM page WHERE page_is_redirect = 0 AND page_namespace = 0 and page_title = 'Italia') AS page
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
ORDER BY page_title, page_namespace
LIMIT 20;
#SHOW TABLES FROM wikidatawiki_p;
#DESCRIBE wikidatawiki_p.page;
SELECT * FROM wikidatawiki_p.page; #WHERE page_id = 'Q38' LIMIT 20;
#DESCRIBE wikidatawiki_p.page_props;
SELECT * FROM wikidatawiki_p.page_props #WHERE pp_page = 'Q38' LIMIT 20;
SQL

Checking query status...
