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 (1372, 2316, 983, 2785, 2371, 4431, 1401, 3060, 3342, 1387, 4837, 1408, 1417, 1381, 2292, 3891, 2294, 5094, 4419, 2301, 3, 2336, 12, 2408, 2434, 2409, 1079, 2418, 3249, 2602, 3588, 4206, 4347, 4353, 5050, 5082, 5103, 5106, 5109, 5112, 5115, 5118, 5121, 5224, 5251, 5254, 4966, 2364, 2430, 3408, 1420, 4260, 3717, 3591, 3441, 4840, 3246, 1424, 2365, 3501, 3462, 1423, 4287, 3405, 3594, 3444, 4843, 3198, 2410, 2367, 2438, 1409, 1422, 4320, 3402, 3597, 3447, 4846, 3675, 2162, 2368, 3387, 1410, 5059, 4323, 3396, 3600, 3450, 4849, 4089, 1386, 2366, 3534, 3732, 3399, 4779, 4852, 4344, 1383, 3390, 1403, 2317, 3393, 4782, 4855, 4428, 4167, 2326, 2319, 3711, 4858, 4476, 4170, 2325, 3885, 3714, 4861, 4719, 3486, 4815, 3726, 4864, 4722, 2324, 1411, 5248, 4867, 4725, 4191, 5053, 1412, 4870, 4728, 4194, 2320, 5056, 4873, 4731, 3474, 3453, 3984, 4876, 4734, 4197, 5080, 2318, 4879, 4368, 3261, 4392, 4882, 4918, 5178, 3882, 4885, 4921, 4386, 4888, 4924, 3459, 4891, 4927, 5077, 4894, 4930, 4897, 5097, 4900, 5100, 4903, 5193, 5068, 5196, 5199, 5202, 5205, 5206, 5209, 5227, 5230, 4939, 5233, 5236, 5242, 5245, 3537, 3903, 3957, 3969, 3900, 4698, 3468, 4785, 3477, 3966, 4527, 3273, 4380, 5133, 4665, 3480, 3489, 4377, 5085, 5124, 4611, 3465, 4329, 4116, 3735, 5130, 4173, 4263, 4290, 4326, 4455, 2369, 5181, 3276, 3906, 3960, 3972, 3990, 4710, 4701, 4530, 3810, 5175, 4668, 4740, 3492, 4548, 5172, 4638, 4614, 3798, 4332, 3504, 3738, 5136, 4176, 4266, 4293, 4458, 4425, 5184, 4383, 3909, 3975, 5029, 4713, 4788, 4533, 4389, 4671, 4743, 3495, 4551, 5215, 4641, 4605, 3801, 4335, 3507, 3741, 5139, 4179, 4269, 4296, 4461, 4704, 5187, 3645, 3912, 4524, 3978, 3996, 4791, 3822, 4746, 3498, 4554, 4644, 4608, 3804, 4338, 3519, 5142, 4272, 4299, 4464, 4707, 3633, 3918, 4906, 3981, 4017, 3471, 3843, 4680, 4749, 4557, 4656, 4617, 3852, 3543, 3747, 5145, 5157, 4275, 4467, 4969, 3639, 3933, 4536, 3999, 3807, 4677, 4752, 4560, 4632, 4620, 3849, 3510, 3753, 5148, 5160, 4278, 4305, 4470, 3654, 3936, 4539, 4002, 3825, 4686, 4755, 3456, 4647, 3846, 3513, 5151, 5163, 4308, 4473, 3666, 3939, 4005, 3831, 4689, 4758, 3531, 4650, 4134, 3750, 5154, 4284, 4311, 3636, 3942, 4008, 3828, 4716, 4761, 4653, 4242, 4452, 5166, 4341, 4314, 3657, 3945, 4011, 3816, 4683, 4764, 4626, 3522, 3759, 5169, 4317, 3651, 3948, 4020, 3819, 4692, 4767, 4659, 3516, 3774, 5212, 4545, 3951, 4023, 3834, 4695, 4770, 4629, 4161, 3765, 3669, 4026, 3813, 5127, 4623, 4152, 3762, 3642, 4794, 4029, 3837, 4662, 4128, 3783, 3663, 4032, 3879, 5065, 4140, 3768, 3660, 4800, 5062, 3858, 4122, 3792, 3678, 4803, 5190, 3873, 4119, 3780, 3708, 4806, 5218, 3867, 4137, 3789, 3687, 4809, 3861, 4239, 3771, 3702, 4812, 3870, 3525, 3786, 3699, 3876, 3528, 4449, 3648, 4395, 4257, 4446, 3681, 4398, 4146, 3795, 3684, 3855, 4125, 3777, 3696, 3864, 4245, 3693, 3840, 4158, 3690, 4251, 3705, 4164, 3546, 4149, 4131, 4542, 4248, 4254, 4143, 4434, 4374, 4401, 4437, 4404, 4440, 5221, 4443)) AND (t_d.attribute_id IN (45, 48, 141)) 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 = 1 WHERE (e.entity_id IN (1372, 2316, 983, 2785, 2371, 4431, 1401, 3060, 3342, 1387, 4837, 1408, 1417, 1381, 2292, 3891, 2294, 5094, 4419, 2301, 3, 2336, 12, 2408, 2434, 2409, 1079, 2418, 3249, 2602, 3588, 4206, 4347, 4353, 5050, 5082, 5103, 5106, 5109, 5112, 5115, 5118, 5121, 5224, 5251, 5254, 4966, 2364, 2430, 3408, 1420, 4260, 3717, 3591, 3441, 4840, 3246, 1424, 2365, 3501, 3462, 1423, 4287, 3405, 3594, 3444, 4843, 3198, 2410, 2367, 2438, 1409, 1422, 4320, 3402, 3597, 3447, 4846, 3675, 2162, 2368, 3387, 1410, 5059, 4323, 3396, 3600, 3450, 4849, 4089, 1386, 2366, 3534, 3732, 3399, 4779, 4852, 4344, 1383, 3390, 1403, 2317, 3393, 4782, 4855, 4428, 4167, 2326, 2319, 3711, 4858, 4476, 4170, 2325, 3885, 3714, 4861, 4719, 3486, 4815, 3726, 4864, 4722, 2324, 1411, 5248, 4867, 4725, 4191, 5053, 1412, 4870, 4728, 4194, 2320, 5056, 4873, 4731, 3474, 3453, 3984, 4876, 4734, 4197, 5080, 2318, 4879, 4368, 3261, 4392, 4882, 4918, 5178, 3882, 4885, 4921, 4386, 4888, 4924, 3459, 4891, 4927, 5077, 4894, 4930, 4897, 5097, 4900, 5100, 4903, 5193, 5068, 5196, 5199, 5202, 5205, 5206, 5209, 5227, 5230, 4939, 5233, 5236, 5242, 5245, 3537, 3903, 3957, 3969, 3900, 4698, 3468, 4785, 3477, 3966, 4527, 3273, 4380, 5133, 4665, 3480, 3489, 4377, 5085, 5124, 4611, 3465, 4329, 4116, 3735, 5130, 4173, 4263, 4290, 4326, 4455, 2369, 5181, 3276, 3906, 3960, 3972, 3990, 4710, 4701, 4530, 3810, 5175, 4668, 4740, 3492, 4548, 5172, 4638, 4614, 3798, 4332, 3504, 3738, 5136, 4176, 4266, 4293, 4458, 4425, 5184, 4383, 3909, 3975, 5029, 4713, 4788, 4533, 4389, 4671, 4743, 3495, 4551, 5215, 4641, 4605, 3801, 4335, 3507, 3741, 5139, 4179, 4269, 4296, 4461, 4704, 5187, 3645, 3912, 4524, 3978, 3996, 4791, 3822, 4746, 3498, 4554, 4644, 4608, 3804, 4338, 3519, 5142, 4272, 4299, 4464, 4707, 3633, 3918, 4906, 3981, 4017, 3471, 3843, 4680, 4749, 4557, 4656, 4617, 3852, 3543, 3747, 5145, 5157, 4275, 4467, 4969, 3639, 3933, 4536, 3999, 3807, 4677, 4752, 4560, 4632, 4620, 3849, 3510, 3753, 5148, 5160, 4278, 4305, 4470, 3654, 3936, 4539, 4002, 3825, 4686, 4755, 3456, 4647, 3846, 3513, 5151, 5163, 4308, 4473, 3666, 3939, 4005, 3831, 4689, 4758, 3531, 4650, 4134, 3750, 5154, 4284, 4311, 3636, 3942, 4008, 3828, 4716, 4761, 4653, 4242, 4452, 5166, 4341, 4314, 3657, 3945, 4011, 3816, 4683, 4764, 4626, 3522, 3759, 5169, 4317, 3651, 3948, 4020, 3819, 4692, 4767, 4659, 3516, 3774, 5212, 4545, 3951, 4023, 3834, 4695, 4770, 4629, 4161, 3765, 3669, 4026, 3813, 5127, 4623, 4152, 3762, 3642, 4794, 4029, 3837, 4662, 4128, 3783, 3663, 4032, 3879, 5065, 4140, 3768, 3660, 4800, 5062, 3858, 4122, 3792, 3678, 4803, 5190, 3873, 4119, 3780, 3708, 4806, 5218, 3867, 4137, 3789, 3687, 4809, 3861, 4239, 3771, 3702, 4812, 3870, 3525, 3786, 3699, 3876, 3528, 4449, 3648, 4395, 4257, 4446, 3681, 4398, 4146, 3795, 3684, 3855, 4125, 3777, 3696, 3864, 4245, 3693, 3840, 4158, 3690, 4251, 3705, 4164, 3546, 4149, 4131, 4542, 4248, 4254, 4143, 4434, 4374, 4401, 4437, 4404, 4440, 5221, 4443)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))