SELECT `t_d`.`attribute_id`, `e`.`entity_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` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id 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 (e.entity_id IN (11, 10, 9, 8, 7, 6, 5, 4, 3, 67, 62, 53, 46, 41, 36, 30, 24, 18, 68, 63, 54, 47, 42, 37, 31, 25, 19, 69, 64, 55, 48, 43, 38, 32, 26, 20, 70, 65, 56, 49, 44, 39, 33, 27, 21, 71, 66, 57, 50, 45, 40, 34, 28, 22, 72, 58, 51, 35, 29, 23, 73, 59, 52, 74, 60, 75, 76, 61, 81, 88, 96, 98, 104, 111, 120, 123, 124, 129, 133, 138, 140, 143, 149, 155, 158, 162, 166, 169, 173, 175, 82, 89, 97, 99, 105, 112, 121, 125, 130, 134, 139, 141, 144, 150, 156, 159, 163, 167, 170, 174, 176, 83, 90, 100, 106, 113, 122, 126, 131, 135, 142, 145, 151, 157, 160, 164, 168, 171, 177, 84, 91, 101, 107, 114, 127, 132, 136, 146, 152, 161, 165, 172, 178, 85, 92, 102, 108, 115, 128, 137, 147, 153, 179, 86, 93, 103, 109, 116, 148, 154, 180, 87, 94, 110, 117, 181, 95, 118, 182, 119, 183, 184, 185, 186, 187, 188, 208, 210, 209, 211, 212, 213, 214)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))