"Back"

SQL Select

{{{Executed SQL}}{{Executed SQL}}{{Executed SQL}}{{Mage_Core}}}
SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (154, 155, 157, 198)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
entity_id attribute_id default_value store_value value
154 41 (Locate) (Locate)
154 43 locate locate
155 41 (Shop) (Shop)
155 43 shop shop
157 41 (BOUTIQUES) (BOUTIQUES)
157 43 boutiques boutiques
198 41 (HK FLAGSHIP) (HK FLAGSHIP)
198 43 hk-flagship hk-flagship