Categorized user pages (cswiki)

SQL

USE wikidatawiki_p;
SELECT page_title#, item_labels.term_language, item_labels.term_text
	FROM wb_property_info
	JOIN (SELECT * FROM page WHERE page_namespace = 120) AS props
		ON page_title = CONCAT("P",pi_property_id)
	JOIN (SELECT * FROM pagelinks WHERE pl_title = 'P1629') AS with_prop
		ON with_prop.pl_from = page_id
	#JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 120 AND pl_from_namespace = 0) AS items
	#	ON items.pl_title = page_title
#	JOIN wb_entity_per_page
	#	ON epp_page_id = items.pl_from
	#JOIN (SELECT * FROM wb_terms WHERE term_type = 'label' AND term_entity_type = 'item') AS item_labels
#    	ON item_labels.term_entity_id
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_entity_type = 'property' AND term_type = 'label') AS prop_labels
		ON prop_labels.term_entity_id = pi_property_id #AND prop_labels.term_language = item_labels.term_language
ORDER BY pi_property_id;
SQL

Checking query status...
