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 (2977, 3, 5161, 33, 36, 34, 2591, 4982, 1050, 5956, 55, 6087, 39, 3133, 53, 56, 6088, 5, 50, 973, 6089, 25, 51, 2334, 6090, 12, 52, 2330, 6091, 7, 959, 11, 38, 9, 10, 4081, 1004, 3562, 6016, 4473, 2055, 5109, 42, 6007, 43, 44, 6226, 6295, 4683, 4461, 5925, 88, 89, 4214, 90, 3467, 91, 2844, 4864, 3636, 2122, 4785, 5271, 2254, 2488, 86, 4465, 503, 4700, 4593, 5324, 3787, 5471, 3936, 4492, 4349, 5326, 2532, 3937, 5237, 3750, 4739, 3431, 5067, 5354, 4850, 5371, 111, 4653, 4663, 2440, 5230, 5236, 4197, 5108, 2478, 3608, 5064, 4813, 3372, 4599, 6206, 3443, 4164, 4597, 4226, 5093, 2819, 5112, 1346, 1861, 3968, 3885, 5495, 5916, 2686, 5104, 5106, 4026, 4435, 5393, 5084, 5113, 120, 121, 5387, 5919, 5483, 6185, 4082, 4118, 4753, 126, 2311, 1642, 3847, 5920, 420, 473, 1274, 5352, 4385, 4656, 1898, 1899, 1900, 1897, 3060, 3077, 165, 198, 226, 241, 331, 398, 1184, 3092, 1005, 4527, 2514, 5930, 4564, 5242, 4427, 4614, 5197, 4436, 4638, 4480, 4493, 4973, 5209, 4668, 4771, 5078, 5452, 5131, 5373, 6097, 6103, 6116, 6127, 421, 456, 474, 67, 485, 3116, 4433, 4657, 1154, 1173, 1178, 1163, 3061, 3078, 166, 197, 227, 242, 332, 399, 3035, 1006, 4528, 2794, 5931, 415, 4565, 4361, 4432, 4615, 4379, 5202, 6264, 5922, 4974, 4872, 4772, 4755, 6297, 5083, 5453, 5358, 5492, 5820, 6266, 6229, 6093, 6094, 6117, 6128, 457, 5115, 2339, 3121, 4381, 4662, 128, 1153, 5029, 3046, 1160, 3063, 3080, 168, 203, 229, 1395, 2604, 1182, 3096, 4260, 5296, 2462, 1752, 2923, 3485, 3378, 4194, 4566, 4015, 5251, 5297, 4616, 5834, 4437, 5298, 4669, 4773, 5299, 6193, 5081, 5441, 5095, 5132, 6239, 5377, 5412, 6231, 6096, 6104, 6110, 6122, 6129, 470, 479, 482, 3138, 5032, 4659, 1152, 1170, 1175, 2617, 3064, 3081, 3194, 4285, 4542, 4261, 3034, 1011, 4533, 1853, 4195, 4567, 5252, 4428, 4617, 5201, 4438, 4643, 4497, 4672, 5275, 6298, 5082, 5446, 5133, 5375, 5413, 6232, 6098, 6105, 6118, 6130, 5037, 483, 5356, 3120, 5766, 1150, 1164, 1283, 1158, 3062, 3079, 3193, 3857, 1185, 3095, 1012, 4537, 3614, 5935, 4192, 4568, 6053, 5243, 4704, 4429, 4618, 5200, 4439, 4639, 4494, 5300, 5212, 4670, 4774, 5085, 5447, 5134, 5376, 5414, 6233, 6099, 6106, 6125, 6119, 6131, 417, 5235, 458, 475, 3861, 492, 3126, 4382, 4658, 1148, 5030, 1174, 1157, 3066, 3083, 2520, 5817, 4737, 1181, 3097, 1013, 4534, 2149, 5293, 5936, 4193, 4569, 5244, 4031, 4430, 4619, 6000, 4440, 4640, 4495, 5213, 4775, 5086, 5461, 5135, 5374, 5415, 6230, 6100, 6179, 6113, 6120, 6144, 27, 469, 477, 3242, 489, 3122, 4383, 4660, 4185, 1165, 1176, 1208, 3065, 3082, 189, 1183, 3098, 4595, 4535, 5432, 5322, 2901, 5933, 2589, 4570, 3790, 5245, 4431, 4620, 6001, 4577, 4641, 4477, 4496, 5289, 5211, 5468, 4776, 5080, 5448, 5136, 5416, 6235, 6101, 6107, 6114, 6121, 6132, 32, 427, 466, 66, 2107, 1270, 3117, 4384, 4661, 1073, 1151, 1166, 2616, 3067, 3084, 3196, 4710, 335, 3099, 4041, 5440, 3983, 5232, 5937, 4186, 5295, 5246, 5199, 4441, 4642, 4478, 4498, 4975, 5210, 4873, 4777, 5090, 5449, 5359, 5417, 6236, 6102, 6140, 6115, 6126, 6133, 3130, 3141, 476, 496, 3124, 4386, 1168, 2145, 4999, 3602, 3197, 1867, 3819, 1186, 3100, 1009, 4631, 5294, 4572, 5247, 4442, 4479, 5216, 4666, 4778, 6299, 5137, 5418, 6234, 6137, 6123, 6136, 6134, 18, 3145, 472, 2687, 1314, 3123, 1147, 1171, 3042, 4612, 3069, 3603, 3853, 3820, 3101, 1010, 4378, 5939, 4188, 4573, 5248, 4443, 4476, 4499, 4976, 4665, 4779, 5138, 5419, 6237, 6124, 6135, 429, 460, 1054, 2646, 488, 3125, 1146, 1172, 1681, 3085, 3199, 5107, 3962, 333, 2546, 3102, 1008, 5962, 5892, 2792, 5028, 5940, 4189, 4574, 4237, 5249, 6191, 4444, 4645, 4486, 4515, 4977, 5218, 4667, 4781, 5450, 5139, 5425, 6109, 6180, 31, 3144, 2575, 2556, 1275, 2769, 2587, 4822, 1167, 5031, 1156, 3453, 3202, 237, 3821, 2001, 3105, 1007, 4817, 3838, 4394, 409, 4575, 5250, 4079, 4445, 4703, 4485, 4500, 4978, 5217, 4694, 4780, 5091, 5451, 5353, 5420, 6022, 432, 65, 4310, 4196, 3118, 4823, 1149, 1169, 3076, 3087, 4843, 238, 245, 2000, 3104, 4529, 3988, 2518, 3136, 4576, 4446, 4730, 4475, 4501, 5290, 5214, 4875, 5068, 5456, 5140, 5125, 5421, 3048, 422, 461, 478, 494, 4870, 1495, 3072, 4844, 3030, 1951, 336, 1014, 4530, 6077, 3390, 5346, 4685, 4979, 5215, 4671, 5069, 5455, 5141, 5126, 5422, 4814, 428, 2555, 3595, 5025, 3088, 4687, 4252, 4818, 3505, 4134, 3103, 1016, 4531, 5894, 4708, 4190, 5493, 4474, 4980, 4695, 5070, 5442, 5142, 5489, 5423, 23, 5034, 459, 4491, 3119, 1155, 3073, 3090, 4688, 205, 3027, 3931, 5958, 4191, 5836, 4482, 4981, 4877, 5071, 5443, 5490, 5424, 68, 1161, 3075, 3089, 4845, 206, 3026, 3506, 5895, 6203, 5467, 4904, 5072, 5444, 5127, 2588, 425, 4821, 4986, 3074, 3192, 209, 3028, 3163, 3504, 5996, 4632, 4452, 2601, 4871, 4874, 5073, 5445, 434, 210, 240, 400, 5457, 5427, 4398, 5033, 4876, 5074, 5454, 5129, 424, 3195, 3268, 3508, 401, 5458, 5428, 6078, 414, 4483, 5075, 4253, 211, 4255, 4039, 3697, 5997, 5429, 5076, 3265, 4466, 5430, 5077, 24, 212, 236, 3987, 4449, 4521, 4467, 5431, 4633, 3383, 5079, 5807, 6207, 213, 3216, 4649, 4634, 2519, 6238, 5167, 3272, 1761, 5194, 2382, 4071, 3215, 247, 1661, 5165, 4707, 416, 4988, 3852, 232, 1660, 5769, 5000, 4200, 228, 1659, 5776, 3384, 5035, 216, 233, 1658, 5899, 2513, 1950, 1666, 4250, 246, 1665, 4271, 4201, 4709, 3264, 2718, 5233, 4949, 230, 4471, 5462, 2905, 5767, 4655, 4838, 2906, 204, 4387, 3849, 4060, 5234, 512, 5772, 2800, 2515, 1621, 1904, 2517, 5191, 234, 6042, 2090, 4088, 201, 2479, 2679, 6079, 2167, 3179, 1723, 4350, 1935, 3176, 4278, 4630, 5111, 2255, 5386, 1674, 239, 3329, 3330, 3333, 3877, 3331, 3878, 3332, 3334, 1792, 3322, 3335, 3934, 5163, 4728, 5157, 1296, 1740, 3336, 1741, 1742, 5963, 5965, 5976, 5971, 2285, 5972, 5970, 5973, 5966, 5967, 6058, 5977, 5968, 6057, 5969, 5974, 5975)) AND (t_d.attribute_id IN (41)) 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 (2977, 3, 5161, 33, 36, 34, 2591, 4982, 1050, 5956, 55, 6087, 39, 3133, 53, 56, 6088, 5, 50, 973, 6089, 25, 51, 2334, 6090, 12, 52, 2330, 6091, 7, 959, 11, 38, 9, 10, 4081, 1004, 3562, 6016, 4473, 2055, 5109, 42, 6007, 43, 44, 6226, 6295, 4683, 4461, 5925, 88, 89, 4214, 90, 3467, 91, 2844, 4864, 3636, 2122, 4785, 5271, 2254, 2488, 86, 4465, 503, 4700, 4593, 5324, 3787, 5471, 3936, 4492, 4349, 5326, 2532, 3937, 5237, 3750, 4739, 3431, 5067, 5354, 4850, 5371, 111, 4653, 4663, 2440, 5230, 5236, 4197, 5108, 2478, 3608, 5064, 4813, 3372, 4599, 6206, 3443, 4164, 4597, 4226, 5093, 2819, 5112, 1346, 1861, 3968, 3885, 5495, 5916, 2686, 5104, 5106, 4026, 4435, 5393, 5084, 5113, 120, 121, 5387, 5919, 5483, 6185, 4082, 4118, 4753, 126, 2311, 1642, 3847, 5920, 420, 473, 1274, 5352, 4385, 4656, 1898, 1899, 1900, 1897, 3060, 3077, 165, 198, 226, 241, 331, 398, 1184, 3092, 1005, 4527, 2514, 5930, 4564, 5242, 4427, 4614, 5197, 4436, 4638, 4480, 4493, 4973, 5209, 4668, 4771, 5078, 5452, 5131, 5373, 6097, 6103, 6116, 6127, 421, 456, 474, 67, 485, 3116, 4433, 4657, 1154, 1173, 1178, 1163, 3061, 3078, 166, 197, 227, 242, 332, 399, 3035, 1006, 4528, 2794, 5931, 415, 4565, 4361, 4432, 4615, 4379, 5202, 6264, 5922, 4974, 4872, 4772, 4755, 6297, 5083, 5453, 5358, 5492, 5820, 6266, 6229, 6093, 6094, 6117, 6128, 457, 5115, 2339, 3121, 4381, 4662, 128, 1153, 5029, 3046, 1160, 3063, 3080, 168, 203, 229, 1395, 2604, 1182, 3096, 4260, 5296, 2462, 1752, 2923, 3485, 3378, 4194, 4566, 4015, 5251, 5297, 4616, 5834, 4437, 5298, 4669, 4773, 5299, 6193, 5081, 5441, 5095, 5132, 6239, 5377, 5412, 6231, 6096, 6104, 6110, 6122, 6129, 470, 479, 482, 3138, 5032, 4659, 1152, 1170, 1175, 2617, 3064, 3081, 3194, 4285, 4542, 4261, 3034, 1011, 4533, 1853, 4195, 4567, 5252, 4428, 4617, 5201, 4438, 4643, 4497, 4672, 5275, 6298, 5082, 5446, 5133, 5375, 5413, 6232, 6098, 6105, 6118, 6130, 5037, 483, 5356, 3120, 5766, 1150, 1164, 1283, 1158, 3062, 3079, 3193, 3857, 1185, 3095, 1012, 4537, 3614, 5935, 4192, 4568, 6053, 5243, 4704, 4429, 4618, 5200, 4439, 4639, 4494, 5300, 5212, 4670, 4774, 5085, 5447, 5134, 5376, 5414, 6233, 6099, 6106, 6125, 6119, 6131, 417, 5235, 458, 475, 3861, 492, 3126, 4382, 4658, 1148, 5030, 1174, 1157, 3066, 3083, 2520, 5817, 4737, 1181, 3097, 1013, 4534, 2149, 5293, 5936, 4193, 4569, 5244, 4031, 4430, 4619, 6000, 4440, 4640, 4495, 5213, 4775, 5086, 5461, 5135, 5374, 5415, 6230, 6100, 6179, 6113, 6120, 6144, 27, 469, 477, 3242, 489, 3122, 4383, 4660, 4185, 1165, 1176, 1208, 3065, 3082, 189, 1183, 3098, 4595, 4535, 5432, 5322, 2901, 5933, 2589, 4570, 3790, 5245, 4431, 4620, 6001, 4577, 4641, 4477, 4496, 5289, 5211, 5468, 4776, 5080, 5448, 5136, 5416, 6235, 6101, 6107, 6114, 6121, 6132, 32, 427, 466, 66, 2107, 1270, 3117, 4384, 4661, 1073, 1151, 1166, 2616, 3067, 3084, 3196, 4710, 335, 3099, 4041, 5440, 3983, 5232, 5937, 4186, 5295, 5246, 5199, 4441, 4642, 4478, 4498, 4975, 5210, 4873, 4777, 5090, 5449, 5359, 5417, 6236, 6102, 6140, 6115, 6126, 6133, 3130, 3141, 476, 496, 3124, 4386, 1168, 2145, 4999, 3602, 3197, 1867, 3819, 1186, 3100, 1009, 4631, 5294, 4572, 5247, 4442, 4479, 5216, 4666, 4778, 6299, 5137, 5418, 6234, 6137, 6123, 6136, 6134, 18, 3145, 472, 2687, 1314, 3123, 1147, 1171, 3042, 4612, 3069, 3603, 3853, 3820, 3101, 1010, 4378, 5939, 4188, 4573, 5248, 4443, 4476, 4499, 4976, 4665, 4779, 5138, 5419, 6237, 6124, 6135, 429, 460, 1054, 2646, 488, 3125, 1146, 1172, 1681, 3085, 3199, 5107, 3962, 333, 2546, 3102, 1008, 5962, 5892, 2792, 5028, 5940, 4189, 4574, 4237, 5249, 6191, 4444, 4645, 4486, 4515, 4977, 5218, 4667, 4781, 5450, 5139, 5425, 6109, 6180, 31, 3144, 2575, 2556, 1275, 2769, 2587, 4822, 1167, 5031, 1156, 3453, 3202, 237, 3821, 2001, 3105, 1007, 4817, 3838, 4394, 409, 4575, 5250, 4079, 4445, 4703, 4485, 4500, 4978, 5217, 4694, 4780, 5091, 5451, 5353, 5420, 6022, 432, 65, 4310, 4196, 3118, 4823, 1149, 1169, 3076, 3087, 4843, 238, 245, 2000, 3104, 4529, 3988, 2518, 3136, 4576, 4446, 4730, 4475, 4501, 5290, 5214, 4875, 5068, 5456, 5140, 5125, 5421, 3048, 422, 461, 478, 494, 4870, 1495, 3072, 4844, 3030, 1951, 336, 1014, 4530, 6077, 3390, 5346, 4685, 4979, 5215, 4671, 5069, 5455, 5141, 5126, 5422, 4814, 428, 2555, 3595, 5025, 3088, 4687, 4252, 4818, 3505, 4134, 3103, 1016, 4531, 5894, 4708, 4190, 5493, 4474, 4980, 4695, 5070, 5442, 5142, 5489, 5423, 23, 5034, 459, 4491, 3119, 1155, 3073, 3090, 4688, 205, 3027, 3931, 5958, 4191, 5836, 4482, 4981, 4877, 5071, 5443, 5490, 5424, 68, 1161, 3075, 3089, 4845, 206, 3026, 3506, 5895, 6203, 5467, 4904, 5072, 5444, 5127, 2588, 425, 4821, 4986, 3074, 3192, 209, 3028, 3163, 3504, 5996, 4632, 4452, 2601, 4871, 4874, 5073, 5445, 434, 210, 240, 400, 5457, 5427, 4398, 5033, 4876, 5074, 5454, 5129, 424, 3195, 3268, 3508, 401, 5458, 5428, 6078, 414, 4483, 5075, 4253, 211, 4255, 4039, 3697, 5997, 5429, 5076, 3265, 4466, 5430, 5077, 24, 212, 236, 3987, 4449, 4521, 4467, 5431, 4633, 3383, 5079, 5807, 6207, 213, 3216, 4649, 4634, 2519, 6238, 5167, 3272, 1761, 5194, 2382, 4071, 3215, 247, 1661, 5165, 4707, 416, 4988, 3852, 232, 1660, 5769, 5000, 4200, 228, 1659, 5776, 3384, 5035, 216, 233, 1658, 5899, 2513, 1950, 1666, 4250, 246, 1665, 4271, 4201, 4709, 3264, 2718, 5233, 4949, 230, 4471, 5462, 2905, 5767, 4655, 4838, 2906, 204, 4387, 3849, 4060, 5234, 512, 5772, 2800, 2515, 1621, 1904, 2517, 5191, 234, 6042, 2090, 4088, 201, 2479, 2679, 6079, 2167, 3179, 1723, 4350, 1935, 3176, 4278, 4630, 5111, 2255, 5386, 1674, 239, 3329, 3330, 3333, 3877, 3331, 3878, 3332, 3334, 1792, 3322, 3335, 3934, 5163, 4728, 5157, 1296, 1740, 3336, 1741, 1742, 5963, 5965, 5976, 5971, 2285, 5972, 5970, 5973, 5966, 5967, 6058, 5977, 5968, 6057, 5969, 5974, 5975)) AND (t_d.attribute_id IN (569, 571, 574)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))