"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 (146, 147, 151, 235)) AND (t_d.attribute_id IN ('41', '43')) AND (t_d.store_id = 0)
entity_id attribute_id default_value store_value value
146 41 (PORTFOLIO) (PORTFOLIO)
146 43 portfolio portfolio
147 41 (Design Service) (Design Service)
147 43 design-service design-service
151 41 (Commercial Projects) (Commercial Projects)
151 43 commercial-projects commercial-projects
235 41 (Hullet House July 2017) (Hullet House July 2017)
235 43 hullet-house-july2017 hullet-house-july2017