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 (3, 56, 159, 5, 380, 45, 404, 449, 15, 472, 76, 455, 161, 381, 183, 450, 9, 473, 87, 69, 382, 415, 694, 206, 485, 86, 470, 4, 422, 44, 392, 474, 89, 57, 383, 453, 6, 475, 83, 72, 384, 507, 476, 471, 467, 385, 454, 477, 84, 456, 589, 433, 10, 478, 85, 460, 387, 38, 234, 479, 82, 17, 235, 480, 388, 46, 481, 200, 482, 42, 7, 483, 14, 484, 41, 13, 39, 610, 629, 829, 608, 609, 16, 199, 8, 273, 184, 220, 281, 576, 211, 331, 827, 434, 731, 47, 58, 70, 73, 80, 785, 741, 405, 345, 201, 207, 790, 521, 393, 419, 423, 451, 457, 469, 590, 662, 674, 618, 630, 695, 166, 274, 691, 185, 221, 493, 426, 214, 332, 32, 435, 732, 48, 59, 71, 74, 77, 778, 742, 406, 346, 202, 208, 258, 238, 394, 417, 420, 424, 452, 458, 466, 468, 165, 591, 663, 675, 620, 631, 167, 275, 692, 186, 222, 577, 213, 334, 793, 437, 733, 49, 60, 75, 828, 830, 754, 407, 347, 204, 209, 249, 236, 395, 416, 425, 459, 511, 664, 676, 621, 632, 700, 168, 276, 690, 187, 229, 283, 219, 335, 706, 438, 734, 61, 78, 779, 753, 408, 351, 203, 210, 247, 237, 496, 421, 462, 509, 665, 677, 622, 633, 701, 169, 277, 375, 193, 230, 490, 215, 336, 717, 441, 735, 62, 824, 780, 752, 410, 352, 205, 259, 243, 401, 461, 519, 666, 678, 623, 634, 34, 504, 279, 377, 194, 232, 487, 218, 337, 723, 442, 736, 63, 825, 781, 739, 411, 353, 248, 245, 497, 520, 667, 679, 624, 635, 711, 173, 278, 195, 231, 289, 216, 338, 443, 737, 64, 826, 782, 740, 412, 348, 254, 244, 498, 517, 668, 680, 627, 636, 718, 171, 693, 196, 233, 288, 217, 738, 65, 81, 787, 751, 414, 349, 256, 246, 402, 518, 669, 681, 625, 660, 505, 378, 494, 224, 488, 339, 440, 66, 79, 788, 750, 350, 255, 241, 403, 512, 670, 682, 626, 661, 172, 379, 197, 225, 290, 340, 436, 67, 789, 749, 257, 242, 397, 176, 671, 683, 628, 655, 502, 198, 226, 491, 341, 445, 68, 748, 250, 239, 398, 510, 672, 684, 619, 637, 506, 189, 227, 291, 342, 444, 747, 251, 240, 399, 513, 673, 685, 638, 503, 190, 228, 284, 343, 446, 746, 252, 499, 515, 639, 174, 191, 285, 611, 447, 745, 253, 400, 514, 640, 175, 495, 489, 688, 448, 744, 516, 641, 177, 192, 286, 689, 743, 642, 178, 492, 687, 643, 501, 287, 686, 644, 179, 344, 645, 180, 646, 181, 656, 182, 647, 500, 648, 649, 650, 651, 654, 652, 657, 658, 659, 593, 705, 391, 770, 755, 522, 535, 566, 409, 413, 427, 260, 578, 33, 712, 719, 724, 784, 703, 771, 777, 523, 536, 559, 549, 567, 418, 595, 605, 615, 713, 721, 725, 783, 704, 772, 757, 524, 537, 560, 550, 568, 596, 594, 616, 698, 714, 722, 726, 786, 31, 773, 758, 525, 538, 561, 551, 569, 263, 262, 699, 710, 715, 720, 727, 40, 774, 759, 526, 539, 562, 552, 570, 428, 604, 716, 728, 775, 761, 527, 540, 563, 553, 571, 598, 265, 580, 729, 776, 760, 528, 541, 564, 554, 572, 429, 264, 614, 730, 762, 529, 542, 556, 573, 599, 266, 612, 763, 530, 543, 555, 574, 430, 267, 581, 764, 531, 544, 557, 268, 613, 765, 532, 545, 558, 606, 582, 766, 533, 546, 431, 607, 583, 756, 534, 547, 575, 270, 584, 767, 432, 261, 271, 768, 601, 769, 603, 586, 617, 587, 269, 592)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))