SELECT 
	distinct(eaov.value) manufacturer  

FROM 
	eav_attribute_option_value eaov,
	eav_attribute_option eao,
	eav_attribute ea

WHERE 
	ea.attribute_id = eao.attribute_id and 
	eao.option_id = eaov.option_id and 
	ea.attribute_code='manufacturer'

