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 (1768, 1223, 1227, 1246, 1233, 1406, 3975, 4069, 3355, 4048, 1234, 2009, 3312, 4173, 3153, 2902, 1231, 3732, 1329, 4172, 1555, 1343, 2903, 3175, 1380, 3516, 4156, 3553, 1441, 3518, 1760, 3080, 3696, 3801, 3584, 1864, 3751, 2960, 1228, 3316, 3320, 3314, 4126, 3717, 1324, 3229, 2175, 3213, 4129, 3694, 4132, 3230, 2893, 3701, 1643, 4125, 1300, 1562, 3839, 2955, 3319, 4113, 3597, 3131, 4119, 1637, 1758, 4088, 3128, 2190, 4110, 1501, 4098, 1842, 2468, 3955, 4050, 3996, 3418, 1282, 3283, 1309, 2201, 2553, 2642, 1761, 1267, 3401, 1401, 2568, 3451, 2901, 3024, 3167, 1279, 3826, 1583, 2537, 3863, 1288, 3941, 3477, 3679, 2989, 3678, 3946, 3496, 3680, 3697, 3691, 3295, 2897, 3677, 3558, 3693, 2974, 3791, 3939, 2668, 2410, 4056, 3647, 3779, 4179, 3225, 2766, 1984, 2975, 3382, 1277, 1483, 1515, 1304, 1525, 1330, 2963, 1314, 1932, 3051, 1764, 3426, 3695, 1252, 2015, 3924, 2409, 3326, 3534, 3121, 3592, 4148, 4150, 4165)) AND (t_d.attribute_id IN (41, 213, 220, 221, 222, 223, 224, 225, 226, 227, 243, 239, 244, 247, 250)) 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_text` AS `t_d` INNER JOIN `catalog_category_entity` AS `e` ON e.entity_id = t_d.entity_id LEFT JOIN `catalog_category_entity_text` 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 (1768, 1223, 1227, 1246, 1233, 1406, 3975, 4069, 3355, 4048, 1234, 2009, 3312, 4173, 3153, 2902, 1231, 3732, 1329, 4172, 1555, 1343, 2903, 3175, 1380, 3516, 4156, 3553, 1441, 3518, 1760, 3080, 3696, 3801, 3584, 1864, 3751, 2960, 1228, 3316, 3320, 3314, 4126, 3717, 1324, 3229, 2175, 3213, 4129, 3694, 4132, 3230, 2893, 3701, 1643, 4125, 1300, 1562, 3839, 2955, 3319, 4113, 3597, 3131, 4119, 1637, 1758, 4088, 3128, 2190, 4110, 1501, 4098, 1842, 2468, 3955, 4050, 3996, 3418, 1282, 3283, 1309, 2201, 2553, 2642, 1761, 1267, 3401, 1401, 2568, 3451, 2901, 3024, 3167, 1279, 3826, 1583, 2537, 3863, 1288, 3941, 3477, 3679, 2989, 3678, 3946, 3496, 3680, 3697, 3691, 3295, 2897, 3677, 3558, 3693, 2974, 3791, 3939, 2668, 2410, 4056, 3647, 3779, 4179, 3225, 2766, 1984, 2975, 3382, 1277, 1483, 1515, 1304, 1525, 1330, 2963, 1314, 1932, 3051, 1764, 3426, 3695, 1252, 2015, 3924, 2409, 3326, 3534, 3121, 3592, 4148, 4150, 4165)) AND (t_d.attribute_id IN (211, 214, 215, 216, 217, 218, 219, 229, 230, 233, 245, 246, 248, 249)) 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 (1768, 1223, 1227, 1246, 1233, 1406, 3975, 4069, 3355, 4048, 1234, 2009, 3312, 4173, 3153, 2902, 1231, 3732, 1329, 4172, 1555, 1343, 2903, 3175, 1380, 3516, 4156, 3553, 1441, 3518, 1760, 3080, 3696, 3801, 3584, 1864, 3751, 2960, 1228, 3316, 3320, 3314, 4126, 3717, 1324, 3229, 2175, 3213, 4129, 3694, 4132, 3230, 2893, 3701, 1643, 4125, 1300, 1562, 3839, 2955, 3319, 4113, 3597, 3131, 4119, 1637, 1758, 4088, 3128, 2190, 4110, 1501, 4098, 1842, 2468, 3955, 4050, 3996, 3418, 1282, 3283, 1309, 2201, 2553, 2642, 1761, 1267, 3401, 1401, 2568, 3451, 2901, 3024, 3167, 1279, 3826, 1583, 2537, 3863, 1288, 3941, 3477, 3679, 2989, 3678, 3946, 3496, 3680, 3697, 3691, 3295, 2897, 3677, 3558, 3693, 2974, 3791, 3939, 2668, 2410, 4056, 3647, 3779, 4179, 3225, 2766, 1984, 2975, 3382, 1277, 1483, 1515, 1304, 1525, 1330, 2963, 1314, 1932, 3051, 1764, 3426, 3695, 1252, 2015, 3924, 2409, 3326, 3534, 3121, 3592, 4148, 4150, 4165)) AND (t_d.attribute_id IN (212, 228, 231, 232, 242, 241, 240)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))