Categorized user pages (cswiki)

SQL

USE wikidatawiki_p;
SELECT page_title, epp_entity_id#, prop_labels.term_language, prop_labels.term_text
	FROM (SELECT * FROM page WHERE page_namespace = 120) AS props
	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 (SELECT * FROM pagelinks WHERE pl_title = 'P1687' AND pl_namespace = 120 AND pl_from_namespace = 0) AS with_prop2
		ON with_prop2.pl_from = items.pl_from
	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...
