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 (514, 2186, 2182, 2183, 811, 515, 2598, 5058, 1051, 5957, 6152, 4915, 814, 6153, 815, 6154, 4348, 807, 6155, 6156, 3563, 809, 2062, 5038, 963, 960, 1262, 1226, 518, 519, 520, 6227, 6296, 4684, 526, 5929, 527, 528, 4215, 529, 3468, 4263, 2715, 4094, 3635, 4865, 4022, 2123, 4803, 5274, 1547, 4070, 5370, 541, 4594, 5325, 3969, 3939, 4503, 4351, 5327, 3801, 3938, 5238, 4740, 3430, 5355, 4851, 5378, 3503, 4654, 5351, 4673, 5231, 5479, 4198, 3850, 3629, 3558, 5065, 4600, 4227, 5993, 5496, 5917, 5105, 4023, 1862, 556, 5388, 5484, 6186, 4761, 4119, 4592, 1643, 3848, 5921, 818, 855, 916, 2165, 2320, 1253, 2319, 2322, 2321, 1774, 4578, 3812, 5395, 5203, 4504, 4989, 5219, 4674, 4917, 5039, 5379, 6252, 2187, 6160, 2202, 3557, 817, 856, 917, 2166, 1243, 1254, 1234, 1227, 1268, 1629, 1775, 4579, 5396, 5204, 4990, 4878, 5821, 6253, 2195, 6161, 2203, 6171, 1244, 1255, 1235, 1228, 1263, 1776, 4580, 5397, 5835, 4679, 4919, 5381, 6254, 2197, 6162, 2348, 6170, 3207, 1245, 1256, 4613, 1229, 1264, 1631, 1778, 4581, 5399, 5205, 4508, 4682, 6194, 5382, 6257, 6157, 6163, 6169, 2201, 4344, 637, 819, 1214, 2154, 1246, 1257, 1236, 1230, 1265, 2150, 1777, 4582, 5400, 5206, 4505, 5220, 4680, 5383, 6258, 6158, 6164, 2214, 2200, 6172, 821, 5357, 2157, 1247, 1258, 1237, 1231, 2141, 5438, 4583, 5401, 6003, 4506, 5221, 5380, 6259, 2193, 6181, 2210, 2209, 6173, 5319, 1209, 3774, 2164, 1248, 1259, 1238, 1232, 1266, 5439, 5323, 4584, 5402, 6004, 4507, 4991, 5222, 6300, 5045, 6260, 2189, 6165, 2211, 2208, 6174, 1074, 3209, 5116, 2155, 1249, 1260, 1239, 3037, 1267, 4738, 5403, 5207, 4509, 5224, 4879, 6301, 5046, 6261, 6159, 6166, 2206, 2205, 5350, 1376, 2156, 1250, 1261, 1240, 3036, 2137, 5903, 4586, 3823, 5404, 6256, 4510, 4992, 5223, 4677, 6302, 5047, 6262, 6167, 2207, 6178, 6175, 1216, 922, 2159, 1251, 1241, 4622, 4587, 5405, 4993, 4676, 5048, 6263, 6168, 6176, 2523, 822, 863, 3867, 4042, 1252, 1242, 5904, 4588, 3825, 5426, 4516, 4994, 5225, 4678, 5049, 6177, 4847, 859, 930, 2160, 3839, 4589, 5406, 4512, 5291, 5226, 4697, 5050, 6212, 4848, 1211, 862, 926, 2158, 5433, 3259, 3391, 4590, 3858, 5407, 4513, 4995, 5227, 4881, 5051, 4690, 2612, 864, 1315, 2161, 5434, 5347, 3933, 5408, 5292, 5228, 4681, 5052, 4692, 865, 928, 4596, 5435, 5906, 5959, 5494, 5409, 4996, 4696, 4849, 823, 861, 919, 2153, 5436, 5907, 5837, 3518, 5410, 4997, 4883, 5053, 1210, 860, 3402, 2162, 5437, 4635, 6204, 622, 3041, 2163, 4880, 5055, 827, 921, 4882, 5460, 4117, 2342, 5057, 5459, 828, 918, 4636, 4254, 5321, 2985, 4637, 4401, 2375, 3024, 4470, 5166, 4450, 829, 3914, 4543, 2773, 2287, 1218, 5910, 2719, 4839, 5998, 4607, 5773, 6043, 5158, 5964, 5980, 5981, 5982, 5983, 5984, 5985, 5986, 5987, 5988, 5989, 5990, 5991, 5992)) 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 = 3 WHERE (e.entity_id IN (514, 2186, 2182, 2183, 811, 515, 2598, 5058, 1051, 5957, 6152, 4915, 814, 6153, 815, 6154, 4348, 807, 6155, 6156, 3563, 809, 2062, 5038, 963, 960, 1262, 1226, 518, 519, 520, 6227, 6296, 4684, 526, 5929, 527, 528, 4215, 529, 3468, 4263, 2715, 4094, 3635, 4865, 4022, 2123, 4803, 5274, 1547, 4070, 5370, 541, 4594, 5325, 3969, 3939, 4503, 4351, 5327, 3801, 3938, 5238, 4740, 3430, 5355, 4851, 5378, 3503, 4654, 5351, 4673, 5231, 5479, 4198, 3850, 3629, 3558, 5065, 4600, 4227, 5993, 5496, 5917, 5105, 4023, 1862, 556, 5388, 5484, 6186, 4761, 4119, 4592, 1643, 3848, 5921, 818, 855, 916, 2165, 2320, 1253, 2319, 2322, 2321, 1774, 4578, 3812, 5395, 5203, 4504, 4989, 5219, 4674, 4917, 5039, 5379, 6252, 2187, 6160, 2202, 3557, 817, 856, 917, 2166, 1243, 1254, 1234, 1227, 1268, 1629, 1775, 4579, 5396, 5204, 4990, 4878, 5821, 6253, 2195, 6161, 2203, 6171, 1244, 1255, 1235, 1228, 1263, 1776, 4580, 5397, 5835, 4679, 4919, 5381, 6254, 2197, 6162, 2348, 6170, 3207, 1245, 1256, 4613, 1229, 1264, 1631, 1778, 4581, 5399, 5205, 4508, 4682, 6194, 5382, 6257, 6157, 6163, 6169, 2201, 4344, 637, 819, 1214, 2154, 1246, 1257, 1236, 1230, 1265, 2150, 1777, 4582, 5400, 5206, 4505, 5220, 4680, 5383, 6258, 6158, 6164, 2214, 2200, 6172, 821, 5357, 2157, 1247, 1258, 1237, 1231, 2141, 5438, 4583, 5401, 6003, 4506, 5221, 5380, 6259, 2193, 6181, 2210, 2209, 6173, 5319, 1209, 3774, 2164, 1248, 1259, 1238, 1232, 1266, 5439, 5323, 4584, 5402, 6004, 4507, 4991, 5222, 6300, 5045, 6260, 2189, 6165, 2211, 2208, 6174, 1074, 3209, 5116, 2155, 1249, 1260, 1239, 3037, 1267, 4738, 5403, 5207, 4509, 5224, 4879, 6301, 5046, 6261, 6159, 6166, 2206, 2205, 5350, 1376, 2156, 1250, 1261, 1240, 3036, 2137, 5903, 4586, 3823, 5404, 6256, 4510, 4992, 5223, 4677, 6302, 5047, 6262, 6167, 2207, 6178, 6175, 1216, 922, 2159, 1251, 1241, 4622, 4587, 5405, 4993, 4676, 5048, 6263, 6168, 6176, 2523, 822, 863, 3867, 4042, 1252, 1242, 5904, 4588, 3825, 5426, 4516, 4994, 5225, 4678, 5049, 6177, 4847, 859, 930, 2160, 3839, 4589, 5406, 4512, 5291, 5226, 4697, 5050, 6212, 4848, 1211, 862, 926, 2158, 5433, 3259, 3391, 4590, 3858, 5407, 4513, 4995, 5227, 4881, 5051, 4690, 2612, 864, 1315, 2161, 5434, 5347, 3933, 5408, 5292, 5228, 4681, 5052, 4692, 865, 928, 4596, 5435, 5906, 5959, 5494, 5409, 4996, 4696, 4849, 823, 861, 919, 2153, 5436, 5907, 5837, 3518, 5410, 4997, 4883, 5053, 1210, 860, 3402, 2162, 5437, 4635, 6204, 622, 3041, 2163, 4880, 5055, 827, 921, 4882, 5460, 4117, 2342, 5057, 5459, 828, 918, 4636, 4254, 5321, 2985, 4637, 4401, 2375, 3024, 4470, 5166, 4450, 829, 3914, 4543, 2773, 2287, 1218, 5910, 2719, 4839, 5998, 4607, 5773, 6043, 5158, 5964, 5980, 5981, 5982, 5983, 5984, 5985, 5986, 5987, 5988, 5989, 5990, 5991, 5992)) AND (t_d.attribute_id IN (569, 571, 574)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))