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, 936, 968, 983, 1082, 1150, 1275, 1543, 1591, 1696, 1798, 1852, 1920, 1967, 2038, 2039, 2040, 2377, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2546, 2547, 2548, 2700, 2704, 2705, 2706, 2707, 2708, 2709, 2714, 2716, 2717, 2718, 2719, 2720, 2724, 2725, 2726, 2727, 2809, 2810, 2812, 2813, 2824, 2838, 2839, 2841, 2842, 2843, 2845, 2846, 2847, 2862, 2863, 2870, 2871, 2872, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 2913, 2914, 2915, 2916, 2918, 2919, 2920, 2921, 2922, 2923, 2924, 2925, 2926, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 3109, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3228, 3258, 3261, 3262, 3282, 3293, 3294, 3298, 3299, 3301, 3303, 3305, 3306, 3307, 3308, 3309, 3314, 3322, 3323, 3327, 3328, 3331, 3332, 3344, 3410, 3411, 3412, 3413, 3414, 3419, 3422, 3435, 3437, 3443, 3445, 3492, 3525, 3531, 3532, 3543, 3581, 3584, 3586, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3596, 3598, 3599, 3600, 3601, 3603, 3604, 3605, 3606, 3609, 3623, 3709, 3717, 3718, 3775, 3813, 3814, 3841, 3842, 3856, 3874, 3948, 3949, 3950, 3963, 3964, 3980, 3981, 4003, 4049, 4050, 4051, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4102, 4106, 4109, 4117, 4139, 4140, 4141, 4163, 4164, 4165, 4186, 4204, 4220, 4221, 4222, 4223, 4226, 4228, 4229, 4230, 4231, 4232, 4233, 4234, 4235, 4244, 4246, 4255, 4260, 4261, 4290, 4294, 4295, 4297, 4298, 4299, 4301, 4315, 4316, 4317, 4351, 4356, 4359, 4361, 4363, 4379, 4380, 4403, 4404, 4405, 4406, 4409, 4410, 4411, 4412, 4417, 4418, 4430, 4431, 4432, 4433, 4463, 4465, 4478, 4520, 4521, 4522, 4523, 4594, 4597, 4602, 4603, 4604, 4605, 4609, 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, 4849, 4850, 4851, 4852, 4859, 4863, 4864, 4871, 4872, 4873, 4874, 4875, 4876, 4877, 4879, 4880, 4881, 4882, 4893, 4896, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4929, 4939, 4942, 4943, 4944, 4978, 5000, 5002, 5003, 5033, 5035, 5036, 5037, 5038, 5043, 5047, 5049, 5062, 5063, 5064, 5065, 5071, 5081, 5082, 5083, 5094, 5095, 5096, 5104, 5105, 5106, 5107, 5116, 5119, 5132, 5133, 5134, 5136, 5138, 5143, 5169, 5200, 5201, 5202, 5203, 5204, 5205, 5209, 5214, 5217, 5218, 5219, 5220, 5242, 5246, 5285, 5299, 5300, 5315, 5321, 5322, 5323, 5362, 5363, 5364, 5465, 5466, 5467, 5470, 5471, 5482, 5504, 5516, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5628, 5629, 5630, 5631, 5632, 5640, 5641, 5642, 5693, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5911, 5925, 5926, 5927, 5946, 5947, 5948, 5949, 5950, 6021, 6129, 6130, 6131, 6132, 6133, 6200, 6206, 6207, 6208, 6209, 6210, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6243, 6252, 6268, 6273, 6274, 6275, 6276, 6286, 6334, 6433, 6434, 6435, 6436, 6445, 6501, 6502, 6503, 6504, 6505, 6506, 6734, 6735, 6736, 6737, 6741, 6743, 6746, 6747, 6748, 6749, 6750, 6755, 6768, 6774, 6775, 6823, 6825, 6826, 6827, 6828, 6829, 6830, 6831, 6833, 6834, 6835, 6850, 6884, 6897, 6898, 6900, 6901, 6902, 6906, 6928, 6929, 6930, 6931, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6946, 6954, 6955, 6957, 6962, 6988, 6989, 6991, 6992, 6993, 7006, 7007, 7008)) ORDER BY FIELD(`e`.`entity_id`, 6901, 6900, 4911, 4910, 4909, 2464, 2463, 2461, 6906, 6898, 6897, 6743, 6268, 5586, 5585, 5584, 5583, 5582, 5581, 5204, 5203, 5202, 5038, 5037, 5036, 4908, 4907, 4906, 4109, 3262, 3261, 2452, 546, 7008, 7007, 7006, 6993, 6992, 6991, 6989, 6988, 6962, 6957, 6955, 6954, 6946, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6931, 6930, 6929, 6928, 6902, 6884, 6850, 6835, 6834, 6833, 6831, 6830, 6828, 6827, 6826, 6825, 6823, 6775, 6774, 6768, 6755, 6750, 6749, 6748, 6747, 6746, 6741, 6436, 6435, 6434, 6433, 6334, 6286, 6276, 6274, 6273, 6221, 6219, 6218, 6217, 6216, 6215, 6208, 6207, 6206, 6200, 6133, 6132, 6131, 6129, 5926, 5925, 5906, 5903, 5902, 5901, 5900, 5899, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5693, 5465, 5246, 5209, 5082, 5081, 5043, 5033, 5003, 5002, 4929, 4893, 4863, 4859, 4851, 4850, 4849, 4823, 4822, 4780, 4775, 4735, 4465, 4433, 4430, 4418, 4412, 4411, 4294, 4260, 4233, 4232, 4231, 4230, 4229, 4228, 4226, 4141, 4140, 4139, 4106, 4050, 4049, 3842, 3841, 3718, 3419, 3413, 3412, 3410, 3314, 3258, 3228, 3215, 3208, 3207, 3205, 2976, 2915, 2914, 2913, 2845, 2841, 2725, 2717, 2714, 2548, 1852, 1798, 1591, 1543, 936, 803, 6829, 6737, 6736, 6735, 6734, 6506, 6505, 6504, 6503, 6502, 6501, 6445, 6275, 6252, 6243, 6220, 6210, 6209, 6130, 6021, 5950, 5949, 5948, 5947, 5946, 5927, 5911, 5905, 5904, 5898, 5890, 5889, 5888, 5642, 5641, 5640, 5632, 5631, 5630, 5629, 5628, 5538, 5516, 5504, 5482, 5471, 5470, 5467, 5466, 5364, 5363, 5362, 5323, 5322, 5321, 5315, 5300, 5299, 5285, 5242, 5220, 5219, 5218, 5217, 5214, 5205, 5201, 5200, 5169, 5143, 5138, 5136, 5134, 5133, 5132, 5119, 5116, 5107, 5106, 5105, 5104, 5096, 5095, 5094, 5083, 5071, 5065, 5064, 5063, 5062, 5049, 5047, 5035, 5000, 4978, 4944, 4943, 4942, 4939, 4914, 4913, 4912, 4896, 4882, 4881, 4880, 4879, 4877, 4876, 4875, 4874, 4873, 4872, 4871, 4864, 4852, 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, 4609, 4605, 4604, 4603, 4602, 4597, 4594, 4523, 4522, 4521, 4520, 4478, 4463, 4432, 4431, 4417, 4410, 4409, 4406, 4405, 4404, 4403, 4380, 4379, 4363, 4361, 4359, 4356, 4351, 4317, 4316, 4315, 4301, 4299, 4298, 4297, 4295, 4290, 4261, 4255, 4246, 4244, 4235, 4234, 4223, 4222, 4221, 4220, 4204, 4186, 4165, 4164, 4163, 4117, 4102, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4051, 4003, 3981, 3980, 3964, 3963, 3950, 3949, 3948, 3874, 3856, 3814, 3813, 3775, 3717, 3709, 3623, 3609, 3606, 3605, 3604, 3603, 3601, 3600, 3599, 3598, 3596, 3594, 3593, 3592, 3591, 3590, 3589, 3588, 3586, 3584, 3581, 3543, 3532, 3531, 3525, 3492, 3445, 3443, 3437, 3435, 3422, 3414, 3411, 3344, 3332, 3331, 3328, 3327, 3323, 3322, 3309, 3308, 3307, 3306, 3305, 3303, 3301, 3299, 3298, 3294, 3293, 3282, 3216, 3210, 3209, 3206, 3204, 3109, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2926, 2925, 2924, 2923, 2922, 2921, 2920, 2919, 2918, 2916, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2872, 2871, 2870, 2863, 2862, 2847, 2846, 2843, 2842, 2839, 2838, 2824, 2813, 2812, 2810, 2809, 2727, 2726, 2724, 2720, 2719, 2718, 2716, 2709, 2708, 2707, 2706, 2705, 2704, 2700, 2547, 2546, 2460, 2458, 2457, 2449, 2377, 2040, 2039, 2038, 1967, 1920, 1696, 1275, 1150, 1082, 983, 968, 763, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5202
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
Giá thường:
45.000 ₫
Special Price
24.000 ₫
546
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-