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(1597, 1600, 1691, 1694, 1696, 1706, 1736, 1740, 2841, 2842, 2843, 2845, 2846, 2847, 3127, 3155, 3158, 3159, 3167, 3170, 3171, 3172, 3173, 3174, 3175, 3176, 3177, 3180, 3181, 3182, 3265, 3267, 3276, 3277, 3281, 3292, 3315, 3318, 3319, 3327, 3382, 3384, 3400, 3422, 3513, 3514, 3515, 3516, 3533, 3534, 3536, 3537, 3551, 3553, 3554, 3555, 3557, 3558, 3559, 3561, 3562, 3564, 3619, 3640, 3642, 3858, 3947, 3950, 3952, 3963, 3964, 4003, 4011, 4012, 4014, 4015, 4016, 4017, 4018, 4019, 4020, 4021, 4025, 4035, 4160, 4176, 4253, 4254, 4255, 4301, 4361, 4366, 4387, 4388, 4389, 4407, 4413, 4414, 4415, 4439, 4458, 4564, 4565, 4566, 4814, 4817, 4875, 4933, 4981, 4998, 5119, 5215, 5224, 5287, 5288, 5289, 5290, 5308, 5450, 6191, 6193, 6372, 6373, 6374, 6992, 6997, 6998, 6999, 7006, 7007, 7008)) ORDER BY FIELD(`e`.`entity_id`, 7008, 7007, 7006, 6999, 6998, 6997, 6992, 6193, 6191, 5215, 4415, 4414, 4413, 4407, 4387, 4176, 4017, 3619, 3536, 3167, 2845, 2841, 1694, 1691, 1597, 6374, 6373, 6372, 5450, 5308, 5290, 5289, 5288, 5287, 5224, 5119, 4998, 4981, 4933, 4875, 4817, 4814, 4566, 4565, 4564, 4458, 4439, 4389, 4388, 4366, 4361, 4301, 4255, 4254, 4253, 4160, 4035, 4025, 4021, 4020, 4019, 4018, 4016, 4015, 4014, 4012, 4011, 4003, 3964, 3963, 3952, 3950, 3947, 3858, 3642, 3640, 3564, 3562, 3561, 3559, 3558, 3557, 3555, 3554, 3553, 3551, 3537, 3534, 3533, 3516, 3515, 3514, 3513, 3422, 3400, 3384, 3382, 3327, 3319, 3318, 3315, 3292, 3281, 3277, 3276, 3267, 3265, 3182, 3181, 3180, 3177, 3176, 3175, 3174, 3173, 3172, 3171, 3170, 3159, 3158, 3155, 3127, 2847, 2846, 2843, 2842, 1740, 1736, 1706, 1696, 1600) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
Giá thường:
650.000 ₫
Special Price
430.000 ₫
5215
Khuyến Mại
>> Đặt qua shopee chỉ còn 589k
>> Miễn phí vận chuyển toàn quốc
-
Giá thường:
400.000 ₫
Special Price
200.000 ₫
4413
-
Giá thường:
560.000 ₫
Special Price
460.000 ₫
4407
-
Giá thường:
800.000 ₫
Special Price
780.000 ₫
4387
-
Giá thường:
400.000 ₫
Special Price
330.000 ₫
4017
-
-
Giá thường:
820.000 ₫
Special Price
760.000 ₫
3167
-
Giá thường:
250.000 ₫
Special Price
145.000 ₫
2841
-
Giá thường:
120.000 ₫
Special Price
84.000 ₫
1694
-
-
-
-
Giá thường:
350.000 ₫
Special Price
280.000 ₫
6373
-
-
-
Giá thường:
350.000 ₫
Special Price
280.000 ₫
5308
-
-
Giá thường:
700.000 ₫
Special Price
476.000 ₫
5289
-
Giá thường:
700.000 ₫
Special Price
448.000 ₫
5288
-
Giá thường:
550.000 ₫
Special Price
380.000 ₫
5287
-
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
5119
-
Giá thường:
320.000 ₫
Special Price
280.000 ₫
4998
-
Đi kèm
- Hộp gấm đựng quà
- Dây sơ cua
-
-
-
Giá thường:
1.600.000 ₫
Special Price
1.120.000 ₫
4817
-
Giá thường:
280.000 ₫
Special Price
130.000 ₫
4814
-
Giá thường:
280.000 ₫
Special Price
240.000 ₫
4566
-
Giá thường:
280.000 ₫
Special Price
240.000 ₫
4565
-
Giá thường:
280.000 ₫
Special Price
240.000 ₫
4564
-
Giá thường:
280.000 ₫
Special Price
250.000 ₫
4458