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 (10, 1372, 2788, 2316, 983, 2785, 3, 2408, 9, 12, 2434, 2743, 1079, 2171, 2178, 2188, 2189, 2190, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2313, 2348, 2349, 2350, 2373, 2374, 2375, 2378, 2379, 2401, 2406, 2411, 2413, 2422, 2423, 2424, 2425, 2427, 2428, 2435, 2436, 2437, 2440, 2441, 2443, 2444, 2445, 2446, 2448, 2454, 2455, 2458, 2459, 2461, 2462, 2465, 2467, 2470, 2473, 2476, 2479, 2482, 2485, 2488, 2491, 2494, 2497, 2500, 2518, 2521, 2524, 2527, 2530, 2533, 2539, 2542, 2545, 2548, 2551, 2557, 2560, 2566, 2572, 2575, 2578, 2584, 2587, 2590, 2593, 2596, 2614, 2620, 2623, 2626, 2629, 2632, 2635, 2638, 2641, 2644, 2647, 2650, 2653, 2659, 2662, 2668, 2671, 2674, 2677, 2686, 2689, 2692, 2695, 2701, 2704, 2710, 2713, 2719, 2725, 2728, 2731, 2734, 2737, 2746, 2752, 2755, 2767, 2770, 2075, 2857, 2824, 1381, 2284, 162, 2830, 2818, 2060, 2854, 2833, 1387, 2285, 161, 2905, 2791, 2074, 2875, 2899, 1401, 2286, 160, 2908, 2794, 2032, 2371, 2902, 1408, 2287, 2163, 2911, 2797, 2722, 2327, 2288, 2137, 2914, 2800, 1309, 2974, 1417, 2289, 159, 2917, 2803, 2076, 1822, 2291, 158, 2920, 2806, 1283, 2162, 2290, 157, 2923, 2809, 999, 2361, 2292, 156, 2926, 2812, 1158, 2362, 2293, 154, 2938, 2815, 784, 2294, 153, 2935, 2821, 2296, 151, 2941, 2297, 155, 2932, 476, 2298, 152, 2944, 606, 2299, 1356, 2929, 2300, 1355, 2394, 2301, 1354, 2390, 2336, 1353, 2389, 315, 2340, 1352, 2392, 2341, 1351, 2953, 2351, 1350, 2956, 2355, 1349, 2959, 2356, 1348, 2962, 2357, 1641, 2965, 246, 2358, 2827, 2968, 2359, 2407, 2947, 168, 2360, 2014, 2950, 532, 478, 2971, 2376, 2090, 2779, 2409, 2108, 2773, 2418, 2112, 2761, 2602, 2398, 2764, 173, 2776, 2399, 2758, 2782, 2400, 2749, 2402, 2698, 2043, 2403, 206, 2415, 1469, 2405, 211, 2192, 2416, 2195, 2404, 2196, 2197, 2200, 2312, 2347, 2417, 2449, 2460, 2463, 2503, 2506, 2509, 2512, 2707, 2536, 2608, 2554, 2569, 2599, 2617, 2716, 2740, 2199, 2089, 2109, 2150, 2167, 2170, 2191, 2193, 2315, 2354, 1059, 2426, 1514, 2429, 2447, 2452, 1640, 2457, 1739, 2611, 2665, 2683, 1848, 1970, 1988, 2039, 2064, 2161, 2107, 1377, 1374, 1442, 2177, 212, 1375, 1378, 1382, 1388, 1402, 1409, 1421, 1473, 11, 2067, 2180, 2117, 2136, 2164, 2328, 2352, 2836, 2839, 2860, 2878, 207, 1376, 1379, 1383, 1389, 1403, 1410, 2410, 1474, 1445, 2068, 2181, 2118, 2138, 2329, 2353, 2842, 2863, 2881, 208, 1384, 1398, 1404, 1411, 1422, 2119, 2139, 2330, 2845, 2866, 2884, 209, 1385, 1399, 1405, 1412, 1423, 2120, 2140, 2331, 2848, 2869, 2887, 288, 1386, 1400, 1406, 1413, 1424, 2121, 2141, 2851, 2872, 2890, 289, 2369, 2334, 1407, 1414, 1427, 2122, 2143, 2893, 290, 2335, 2320, 1415, 1428, 2123, 2433, 291, 2364, 2321, 1416, 1429, 2124, 259, 2365, 2322, 2317, 1823, 2125, 292, 2366, 2323, 2318, 2332, 293, 2367, 2324, 2319, 2333, 294, 2368, 2325, 2363, 1420, 2326, 2431, 2370, 2430, 2438, 1390, 1393, 1425, 2896, 1391, 1394, 1426, 1392, 1446, 1396)) AND (t_d.attribute_id IN (45, 48, 141)) 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 (10, 1372, 2788, 2316, 983, 2785, 3, 2408, 9, 12, 2434, 2743, 1079, 2171, 2178, 2188, 2189, 2190, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2313, 2348, 2349, 2350, 2373, 2374, 2375, 2378, 2379, 2401, 2406, 2411, 2413, 2422, 2423, 2424, 2425, 2427, 2428, 2435, 2436, 2437, 2440, 2441, 2443, 2444, 2445, 2446, 2448, 2454, 2455, 2458, 2459, 2461, 2462, 2465, 2467, 2470, 2473, 2476, 2479, 2482, 2485, 2488, 2491, 2494, 2497, 2500, 2518, 2521, 2524, 2527, 2530, 2533, 2539, 2542, 2545, 2548, 2551, 2557, 2560, 2566, 2572, 2575, 2578, 2584, 2587, 2590, 2593, 2596, 2614, 2620, 2623, 2626, 2629, 2632, 2635, 2638, 2641, 2644, 2647, 2650, 2653, 2659, 2662, 2668, 2671, 2674, 2677, 2686, 2689, 2692, 2695, 2701, 2704, 2710, 2713, 2719, 2725, 2728, 2731, 2734, 2737, 2746, 2752, 2755, 2767, 2770, 2075, 2857, 2824, 1381, 2284, 162, 2830, 2818, 2060, 2854, 2833, 1387, 2285, 161, 2905, 2791, 2074, 2875, 2899, 1401, 2286, 160, 2908, 2794, 2032, 2371, 2902, 1408, 2287, 2163, 2911, 2797, 2722, 2327, 2288, 2137, 2914, 2800, 1309, 2974, 1417, 2289, 159, 2917, 2803, 2076, 1822, 2291, 158, 2920, 2806, 1283, 2162, 2290, 157, 2923, 2809, 999, 2361, 2292, 156, 2926, 2812, 1158, 2362, 2293, 154, 2938, 2815, 784, 2294, 153, 2935, 2821, 2296, 151, 2941, 2297, 155, 2932, 476, 2298, 152, 2944, 606, 2299, 1356, 2929, 2300, 1355, 2394, 2301, 1354, 2390, 2336, 1353, 2389, 315, 2340, 1352, 2392, 2341, 1351, 2953, 2351, 1350, 2956, 2355, 1349, 2959, 2356, 1348, 2962, 2357, 1641, 2965, 246, 2358, 2827, 2968, 2359, 2407, 2947, 168, 2360, 2014, 2950, 532, 478, 2971, 2376, 2090, 2779, 2409, 2108, 2773, 2418, 2112, 2761, 2602, 2398, 2764, 173, 2776, 2399, 2758, 2782, 2400, 2749, 2402, 2698, 2043, 2403, 206, 2415, 1469, 2405, 211, 2192, 2416, 2195, 2404, 2196, 2197, 2200, 2312, 2347, 2417, 2449, 2460, 2463, 2503, 2506, 2509, 2512, 2707, 2536, 2608, 2554, 2569, 2599, 2617, 2716, 2740, 2199, 2089, 2109, 2150, 2167, 2170, 2191, 2193, 2315, 2354, 1059, 2426, 1514, 2429, 2447, 2452, 1640, 2457, 1739, 2611, 2665, 2683, 1848, 1970, 1988, 2039, 2064, 2161, 2107, 1377, 1374, 1442, 2177, 212, 1375, 1378, 1382, 1388, 1402, 1409, 1421, 1473, 11, 2067, 2180, 2117, 2136, 2164, 2328, 2352, 2836, 2839, 2860, 2878, 207, 1376, 1379, 1383, 1389, 1403, 1410, 2410, 1474, 1445, 2068, 2181, 2118, 2138, 2329, 2353, 2842, 2863, 2881, 208, 1384, 1398, 1404, 1411, 1422, 2119, 2139, 2330, 2845, 2866, 2884, 209, 1385, 1399, 1405, 1412, 1423, 2120, 2140, 2331, 2848, 2869, 2887, 288, 1386, 1400, 1406, 1413, 1424, 2121, 2141, 2851, 2872, 2890, 289, 2369, 2334, 1407, 1414, 1427, 2122, 2143, 2893, 290, 2335, 2320, 1415, 1428, 2123, 2433, 291, 2364, 2321, 1416, 1429, 2124, 259, 2365, 2322, 2317, 1823, 2125, 292, 2366, 2323, 2318, 2332, 293, 2367, 2324, 2319, 2333, 294, 2368, 2325, 2363, 1420, 2326, 2431, 2370, 2430, 2438, 1390, 1393, 1425, 2896, 1391, 1394, 1426, 1392, 1446, 1396)) AND (t_d.attribute_id IN (46)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))