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 (804, 935, 981, 991, 1042, 1063, 575, 805, 936, 982, 992, 813, 937, 983, 1005, 822, 938, 984, 1013, 578, 823, 944, 985, 1014, 718, 828, 945, 986, 1015, 829, 952, 987, 1019, 580, 837, 953, 988, 581, 843, 964, 989, 1023, 719, 850, 970, 990, 1027, 582, 860, 979, 1030, 879, 980, 1031, 1047, 887, 1032, 584, 895, 1033, 721, 901, 585, 913, 920, 587, 930, 588, 931, 589, 932, 590, 933, 591, 934, 592, 1036, 593, 594, 595, 1040, 596, 597, 598, 1046, 1038, 600, 601, 602, 781, 1041, 712, 737, 722, 774, 1066, 720, 796, 605, 606, 799, 607, 608, 609, 610, 611, 1037, 612, 1054, 1039, 613, 759, 1049, 614, 615, 616, 1048, 618, 619, 620, 621, 622, 1053, 623, 624, 625, 626, 627, 628, 629, 631, 634, 713, 635, 637, 1057, 638, 639, 640, 641, 642, 643, 711, 644, 645, 647, 648, 649, 650, 651, 780, 652, 653, 603, 654, 1043, 1052, 655, 714, 656, 1060, 1062, 657, 658, 1065, 660, 661, 662, 663, 664, 665, 666, 798, 801, 667, 1061, 806, 814, 824, 830, 838, 844, 851, 861, 880, 888, 896, 902, 914, 921, 939, 946, 954, 965, 971, 993, 1006, 1016, 1020, 1024, 1028, 807, 815, 825, 831, 839, 845, 852, 862, 881, 889, 897, 903, 915, 922, 940, 947, 955, 966, 972, 994, 1007, 1017, 1021, 1025, 1029, 808, 816, 826, 832, 840, 846, 853, 863, 882, 890, 898, 904, 916, 923, 941, 948, 956, 967, 973, 995, 1008, 1018, 1026, 809, 817, 827, 833, 841, 847, 854, 864, 883, 891, 899, 905, 917, 924, 942, 949, 957, 968, 974, 996, 1009, 1045, 810, 818, 834, 842, 848, 855, 865, 884, 892, 900, 906, 918, 925, 943, 950, 958, 969, 975, 997, 1010, 1059, 811, 819, 835, 849, 856, 866, 885, 893, 907, 919, 926, 951, 959, 976, 998, 1011, 812, 820, 836, 857, 867, 886, 894, 908, 927, 960, 977, 999, 1012, 821, 858, 868, 909, 928, 961, 978, 1000, 859, 869, 910, 929, 962, 1001, 1055, 870, 911, 963, 1002, 871, 912, 1003, 872, 1004, 873, 874, 875, 876, 877, 878)) AND (t_d.attribute_id IN (33)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))