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 (14, 3282, 4743, 3202, 3097, 3021, 4763, 3074, 3188, 4757, 4657, 3992, 3254, 3288, 4655, 4672, 4744, 3279, 3289, 4673, 4745, 3280, 3102, 3290, 4661, 3281, 3103, 3292, 4668, 3283, 3114, 3291, 3284, 3150, 3287, 4666, 3285, 3115, 3116, 3286, 3106, 3117, 3104, 3108, 3118, 3109, 3119, 3112, 3120, 3113, 3121, 3122, 3123, 3128, 3124, 3129, 3125, 3130, 3126, 3131, 3127, 3132, 3133, 3134, 3135, 3149, 3152, 3151, 3710, 3723, 3724, 3096, 3731, 3732, 3734, 3740, 4451, 3294, 3302, 3310, 3350, 3358, 3366, 3566, 3422, 3614, 3993, 4452, 3255, 3326, 246, 253, 4752, 3374, 4746, 3079, 3256, 3318, 254, 4753, 4747, 3080, 4736, 3257, 3334, 245, 4754, 4748, 3081, 4737, 3342, 3032, 4755, 4749, 3082, 4738, 4756, 4750, 3083, 4739, 4751, 3084, 4740, 3085, 3086, 3018, 3019, 3035, 3044, 3045, 3046, 3047, 3048, 3265, 3266, 3267, 3268, 3269, 3270, 3271, 3272, 3273, 3274, 3275, 3276, 3277, 3278, 3295, 3296, 3297, 3298, 3299, 3300, 3301, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3311, 3312, 3313, 3314, 3315, 3316, 3317, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3328, 3329, 3330, 3333, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3344, 3346, 3347, 3348, 3349, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3360, 3365, 3368, 3371, 3373, 3376, 3423, 3429, 3441, 3447, 3455, 3463, 3567, 3573, 3585, 3591, 3599, 3607, 3615, 3621, 3633, 3639, 3647, 3655, 4001, 4013, 4007, 3995, 4004, 3998, 4010, 4016, 3994, 4019, 4023, 4025, 4026, 4029, 4031, 4040, 4041, 4044, 4047, 4048, 4049, 4051, 4054, 4055, 4056, 4057, 4065, 4068, 4069, 4070, 4076, 4079, 4080, 4081, 4083, 4084, 4085, 4087, 4088, 4090, 4092, 4097, 4104, 4105, 4106, 4108, 4110, 4113, 4114, 4115, 4116, 4117, 4122, 4123, 4127, 4136, 4144, 4145, 4147, 4148, 4154, 4159, 4160, 4161, 4165, 4166, 4170, 4171, 4172, 4173, 4174, 4175, 4177, 4185, 4186, 4187, 4189, 4195, 4201, 4202, 4203, 4209, 4210, 4211, 4212, 4217, 4225, 4226, 4227, 4228, 4233, 4234, 4235, 4244, 4245, 4246, 4247, 4248, 4250, 4252, 4261, 4264, 4266, 4268, 4269, 4272, 4273, 4274, 4284, 4285, 4286, 4291, 4294, 4298, 4304, 4305, 4307, 4310, 4312, 4314, 4315, 4324, 4325, 4326, 4327, 4328, 4330, 4331, 4340, 4349, 4350, 4351, 4357, 4358, 4359, 4366, 4367, 4368, 4371, 4379, 4387, 4392, 4399, 4400, 4408, 4411, 4412, 4417, 4426, 4427, 4428, 4430, 4433, 4434, 4436, 4438, 4439, 4440, 4442, 4450, 4454, 4463, 4464, 4466, 4467, 4468, 4470, 4471, 4472, 4481, 4482, 4483, 4492, 4499, 4503, 4504, 4505, 4508, 4513, 4514, 4516, 4522, 4524, 4525, 4526, 4529, 4532, 4533, 4535, 4536, 4537, 4538, 4539, 4540, 4541, 4547, 4553, 4562, 4563, 4564, 4565, 4570, 4571, 4572, 4581, 4582, 4591, 4594, 4596, 4598, 4600, 4601, 4610, 4611, 4614, 4623, 4625, 4627, 4628, 4629, 4637, 4640, 4647, 4648, 4652, 4653, 4654, 4656, 4669, 4670, 4676, 4685, 4691, 4697, 4706, 4453, 349, 354, 310, 364, 359, 3049, 3264, 3735, 3050, 350, 355, 313, 360, 3258, 3741, 351, 356, 315, 361, 3263, 352, 357, 316, 362, 3259, 3378, 353, 358, 317, 363, 3260, 3379, 3262, 3380, 3261, 3375, 3051, 3052, 3053, 3377, 3066, 3067, 3068, 3069, 3058, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3407, 3408, 3409, 3410, 3411, 3386, 3412, 3413, 3414, 3415, 3395, 3396, 3397, 3398, 3399, 3400, 3401, 3402, 3403, 3404, 3405, 3406, 3383, 3424, 3425, 3426, 3427, 3428, 3430, 3431, 3432, 3433, 3434, 3435, 3436, 3437, 3438, 3439, 3440, 3442, 3443, 3444, 3445, 3446, 3448, 3449, 3450, 3451, 3452, 3453, 3454, 3456, 3457, 3458, 3459, 3460, 3461, 3462, 3464, 3465, 3466, 3467, 3468, 3469, 3568, 3569, 3570, 3571, 3572, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3586, 3587, 3588, 3589, 3590, 3592, 3593, 3594, 3595, 3596, 3597, 3598, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3608, 3609, 3610, 3611, 3612, 3613, 3616, 3617, 3618, 3619, 3620, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3631, 3632, 3634, 3635, 3636, 3637, 3638, 3640, 3641, 3642, 3643, 3644, 3645, 3646, 3648, 3649, 3650, 3651, 3652, 3653, 3654, 3656, 3657, 3658, 3659, 3660, 3661, 3996, 3999, 4002, 4005, 4008, 4011, 4014, 4017, 380, 3055, 3387, 3418, 3420, 3421, 3381, 3056, 3394, 3382, 3054, 3388, 3057, 3389, 3385, 3390, 3384, 3391, 3416, 3392, 3393, 3417, 3419, 3997, 4021, 4038, 4053, 4064, 4075, 4094, 4102, 4133, 4140, 4156, 4163, 4181, 4215, 4218, 4229, 4239, 4255, 4263, 4271, 4277, 4283, 4290, 4293, 4322, 4332, 4341, 4370, 4374, 4384, 4388, 4397, 4401, 4425, 4443, 4460, 4473, 4485, 4518, 4534, 4542, 4548, 4559, 4576, 4590, 4597, 4605, 4619, 4635, 4643, 4667, 4671, 4683, 4687, 4699, 4000, 4033, 4046, 4050, 4058, 4072, 4091, 4095, 4112, 4124, 4131, 4139, 4157, 4164, 4180, 4198, 4205, 4243, 4254, 4275, 4302, 4323, 4338, 4347, 4363, 4378, 4393, 4406, 4421, 4441, 4456, 4475, 4484, 4495, 4501, 4511, 4545, 4551, 4558, 4567, 4578, 4587, 4593, 4608, 4612, 4615, 4638, 4641, 4650, 4659, 4680, 4690, 4703, 4003, 4028, 4037, 4045, 4060, 4066, 4101, 4107, 4121, 4132, 4143, 4152, 4167, 4184, 4193, 4197, 4204, 4216, 4220, 4230, 4241, 4249, 4251, 4257, 4279, 4287, 4292, 4303, 4309, 4319, 4329, 4333, 4348, 4355, 4360, 4376, 4381, 4390, 4405, 4416, 4418, 4448, 4457, 4479, 4489, 4498, 4519, 4528, 4554, 4569, 4577, 4586, 4602, 4618, 4633, 4642, 4665, 4684, 4686, 4705, 4006, 4027, 4039, 4052, 4062, 4067, 4073, 4089, 4099, 4111, 4138, 4150, 4155, 4169, 4200, 4206, 4224, 4231, 4242, 4259, 4281, 4300, 4313, 4320, 4334, 4346, 4352, 4361, 4372, 4386, 4402, 4409, 4415, 4423, 4446, 4461, 4469, 4480, 4490, 4496, 4527, 4546, 4550, 4560, 4566, 4573, 4585, 4592, 4607, 4621, 4636, 4644, 4662, 4678, 4698, 4009, 4024, 4032, 4061, 4096, 4103, 4119, 4125, 4128, 4141, 4146, 4168, 4178, 4192, 4208, 4214, 4221, 4232, 4237, 4260, 4262, 4265, 4276, 4297, 4317, 4335, 4344, 4364, 4369, 4375, 4382, 4391, 4395, 4407, 4410, 4424, 4429, 4447, 4455, 4465, 4478, 4487, 4493, 4502, 4507, 4510, 4515, 4517, 4523, 4530, 4544, 4557, 4574, 4589, 4603, 4620, 4626, 4632, 4639, 4645, 4664, 4681, 4692, 4700, 4012, 4022, 4034, 4059, 4078, 4086, 4093, 4109, 4118, 4134, 4142, 4149, 4158, 4182, 4191, 4196, 4207, 4213, 4222, 4240, 4258, 4270, 4282, 4289, 4295, 4306, 4311, 4316, 4336, 4343, 4356, 4362, 4373, 4383, 4389, 4398, 4404, 4414, 4422, 4432, 4449, 4458, 4476, 4488, 4497, 4500, 4506, 4512, 4552, 4556, 4568, 4580, 4584, 4599, 4609, 4613, 4616, 4630, 4646, 4663, 4674, 4679, 4702, 4015, 4035, 4043, 4074, 4077, 4098, 4126, 4130, 4137, 4151, 4162, 4183, 4190, 4199, 4223, 4238, 4256, 4267, 4278, 4288, 4296, 4299, 4308, 4318, 4337, 4345, 4353, 4365, 4377, 4380, 4394, 4420, 4435, 4437, 4444, 4462, 4477, 4486, 4494, 4509, 4520, 4531, 4543, 4555, 4579, 4583, 4604, 4617, 4634, 4649, 4658, 4677, 4689, 4693, 4704, 4018, 4020, 4030, 4036, 4042, 4063, 4071, 4082, 4100, 4120, 4129, 4135, 4153, 4176, 4179, 4188, 4194, 4219, 4236, 4253, 4280, 4301, 4321, 4339, 4342, 4354, 4385, 4396, 4403, 4413, 4419, 4431, 4445, 4459, 4474, 4491, 4521, 4549, 4561, 4575, 4588, 4595, 4606, 4622, 4624, 4631, 4651, 4660, 4675, 4682, 4688, 4701)) AND (t_d.attribute_id IN (41)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))