Testing - Quarry

SQL

USE wikidatawiki_p;
SELECT *#pg1.*, pg2.*
FROM page pg1
JOIN page pg2 ON pg2.page_title = pg1.page_title AND pg2.page_namespace = 0
WHERE pg1.page_namespace = 1
LIMIT 10;
/*
SELECT pp.pp_value #pg.page_id, pl.*, pp.*
FROM pagelinks pl
JOIN page AS pg
ON page_title = pl_title AND page_namespace = pl_namespace
JOIN page_props AS pp
ON pp_page = page_id AND pp_propname = 'wikibase_item'
WHERE pl_from = 39377526
AND EXISTS (
	SELECT 1
	FROM categorylinks
	WHERE cl_from = pg.page_id
	AND cl_to = 'Living_people'
)
*/
SQL

Checking query status...
