Magento 2 || Magento 1 || get attribute set values - mpaz-redstage/magento-snippets GitHub Wiki

select 
	eov.store_id as eov_store_id,
	eov.value as evo_value, 
    eov.option_id as eov_option_id, 
    eo.option_id as eo_option_id, 
    eo.attribute_id
from 
	eav_attribute_option_value as eov 
    
    join eav_attribute_option as eo 
    	on eov.option_id = eo.option_id 
where 
	eo.attribute_id=157 
    and eov.store_id = 0
    
ORDER BY 
	`eov`.`value` ASC