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(1227, 2407, 2408, 2409, 2533, 2534, 2535, 2536, 2537, 2538, 2539, 2540, 2541, 2542, 2543, 2544, 2679, 2680, 3441, 3444, 3491, 3689, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3859, 4224, 4225, 4293, 4299, 4535, 4564, 4731, 4782, 4834, 5429, 5468, 5498, 5520, 5712, 5713, 5714, 5715, 5750, 5751, 5752, 6211, 6375, 6376, 6377, 6439, 6788, 6789, 6790, 6791, 6894)) ORDER BY FIELD(`e`.`entity_id`, 6894, 6791, 6790, 6789, 6788, 6439, 6377, 6375, 6211, 5752, 5751, 5750, 5715, 5714, 5713, 5712, 5498, 4731, 3731, 3730, 3729, 3726, 2540, 2538, 2408, 2407, 1227, 6376, 5520, 5468, 5429, 4834, 4782, 4564, 4535, 4299, 4293, 4225, 4224, 3859, 3732, 3728, 3727, 3689, 3491, 3444, 3441, 2680, 2679, 2544, 2543, 2542, 2541, 2539, 2537, 2536, 2535, 2534, 2533, 2409) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
Giá thường:
220.000 ₫
Special Price
77.000 ₫
3726
-
Giá thường:
280.000 ₫
Special Price
196.000 ₫
2538
-
Giá thường:
210.000 ₫
Special Price
147.000 ₫
2407
-
Kèm theo
- Hộp quà nhung sang trọng
-
-
-
Giá thường:
180.000 ₫
Special Price
120.000 ₫
5429
-
Giá thường:
340.000 ₫
Special Price
238.000 ₫
4834
-
Giá thường:
120.000 ₫
Special Price
90.000 ₫
4782
-
Giá thường:
280.000 ₫
Special Price
240.000 ₫
4564
-
Giá thường:
400.000 ₫
Special Price
380.000 ₫
4535
-
Giá thường:
160.000 ₫
Special Price
98.000 ₫
4299
-
Giá thường:
400.000 ₫
Special Price
380.000 ₫
4293
-
Giá thường:
320.000 ₫
Special Price
280.000 ₫
4225
-
Giá thường:
200.000 ₫
Special Price
180.000 ₫
4224
Lựa chọn thêm
- Dịch vụ khắc thông điệp lên gỗ
-
-
-
-
-
-
-
-
-
-
-
-
-