SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock`.`qty` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id WHERE (`e`.`entity_id` IN(632, 633, 634, 684, 697, 699, 896, 940, 949, 1164, 1225, 1230, 1276, 1336, 1550, 1572, 1595, 1603, 1610, 1633, 1650, 1652, 1713, 1714, 1717, 1789, 1790, 1791, 1862, 1864, 1931, 1932, 2000, 2001, 2002, 2003, 2004, 2024, 2025, 2031, 2038, 2041, 2042, 2043, 2044, 2046, 2047, 2048, 2059, 2061, 2062, 2063, 2064, 2065, 2075, 2076, 2077, 2078, 2080, 2081, 2082, 2083, 2085, 2086, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2105, 2106, 2108, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2132, 2139, 2141, 2142, 2145, 2146, 2147, 2148, 2151, 2153, 2159, 2160, 2163, 2175, 2181, 2183, 2184, 2190, 2191, 2198, 2199, 2200, 2205, 2216, 2217, 2218, 2219, 2223, 2231, 2240, 2245, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2283, 2284, 2285, 2287, 2293, 2294, 2300, 2301, 2302, 2305, 2306, 2307, 2308, 2318, 2320, 2321, 2322, 2326, 2331, 2332, 2334, 2355, 2360, 2361, 2362, 2363, 2371, 2373, 2375, 2379, 2380, 2381, 2382, 2391, 2407, 2438, 2439, 2441, 2442, 2467, 2468, 2472, 2473, 2474, 2483, 2484, 2512, 2513, 2517, 2528, 2533, 2534, 2535, 2536, 2537, 2538, 2554, 2559, 2560, 2561, 2563, 2569, 2570, 2571, 2572, 2577, 2586, 2588, 2589, 2601, 2602, 2603, 2604, 2615, 2616, 2617, 2674, 2675, 2676, 2696, 2710, 2711, 2712, 2713, 2796, 2798, 2799, 2800, 2802, 2803, 2805, 2806, 2821, 2822, 2824, 2832, 2833, 2838, 2839, 2864, 2865, 2866, 2867, 2868, 2908, 2909, 2931, 2940, 2941, 2967, 2968, 2969, 2992, 2995, 2996, 2998, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3209, 3214, 3237, 3238, 3239, 3324, 3325, 3326, 3342, 3359, 3360, 3361, 3367, 3381, 3384, 3386, 3401, 3402, 3403, 3406, 3407, 3415, 3418, 3435, 3437, 3456, 3458, 3469, 3470, 3471, 3477, 3478, 3479, 3480, 3481, 3539, 3540, 3542, 3544, 3547, 3565, 3566, 3567, 3568, 3587, 3588, 3589, 3610, 3611, 3612, 3643, 3653, 3654, 3655, 3657, 3674, 3685, 3697, 3698, 3699, 3715, 3721, 3722, 3723, 3724, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3736, 3737, 3738, 3746, 3747, 3748, 3749, 3750, 3753, 3755, 3756, 3757, 3758, 3759, 3763, 3764, 3765, 3766, 3767, 3768, 3769, 3770, 3850, 3851, 3854, 3889, 3891, 3895, 3897, 3908, 3909, 3914, 3972, 3977, 3982, 3984, 3985, 3988, 3989, 3994, 4007, 4022, 4023, 4024, 4092, 4098, 4099, 4100, 4101, 4112, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4188, 4189, 4190, 4191, 4192, 4194, 4195, 4204, 4247, 4248, 4249, 4250, 4251, 4252, 4262, 4292, 4321, 4335, 4349, 4350, 4369, 4381, 4382, 4383, 4384, 4385, 4386, 4453, 4466, 4468, 4469, 4470, 4471, 4472, 4480, 4481, 4482, 4484, 4485, 4486, 4487, 4488, 4489, 4498, 4505, 4506, 4508, 4509, 4540, 4548, 4549, 4550, 4551, 4553, 4554, 4555, 4556, 4557, 4558, 4567, 4568, 4569, 4594, 4609, 4636, 4637, 4638, 4639, 4640, 4641, 4644, 4645, 4646, 4647, 4648, 4649, 4651, 4664, 4665, 4666, 4685, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4696, 4702, 4703, 4716, 4738, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4800, 4801, 4802, 4803, 4804, 4805, 4806, 4807, 4808, 4809, 4810, 4826, 4834, 4835, 4836, 4837, 4841, 4844, 4847, 4879, 4937, 4938, 4940, 4941, 4945, 4963, 4964, 4965, 4966, 4967, 4976, 4999, 5059, 5060, 5061, 5066, 5067, 5072, 5086, 5090, 5091, 5129, 5130, 5131, 5147, 5172, 5216, 5221, 5225, 5251, 5252, 5253, 5254, 5257, 5258, 5259, 5260, 5261, 5290, 5319, 5351, 5352, 5353, 5358, 5385, 5386, 5387, 5392, 5412, 5415, 5427, 5468, 5484, 5491, 5492, 5493, 5529, 5569, 5570, 5571, 5572, 5573, 5574, 5575, 5576, 5577, 5587, 5588, 5593, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5632, 5634, 5644, 5645, 5646, 5703, 5708, 5709, 5734, 5735, 5736, 5768, 5769, 5770, 5834, 5860, 5861, 5862, 5863, 5864, 5865, 5866, 5919, 5933, 6043, 6129, 6130, 6131, 6132, 6133, 6157, 6158, 6162, 6164, 6165, 6175, 6176, 6177, 6188, 6189, 6190, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6225, 6243, 6252, 6283, 6288, 6289, 6290, 6291, 6292, 6316, 6379, 6380, 6381, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6405, 6406, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6457, 6466, 6468, 6469, 6514, 6515, 6516, 6605, 6606, 6607, 6608, 6609, 6610, 6611, 6612, 6613, 6614, 6636, 6681, 6682, 6683, 6687, 6688, 6720, 6721, 6722, 6724, 6725, 6727, 6728, 6729, 6731, 6732, 6733, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6760, 6761, 6766, 6767, 6771, 6772, 6793, 6880, 6881, 6882, 6883, 6889, 6891, 6892, 6893, 6894, 6945, 6963, 6971, 7000, 7001, 7033)) ORDER BY FIELD(`e`.`entity_id`, 3456, 2216, 2024, 7033, 7001, 7000, 6971, 6963, 6945, 6894, 6893, 6892, 6891, 6889, 6883, 6882, 6881, 6880, 6793, 6772, 6771, 6767, 6761, 6760, 6753, 6752, 6751, 6750, 6749, 6748, 6747, 6746, 6733, 6732, 6731, 6729, 6728, 6727, 6725, 6724, 6722, 6721, 6720, 6687, 6614, 6613, 6612, 6611, 6610, 6609, 6608, 6607, 6606, 6605, 6516, 6515, 6514, 6469, 6468, 6466, 6457, 6431, 6421, 6420, 6419, 6418, 6416, 6415, 6414, 6413, 6406, 6405, 6382, 6380, 6316, 6292, 6291, 6290, 6289, 6288, 6283, 6197, 6195, 6194, 6193, 6188, 6177, 6176, 6165, 6164, 6162, 6158, 6157, 6133, 6132, 6131, 6129, 5933, 5866, 5864, 5862, 5861, 5860, 5834, 5769, 5768, 5736, 5735, 5734, 5645, 5644, 5634, 5623, 5622, 5620, 5617, 5614, 5612, 5611, 5609, 5607, 5606, 5604, 5603, 5602, 5601, 5600, 5599, 5598, 5597, 5596, 5595, 5594, 5593, 5576, 5575, 5574, 5569, 5392, 5358, 5353, 5352, 5351, 5225, 5216, 5130, 5129, 5072, 4976, 4967, 4965, 4964, 4963, 4945, 4940, 4807, 4805, 4690, 4651, 4645, 4644, 4641, 4640, 4639, 4638, 4569, 4568, 4567, 4556, 4555, 4553, 4540, 4498, 4489, 4481, 4385, 4384, 4382, 4381, 4262, 4250, 4249, 4173, 4169, 4101, 4092, 3994, 3908, 3767, 3766, 3765, 3753, 3750, 3738, 3735, 3731, 3730, 3729, 3726, 3612, 3610, 3481, 3480, 3479, 3478, 3324, 2941, 2712, 2710, 2617, 2615, 2559, 2554, 2538, 2483, 2473, 2472, 2468, 2407, 2391, 2373, 2371, 2275, 2273, 2271, 2269, 2265, 2252, 2251, 2245, 2231, 2153, 2148, 2147, 2146, 2145, 2096, 2095, 2083, 2078, 2064, 2048, 2044, 2042, 2031, 1336, 1230, 1225, 940, 6766, 6688, 6683, 6682, 6681, 6636, 6417, 6390, 6389, 6388, 6387, 6386, 6385, 6384, 6383, 6381, 6379, 6252, 6243, 6225, 6199, 6198, 6196, 6190, 6189, 6175, 6130, 6043, 5919, 5865, 5863, 5770, 5709, 5708, 5703, 5646, 5632, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5610, 5608, 5605, 5588, 5587, 5577, 5573, 5572, 5571, 5570, 5529, 5493, 5492, 5491, 5484, 5468, 5427, 5415, 5412, 5387, 5386, 5385, 5319, 5290, 5261, 5260, 5259, 5258, 5257, 5254, 5253, 5252, 5251, 5221, 5172, 5147, 5131, 5091, 5090, 5086, 5067, 5066, 5061, 5060, 5059, 4999, 4966, 4941, 4938, 4937, 4879, 4847, 4844, 4841, 4837, 4836, 4835, 4834, 4826, 4810, 4809, 4808, 4806, 4804, 4803, 4802, 4801, 4800, 4798, 4797, 4796, 4795, 4794, 4793, 4792, 4791, 4790, 4738, 4716, 4703, 4702, 4696, 4693, 4692, 4691, 4689, 4688, 4687, 4685, 4666, 4665, 4664, 4649, 4648, 4647, 4646, 4637, 4636, 4609, 4594, 4558, 4557, 4554, 4551, 4550, 4549, 4548, 4509, 4508, 4506, 4505, 4488, 4487, 4486, 4485, 4484, 4482, 4480, 4472, 4471, 4470, 4469, 4468, 4466, 4453, 4386, 4383, 4369, 4350, 4349, 4335, 4321, 4292, 4252, 4251, 4248, 4247, 4204, 4195, 4194, 4192, 4191, 4190, 4189, 4188, 4175, 4174, 4172, 4171, 4170, 4112, 4100, 4099, 4098, 4024, 4023, 4022, 4007, 3989, 3988, 3985, 3984, 3982, 3977, 3972, 3914, 3909, 3897, 3895, 3891, 3889, 3854, 3851, 3850, 3770, 3769, 3768, 3764, 3763, 3759, 3758, 3757, 3756, 3755, 3749, 3748, 3747, 3746, 3737, 3736, 3734, 3733, 3732, 3728, 3727, 3725, 3724, 3723, 3722, 3721, 3715, 3699, 3698, 3697, 3685, 3674, 3657, 3655, 3654, 3653, 3643, 3611, 3589, 3588, 3587, 3568, 3567, 3566, 3565, 3547, 3544, 3542, 3540, 3539, 3477, 3471, 3470, 3469, 3458, 3437, 3435, 3418, 3415, 3407, 3406, 3403, 3402, 3401, 3386, 3384, 3381, 3367, 3361, 3360, 3359, 3342, 3326, 3325, 3239, 3238, 3237, 3214, 3209, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 2998, 2996, 2995, 2992, 2969, 2968, 2967, 2940, 2931, 2909, 2908, 2868, 2867, 2866, 2865, 2864, 2839, 2838, 2833, 2832, 2824, 2822, 2821, 2806, 2805, 2803, 2802, 2800, 2799, 2798, 2796, 2713, 2711, 2696, 2676, 2675, 2674, 2616, 2604, 2603, 2602, 2601, 2589, 2588, 2586, 2577, 2572, 2571, 2570, 2569, 2563, 2561, 2560, 2537, 2536, 2535, 2534, 2533, 2528, 2517, 2513, 2512, 2484, 2474, 2467, 2442, 2441, 2439, 2438, 2382, 2381, 2380, 2379, 2375, 2363, 2362, 2361, 2360, 2355, 2334, 2332, 2331, 2326, 2322, 2321, 2320, 2318, 2308, 2307, 2306, 2305, 2302, 2301, 2300, 2294, 2293, 2287, 2285, 2284, 2283, 2278, 2277, 2276, 2274, 2272, 2270, 2268, 2267, 2266, 2263, 2262, 2261, 2260, 2259, 2258, 2257, 2256, 2255, 2254, 2253, 2240, 2223, 2219, 2218, 2217, 2205, 2200, 2199, 2198, 2191, 2190, 2184, 2183, 2181, 2175, 2163, 2160, 2159, 2151, 2142, 2141, 2139, 2132, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2108, 2106, 2105, 2101, 2100, 2099, 2098, 2097, 2094, 2093, 2092, 2086, 2085, 2082, 2081, 2080, 2077, 2076, 2075, 2065, 2063, 2062, 2061, 2059, 2047, 2046, 2043, 2041, 2038, 2025, 2004, 2003, 2002, 2001, 2000, 1932, 1931, 1864, 1862, 1791, 1790, 1789, 1717, 1714, 1713, 1652, 1650, 1633, 1610, 1603, 1595, 1572, 1550, 1276, 1164, 949, 896, 699, 697, 684, 634, 633, 632) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36