Skip to content

Instantly share code, notes, and snippets.

@vasilii-b

vasilii-b/query.sql

Created September 11, 2024 12:05
Show Gist options
  • Save vasilii-b/2673a0c739bf99ff0700a1b91582202a to your computer and use it in GitHub Desktop.
Save vasilii-b/2673a0c739bf99ff0700a1b91582202a to your computer and use it in GitHub Desktop.
Download ZIP
Select all (multi)select values for specific product attribute(s)
Raw
query.sql
select ea.attribute_code, eaov.value
from eav_attribute as ea
left join eav_attribute_option as eao on ea.attribute_id = eao.attribute_id
join eav_attribute_option_value eaov on eao.`option_id` = eaov.option_id
where ea.attribute_code like "%_range"
order by ea.attribute_code
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment