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(1158, 1436, 1471, 1652, 1736, 1988, 1989, 1990, 2674, 2675, 2676, 2841, 2842, 2843, 2845, 2846, 2847, 2870, 2871, 2872, 2913, 2914, 2915, 3277, 3279, 3280, 3368, 3389, 3390, 3391, 3392, 3393, 3432, 3433, 3434, 3458, 3574, 3581, 3679, 3773, 3790, 3791, 3792, 3793, 3794, 3848, 3861, 3862, 3863, 3864, 3865, 3876, 3884, 3893, 3902, 3908, 3915, 3917, 3918, 3920, 3921, 3937, 3942, 3948, 4026, 4052, 4093, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4148, 4149, 4150, 4151, 4152, 4153, 4154, 4155, 4156, 4201, 4253, 4254, 4256, 4257, 4258, 4260, 4302, 4303, 4304, 4305, 4306, 4307, 4342, 4364, 4369, 4397, 4409, 4410, 4411, 4490, 4493, 4537, 4545, 4551, 4553, 4554, 4555, 4589, 4591, 4616, 4638, 4639, 4641, 4644, 4645, 4646, 4686, 4770, 4771, 4772, 4786, 4831, 4832, 4833, 4898, 4939, 4942, 4943, 4944, 4947, 4948, 4949, 4950, 4951, 4952, 4953, 4954, 5003, 5022, 5023, 5025, 5026, 5027, 5028, 5029, 5033, 5034, 5042, 5048, 5117, 5124, 5134, 5136, 5153, 5232, 5266, 5296, 5311, 5312, 5331, 5339, 5462, 5463, 5476, 5481, 5486, 5488, 5492, 5523, 5525, 5526, 5527, 5541, 5596, 5621, 5638, 5647, 5648, 5649, 5650, 5687, 5697, 5698, 5721, 5722, 5723, 5724, 5742, 5753, 5770, 5773, 5799, 5810, 5811, 5812, 5813, 5814, 5815, 5830, 5873, 5885, 5887, 5908, 5909, 5910, 5951, 5952, 5953, 5954, 5955, 5956, 5957, 5958, 6024, 6040, 6041, 6078, 6079, 6080, 6081, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6113, 6156, 6183, 6184, 6185, 6186, 6187, 6233, 6234, 6235, 6272, 6417, 6519, 6539, 6540, 6552, 6555, 6648, 6649, 6650, 6651, 6652, 6653, 6716, 6738, 6743, 6814, 6838, 6849, 6850, 6856, 6921, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6954, 6955, 6957, 6962, 6963, 6973, 6975, 6976, 6977, 6989)) ORDER BY FIELD(`e`.`entity_id`, 6989, 6977, 6976, 6975, 6973, 6963, 6962, 6957, 6955, 6954, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6921, 6856, 6850, 6849, 6814, 6743, 6738, 6716, 6653, 6652, 6651, 6650, 6649, 6648, 6555, 6552, 6540, 6539, 6519, 6235, 6234, 6233, 6156, 6079, 6078, 6041, 5873, 5830, 5815, 5814, 5813, 5811, 5810, 5742, 5724, 5723, 5722, 5721, 5698, 5697, 5687, 5648, 5647, 5596, 5488, 5481, 5339, 5266, 5232, 5048, 5034, 5033, 5029, 5028, 5027, 5026, 5025, 5022, 5003, 4952, 4950, 4948, 4947, 4786, 4645, 4644, 4641, 4639, 4638, 4555, 4553, 4545, 4493, 4490, 4411, 4306, 4305, 4260, 4257, 4256, 4093, 4052, 3917, 3915, 3908, 3679, 2915, 2914, 2913, 2845, 2841, 1989, 1988, 1471, 1436, 1158, 6838, 6417, 6272, 6187, 6186, 6185, 6184, 6183, 6113, 6110, 6109, 6108, 6107, 6106, 6105, 6104, 6103, 6102, 6101, 6100, 6099, 6098, 6097, 6096, 6095, 6094, 6093, 6092, 6091, 6090, 6081, 6080, 6040, 6024, 5958, 5957, 5956, 5955, 5954, 5953, 5952, 5951, 5910, 5909, 5908, 5887, 5885, 5812, 5799, 5773, 5770, 5753, 5650, 5649, 5638, 5621, 5541, 5527, 5526, 5525, 5523, 5492, 5486, 5476, 5463, 5462, 5331, 5312, 5311, 5296, 5153, 5136, 5134, 5124, 5117, 5042, 5023, 4954, 4953, 4951, 4949, 4944, 4943, 4942, 4939, 4898, 4833, 4832, 4831, 4772, 4771, 4770, 4686, 4646, 4616, 4591, 4589, 4554, 4551, 4537, 4410, 4409, 4397, 4369, 4364, 4342, 4307, 4304, 4303, 4302, 4258, 4254, 4253, 4201, 4156, 4155, 4154, 4153, 4152, 4151, 4150, 4149, 4148, 4125, 4124, 4123, 4122, 4121, 4120, 4119, 4118, 4117, 4116, 4115, 4026, 3948, 3942, 3937, 3921, 3920, 3918, 3902, 3893, 3884, 3876, 3865, 3864, 3863, 3862, 3861, 3848, 3794, 3793, 3792, 3791, 3790, 3773, 3581, 3574, 3458, 3434, 3433, 3432, 3393, 3392, 3391, 3390, 3389, 3368, 3280, 3279, 3277, 2872, 2871, 2870, 2847, 2846, 2843, 2842, 2676, 2675, 2674, 1990, 1736, 1652) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
150.000 ₫
Special Price
120.000 ₫
6078
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5698
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5697
-
Giá thường:
290.000 ₫
Special Price
250.000 ₫
5687
-
-
-
-
Giá thường:
85.000 ₫
Special Price
59.000 ₫
5481
-
Giá thường:
350.000 ₫
Special Price
200.000 ₫
5339
Kèm theo
- Túi đựng quà sang trọng
-
-
Giá thường:
450.000 ₫
Special Price
224.000 ₫
5048