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(546, 558, 561, 562, 588, 697, 699, 763, 803, 968, 983, 1082, 1150, 1230, 1275, 1276, 1543, 1676, 1696, 1717, 1798, 1852, 1920, 1931, 1932, 1967, 2000, 2001, 2002, 2003, 2004, 2024, 2025, 2031, 2038, 2039, 2040, 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, 2377, 2379, 2380, 2381, 2382, 2391, 2407, 2438, 2439, 2441, 2442, 2449, 2460, 2461, 2463, 2464, 2467, 2468, 2470, 2471, 2472, 2473, 2474, 2479, 2481, 2483, 2484, 2487, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2503, 2504, 2508, 2512, 2513, 2517, 2528, 2530, 2533, 2534, 2535, 2536, 2537, 2538, 2546, 2547, 2548, 2554, 2559, 2560, 2561, 2563, 2569, 2570, 2571, 2572, 2577, 2586, 2588, 2589, 2601, 2602, 2603, 2604, 2615, 2616, 2617, 2674, 2675, 2676, 2696, 2700, 2704, 2705, 2706, 2707, 2708, 2709, 2710, 2711, 2712, 2713, 2714, 2716, 2717, 2718, 2719, 2720, 2724, 2725, 2726, 2727, 2796, 2798, 2799, 2800, 2802, 2803, 2809, 2810, 2812, 2813, 2821, 2822, 2824, 2832, 2833, 2838, 2839, 2862, 2863, 2864, 2865, 2866, 2867, 2868, 2870, 2871, 2872, 2908, 2909, 2913, 2914, 2915, 2916, 2918, 2919, 2920, 2921, 2922, 2923, 2924, 2925, 2926, 2931, 2940, 2941, 2967, 2968, 2969, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2992, 2995, 2996, 2998, 3161, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3214, 3215, 3216, 3228, 3282, 3293, 3294, 3298, 3303, 3305, 3306, 3307, 3309, 3322, 3323, 3324, 3325, 3327, 3342, 3344, 3367, 3374, 3386, 3392, 3393, 3401, 3402, 3403, 3406, 3407, 3410, 3411, 3412, 3413, 3414, 3415, 3418, 3419, 3435, 3437, 3443, 3456, 3458, 3469, 3470, 3471, 3477, 3478, 3479, 3480, 3481, 3490, 3492, 3496, 3539, 3540, 3542, 3543, 3544, 3547, 3565, 3566, 3567, 3568, 3581, 3584, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3596, 3598, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3609, 3610, 3611, 3612, 3653, 3655, 3674, 3676, 3677, 3678, 3679, 3680, 3685, 3697, 3698, 3699, 3709, 3710, 3715, 3717, 3718, 3721, 3722, 3723, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3736, 3737, 3738, 3764, 3765, 3766, 3767, 3768, 3775, 3813, 3814, 3841, 3842, 3850, 3851, 3854, 3856, 3874, 3879, 3908, 3909, 3948, 3949, 3950, 3963, 3964, 3969, 3980, 3981, 3982, 3984, 3985, 3987, 3988, 3989, 3994, 4003, 4007, 4022, 4023, 4024, 4049, 4050, 4051, 4061, 4064, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4092, 4095, 4102, 4117, 4163, 4164, 4165, 4188, 4189, 4190, 4191, 4192, 4194, 4195, 4201, 4204, 4220, 4221, 4222, 4223, 4224, 4226, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4247, 4248, 4249, 4250, 4251, 4252, 4255, 4260, 4262, 4274, 4275, 4276, 4281, 4290, 4293, 4294, 4295, 4297, 4298, 4299, 4301, 4315, 4316, 4317, 4321, 4335, 4349, 4350, 4351, 4356, 4361, 4363, 4368, 4379, 4380, 4409, 4410, 4411, 4440, 4441, 4442, 4463, 4465, 4466, 4468, 4469, 4470, 4471, 4472, 4478, 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, 4665, 4697, 4730, 4735, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4768, 4769, 4774, 4775, 4777, 4778, 4779, 4780, 4781, 4782, 4783, 4784, 4785, 4787, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4800, 4801, 4802, 4803, 4804, 4805, 4806, 4807, 4808, 4809, 4810, 4814, 4815, 4816, 4818, 4822, 4823, 4824, 4825, 4826, 4834, 4835, 4836, 4837, 4838, 4841, 4844, 4845, 4847, 4849, 4850, 4851, 4852, 4859, 4863, 4864, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4879, 4880, 4881, 4882, 4893, 4896, 4909, 4910, 4911, 4929, 4939, 4942, 4943, 4944, 4999, 5033, 5035, 5049, 5062, 5063, 5064, 5065, 5080, 5081, 5082, 5083, 5086, 5090, 5091, 5094, 5095, 5096, 5116, 5119, 5129, 5130, 5131, 5132, 5133, 5134, 5135, 5138, 5143, 5147, 5172, 5200, 5201, 5209, 5214, 5216, 5217, 5218, 5219, 5220, 5285, 5315, 5321, 5322, 5323, 5351, 5352, 5353, 5358, 5362, 5363, 5364, 5385, 5386, 5387, 5392, 5393, 5395, 5412, 5415, 5430, 5459, 5465, 5466, 5467, 5468, 5470, 5471, 5482, 5489, 5490, 5491, 5492, 5493, 5495, 5496, 5497, 5504, 5539, 5540, 5541, 5571, 5586, 5587, 5588, 5589, 5590, 5591, 5592, 5596, 5599, 5600, 5603, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5628, 5629, 5630, 5631, 5632, 5640, 5641, 5642, 5692, 5693, 5695, 5703, 5708, 5709, 5734, 5735, 5736, 5760, 5761, 5816, 5834, 5867, 5868, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5911, 5919, 5925, 5926, 5927, 6043, 6129, 6130, 6131, 6132, 6133, 6158, 6194, 6195, 6196, 6206, 6207, 6208, 6209, 6210, 6212, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6243, 6252, 6268, 6273, 6274, 6275, 6276, 6286, 6322, 6334, 6358, 6416, 6431, 6433, 6434, 6435, 6436, 6445, 6457, 6501, 6502, 6503, 6504, 6505, 6506, 6514, 6515, 6516, 6588, 6589, 6590, 6605, 6606, 6612, 6613, 6614, 6637, 6638, 6639, 6640, 6641, 6642, 6643, 6644, 6645, 6646, 6647, 6731, 6732, 6733, 6741, 6743, 6746, 6747, 6748, 6749, 6750, 6755, 6758, 6759, 6761, 6766, 6767, 6768, 6775, 6786, 6823, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6833, 6834, 6835, 6836, 6837, 6838, 6850, 6873, 6875, 6880, 6881, 6882, 6883, 6884, 6889, 6890, 6900, 6901, 6902, 6928, 6929, 6930, 6931, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6945, 6946, 6954, 6955, 6957, 6962, 6988, 7000, 7001, 7006, 7007, 7008, 7012)) ORDER BY FIELD(`e`.`entity_id`, 7001, 6889, 6614, 6613, 6612, 6606, 6605, 6208, 6207, 6206, 5736, 5735, 5734, 5612, 5392, 5353, 5352, 5351, 3994, 3738, 3735, 3324, 3228, 3215, 3207, 3205, 2941, 2710, 2617, 2615, 2559, 2554, 2483, 2473, 2472, 2468, 2373, 2371, 2245, 2231, 2216, 2153, 2148, 2147, 2146, 2145, 2064, 2042, 7012, 7008, 7007, 7006, 7000, 6988, 6962, 6957, 6955, 6954, 6946, 6945, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6931, 6930, 6929, 6928, 6902, 6901, 6900, 6890, 6884, 6883, 6882, 6881, 6880, 6875, 6873, 6850, 6837, 6836, 6835, 6834, 6833, 6831, 6830, 6828, 6827, 6826, 6825, 6823, 6786, 6775, 6768, 6767, 6761, 6759, 6758, 6755, 6750, 6749, 6748, 6747, 6746, 6743, 6741, 6733, 6732, 6731, 6647, 6646, 6645, 6643, 6642, 6641, 6640, 6639, 6638, 6637, 6589, 6588, 6516, 6515, 6514, 6457, 6436, 6435, 6434, 6433, 6431, 6416, 6358, 6334, 6322, 6286, 6276, 6274, 6273, 6221, 6219, 6218, 6217, 6216, 6215, 6214, 6213, 6212, 6195, 6194, 6158, 6133, 6132, 6131, 6129, 5926, 5925, 5902, 5901, 5900, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5868, 5834, 5816, 5695, 5693, 5623, 5622, 5620, 5617, 5614, 5611, 5609, 5607, 5603, 5600, 5599, 5596, 5490, 5489, 5465, 5430, 5393, 5358, 5216, 5209, 5130, 5129, 5082, 5081, 5033, 4929, 4911, 4910, 4909, 4893, 4863, 4859, 4851, 4850, 4849, 4823, 4822, 4807, 4805, 4780, 4775, 4735, 4730, 4645, 4644, 4641, 4640, 4639, 4638, 4569, 4568, 4567, 4556, 4555, 4553, 4540, 4498, 4489, 4465, 4411, 4294, 4262, 4260, 4250, 4249, 4233, 4232, 4231, 4230, 4229, 4228, 4226, 4095, 4092, 4050, 4049, 3908, 3842, 3841, 3767, 3766, 3765, 3731, 3730, 3729, 3726, 3718, 3680, 3679, 3678, 3677, 3676, 3612, 3610, 3481, 3480, 3479, 3478, 3456, 3419, 3413, 3412, 3410, 3208, 2976, 2915, 2914, 2913, 2725, 2717, 2714, 2712, 2548, 2538, 2493, 2487, 2481, 2464, 2463, 2461, 2407, 2391, 2275, 2273, 2271, 2269, 2265, 2252, 2251, 2096, 2095, 2083, 2078, 2048, 2044, 2031, 2024, 1852, 1798, 1676, 1543, 1230, 803, 562, 561, 558, 546, 6838, 6829, 6766, 6644, 6590, 6506, 6505, 6504, 6503, 6502, 6501, 6445, 6275, 6268, 6252, 6243, 6220, 6210, 6209, 6196, 6130, 6043, 5927, 5919, 5911, 5906, 5905, 5904, 5903, 5899, 5898, 5890, 5889, 5888, 5867, 5761, 5760, 5709, 5708, 5703, 5692, 5642, 5641, 5640, 5632, 5631, 5630, 5629, 5628, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5610, 5608, 5592, 5591, 5590, 5589, 5588, 5587, 5586, 5571, 5541, 5540, 5539, 5504, 5497, 5496, 5495, 5493, 5492, 5491, 5482, 5471, 5470, 5468, 5467, 5466, 5459, 5415, 5412, 5395, 5387, 5386, 5385, 5364, 5363, 5362, 5323, 5322, 5321, 5315, 5285, 5220, 5219, 5218, 5217, 5214, 5201, 5200, 5172, 5147, 5143, 5138, 5135, 5134, 5133, 5132, 5131, 5119, 5116, 5096, 5095, 5094, 5091, 5090, 5086, 5083, 5080, 5065, 5064, 5063, 5062, 5049, 5035, 4999, 4944, 4943, 4942, 4939, 4896, 4882, 4881, 4880, 4879, 4877, 4876, 4875, 4874, 4873, 4872, 4871, 4864, 4852, 4847, 4845, 4844, 4841, 4838, 4837, 4836, 4835, 4834, 4826, 4825, 4824, 4818, 4816, 4815, 4814, 4810, 4809, 4808, 4806, 4804, 4803, 4802, 4801, 4800, 4798, 4797, 4796, 4795, 4794, 4793, 4792, 4791, 4790, 4787, 4785, 4784, 4783, 4782, 4781, 4779, 4778, 4777, 4774, 4769, 4768, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4697, 4665, 4649, 4648, 4647, 4646, 4637, 4636, 4609, 4594, 4558, 4557, 4554, 4551, 4550, 4549, 4548, 4509, 4508, 4506, 4505, 4488, 4487, 4486, 4485, 4484, 4478, 4472, 4471, 4470, 4469, 4468, 4466, 4463, 4442, 4441, 4440, 4410, 4409, 4380, 4379, 4368, 4363, 4361, 4356, 4351, 4350, 4349, 4335, 4321, 4317, 4316, 4315, 4301, 4299, 4298, 4297, 4295, 4293, 4290, 4281, 4276, 4275, 4274, 4255, 4252, 4251, 4248, 4247, 4235, 4234, 4224, 4223, 4222, 4221, 4220, 4204, 4201, 4195, 4194, 4192, 4191, 4190, 4189, 4188, 4165, 4164, 4163, 4117, 4102, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4064, 4061, 4051, 4024, 4023, 4022, 4007, 4003, 3989, 3988, 3987, 3985, 3984, 3982, 3981, 3980, 3969, 3964, 3963, 3950, 3949, 3948, 3909, 3879, 3874, 3856, 3854, 3851, 3850, 3814, 3813, 3775, 3768, 3764, 3737, 3736, 3734, 3733, 3732, 3728, 3727, 3725, 3723, 3722, 3721, 3717, 3715, 3710, 3709, 3699, 3698, 3697, 3685, 3674, 3655, 3653, 3611, 3609, 3606, 3605, 3604, 3603, 3601, 3600, 3599, 3598, 3596, 3594, 3593, 3592, 3591, 3590, 3589, 3588, 3587, 3586, 3584, 3581, 3568, 3567, 3566, 3565, 3547, 3544, 3543, 3542, 3540, 3539, 3496, 3492, 3490, 3477, 3471, 3470, 3469, 3458, 3443, 3437, 3435, 3418, 3415, 3414, 3411, 3407, 3406, 3403, 3402, 3401, 3393, 3392, 3386, 3374, 3367, 3344, 3342, 3327, 3325, 3323, 3322, 3309, 3307, 3306, 3305, 3303, 3298, 3294, 3293, 3282, 3216, 3214, 3210, 3209, 3206, 3204, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 3161, 2998, 2996, 2995, 2992, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2969, 2968, 2967, 2940, 2931, 2926, 2925, 2924, 2923, 2922, 2921, 2920, 2919, 2918, 2916, 2909, 2908, 2872, 2871, 2870, 2868, 2867, 2866, 2865, 2864, 2863, 2862, 2839, 2838, 2833, 2832, 2824, 2822, 2821, 2813, 2812, 2810, 2809, 2803, 2802, 2800, 2799, 2798, 2796, 2727, 2726, 2724, 2720, 2719, 2718, 2716, 2713, 2711, 2709, 2708, 2707, 2706, 2705, 2704, 2700, 2696, 2676, 2675, 2674, 2616, 2604, 2603, 2602, 2601, 2589, 2588, 2586, 2577, 2572, 2571, 2570, 2569, 2563, 2561, 2560, 2547, 2546, 2537, 2536, 2535, 2534, 2533, 2530, 2528, 2517, 2513, 2512, 2508, 2504, 2503, 2498, 2497, 2496, 2495, 2494, 2492, 2491, 2490, 2484, 2479, 2474, 2471, 2470, 2467, 2460, 2449, 2442, 2441, 2439, 2438, 2382, 2381, 2380, 2379, 2377, 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, 2040, 2039, 2038, 2025, 2004, 2003, 2002, 2001, 2000, 1967, 1932, 1931, 1920, 1717, 1696, 1276, 1275, 1150, 1082, 983, 968, 763, 699, 697, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
Giá thường:
250.000 ₫
Special Price
160.000 ₫
3228
-
Giá thường:
170.000 ₫
Special Price
119.000 ₫
3215
-
-
-
Giá thường:
1.500.000 ₫
Special Price
1.050.000 ₫
2710
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
2615
-
-
Giá thường:
110.000 ₫
Special Price
77.000 ₫
2371
-
-
Giá thường:
320.000 ₫
Special Price
224.000 ₫
2145
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
2064
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
2042
-
-
-
-
-
-
-
-
-
-
-