"Back"

SQL Select

Executed SQL
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, 156, 200)) 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
156 41 (PARTNERS) (PARTNERS)
156 43 partners partners
200 41 (Macau Shop) (Macau Shop)
200 43 macau-shop macau-shop