Get a list of all customers by int attribute is_dealers - Magento sql

customers-by-init-attribute.sql

SELECT cv.value as `is_dealer`, e.* FROM customer_entity AS e
LEFT JOIN customer_entity_int AS cv 
ON ( cv.attribute_id = (
	SELECT attribute_id FROM eav_attribute 
	WHERE entity_type_id = e.entity_type_id 
	AND attribute_code = 'is_dealer'
	)
AND cv.entity_id = e.entity_id)
WHERE cv.value = 1