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 = 58 WHERE (e.entity_id IN (2074, 2378, 93, 2666, 983, 2658, 2315, 38, 565, 123, 20, 2705, 95, 117, 2121, 86, 605, 26, 46, 442, 126, 115, 2297, 45, 2332, 98, 132, 2086, 2059, 2094, 2109, 2134, 2490, 2062, 1961, 160, 2380, 63, 981, 2381, 2373, 2136, 2375, 2363, 2364, 1119, 325, 2366, 2775, 2290, 140, 2349, 2080, 2353, 2120, 2807, 2809, 118, 2644, 127, 133, 2106, 2318, 566, 606, 2329, 2307, 2326, 990, 2063, 1198, 137, 111, 2298, 102, 2340, 2365, 2075, 2303, 100, 2292, 2078, 2350, 2731, 2354, 2118, 96, 2788, 2645, 128, 2341, 567, 607, 2330, 91, 991, 2064, 2639, 995, 138, 112, 2299, 2337, 2367, 2076, 2077, 2095, 2291, 2355, 2117, 2115, 121, 2682, 131, 134, 2108, 2320, 569, 2311, 2331, 2310, 2061, 2065, 2640, 2090, 2324, 113, 2300, 2317, 2335, 2659, 2667, 16, 55, 2082, 2356, 125, 2342, 568, 89, 2060, 2066, 2641, 994, 2325, 2111, 2357, 2301, 2726, 2334, 2073, 2696, 2708, 25, 2083, 2104, 2646, 130, 135, 2321, 2067, 2642, 2092, 2112, 2122, 2333, 2352, 2808, 2359, 120, 2655, 2105, 2322, 571, 982, 993, 2068, 2643, 2093, 2336, 2715, 2360, 711, 2647, 545, 989, 2069, 2114, 2339, 119, 2648, 1624, 988, 2070, 2338, 2721, 2649, 2126, 2071, 2723, 2650, 2127, 2097, 2725, 2288, 2131, 3012, 2374, 49, 2306, 307, 2130, 1138, 2308, 2766, 2309, 2765, 2132, 2343, 2128, 2129, 2133, 2125, 2767, 2815)) 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 = 58 WHERE (e.entity_id IN (2074, 2378, 93, 2666, 983, 2658, 2315, 38, 565, 123, 20, 2705, 95, 117, 2121, 86, 605, 26, 46, 442, 126, 115, 2297, 45, 2332, 98, 132, 2086, 2059, 2094, 2109, 2134, 2490, 2062, 1961, 160, 2380, 63, 981, 2381, 2373, 2136, 2375, 2363, 2364, 1119, 325, 2366, 2775, 2290, 140, 2349, 2080, 2353, 2120, 2807, 2809, 118, 2644, 127, 133, 2106, 2318, 566, 606, 2329, 2307, 2326, 990, 2063, 1198, 137, 111, 2298, 102, 2340, 2365, 2075, 2303, 100, 2292, 2078, 2350, 2731, 2354, 2118, 96, 2788, 2645, 128, 2341, 567, 607, 2330, 91, 991, 2064, 2639, 995, 138, 112, 2299, 2337, 2367, 2076, 2077, 2095, 2291, 2355, 2117, 2115, 121, 2682, 131, 134, 2108, 2320, 569, 2311, 2331, 2310, 2061, 2065, 2640, 2090, 2324, 113, 2300, 2317, 2335, 2659, 2667, 16, 55, 2082, 2356, 125, 2342, 568, 89, 2060, 2066, 2641, 994, 2325, 2111, 2357, 2301, 2726, 2334, 2073, 2696, 2708, 25, 2083, 2104, 2646, 130, 135, 2321, 2067, 2642, 2092, 2112, 2122, 2333, 2352, 2808, 2359, 120, 2655, 2105, 2322, 571, 982, 993, 2068, 2643, 2093, 2336, 2715, 2360, 711, 2647, 545, 989, 2069, 2114, 2339, 119, 2648, 1624, 988, 2070, 2338, 2721, 2649, 2126, 2071, 2723, 2650, 2127, 2097, 2725, 2288, 2131, 3012, 2374, 49, 2306, 307, 2130, 1138, 2308, 2766, 2309, 2765, 2132, 2343, 2128, 2129, 2133, 2125, 2767, 2815)) AND (t_d.attribute_id IN (224, 223)) 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 = 58 WHERE (e.entity_id IN (2074, 2378, 93, 2666, 983, 2658, 2315, 38, 565, 123, 20, 2705, 95, 117, 2121, 86, 605, 26, 46, 442, 126, 115, 2297, 45, 2332, 98, 132, 2086, 2059, 2094, 2109, 2134, 2490, 2062, 1961, 160, 2380, 63, 981, 2381, 2373, 2136, 2375, 2363, 2364, 1119, 325, 2366, 2775, 2290, 140, 2349, 2080, 2353, 2120, 2807, 2809, 118, 2644, 127, 133, 2106, 2318, 566, 606, 2329, 2307, 2326, 990, 2063, 1198, 137, 111, 2298, 102, 2340, 2365, 2075, 2303, 100, 2292, 2078, 2350, 2731, 2354, 2118, 96, 2788, 2645, 128, 2341, 567, 607, 2330, 91, 991, 2064, 2639, 995, 138, 112, 2299, 2337, 2367, 2076, 2077, 2095, 2291, 2355, 2117, 2115, 121, 2682, 131, 134, 2108, 2320, 569, 2311, 2331, 2310, 2061, 2065, 2640, 2090, 2324, 113, 2300, 2317, 2335, 2659, 2667, 16, 55, 2082, 2356, 125, 2342, 568, 89, 2060, 2066, 2641, 994, 2325, 2111, 2357, 2301, 2726, 2334, 2073, 2696, 2708, 25, 2083, 2104, 2646, 130, 135, 2321, 2067, 2642, 2092, 2112, 2122, 2333, 2352, 2808, 2359, 120, 2655, 2105, 2322, 571, 982, 993, 2068, 2643, 2093, 2336, 2715, 2360, 711, 2647, 545, 989, 2069, 2114, 2339, 119, 2648, 1624, 988, 2070, 2338, 2721, 2649, 2126, 2071, 2723, 2650, 2127, 2097, 2725, 2288, 2131, 3012, 2374, 49, 2306, 307, 2130, 1138, 2308, 2766, 2309, 2765, 2132, 2343, 2128, 2129, 2133, 2125, 2767, 2815)) AND (t_d.attribute_id IN (242)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))