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 = 5 WHERE (e.entity_id IN (2300, 2298, 2299, 2301, 4485, 3204, 2303, 4445, 4068, 2819, 2302, 4446, 4069, 2999, 2304, 4070, 2793, 2305, 3035, 3107, 3149, 3172, 3187, 3295, 3313, 4004, 2794, 2820, 3005, 3036, 3108, 3150, 3173, 4073, 3296, 3385, 4005, 2801, 2839, 3000, 3051, 3109, 3151, 3174, 3189, 3297, 3322, 4006, 2810, 2861, 3056, 3110, 3175, 3298, 3314, 4007, 2875, 3001, 3063, 3111, 3299, 3315, 4008, 2885, 3002, 3068, 3112, 3154, 3177, 3300, 4600, 2306, 2890, 3004, 3069, 3113, 3178, 3301, 4601, 2898, 3003, 3077, 3114, 3179, 3194, 3302, 2909, 3033, 3080, 3180, 3303, 3317, 2913, 3034, 3081, 3116, 3181, 3196, 3304, 3318, 2928, 3086, 3117, 3197, 3305, 4424, 2943, 3092, 3183, 3306, 3319, 2958, 3095, 3119, 3184, 3307, 4602, 2973, 3096, 3120, 3185, 3200, 3308, 2974, 3097, 3186, 3309, 3321, 2988, 3098, 3202, 3310, 3123, 3311, 3324, 3103, 3124, 3312, 4603, 3104, 3125, 4437, 3127, 3327, 3128, 3328, 3129, 4604, 4605, 3131, 4606, 3132, 3329, 3133, 3330, 3134, 3331, 3135, 4607, 3136, 4610, 3137, 4608, 4609, 3139, 4611, 3140, 4612, 4613, 3142, 3332, 3143, 3333, 3144, 4614, 3145, 4615, 3146, 4616, 3147, 3334, 3148, 4617, 3335, 4618, 3336, 4619, 4620, 4621, 3337, 3338, 4622, 3339, 4623, 3340, 4624, 3341, 3342, 3344, 3345, 4625, 4626, 3346, 4627, 3348, 3349, 3350, 3351, 3352, 4628, 4629, 3353, 3355, 4630, 4631, 3356, 3357, 4632, 4634, 4633, 3359, 3360, 4635, 4636, 3361, 3362, 3363, 4637, 4638, 4639, 3364, 4640, 3365, 3366, 3367, 4641, 4419, 4642, 3368, 4643, 3369, 4644, 3370, 4645, 4646, 3371, 4647, 3372, 3373, 3374, 3375, 4648, 4649, 4650, 4651, 3377, 3378, 3380, 4652, 4653, 4654, 4655, 3383, 4656, 3384, 3386, 4657, 3387, 2795, 2803, 2811, 2821, 2840, 2862, 2876, 2886, 2891, 2899, 2910, 2914, 2929, 2944, 2959, 2975, 2989, 3006, 3037, 3052, 3057, 3064, 3070, 3078, 3082, 3087, 3093, 3099, 3105, 3155, 4074, 2796, 2804, 2812, 2822, 2841, 2863, 2877, 2887, 2892, 2900, 2915, 2930, 2945, 2960, 2976, 2990, 3009, 3038, 3053, 3058, 3065, 3071, 3079, 3083, 3088, 3094, 3156, 4075, 2797, 2805, 2813, 2823, 2842, 2878, 2893, 2901, 2916, 2931, 2946, 2977, 2991, 3010, 3039, 3054, 3059, 3066, 3072, 3084, 3089, 3101, 4076, 2798, 2806, 2814, 2824, 2843, 2866, 2879, 2889, 2894, 2902, 2917, 2932, 2947, 2962, 2978, 2992, 3013, 3040, 3055, 3060, 3067, 3073, 3085, 3090, 4077, 2807, 2815, 2825, 2844, 2867, 2880, 2895, 2903, 2918, 2933, 2948, 2963, 2979, 2993, 3016, 3041, 3061, 3074, 3091, 4078, 2800, 2808, 2816, 2826, 2845, 2868, 2896, 2904, 2919, 2934, 2949, 2964, 2980, 2994, 3019, 3042, 3075, 4079, 2817, 2827, 2846, 2869, 2897, 2905, 2920, 2935, 2950, 2965, 2981, 3022, 3043, 3076, 4080, 2818, 2828, 2847, 2870, 2906, 2921, 2936, 2951, 2966, 2982, 2996, 3023, 3044, 4081, 2829, 2848, 2871, 2907, 2922, 2937, 2952, 2967, 2983, 3028, 2830, 2849, 2872, 2908, 2923, 2938, 2953, 2968, 2984, 2998, 4089, 3046, 2831, 2850, 2873, 3457, 2939, 2954, 2969, 2985, 4105, 3047, 2832, 2851, 2874, 4430, 2940, 2955, 2970, 2986, 3048, 2833, 4441, 2941, 2956, 2987, 3049, 2834, 2853, 4481, 2942, 2957, 2972, 3050, 2835, 2854, 2836, 2855, 2837, 2856, 2838, 2857, 2858, 2859, 2860, 3406, 2924, 3007, 3011, 3014, 3017, 3020, 3031, 3024, 3029, 3157, 2925, 3008, 3012, 3015, 3018, 3021, 3032, 3025, 3030, 3158, 2926, 3026, 3159, 2927, 3027, 3160, 4090, 3161, 4186, 3162, 3163, 3164, 3165, 3166, 3167, 3168, 3169, 3171)) AND (t_d.attribute_id IN (45, 48, 215)) 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 = 5 WHERE (e.entity_id IN (2300, 2298, 2299, 2301, 4485, 3204, 2303, 4445, 4068, 2819, 2302, 4446, 4069, 2999, 2304, 4070, 2793, 2305, 3035, 3107, 3149, 3172, 3187, 3295, 3313, 4004, 2794, 2820, 3005, 3036, 3108, 3150, 3173, 4073, 3296, 3385, 4005, 2801, 2839, 3000, 3051, 3109, 3151, 3174, 3189, 3297, 3322, 4006, 2810, 2861, 3056, 3110, 3175, 3298, 3314, 4007, 2875, 3001, 3063, 3111, 3299, 3315, 4008, 2885, 3002, 3068, 3112, 3154, 3177, 3300, 4600, 2306, 2890, 3004, 3069, 3113, 3178, 3301, 4601, 2898, 3003, 3077, 3114, 3179, 3194, 3302, 2909, 3033, 3080, 3180, 3303, 3317, 2913, 3034, 3081, 3116, 3181, 3196, 3304, 3318, 2928, 3086, 3117, 3197, 3305, 4424, 2943, 3092, 3183, 3306, 3319, 2958, 3095, 3119, 3184, 3307, 4602, 2973, 3096, 3120, 3185, 3200, 3308, 2974, 3097, 3186, 3309, 3321, 2988, 3098, 3202, 3310, 3123, 3311, 3324, 3103, 3124, 3312, 4603, 3104, 3125, 4437, 3127, 3327, 3128, 3328, 3129, 4604, 4605, 3131, 4606, 3132, 3329, 3133, 3330, 3134, 3331, 3135, 4607, 3136, 4610, 3137, 4608, 4609, 3139, 4611, 3140, 4612, 4613, 3142, 3332, 3143, 3333, 3144, 4614, 3145, 4615, 3146, 4616, 3147, 3334, 3148, 4617, 3335, 4618, 3336, 4619, 4620, 4621, 3337, 3338, 4622, 3339, 4623, 3340, 4624, 3341, 3342, 3344, 3345, 4625, 4626, 3346, 4627, 3348, 3349, 3350, 3351, 3352, 4628, 4629, 3353, 3355, 4630, 4631, 3356, 3357, 4632, 4634, 4633, 3359, 3360, 4635, 4636, 3361, 3362, 3363, 4637, 4638, 4639, 3364, 4640, 3365, 3366, 3367, 4641, 4419, 4642, 3368, 4643, 3369, 4644, 3370, 4645, 4646, 3371, 4647, 3372, 3373, 3374, 3375, 4648, 4649, 4650, 4651, 3377, 3378, 3380, 4652, 4653, 4654, 4655, 3383, 4656, 3384, 3386, 4657, 3387, 2795, 2803, 2811, 2821, 2840, 2862, 2876, 2886, 2891, 2899, 2910, 2914, 2929, 2944, 2959, 2975, 2989, 3006, 3037, 3052, 3057, 3064, 3070, 3078, 3082, 3087, 3093, 3099, 3105, 3155, 4074, 2796, 2804, 2812, 2822, 2841, 2863, 2877, 2887, 2892, 2900, 2915, 2930, 2945, 2960, 2976, 2990, 3009, 3038, 3053, 3058, 3065, 3071, 3079, 3083, 3088, 3094, 3156, 4075, 2797, 2805, 2813, 2823, 2842, 2878, 2893, 2901, 2916, 2931, 2946, 2977, 2991, 3010, 3039, 3054, 3059, 3066, 3072, 3084, 3089, 3101, 4076, 2798, 2806, 2814, 2824, 2843, 2866, 2879, 2889, 2894, 2902, 2917, 2932, 2947, 2962, 2978, 2992, 3013, 3040, 3055, 3060, 3067, 3073, 3085, 3090, 4077, 2807, 2815, 2825, 2844, 2867, 2880, 2895, 2903, 2918, 2933, 2948, 2963, 2979, 2993, 3016, 3041, 3061, 3074, 3091, 4078, 2800, 2808, 2816, 2826, 2845, 2868, 2896, 2904, 2919, 2934, 2949, 2964, 2980, 2994, 3019, 3042, 3075, 4079, 2817, 2827, 2846, 2869, 2897, 2905, 2920, 2935, 2950, 2965, 2981, 3022, 3043, 3076, 4080, 2818, 2828, 2847, 2870, 2906, 2921, 2936, 2951, 2966, 2982, 2996, 3023, 3044, 4081, 2829, 2848, 2871, 2907, 2922, 2937, 2952, 2967, 2983, 3028, 2830, 2849, 2872, 2908, 2923, 2938, 2953, 2968, 2984, 2998, 4089, 3046, 2831, 2850, 2873, 3457, 2939, 2954, 2969, 2985, 4105, 3047, 2832, 2851, 2874, 4430, 2940, 2955, 2970, 2986, 3048, 2833, 4441, 2941, 2956, 2987, 3049, 2834, 2853, 4481, 2942, 2957, 2972, 3050, 2835, 2854, 2836, 2855, 2837, 2856, 2838, 2857, 2858, 2859, 2860, 3406, 2924, 3007, 3011, 3014, 3017, 3020, 3031, 3024, 3029, 3157, 2925, 3008, 3012, 3015, 3018, 3021, 3032, 3025, 3030, 3158, 2926, 3026, 3159, 2927, 3027, 3160, 4090, 3161, 4186, 3162, 3163, 3164, 3165, 3166, 3167, 3168, 3169, 3171)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))