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 (55, 56, 42, 44, 45, 53, 8700, 8736, 213, 79, 99, 216, 80, 121, 144, 201, 104, 190, 191, 8701, 158, 64, 100, 203, 93, 120, 105, 195, 77, 189, 202, 88, 206, 94, 114, 106, 199, 175, 184, 85, 136, 207, 159, 107, 200, 63, 193, 186, 86, 209, 122, 177, 183, 87, 138, 211, 109, 181, 185, 92, 140, 214, 174, 101, 97, 215, 111, 194, 171, 196, 142, 217, 112, 178, 182, 197, 157, 218, 113, 161, 220, 187, 219, 116, 167, 98, 198, 117, 164, 204, 118, 188, 123, 165, 192, 124, 166, 212, 125, 173, 126, 168, 127, 180, 128, 169, 129, 130, 170, 179, 162, 889, 163, 172, 160, 8699, 8573, 8708, 278, 221, 300, 490, 8707, 413, 416, 513, 326, 323, 487, 887, 463, 496, 464, 540, 470, 541, 512, 333, 461, 288, 522, 495, 308, 319, 279, 233, 355, 491, 414, 417, 515, 324, 488, 888, 462, 484, 497, 482, 539, 501, 473, 303, 439, 335, 409, 523, 545, 353, 320, 280, 234, 369, 492, 418, 516, 345, 489, 476, 465, 511, 481, 8704, 502, 469, 304, 506, 337, 423, 321, 336, 235, 370, 493, 419, 521, 346, 503, 467, 339, 507, 468, 305, 438, 338, 424, 537, 322, 236, 371, 494, 420, 514, 466, 477, 526, 508, 471, 306, 425, 538, 250, 372, 434, 504, 478, 509, 472, 426, 435, 474, 479, 510, 427, 531, 449, 475, 480, 499, 450, 485, 451, 505, 544, 1853, 626, 601, 747, 605, 748, 625, 637, 723, 720, 740, 689, 627, 756, 749, 638, 725, 721, 741, 774, 757, 752, 639, 722, 742, 750, 765, 753, 684, 780, 766, 754, 870, 871)) AND (t_d.attribute_id IN (41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))