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, 588, 763, 803, 968, 983, 1082, 1150, 1275, 1543, 1696, 1729, 1734, 1798, 1852, 1920, 1967, 2038, 2039, 2040, 2377, 2384, 2441, 2442, 2449, 2460, 2461, 2463, 2464, 2530, 2546, 2547, 2548, 2700, 2704, 2705, 2706, 2707, 2708, 2709, 2714, 2716, 2717, 2718, 2719, 2720, 2724, 2725, 2726, 2727, 2809, 2810, 2812, 2813, 2838, 2839, 2862, 2863, 2870, 2871, 2872, 2913, 2914, 2915, 2916, 2918, 2919, 2920, 2921, 2922, 2923, 2924, 2925, 2926, 2940, 2941, 2943, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3228, 3282, 3293, 3294, 3298, 3303, 3305, 3306, 3307, 3309, 3322, 3323, 3327, 3339, 3344, 3410, 3411, 3412, 3413, 3414, 3419, 3439, 3440, 3441, 3443, 3444, 3447, 3448, 3492, 3538, 3539, 3540, 3542, 3543, 3572, 3581, 3584, 3586, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3596, 3598, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3609, 3709, 3717, 3718, 3748, 3749, 3750, 3775, 3795, 3796, 3797, 3798, 3799, 3800, 3813, 3814, 3841, 3842, 3856, 3874, 3948, 3949, 3950, 3963, 3964, 3977, 3978, 3980, 3981, 4003, 4014, 4016, 4019, 4020, 4049, 4050, 4051, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4102, 4117, 4119, 4120, 4121, 4122, 4123, 4163, 4164, 4165, 4188, 4201, 4202, 4204, 4213, 4220, 4221, 4222, 4223, 4226, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4255, 4260, 4289, 4290, 4291, 4292, 4293, 4294, 4295, 4296, 4297, 4298, 4299, 4300, 4301, 4315, 4316, 4317, 4351, 4356, 4361, 4363, 4379, 4380, 4409, 4410, 4411, 4453, 4460, 4463, 4465, 4478, 4481, 4505, 4506, 4508, 4509, 4535, 4594, 4595, 4596, 4671, 4722, 4735, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4768, 4769, 4775, 4777, 4778, 4779, 4780, 4781, 4782, 4783, 4784, 4787, 4814, 4815, 4816, 4818, 4822, 4823, 4824, 4825, 4838, 4847, 4849, 4850, 4851, 4852, 4859, 4863, 4864, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4880, 4881, 4882, 4893, 4896, 4909, 4910, 4911, 4921, 4929, 4930, 4931, 4932, 4939, 4942, 4943, 4944, 4966, 5030, 5033, 5035, 5045, 5049, 5062, 5063, 5064, 5065, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5092, 5094, 5095, 5096, 5116, 5119, 5122, 5132, 5133, 5134, 5135, 5136, 5138, 5142, 5143, 5147, 5150, 5151, 5152, 5153, 5154, 5155, 5156, 5169, 5170, 5172, 5197, 5198, 5200, 5201, 5209, 5214, 5217, 5218, 5219, 5220, 5292, 5296, 5300, 5315, 5321, 5322, 5323, 5331, 5341, 5362, 5363, 5364, 5413, 5465, 5466, 5467, 5468, 5469, 5470, 5471, 5477, 5478, 5479, 5480, 5482, 5491, 5492, 5493, 5504, 5581, 5582, 5583, 5584, 5585, 5586, 5628, 5629, 5630, 5631, 5632, 5640, 5641, 5642, 5647, 5648, 5649, 5650, 5693, 5753, 5769, 5811, 5814, 5879, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5911, 5925, 5926, 5927, 6024, 6129, 6130, 6131, 6132, 6133, 6175, 6185, 6206, 6207, 6208, 6209, 6210, 6211, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6243, 6252, 6268, 6273, 6274, 6275, 6276, 6281, 6284, 6286, 6300, 6301, 6302, 6334, 6391, 6392, 6393, 6394, 6433, 6434, 6435, 6436, 6445, 6501, 6502, 6503, 6504, 6505, 6506, 6700, 6722, 6724, 6727, 6743, 6746, 6747, 6748, 6749, 6750, 6755, 6768, 6775, 6823, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6833, 6834, 6835, 6850, 6884, 6900, 6901, 6902, 6928, 6929, 6930, 6931, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6944, 6946, 6954, 6955, 6957, 6962, 6978, 6979, 6980, 6988, 7006, 7007, 7008)) ORDER BY FIELD(`e`.`entity_id`, 6946, 4929, 4780, 4735, 7008, 7007, 7006, 6988, 6980, 6979, 6978, 6962, 6957, 6955, 6954, 6944, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6931, 6930, 6929, 6928, 6902, 6901, 6900, 6884, 6850, 6835, 6834, 6833, 6831, 6830, 6828, 6827, 6826, 6825, 6823, 6775, 6768, 6755, 6750, 6749, 6748, 6747, 6746, 6743, 6727, 6724, 6722, 6436, 6435, 6434, 6433, 6394, 6391, 6334, 6302, 6301, 6300, 6286, 6276, 6274, 6273, 6268, 6221, 6219, 6218, 6217, 6216, 6215, 6211, 6208, 6207, 6206, 6133, 6132, 6131, 6129, 5926, 5925, 5906, 5903, 5902, 5901, 5900, 5899, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5814, 5811, 5769, 5693, 5648, 5647, 5586, 5585, 5584, 5583, 5582, 5581, 5480, 5478, 5469, 5465, 5413, 5209, 5082, 5081, 5045, 5033, 4911, 4910, 4909, 4893, 4863, 4859, 4851, 4850, 4849, 4823, 4822, 4775, 4595, 4481, 4465, 4411, 4294, 4260, 4233, 4232, 4231, 4230, 4229, 4228, 4226, 4050, 4049, 3842, 3841, 3750, 3718, 3419, 3413, 3412, 3410, 3228, 3215, 3208, 3207, 3205, 2976, 2943, 2941, 2915, 2914, 2913, 2725, 2717, 2714, 2548, 2464, 2463, 2461, 1852, 1798, 1543, 803, 546, 6829, 6700, 6506, 6505, 6504, 6503, 6502, 6501, 6445, 6393, 6392, 6284, 6281, 6275, 6252, 6243, 6220, 6210, 6209, 6185, 6175, 6130, 6024, 5927, 5911, 5905, 5904, 5898, 5890, 5889, 5888, 5879, 5753, 5650, 5649, 5642, 5641, 5640, 5632, 5631, 5630, 5629, 5628, 5504, 5493, 5492, 5491, 5482, 5479, 5477, 5471, 5470, 5468, 5467, 5466, 5364, 5363, 5362, 5341, 5331, 5323, 5322, 5321, 5315, 5300, 5296, 5292, 5220, 5219, 5218, 5217, 5214, 5201, 5200, 5198, 5197, 5172, 5170, 5169, 5156, 5155, 5154, 5153, 5152, 5151, 5150, 5147, 5143, 5142, 5138, 5136, 5135, 5134, 5133, 5132, 5122, 5119, 5116, 5096, 5095, 5094, 5092, 5091, 5090, 5089, 5088, 5087, 5086, 5085, 5083, 5065, 5064, 5063, 5062, 5049, 5035, 5030, 4966, 4944, 4943, 4942, 4939, 4932, 4931, 4930, 4921, 4896, 4882, 4881, 4880, 4877, 4876, 4875, 4874, 4873, 4872, 4871, 4864, 4852, 4847, 4838, 4825, 4824, 4818, 4816, 4815, 4814, 4787, 4784, 4783, 4782, 4781, 4779, 4778, 4777, 4769, 4768, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4722, 4671, 4596, 4594, 4535, 4509, 4508, 4506, 4505, 4478, 4463, 4460, 4453, 4410, 4409, 4380, 4379, 4363, 4361, 4356, 4351, 4317, 4316, 4315, 4301, 4300, 4299, 4298, 4297, 4296, 4295, 4293, 4292, 4291, 4290, 4289, 4255, 4235, 4234, 4223, 4222, 4221, 4220, 4213, 4204, 4202, 4201, 4188, 4165, 4164, 4163, 4123, 4122, 4121, 4120, 4119, 4117, 4102, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4051, 4020, 4019, 4016, 4014, 4003, 3981, 3980, 3978, 3977, 3964, 3963, 3950, 3949, 3948, 3874, 3856, 3814, 3813, 3800, 3799, 3798, 3797, 3796, 3795, 3775, 3749, 3748, 3717, 3709, 3609, 3606, 3605, 3604, 3603, 3601, 3600, 3599, 3598, 3596, 3594, 3593, 3592, 3591, 3590, 3589, 3588, 3586, 3584, 3581, 3572, 3543, 3542, 3540, 3539, 3538, 3492, 3448, 3447, 3444, 3443, 3441, 3440, 3439, 3414, 3411, 3344, 3339, 3327, 3323, 3322, 3309, 3307, 3306, 3305, 3303, 3298, 3294, 3293, 3282, 3216, 3210, 3209, 3206, 3204, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2926, 2925, 2924, 2923, 2922, 2921, 2920, 2919, 2918, 2916, 2872, 2871, 2870, 2863, 2862, 2839, 2838, 2813, 2812, 2810, 2809, 2727, 2726, 2724, 2720, 2719, 2718, 2716, 2709, 2708, 2707, 2706, 2705, 2704, 2700, 2547, 2546, 2530, 2460, 2449, 2442, 2441, 2384, 2377, 2040, 2039, 2038, 1967, 1920, 1734, 1729, 1696, 1275, 1150, 1082, 983, 968, 763, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
Giá thường:
980.000 ₫
Special Price
588.000 ₫
4929
-
Giá thường:
540.000 ₫
Special Price
378.000 ₫
4780
-
Giá thường:
40.000 ₫
Special Price
30.000 ₫
4735
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-