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 = 2 WHERE (e.entity_id IN (4, 96, 146, 2442, 2444, 2703, 2450, 2461, 2471, 2480, 230, 2484, 238, 2491, 181, 922, 2363, 2423, 182, 2636, 253, 2606, 780, 1388, 2353, 2481, 1414, 2388, 2435, 192, 211, 433, 3027, 2860, 2477, 2483, 201, 2567, 2395, 2430, 187, 234, 239, 2601, 220, 131, 2492, 2407, 2411, 1154, 232, 2556, 1165, 287, 216, 2472, 314, 1129, 97, 2419, 193, 231, 2512, 2451, 355, 218, 313, 115, 180, 2592, 2555, 2704, 1394, 2453, 356, 2482, 2401, 2418, 2589, 2528, 1385, 2374, 2509, 2790, 2759, 2490, 2445, 2498, 2497, 116, 1155, 2576, 363, 398, 2507, 1085, 1197, 2605, 1868, 2947, 1400, 2565, 2364, 2375, 2389, 2396, 2402, 2408, 2413, 2420, 2817, 2424, 2434, 294, 1101, 811, 1821, 2510, 2520, 2529, 1375, 2593, 2602, 1167, 2943, 256, 119, 1359, 2579, 852, 742, 2634, 2635, 2504, 2615, 2568, 2604, 1867, 2944, 2564, 2365, 2390, 2397, 2414, 2421, 2818, 2798, 2437, 292, 580, 2499, 2511, 2532, 2557, 126, 124, 118, 2578, 1162, 1433, 1369, 364, 391, 3006, 2552, 560, 2670, 2889, 1866, 2945, 2366, 2376, 2391, 98, 2404, 2415, 2416, 2438, 289, 2562, 249, 240, 2590, 1186, 396, 2779, 2946, 1401, 2563, 2367, 2392, 2412, 2422, 2427, 2832, 283, 812, 435, 2559, 221, 581, 2594, 2595, 122, 511, 388, 1104, 2501, 2672, 2571, 2587, 2992, 2368, 2393, 2417, 1389, 285, 296, 340, 436, 2561, 361, 254, 205, 189, 2616, 389, 421, 2502, 1387, 2369, 2429, 2431, 288, 2924, 252, 1395, 2617, 1010, 2782, 1871, 1384, 2370, 133, 2425, 2432, 2831, 2452, 248, 2550, 1016, 2780, 1869, 2371, 2825, 295, 1169, 2519, 815, 2781, 2372, 2823, 2833, 297, 360, 246, 413, 2505, 2373, 2428, 250, 2620, 2506, 359, 203, 1012, 101, 227, 2751, 1014, 2796, 362, 2750, 2922, 245, 243, 1374, 2626, 870, 2543, 1086, 1130, 2642, 1137, 1845, 2542, 1844, 3005)) AND (t_d.attribute_id IN (41, 304, 311, 312, 313, 314, 315, 316, 317, 318, 334, 330, 335, 338, 341)) 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 = 2 WHERE (e.entity_id IN (4, 96, 146, 2442, 2444, 2703, 2450, 2461, 2471, 2480, 230, 2484, 238, 2491, 181, 922, 2363, 2423, 182, 2636, 253, 2606, 780, 1388, 2353, 2481, 1414, 2388, 2435, 192, 211, 433, 3027, 2860, 2477, 2483, 201, 2567, 2395, 2430, 187, 234, 239, 2601, 220, 131, 2492, 2407, 2411, 1154, 232, 2556, 1165, 287, 216, 2472, 314, 1129, 97, 2419, 193, 231, 2512, 2451, 355, 218, 313, 115, 180, 2592, 2555, 2704, 1394, 2453, 356, 2482, 2401, 2418, 2589, 2528, 1385, 2374, 2509, 2790, 2759, 2490, 2445, 2498, 2497, 116, 1155, 2576, 363, 398, 2507, 1085, 1197, 2605, 1868, 2947, 1400, 2565, 2364, 2375, 2389, 2396, 2402, 2408, 2413, 2420, 2817, 2424, 2434, 294, 1101, 811, 1821, 2510, 2520, 2529, 1375, 2593, 2602, 1167, 2943, 256, 119, 1359, 2579, 852, 742, 2634, 2635, 2504, 2615, 2568, 2604, 1867, 2944, 2564, 2365, 2390, 2397, 2414, 2421, 2818, 2798, 2437, 292, 580, 2499, 2511, 2532, 2557, 126, 124, 118, 2578, 1162, 1433, 1369, 364, 391, 3006, 2552, 560, 2670, 2889, 1866, 2945, 2366, 2376, 2391, 98, 2404, 2415, 2416, 2438, 289, 2562, 249, 240, 2590, 1186, 396, 2779, 2946, 1401, 2563, 2367, 2392, 2412, 2422, 2427, 2832, 283, 812, 435, 2559, 221, 581, 2594, 2595, 122, 511, 388, 1104, 2501, 2672, 2571, 2587, 2992, 2368, 2393, 2417, 1389, 285, 296, 340, 436, 2561, 361, 254, 205, 189, 2616, 389, 421, 2502, 1387, 2369, 2429, 2431, 288, 2924, 252, 1395, 2617, 1010, 2782, 1871, 1384, 2370, 133, 2425, 2432, 2831, 2452, 248, 2550, 1016, 2780, 1869, 2371, 2825, 295, 1169, 2519, 815, 2781, 2372, 2823, 2833, 297, 360, 246, 413, 2505, 2373, 2428, 250, 2620, 2506, 359, 203, 1012, 101, 227, 2751, 1014, 2796, 362, 2750, 2922, 245, 243, 1374, 2626, 870, 2543, 1086, 1130, 2642, 1137, 1845, 2542, 1844, 3005)) AND (t_d.attribute_id IN (302, 305, 306, 307, 308, 309, 310, 320, 321, 324, 336, 337, 339, 340)) 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 = 2 WHERE (e.entity_id IN (4, 96, 146, 2442, 2444, 2703, 2450, 2461, 2471, 2480, 230, 2484, 238, 2491, 181, 922, 2363, 2423, 182, 2636, 253, 2606, 780, 1388, 2353, 2481, 1414, 2388, 2435, 192, 211, 433, 3027, 2860, 2477, 2483, 201, 2567, 2395, 2430, 187, 234, 239, 2601, 220, 131, 2492, 2407, 2411, 1154, 232, 2556, 1165, 287, 216, 2472, 314, 1129, 97, 2419, 193, 231, 2512, 2451, 355, 218, 313, 115, 180, 2592, 2555, 2704, 1394, 2453, 356, 2482, 2401, 2418, 2589, 2528, 1385, 2374, 2509, 2790, 2759, 2490, 2445, 2498, 2497, 116, 1155, 2576, 363, 398, 2507, 1085, 1197, 2605, 1868, 2947, 1400, 2565, 2364, 2375, 2389, 2396, 2402, 2408, 2413, 2420, 2817, 2424, 2434, 294, 1101, 811, 1821, 2510, 2520, 2529, 1375, 2593, 2602, 1167, 2943, 256, 119, 1359, 2579, 852, 742, 2634, 2635, 2504, 2615, 2568, 2604, 1867, 2944, 2564, 2365, 2390, 2397, 2414, 2421, 2818, 2798, 2437, 292, 580, 2499, 2511, 2532, 2557, 126, 124, 118, 2578, 1162, 1433, 1369, 364, 391, 3006, 2552, 560, 2670, 2889, 1866, 2945, 2366, 2376, 2391, 98, 2404, 2415, 2416, 2438, 289, 2562, 249, 240, 2590, 1186, 396, 2779, 2946, 1401, 2563, 2367, 2392, 2412, 2422, 2427, 2832, 283, 812, 435, 2559, 221, 581, 2594, 2595, 122, 511, 388, 1104, 2501, 2672, 2571, 2587, 2992, 2368, 2393, 2417, 1389, 285, 296, 340, 436, 2561, 361, 254, 205, 189, 2616, 389, 421, 2502, 1387, 2369, 2429, 2431, 288, 2924, 252, 1395, 2617, 1010, 2782, 1871, 1384, 2370, 133, 2425, 2432, 2831, 2452, 248, 2550, 1016, 2780, 1869, 2371, 2825, 295, 1169, 2519, 815, 2781, 2372, 2823, 2833, 297, 360, 246, 413, 2505, 2373, 2428, 250, 2620, 2506, 359, 203, 1012, 101, 227, 2751, 1014, 2796, 362, 2750, 2922, 245, 243, 1374, 2626, 870, 2543, 1086, 1130, 2642, 1137, 1845, 2542, 1844, 3005)) AND (t_d.attribute_id IN (303, 319, 322, 323, 333, 332, 331)) AND (t_d.store_id = IFNULL(t_s.store_id, 0))