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 = 3 WHERE (e.entity_id IN (2326, 42, 3, 5446, 844, 76, 2176, 2325, 2324, 2332, 2323, 169, 149, 778, 5475, 5477, 5441, 843, 2329, 47, 200, 65, 2492, 2495, 2497, 2498, 2506, 2510, 2511, 2512, 2513, 2514, 2515, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2528, 2529, 2530, 2553, 2582, 2585, 2589, 2616, 2617, 2621, 35, 5476, 5478, 183, 5469, 249, 2177, 788, 2551, 5393, 5479, 4, 75, 2208, 5470, 71, 39, 2180, 786, 2561, 5394, 165, 5480, 5588, 63, 2182, 776, 2559, 5395, 54, 5481, 2175, 206, 72, 2185, 773, 2554, 36, 5482, 48, 5483, 784, 2189, 2560, 5468, 170, 49, 5484, 2505, 2193, 765, 2547, 2550, 2552, 2555, 2556, 2558, 2562, 2564, 2565, 5440, 5485, 2504, 2195, 758, 2548, 5442, 253, 129, 345, 15, 5595, 2538, 2545, 161, 53, 783, 5585, 124, 5586, 5443, 5471, 5587, 5444, 5472, 5445, 5473, 5448, 5474, 5454, 304, 317, 251, 5490, 5491, 5492, 5493, 40, 98, 105, 121, 5487, 5488, 5489, 64, 66, 89, 194, 5589, 5466, 5486, 5566, 5567, 184, 207, 250, 346, 5518, 759, 5510, 5511, 5512, 5519, 5520, 5521, 5522, 5523, 5524, 5513, 5514, 5515, 5516, 5517, 785, 5528, 5529, 5530, 5531, 5532, 5533, 5534, 5535, 5507, 5508, 5509, 5414, 2178, 2181, 300, 2280, 288, 2196, 5572, 5573, 5574, 5575, 5576, 5577, 3432, 3436, 3458, 3459, 3460, 3461, 3462, 3467, 3469, 3472, 3473, 3482, 3527, 3529, 3532, 3542, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3639, 3640, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3648, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3661, 3666, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 3682, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 3690, 3691, 3692, 3693, 3694, 3695, 3696, 3762, 3772, 3774, 3784, 5504, 3845, 3846, 3857, 3868, 3869, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3880, 3881, 3882, 3888, 3889, 3891, 3892, 3893, 3894, 3897, 3898, 3899, 3900, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3909, 3910, 3911, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3920, 3922, 3923, 3924, 3926, 3927, 3931, 3939, 3940, 3946, 3948, 3949, 3950, 3951, 3952, 3954, 3955, 3956, 3957, 3958, 3960, 3962, 3976, 3977, 3978, 3988, 4089, 4091, 4104, 4151, 4152, 4153, 4154, 4156, 4160, 4337, 4338, 4357, 5397, 151, 150, 109, 104, 111, 5449, 5455, 55, 787, 5494, 5495, 5496, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 358, 5505, 5506, 777, 770, 5525, 350, 5526, 5527, 5536, 5537, 5538, 5539, 5540, 5541, 5542, 5543, 5544, 5545, 5546, 175, 5547, 5548, 5549, 5550, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5559, 5560, 173, 5561, 5562, 5563, 5564, 5565, 5568, 5569, 5570, 5571, 5578, 5579, 5580, 17, 323, 16, 308, 5597, 318, 41, 99, 107, 117, 88, 90, 195, 5590, 5467, 185, 208, 332, 347, 760, 3562, 5415, 2179, 2184, 298, 2170, 2194, 3484, 5409, 5408, 5421, 5407, 5611, 5423, 5412, 5410, 3662, 5420, 5411, 3862, 4129, 5392, 5398, 205, 106, 128, 112, 5450, 5456, 301, 3763, 780, 766, 59, 324, 2209, 5599, 306, 319, 96, 100, 108, 118, 130, 68, 91, 196, 5605, 186, 209, 333, 348, 5416, 2188, 2187, 285, 282, 5413, 5424, 2587, 5400, 5399, 123, 116, 113, 5451, 5457, 3751, 94, 320, 5601, 307, 321, 97, 101, 92, 197, 187, 210, 335, 351, 762, 5417, 284, 281, 5401, 132, 110, 114, 5452, 5603, 309, 322, 102, 120, 70, 325, 198, 188, 211, 352, 763, 5418, 2183, 280, 5402, 136, 5453, 310, 6, 122, 326, 189, 2173, 262, 353, 764, 5419, 2186, 5403, 1374, 311, 5405, 327, 355, 767, 2207, 4399, 86, 2309, 768, 5613, 115, 356, 769, 357, 772, 775, 5425, 5427, 5426, 5428, 5430, 5429, 5435, 5431, 5436, 5432, 5437, 5433, 5438, 5434)) AND (t_d.attribute_id IN (45, 48, 157)) AND (t_d.store_id = IFNULL(t_s.store_id, 0)) UNION ALL 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_int` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_int` 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 = 3 WHERE (e.entity_id IN (2326, 42, 3, 5446, 844, 76, 2176, 2325, 2324, 2332, 2323, 169, 149, 778, 5475, 5477, 5441, 843, 2329, 47, 200, 65, 2492, 2495, 2497, 2498, 2506, 2510, 2511, 2512, 2513, 2514, 2515, 2516, 2517, 2518, 2519, 2520, 2521, 2522, 2523, 2524, 2525, 2526, 2528, 2529, 2530, 2553, 2582, 2585, 2589, 2616, 2617, 2621, 35, 5476, 5478, 183, 5469, 249, 2177, 788, 2551, 5393, 5479, 4, 75, 2208, 5470, 71, 39, 2180, 786, 2561, 5394, 165, 5480, 5588, 63, 2182, 776, 2559, 5395, 54, 5481, 2175, 206, 72, 2185, 773, 2554, 36, 5482, 48, 5483, 784, 2189, 2560, 5468, 170, 49, 5484, 2505, 2193, 765, 2547, 2550, 2552, 2555, 2556, 2558, 2562, 2564, 2565, 5440, 5485, 2504, 2195, 758, 2548, 5442, 253, 129, 345, 15, 5595, 2538, 2545, 161, 53, 783, 5585, 124, 5586, 5443, 5471, 5587, 5444, 5472, 5445, 5473, 5448, 5474, 5454, 304, 317, 251, 5490, 5491, 5492, 5493, 40, 98, 105, 121, 5487, 5488, 5489, 64, 66, 89, 194, 5589, 5466, 5486, 5566, 5567, 184, 207, 250, 346, 5518, 759, 5510, 5511, 5512, 5519, 5520, 5521, 5522, 5523, 5524, 5513, 5514, 5515, 5516, 5517, 785, 5528, 5529, 5530, 5531, 5532, 5533, 5534, 5535, 5507, 5508, 5509, 5414, 2178, 2181, 300, 2280, 288, 2196, 5572, 5573, 5574, 5575, 5576, 5577, 3432, 3436, 3458, 3459, 3460, 3461, 3462, 3467, 3469, 3472, 3473, 3482, 3527, 3529, 3532, 3542, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3639, 3640, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3648, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3661, 3666, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 3682, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 3690, 3691, 3692, 3693, 3694, 3695, 3696, 3762, 3772, 3774, 3784, 5504, 3845, 3846, 3857, 3868, 3869, 3870, 3871, 3872, 3873, 3874, 3875, 3876, 3877, 3878, 3880, 3881, 3882, 3888, 3889, 3891, 3892, 3893, 3894, 3897, 3898, 3899, 3900, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3909, 3910, 3911, 3912, 3913, 3914, 3915, 3916, 3917, 3918, 3919, 3920, 3922, 3923, 3924, 3926, 3927, 3931, 3939, 3940, 3946, 3948, 3949, 3950, 3951, 3952, 3954, 3955, 3956, 3957, 3958, 3960, 3962, 3976, 3977, 3978, 3988, 4089, 4091, 4104, 4151, 4152, 4153, 4154, 4156, 4160, 4337, 4338, 4357, 5397, 151, 150, 109, 104, 111, 5449, 5455, 55, 787, 5494, 5495, 5496, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 358, 5505, 5506, 777, 770, 5525, 350, 5526, 5527, 5536, 5537, 5538, 5539, 5540, 5541, 5542, 5543, 5544, 5545, 5546, 175, 5547, 5548, 5549, 5550, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5559, 5560, 173, 5561, 5562, 5563, 5564, 5565, 5568, 5569, 5570, 5571, 5578, 5579, 5580, 17, 323, 16, 308, 5597, 318, 41, 99, 107, 117, 88, 90, 195, 5590, 5467, 185, 208, 332, 347, 760, 3562, 5415, 2179, 2184, 298, 2170, 2194, 3484, 5409, 5408, 5421, 5407, 5611, 5423, 5412, 5410, 3662, 5420, 5411, 3862, 4129, 5392, 5398, 205, 106, 128, 112, 5450, 5456, 301, 3763, 780, 766, 59, 324, 2209, 5599, 306, 319, 96, 100, 108, 118, 130, 68, 91, 196, 5605, 186, 209, 333, 348, 5416, 2188, 2187, 285, 282, 5413, 5424, 2587, 5400, 5399, 123, 116, 113, 5451, 5457, 3751, 94, 320, 5601, 307, 321, 97, 101, 92, 197, 187, 210, 335, 351, 762, 5417, 284, 281, 5401, 132, 110, 114, 5452, 5603, 309, 322, 102, 120, 70, 325, 198, 188, 211, 352, 763, 5418, 2183, 280, 5402, 136, 5453, 310, 6, 122, 326, 189, 2173, 262, 353, 764, 5419, 2186, 5403, 1374, 311, 5405, 327, 355, 767, 2207, 4399, 86, 2309, 768, 5613, 115, 356, 769, 357, 772, 775, 5425, 5427, 5426, 5428, 5430, 5429, 5435, 5431, 5436, 5432, 5437, 5433, 5438, 5434)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))