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(945, 1037, 1998, 1999, 2446, 2521, 3276, 3277, 3284, 3288, 3460, 3508, 3509, 3510, 3511, 3513, 3514, 3515, 3516, 3518, 3519, 3520, 3522, 3523, 3524, 3525, 3529, 3530, 3531, 3532, 3533, 3534, 3536, 3537, 3619, 3623, 3624, 3625, 3636, 3640, 3641, 3642, 3704, 3705, 3739, 3853, 4035, 4043, 4044, 4045, 4046, 4047, 4048, 4069, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4135, 4136, 4137, 4138, 4139, 4140, 4141, 4166, 4167, 4168, 4176, 4177, 4178, 4179, 4181, 4184, 4185, 4210, 4224, 4225, 4253, 4254, 4255, 4289, 4290, 4291, 4292, 4302, 4303, 4304, 4374, 4402, 4413, 4414, 4415, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4439, 4453, 4530, 4561, 4562, 4563, 4564, 4565, 4566, 4679, 4764, 4933, 4978, 4980, 4981, 4982, 4983, 4986, 4987, 4988, 4995, 4996, 4997, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5022, 5024, 5055, 5056, 5057, 5058, 5068, 5069, 5070, 5103, 5161, 5162, 5163, 5176, 5199, 5209, 5214, 5222, 5316, 5420, 5433, 5434, 5435, 5468, 5500, 5501, 5502, 5607, 5608, 5609, 5610, 5693, 5712, 5713, 6049, 6395, 6396, 6397, 6452, 6453, 6454, 6455, 6456, 6648, 6649, 6650, 6651, 6652, 6653, 6692, 6693, 6694, 6788, 6789, 6790, 6791, 6825, 6826, 6827, 6831, 6833, 6834, 6835, 6850, 6902, 6906, 6927, 6929, 6930, 6931, 6955, 6957, 6962, 7002, 7003, 7004)) ORDER BY FIELD(`e`.`entity_id`, 7004, 7003, 7002, 6962, 6957, 6955, 6931, 6930, 6929, 6927, 6906, 6902, 6850, 6835, 6834, 6833, 6831, 6827, 6826, 6825, 6791, 6790, 6789, 6788, 6694, 6693, 6692, 6653, 6652, 6651, 6650, 6649, 6648, 6453, 6452, 6396, 6395, 5713, 5712, 5693, 5609, 5607, 5500, 5209, 5199, 5070, 5069, 5056, 5055, 5022, 5019, 5018, 4988, 4986, 4563, 4562, 4561, 4437, 4436, 4434, 4433, 4430, 4415, 4414, 4413, 4374, 4178, 4177, 4176, 4168, 4166, 4141, 4140, 4139, 4137, 4136, 4132, 4131, 4129, 4128, 4126, 3705, 3625, 3619, 3536, 3530, 2446, 1999, 1998, 1037, 6456, 6455, 6454, 6397, 6049, 5610, 5608, 5502, 5501, 5468, 5435, 5434, 5433, 5420, 5316, 5222, 5214, 5176, 5163, 5162, 5161, 5103, 5068, 5058, 5057, 5024, 5021, 5020, 5007, 5006, 5005, 5004, 4997, 4996, 4995, 4987, 4983, 4982, 4981, 4980, 4978, 4933, 4764, 4679, 4566, 4565, 4564, 4530, 4453, 4439, 4438, 4435, 4432, 4431, 4402, 4304, 4303, 4302, 4292, 4291, 4290, 4289, 4255, 4254, 4253, 4225, 4224, 4210, 4185, 4184, 4181, 4179, 4167, 4138, 4135, 4130, 4127, 4069, 4048, 4047, 4046, 4045, 4044, 4043, 4035, 3853, 3739, 3704, 3642, 3641, 3640, 3636, 3624, 3623, 3537, 3534, 3533, 3532, 3531, 3529, 3525, 3524, 3523, 3522, 3520, 3519, 3518, 3516, 3515, 3514, 3513, 3511, 3510, 3509, 3508, 3460, 3288, 3284, 3277, 3276, 2521, 945) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
5500
-
-
-
Giá thường:
260.000 ₫
Special Price
182.000 ₫
5069
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
5055
Đi kèm
- Hộp gấm đựng quà
- Dây sơ cua
-
Giá thường:
250.000 ₫
Special Price
195.000 ₫
5022
-
Giá thường:
250.000 ₫
Special Price
145.000 ₫
5018
-
Giá thường:
190.000 ₫
Special Price
145.000 ₫
4986
-
-
-
Giá thường:
400.000 ₫
Special Price
200.000 ₫
4413
-
Giá thường:
200.000 ₫
Special Price
120.000 ₫
4374
-
Giá thường:
310.000 ₫
Special Price
245.000 ₫
4177
-
Giá thường:
150.000 ₫
Special Price
120.000 ₫
4166
-
-
-
-