Wikidata properties missing in summary table

[[Wikidata:List of properties/Summary table]] lists all properties from all subpages of [[Wikidata:List of properties]]. These properties are not linked from any of those subpages, so it's harder to find them for users.

SQL

USE wikidatawiki_p;
SELECT CONCAT("P",pi_property_id) AS propertyId, term_text AS label, pi_type, COUNT(pl2.pl_from) AS backlinks
FROM wb_property_info
	JOIN wb_terms
		ON term_entity_type = 'property' AND term_entity_id = pi_property_id AND term_entity_id > 1900 AND term_language = 'en' AND term_type = 'label'
	LEFT JOIN pagelinks AS pl1
		ON pl1.pl_from = 14546880 AND pl1.pl_namespace = 120 AND pl1.pl_title = CONCAT("P",pi_property_id)
	LEFT JOIN pagelinks AS pl2
		ON pl2.pl_title = CONCAT("P",pi_property_id) AND pl2.pl_from_namespace = 0
WHERE pl1.pl_title IS NULL
GROUP BY pl1.pl_title
ORDER BY pl1.pl_title;

SQL

Checking query status...