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(536, 546, 936, 1092, 1132, 1591, 1727, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2696, 2821, 2822, 2824, 2841, 2842, 2843, 2845, 2846, 2847, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 3086, 3109, 3258, 3261, 3262, 3294, 3299, 3301, 3308, 3314, 3322, 3323, 3328, 3331, 3332, 3351, 3404, 3415, 3416, 3422, 3435, 3437, 3445, 3460, 3477, 3478, 3479, 3480, 3481, 3488, 3525, 3531, 3532, 3595, 3616, 3617, 3623, 3709, 3710, 3878, 3902, 3936, 3937, 3938, 3966, 3967, 3968, 3969, 3971, 4031, 4032, 4034, 4040, 4041, 4042, 4052, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4095, 4104, 4106, 4109, 4110, 4139, 4140, 4141, 4166, 4167, 4168, 4186, 4206, 4244, 4246, 4261, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4283, 4284, 4285, 4344, 4345, 4346, 4347, 4348, 4356, 4359, 4403, 4404, 4405, 4406, 4412, 4417, 4418, 4424, 4425, 4426, 4427, 4428, 4430, 4431, 4432, 4433, 4449, 4450, 4451, 4452, 4471, 4520, 4521, 4522, 4523, 4597, 4602, 4603, 4604, 4605, 4609, 4697, 4698, 4699, 4710, 4711, 4713, 4722, 4723, 4724, 4725, 4762, 4763, 4764, 4815, 4818, 4857, 4865, 4879, 4889, 4891, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4978, 5000, 5002, 5003, 5035, 5036, 5037, 5038, 5043, 5047, 5071, 5080, 5104, 5105, 5106, 5107, 5111, 5114, 5118, 5136, 5169, 5202, 5203, 5204, 5205, 5242, 5246, 5285, 5294, 5299, 5300, 5302, 5303, 5305, 5307, 5334, 5336, 5338, 5357, 5371, 5376, 5377, 5381, 5384, 5490, 5516, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5607, 5608, 5609, 5610, 5703, 5708, 5709, 5835, 5946, 5947, 5948, 5949, 5950, 5951, 5952, 5953, 5954, 5955, 5956, 5957, 5958, 5974, 5975, 5976, 6002, 6016, 6017, 6018, 6019, 6021, 6040, 6200, 6268, 6356, 6369, 6370, 6371, 6437, 6460, 6470, 6477, 6478, 6479, 6677, 6678, 6679, 6689, 6690, 6691, 6703, 6712, 6714, 6715, 6716, 6717, 6718, 6719, 6731, 6734, 6735, 6736, 6737, 6741, 6743, 6774, 6813, 6814, 6849, 6897, 6898, 6900, 6901, 6906, 6948, 6964, 6965, 6966, 6967, 6968, 6969, 6975, 6976, 6977, 6989, 6991, 6992, 6993, 7002, 7003, 7004)) ORDER BY FIELD(`e`.`entity_id`, 6906, 6901, 6900, 6898, 6897, 6691, 6689, 6679, 6677, 6479, 6477, 6356, 5585, 5584, 5583, 5582, 5581, 5371, 5334, 5204, 5203, 5202, 5038, 5037, 5036, 4911, 4910, 4909, 4908, 4907, 4906, 4418, 4412, 4109, 3617, 3262, 3261, 2464, 2463, 2461, 2452, 1132, 7004, 7003, 7002, 6993, 6992, 6991, 6989, 6977, 6976, 6975, 6969, 6968, 6967, 6966, 6965, 6964, 6948, 6849, 6814, 6813, 6774, 6743, 6741, 6731, 6719, 6718, 6716, 6715, 6714, 6703, 6678, 6437, 6200, 6019, 6018, 6017, 6002, 5835, 5609, 5607, 5490, 5377, 5357, 5114, 5111, 5043, 5003, 5002, 4763, 4433, 4430, 4425, 4424, 4285, 4284, 4283, 4168, 4166, 4141, 4140, 4139, 4106, 4095, 4052, 4032, 3481, 3480, 3479, 3478, 3437, 3435, 3314, 3258, 2845, 2841, 1591, 1092, 936, 546, 6737, 6736, 6735, 6734, 6717, 6712, 6690, 6478, 6470, 6460, 6371, 6370, 6369, 6268, 6040, 6021, 6016, 5976, 5975, 5974, 5958, 5957, 5956, 5955, 5954, 5953, 5952, 5951, 5950, 5949, 5948, 5947, 5946, 5709, 5708, 5703, 5610, 5608, 5586, 5538, 5516, 5384, 5381, 5376, 5338, 5336, 5307, 5305, 5303, 5302, 5300, 5299, 5294, 5285, 5246, 5242, 5205, 5169, 5136, 5118, 5107, 5106, 5105, 5104, 5080, 5071, 5047, 5035, 5000, 4978, 4914, 4913, 4912, 4891, 4889, 4879, 4865, 4857, 4818, 4815, 4764, 4762, 4725, 4724, 4723, 4722, 4713, 4711, 4710, 4699, 4698, 4697, 4609, 4605, 4604, 4603, 4602, 4597, 4523, 4522, 4521, 4520, 4471, 4452, 4451, 4450, 4449, 4432, 4431, 4428, 4427, 4426, 4417, 4406, 4405, 4404, 4403, 4359, 4356, 4348, 4347, 4346, 4345, 4344, 4276, 4275, 4274, 4273, 4272, 4271, 4270, 4269, 4268, 4261, 4246, 4244, 4206, 4186, 4167, 4110, 4104, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4042, 4041, 4040, 4034, 4031, 3971, 3969, 3968, 3967, 3966, 3938, 3937, 3936, 3902, 3878, 3710, 3709, 3623, 3616, 3595, 3532, 3531, 3525, 3488, 3477, 3460, 3445, 3422, 3416, 3415, 3404, 3351, 3332, 3331, 3328, 3323, 3322, 3308, 3301, 3299, 3294, 3109, 3086, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2847, 2846, 2843, 2842, 2824, 2822, 2821, 2696, 2460, 2458, 2457, 2449, 1727, 536) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
Giá thường:
420.000 ₫
Special Price
340.000 ₫
6691
-
Giá thường:
420.000 ₫
Special Price
390.000 ₫
6689
-
Giá thường:
650.000 ₫
Special Price
480.000 ₫
6679
-
Giá thường:
280.000 ₫
Special Price
190.000 ₫
6677
-
-
-
-
-
Giá thường:
280.000 ₫
Special Price
190.000 ₫
5371
Kèm theo
- Hộp và Túi đựng quà sang trọng
-
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5202
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4412
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-