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(933, 1101, 1987, 2430, 2431, 2432, 2433, 2434, 2438, 2439, 2441, 2442, 2457, 2458, 2460, 2461, 2798, 2799, 2800, 2928, 2937, 2938, 2983, 3217, 3289, 3295, 3298, 3300, 3303, 3304, 3305, 3306, 3307, 3309, 3310, 3321, 3344, 3441, 3447, 3460, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3574, 3577, 3578, 3587, 3590, 3591, 3592, 3593, 3595, 3677, 3688, 3710, 3739, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3853, 3892, 3902, 3917, 3918, 3920, 3921, 3922, 3923, 3924, 3969, 4000, 4001, 4002, 4053, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4107, 4108, 4109, 4113, 4142, 4143, 4146, 4158, 4210, 4211, 4212, 4217, 4218, 4220, 4221, 4222, 4223, 4224, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4336, 4337, 4338, 4339, 4340, 4341, 4346, 4356, 4357, 4358, 4359, 4365, 4367, 4368, 4398, 4422, 4423, 4424, 4425, 4426, 4427, 4428, 4440, 4441, 4442, 4444, 4445, 4446, 4447, 4448, 4570, 4572, 4573, 4574, 4575, 4586, 4587, 4588, 4589, 4590, 4591, 4592, 4593, 4697, 4698, 4699, 4701, 4707, 4709, 4710, 4711, 4712, 4713, 4727, 4728, 4729, 4732, 4733, 4734, 4736, 4749, 4750, 4751, 4766, 4767, 4773, 4774, 4856, 4857, 4858, 4861, 4869, 4870, 4871, 4891, 4933, 4935, 4968, 4969, 4977, 5053, 5082, 5083, 5084, 5093, 5117, 5138, 5152, 5155, 5194, 5195, 5196, 5231, 5232, 5233, 5263, 5266, 5280, 5281, 5282, 5283, 5284, 5285, 5291, 5292, 5293, 5294, 5299, 5301, 5302, 5303, 5305, 5307, 5308, 5310, 5311, 5312, 5314, 5327, 5328, 5329, 5330, 5331, 5335, 5336, 5338, 5339, 5343, 5350, 5371, 5376, 5377, 5379, 5381, 5391, 5396, 5407, 5409, 5417, 5420, 5430, 5473, 5474, 5477, 5498, 5607, 5608, 5609, 5610, 5691, 5693, 5694, 5696, 5712, 5713, 5714, 5715, 5725, 5726, 5727, 5732, 5750, 5751, 5752, 5771, 5772, 5773, 5774, 5775, 5830, 5833, 5835, 5838, 5888, 5889, 5890, 5918, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5927, 5936, 5937, 5938, 5939, 5940, 5941, 5942, 5944, 5970, 5971, 5972, 5973, 5980, 5981, 5982, 5983, 5984, 5985, 5986, 5987, 5988, 5989, 5990, 5991, 5992, 5993, 5994, 5995, 6016, 6017, 6018, 6019, 6025, 6051, 6054, 6055, 6056, 6062, 6063, 6064, 6065, 6143, 6144, 6147, 6148, 6150, 6151, 6152, 6153, 6154, 6155, 6191, 6192, 6193, 6201, 6202, 6203, 6204, 6230, 6231, 6232, 6253, 6254, 6255, 6256, 6267, 6300, 6301, 6302, 6321, 6322, 6323, 6325, 6326, 6348, 6349, 6350, 6351, 6369, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6377, 6391, 6392, 6393, 6394, 6496, 6508, 6509, 6534, 6535, 6536, 6537, 6538, 6539, 6540, 6541, 6542, 6543, 6551, 6552, 6553, 6554, 6555, 6556, 6557, 6558, 6559, 6573, 6601, 6602, 6603, 6604, 6677, 6678, 6679, 6690, 6691, 6714, 6715, 6716, 6717, 6718, 6719, 6751, 6752, 6753, 6781, 6782, 6783, 6788, 6794, 6795, 6815, 6816, 6817, 6818, 6821, 6822, 6827, 6847, 6848, 6902, 6907, 6908, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6942, 6943, 6944, 6947, 6948, 6978, 6979, 6980, 6989, 6991, 6992, 6993, 7002, 7003, 7004, 7009, 7010, 7011, 7036, 7037)) ORDER BY FIELD(`e`.`entity_id`, 7037, 7036, 6993, 6992, 6991, 6910, 6908, 6907, 6848, 6847, 6817, 6815, 6783, 6782, 6781, 6543, 6542, 6541, 6540, 6539, 6538, 6537, 6536, 6534, 6509, 6508, 6496, 6377, 6375, 6326, 6322, 6321, 6193, 6192, 6191, 5693, 5474, 5266, 5263, 4425, 4424, 4285, 4284, 4283, 4282, 4280, 4146, 4109, 7011, 7010, 7009, 7004, 7003, 7002, 6989, 6980, 6979, 6978, 6948, 6947, 6944, 6943, 6942, 6921, 6920, 6919, 6918, 6917, 6916, 6915, 6914, 6913, 6912, 6911, 6902, 6827, 6822, 6821, 6818, 6795, 6794, 6788, 6753, 6752, 6751, 6719, 6718, 6716, 6715, 6714, 6691, 6679, 6678, 6677, 6604, 6603, 6602, 6601, 6573, 6559, 6558, 6557, 6556, 6555, 6554, 6553, 6552, 6551, 6394, 6391, 6351, 6350, 6348, 6302, 6301, 6300, 6230, 6204, 6203, 6202, 6201, 6154, 6150, 6148, 6147, 6056, 6054, 6051, 6019, 6018, 6017, 5992, 5990, 5980, 5973, 5944, 5926, 5925, 5924, 5923, 5922, 5921, 5920, 5918, 5838, 5835, 5830, 5752, 5751, 5750, 5727, 5725, 5715, 5714, 5713, 5712, 5609, 5607, 5498, 5430, 5396, 5379, 5377, 5371, 5350, 5339, 5335, 5329, 5328, 5327, 5233, 5232, 5231, 5082, 4977, 4767, 4750, 4749, 4422, 4358, 4357, 4108, 4002, 4001, 3917, 3677, 2461, 1987, 1101, 933, 6816, 6717, 6690, 6535, 6393, 6392, 6376, 6374, 6373, 6372, 6371, 6370, 6369, 6349, 6325, 6323, 6267, 6256, 6255, 6254, 6253, 6232, 6231, 6155, 6153, 6152, 6151, 6144, 6143, 6065, 6064, 6063, 6062, 6055, 6025, 6016, 5995, 5994, 5993, 5991, 5989, 5988, 5987, 5986, 5985, 5984, 5983, 5982, 5981, 5972, 5971, 5970, 5942, 5941, 5940, 5939, 5938, 5937, 5936, 5927, 5919, 5890, 5889, 5888, 5833, 5775, 5774, 5773, 5772, 5771, 5732, 5726, 5696, 5694, 5691, 5610, 5608, 5477, 5473, 5420, 5417, 5409, 5407, 5391, 5381, 5376, 5343, 5338, 5336, 5331, 5330, 5314, 5312, 5311, 5310, 5308, 5307, 5305, 5303, 5302, 5301, 5299, 5294, 5293, 5292, 5291, 5285, 5284, 5283, 5282, 5281, 5280, 5196, 5195, 5194, 5155, 5152, 5138, 5117, 5093, 5084, 5083, 5053, 4969, 4968, 4935, 4933, 4891, 4871, 4870, 4869, 4861, 4858, 4857, 4856, 4774, 4773, 4766, 4751, 4736, 4734, 4733, 4732, 4729, 4728, 4727, 4713, 4712, 4711, 4710, 4709, 4707, 4701, 4699, 4698, 4697, 4593, 4592, 4591, 4590, 4589, 4588, 4587, 4586, 4575, 4574, 4573, 4572, 4570, 4448, 4447, 4446, 4445, 4444, 4442, 4441, 4440, 4428, 4427, 4426, 4423, 4398, 4368, 4367, 4365, 4359, 4356, 4346, 4341, 4340, 4339, 4338, 4337, 4336, 4281, 4279, 4278, 4277, 4276, 4275, 4274, 4273, 4272, 4271, 4270, 4269, 4268, 4224, 4223, 4222, 4221, 4220, 4218, 4217, 4212, 4211, 4210, 4158, 4143, 4142, 4113, 4107, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4053, 4000, 3969, 3924, 3923, 3922, 3921, 3920, 3918, 3902, 3892, 3853, 3840, 3839, 3838, 3837, 3836, 3835, 3834, 3833, 3832, 3831, 3830, 3829, 3828, 3827, 3826, 3825, 3824, 3823, 3822, 3739, 3710, 3688, 3595, 3593, 3592, 3591, 3590, 3587, 3578, 3577, 3574, 3571, 3570, 3569, 3568, 3567, 3566, 3565, 3460, 3447, 3441, 3344, 3321, 3310, 3309, 3307, 3306, 3305, 3304, 3303, 3300, 3298, 3295, 3289, 3217, 2983, 2938, 2937, 2928, 2800, 2799, 2798, 2460, 2458, 2457, 2442, 2441, 2439, 2438, 2434, 2433, 2432, 2431, 2430) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
550.000 ₫
Special Price
395.000 ₫
5474
-
-
-
-
-
-
Giá thường:
180.000 ₫
Special Price
160.000 ₫
4146
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
-
-
-
-
-
-
-
-
-
-
-