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 (44, 45, 49, 40, 41, 42, 43, 76886, 47, 48, 46, 50, 11732, 13079, 13082, 31502, 97799, 11747, 13046, 3755, 273, 275, 113, 109394, 87824, 12218, 99, 77738, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 77, 76, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 278, 63, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 90, 92, 93, 89, 91, 94, 95, 98, 100, 26696, 101, 102, 103, 105, 106, 107, 108, 104, 109, 110, 111, 479, 26693, 11744, 13121, 112, 13151, 13178, 26807, 26810, 27500, 31514, 31517, 31520, 31523, 31526, 31529, 50090, 82394, 95105, 95108, 95111, 95252, 95186, 95114, 95189, 102173, 97811, 97814, 97817, 97820, 100232, 134796, 165, 181, 295, 379, 80879, 219, 26915, 97844, 96, 183, 292, 126285, 80882, 97847, 97, 186, 294, 126288, 25661, 102185, 185, 80885, 96485, 184, 401, 96461, 96488, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 194, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 151, 152, 153, 150, 149, 154, 155, 156, 157, 158, 159, 160, 161, 163, 164, 162, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 182, 187, 188, 189, 190, 191, 192, 193, 195, 280, 196, 197, 198, 199, 200, 201, 202, 204, 205, 206, 207, 203, 208, 109403, 209, 476, 210, 211, 220, 221, 222, 223, 212, 213, 214, 215, 216, 217, 218, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 242, 241, 239, 243, 240, 238, 244, 245, 246, 247, 248, 249, 250, 251, 266, 267, 269, 270, 271, 276, 12230, 126291, 126294, 272, 470, 281, 282, 284, 285, 286, 287, 288, 290, 291, 293, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 482, 485, 488, 491, 10037, 11750, 11753, 12233, 13058, 13061, 13124, 13127, 13130, 13133, 13097, 13154, 13157, 13160, 13163, 326, 13181, 13184, 26708, 26711, 26714, 26717, 26720, 26750, 26753, 26756, 26759, 26762, 26765, 26768, 26771, 26723, 26726, 26729, 26732, 26822, 26843, 26846, 26864, 26867, 26870, 26849, 26852, 26855, 26858, 26861, 65975, 110315, 27515, 27506, 27518, 268, 27830, 27713, 28430, 28439, 28421, 31532, 31535, 31538, 31541, 31544, 31547, 31550, 31553, 31556, 33764, 274, 33767, 36806, 39905, 109463, 5558, 50078, 50102, 50105, 50108, 50111, 55700, 50114, 55733, 55736, 55739, 55742, 62390, 289, 77654, 67646, 77657, 77660, 77699, 77702, 77750, 87908, 77696, 77762, 77765, 77768, 77771, 82427, 82430, 82433, 87827, 87830, 87833, 87836, 87866, 90998, 95120, 95123, 95126, 95129, 95132, 95135, 95138, 95141, 95144, 102152, 95147, 95150, 95153, 95156, 95159, 95162, 95165, 95168, 95171, 95192, 95174, 95195, 95219, 95222, 95225, 95228, 95231, 95234, 95237, 95240, 95243, 95246, 95249, 95276, 95279, 95282, 95255, 95285, 95258, 95261, 95264, 97823, 97832, 97826, 97829, 97838, 97835, 97841, 97850, 97853, 97856, 97859, 97862, 97865, 97868, 98159, 98165, 98162, 98231, 98225, 98234, 98174, 98177, 98222, 98228, 98237, 98168, 98240, 98171, 100244, 100247, 100250, 100253, 100256, 100259, 100262, 100265, 100268, 100271, 100274, 100277, 100280, 101591, 107855, 107858, 107861, 107864, 107867, 109424, 109427, 37226, 37223, 109412, 110024, 109448, 109460, 283, 374, 3767, 9122, 26900, 26888, 96515, 109415, 376, 126261, 126231, 126264, 3770, 3779, 26903, 95117, 96518, 109418, 375, 126222, 378, 126249, 3773, 3776, 26906, 96521, 377, 126225, 126234, 126240, 4187, 96524, 126219, 126228, 126237, 126243, 8702, 96512, 126246, 8705, 87899, 425, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 366, 367, 365, 368, 369, 252, 253, 254, 255, 256, 258, 259, 260, 370, 371, 372, 261, 262, 263, 265, 257, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 494, 497, 500, 503, 506, 509, 512, 515, 518, 521, 10040, 10043, 10055, 11765, 13064, 13067, 13070, 13073, 13076, 13100, 13103, 13106, 13109, 13112, 13115, 13118, 13145, 13148, 23129, 26735, 26738, 26741, 26744, 26747, 279, 109421, 26774, 26777, 26780, 26783, 26786, 26789, 26792, 26795, 26798, 26801, 26804, 26825, 26828, 26831, 26834, 26837, 26840, 28436, 28433, 33770, 33773, 33776, 33779, 50063, 50066, 50069, 50072, 50075, 50081, 50084, 50087, 55703, 55745, 55748, 55751, 65978, 26930, 77663, 77666, 77669, 373, 77672, 77675, 77678, 77681, 77684, 77705, 77708, 77729, 77732, 77735, 77753, 77756, 77759, 81293, 82406, 82409, 82412, 82424, 82436, 82439, 82442, 82445, 82448, 82451, 82454, 82457, 82460, 82463, 87911, 87914, 87917, 87920, 87923, 87926, 95198, 95201, 95204, 95207, 95210, 95213, 95216, 95267, 95270, 95273, 96467, 96470, 96473, 96476, 96533, 96536, 96539, 96542, 96545, 264, 96548, 96551, 96554, 96557, 96560, 96563, 96566, 96569, 96572, 96575, 96578, 96581, 96584, 96494, 96497, 96500, 96503, 96506, 96509, 96590, 96593, 96596, 96599, 96602, 96605, 96608, 96611, 96614, 96617, 96620, 98180, 98183, 98186, 98189, 98192, 98195, 98198, 98201, 98204, 98207, 98210, 108356, 109430, 109433, 109436, 109439, 109442, 109445, 110066, 110078, 110027)) AND (t_d.attribute_id IN (45)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))