"Back"

SQL Select

Executed SQL
SELECT `main_table`.*, `tdv`.`value` AS `default_value`, `tsv`.`value` AS `store_default_value`, IF(tsv.value_id > 0, tsv.value, tdv.value) AS `value` FROM `eav_attribute_option` AS `main_table` INNER JOIN `eav_attribute_option_value` AS `tdv` ON tdv.option_id = main_table.option_id LEFT JOIN `eav_attribute_option_value` AS `tsv` ON tsv.option_id = main_table.option_id AND tsv.store_id = '1' WHERE (attribute_id = '81') AND (tdv.store_id = 0) ORDER BY main_table.sort_order ASC, value ASC
option_id attribute_id sort_order default_value store_default_value value
5 81 0 buberry buberry
6 81 0 chanel chanel
4 81 0 dell dell
8 81 0 gucci gucci
3 81 0 microsoft microsoft
7 81 0 nokia nokia