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(512, 515, 568, 590, 920, 1048, 1694, 1768, 1785, 1788, 1798, 1831, 2741, 2749, 2750, 2751, 2752, 2753, 2778, 2782, 3032, 3033, 3036, 3161, 3365, 3412, 3413, 3414, 3616, 3651, 3656, 3660, 3661, 3662, 3664, 3665, 3666, 3689, 3700, 3709, 3740, 3756, 3757, 3758, 3761, 3762, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3806, 3841, 3842, 3870, 3871, 3872, 3889, 3895, 3953, 3954, 3979, 4095, 4098, 4099, 4100, 4161, 4162, 4196, 4239, 4302, 4303, 4304, 4305, 4306, 4307, 4342, 4357, 4358, 4359, 4364, 4381, 4382, 4383, 4384, 4385, 4386, 4625, 4626, 4627, 4672, 4690, 4731, 4734, 4767, 4865, 4867, 4959, 4960, 4961, 4962, 4994, 5001, 5030, 5038, 5045, 5049, 5050, 5051, 5081, 5124, 5139, 5140, 5141, 5145, 5146, 5184, 5185, 5186, 5206, 5207, 5208, 5297, 5298, 5318, 5371, 5414, 5451, 5453, 5454, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5488, 5534, 5539, 5540, 5541, 5554, 5633, 5651, 5652, 5653, 5654, 5655, 5656, 5688, 5689, 5690, 5717, 5749, 5767, 5799, 5809, 5912, 5913, 5914, 5944, 6020, 6021, 6022, 6029, 6030, 6031, 6032, 6044, 6045, 6046, 6047, 6050, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6137, 6139, 6140, 6141, 6211, 6224, 6230, 6231, 6308, 6366, 6460, 6501, 6502, 6503, 6504, 6505, 6506, 6636, 6744, 6745, 6751, 6752, 6753, 6774, 6793, 7011, 7022)) ORDER BY FIELD(`e`.`entity_id`, 6087, 6086, 6083, 6082, 6793, 6636, 6366, 6022, 6020, 5146, 5145, 4690, 4162, 4161, 1798, 1788, 1785, 1694, 7022, 7011, 6774, 6752, 6751, 6745, 6744, 6230, 6224, 6211, 6079, 6078, 6077, 6076, 6074, 5944, 5914, 5913, 5912, 5767, 5554, 5534, 5488, 5461, 5454, 5453, 5451, 5371, 5298, 5208, 5207, 5206, 5141, 5140, 5139, 5081, 5051, 5050, 5045, 5038, 5001, 4767, 4731, 4385, 4384, 4383, 4382, 4381, 4358, 4357, 4306, 4305, 4095, 3842, 3841, 3413, 3412, 3036, 3032, 1768, 920, 590, 568, 512, 6753, 6506, 6505, 6504, 6503, 6502, 6501, 6460, 6308, 6231, 6141, 6140, 6139, 6137, 6085, 6084, 6081, 6080, 6075, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6050, 6047, 6046, 6045, 6044, 6032, 6031, 6030, 6029, 6021, 5809, 5799, 5749, 5717, 5690, 5689, 5688, 5656, 5655, 5654, 5653, 5652, 5651, 5633, 5541, 5540, 5539, 5463, 5462, 5460, 5459, 5458, 5457, 5456, 5414, 5318, 5297, 5186, 5185, 5184, 5124, 5049, 5030, 4994, 4962, 4961, 4960, 4959, 4867, 4865, 4734, 4672, 4627, 4626, 4625, 4386, 4364, 4359, 4342, 4307, 4304, 4303, 4302, 4239, 4196, 4100, 4099, 4098, 3979, 3954, 3953, 3895, 3889, 3872, 3871, 3870, 3806, 3805, 3804, 3803, 3802, 3801, 3800, 3799, 3798, 3797, 3796, 3795, 3762, 3761, 3758, 3757, 3756, 3740, 3709, 3700, 3689, 3666, 3665, 3664, 3662, 3661, 3660, 3656, 3651, 3616, 3414, 3365, 3161, 3033, 2782, 2778, 2753, 2752, 2751, 2750, 2749, 2741, 1831, 1048, 515) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
Giá thường:
50.000 ₫
Special Price
42.000 ₫
6082
-
-
-
-
-
-
Giá thường:
890.000 ₫
Special Price
790.000 ₫
5146
-
Giá thường:
890.000 ₫
Special Price
790.000 ₫
5145
-
-
Giá thường:
90.000 ₫
Special Price
35.000 ₫
4162
-
Giá thường:
90.000 ₫
Special Price
40.000 ₫
4161
-
-
-
-
Giá thường:
120.000 ₫
Special Price
84.000 ₫
1694
-
-
-
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
6745
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
6744
-
-
-
-
Giá thường:
150.000 ₫
Special Price
120.000 ₫
6078
-
Giá thường:
350.000 ₫
Special Price
290.000 ₫
6074
-
Giá thường:
970.000 ₫
Special Price
945.000 ₫
5944
-
-
-
-
-
-
Giá thường:
1.680.000 ₫
Special Price
1.176.000 ₫
5461
-
-
-
-
Giá thường:
280.000 ₫
Special Price
190.000 ₫
5371
Kèm theo
- Hộp và Túi đựng quà sang trọng