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 * FROM page WHERE page_namespace = 4 AND page_title LIKE "Database reports/Constraint violations/P%"
LIMIT 50 /*
SELECT * CONCAT("P",pi_property_id) AS propertyId, term_text AS label
FROM wb_property_info
	JOIN wb_terms
		ON term_entity_type = 'property' AND term_type = 'label' AND term_language = 'en' AND term_entity_id = pi_property_id
	LEFT JOIN page
		ON page_namespace = 4 AND CONCAT("Database reports/Constraint violations/P",pi_property_id) = page_title
WHERE page_title IS NULL*/

SQL

Checking query status...