Skip to content

Instantly share code, notes, and snippets.

@adamzero1

adamzero1/show_store_label_for_attribute_option_by_option_code.sql

Last active January 10, 2022 08:46
Show Gist options
  • Save adamzero1/4ea9f92ce69083c8bb811321e39be3b2 to your computer and use it in GitHub Desktop.
Save adamzero1/4ea9f92ce69083c8bb811321e39be3b2 to your computer and use it in GitHub Desktop.
Download ZIP
Show store label for attribute option, by option_code
Raw
show_store_label_for_attribute_option_by_option_code.sql
select ea.attribute_code,
ea.frontend_label,
oc.option_id,
oc.attribute_id,
oc.option_code,
eaov.value_id,
eaov.store_id,
eaov.value from option_code as oc
left join eav_attribute_option_value as eaov on oc.option_id = eaov.option_id
left join eav_attribute as ea on oc.attribute_id = ea.attribute_id
where oc.option_code = 'OPTION_CODE'
and eaov.store_id = STORE_ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment