Wikidata properties without report

For every property a "constraint violation" report can be set to analyze property uses by a bot or the new extension. These properties do not have any.

SQL

use wikidatawiki_p;
SELECT CONCAT("P",pi_property_id) AS pId, term_text AS label, pi_type AS datatype
	FROM wb_property_info
	LEFT JOIN (SELECT * FROM page WHERE page_namespace = 4 AND page_title LIKE "Database&_reports/Constraint&_violations/P%" ESCAPE "&") AS pages
		ON page_title = CONCAT("Database_reports/Constraint_violations/P",pi_property_id)
	LEFT JOIN (SELECT * FROM wb_terms WHERE term_entity_type = 'property' AND term_type = 'label' AND term_language = 'en') AS labels
		ON term_entity_id = pi_property_id
WHERE page_title IS NULL
ORDER BY pi_property_id;

SQL

Checking query status...