Find all WikiData Entries with Property Image not Null

SQL

USE wikidatawiki_p;
SELECT COUNT(term_row_id) FROM wb_terms
WHERE term_entity_id='18' AND term_entity_type = 'property'
#SELECT CONCAT("P",pi_property_id) AS property, term_text AS label, pi_type
#	FROM wb_property_info
#	LEFT JOIN wb_terms
#		ON term_entity_id = pi_property_id AND term_entity_type = 'property' AND term_language = 'en' AND term_type = 'label'
#	LEFT JOIN pagelinks
#		ON pl_from = 14546880 AND pl_namespace = 120 AND pl_title = CONCAT("P",pi_property_id)
#WHERE pl_title IS NULL
#ORDER BY pi_property_id;

SQL

Checking query status...