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(588, 697, 968, 1115, 1275, 1281, 1605, 1612, 1617, 1967, 1999, 2038, 2039, 2040, 2122, 2124, 2125, 2151, 2153, 2159, 2160, 2287, 2331, 2332, 2334, 2355, 2377, 2379, 2380, 2381, 2382, 2384, 2391, 2392, 2393, 2394, 2395, 2441, 2442, 2530, 2721, 2838, 2839, 2850, 2851, 2940, 2941, 2943, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2992, 2998, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3339, 3395, 3396, 3397, 3404, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3432, 3433, 3434, 3488, 3539, 3540, 3542, 3543, 3565, 3566, 3567, 3568, 3572, 3573, 3574, 3577, 3578, 3588, 3589, 3681, 3682, 3683, 3684, 3685, 3698, 3699, 3711, 3717, 3718, 3719, 3720, 3748, 3749, 3750, 3795, 3796, 3797, 3798, 3799, 3800, 3841, 3842, 3844, 3856, 3876, 3908, 3909, 3944, 3945, 3947, 3948, 3949, 3977, 3978, 3979, 3980, 3981, 3987, 4014, 4016, 4019, 4020, 4027, 4092, 4093, 4119, 4120, 4121, 4122, 4123, 4206, 4226, 4228, 4229, 4230, 4262, 4289, 4290, 4291, 4292, 4293, 4299, 4309, 4310, 4311, 4312, 4313, 4361, 4375, 4376, 4377, 4429, 4453, 4454, 4455, 4456, 4457, 4461, 4467, 4481, 4505, 4506, 4508, 4509, 4535, 4636, 4637, 4638, 4639, 4653, 4655, 4694, 4707, 4709, 4710, 4722, 4730, 4735, 4780, 4787, 4788, 4789, 4815, 4842, 4843, 4845, 4849, 4850, 4851, 4852, 4883, 4884, 4885, 4886, 4887, 4912, 4913, 4914, 4921, 4930, 4966, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5030, 5045, 5052, 5068, 5069, 5070, 5073, 5089, 5109, 5134, 5147, 5153, 5168, 5169, 5170, 5197, 5198, 5215, 5234, 5235, 5236, 5237, 5292, 5296, 5300, 5334, 5336, 5341, 5413, 5415, 5468, 5491, 5498, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5581, 5582, 5583, 5584, 5585, 5586, 5625, 5626, 5627, 5647, 5648, 5649, 5650, 5687, 5712, 5713, 5750, 5751, 5752, 5753, 5769, 5811, 5814, 5879, 5888, 5889, 5890, 5912, 5913, 5914, 5915, 5917, 5921, 5922, 5923, 5924, 5944, 5970, 5971, 5972, 6024, 6123, 6124, 6125, 6126, 6127, 6151, 6152, 6153, 6154, 6155, 6156, 6175, 6184, 6185, 6211, 6230, 6231, 6267, 6300, 6301, 6302, 6340, 6341, 6342, 6343, 6344, 6345, 6346, 6347, 6348, 6349, 6350, 6351, 6391, 6392, 6393, 6394, 6655, 6699, 6700, 6722, 6724, 6727, 6847, 6848, 6855, 6918, 6919, 6920, 6921, 6978, 6979, 6980, 7023, 7024, 7025, 7026, 7027, 7028, 7029)) ORDER BY FIELD(`e`.`entity_id`, 2941, 2976, 1115, 6980, 6979, 6978, 6302, 6301, 6300, 5585, 5584, 5583, 5582, 5581, 3842, 3841, 3413, 3412, 7029, 7027, 7026, 7025, 7024, 7023, 6921, 6920, 6919, 6918, 6855, 6848, 6847, 6727, 6724, 6722, 6699, 6655, 6394, 6391, 6351, 6350, 6348, 6347, 6346, 6345, 6344, 6343, 6342, 6341, 6340, 6230, 6211, 6156, 6154, 5944, 5924, 5923, 5922, 5921, 5915, 5914, 5913, 5912, 5814, 5811, 5769, 5752, 5751, 5750, 5713, 5712, 5687, 5648, 5647, 5626, 5625, 5498, 5413, 5334, 5215, 5070, 5069, 5052, 5045, 4993, 4992, 4989, 4887, 4883, 4851, 4850, 4849, 4789, 4780, 4735, 4730, 4655, 4653, 4639, 4638, 4481, 4461, 4377, 4376, 4375, 4310, 4309, 4262, 4230, 4229, 4228, 4226, 4093, 4092, 4027, 3908, 3750, 3720, 3719, 3718, 3711, 3681, 3410, 3409, 3215, 3208, 3207, 3205, 2943, 2721, 2395, 2391, 2153, 1999, 1617, 7028, 6700, 6393, 6392, 6349, 6267, 6231, 6185, 6184, 6175, 6155, 6153, 6152, 6151, 6127, 6126, 6125, 6124, 6123, 6024, 5972, 5971, 5970, 5917, 5890, 5889, 5888, 5879, 5753, 5650, 5649, 5627, 5586, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5491, 5468, 5415, 5341, 5336, 5300, 5296, 5292, 5237, 5236, 5235, 5234, 5198, 5197, 5170, 5169, 5168, 5153, 5147, 5134, 5109, 5089, 5073, 5068, 5030, 4999, 4994, 4991, 4990, 4966, 4930, 4921, 4914, 4913, 4912, 4886, 4885, 4884, 4852, 4845, 4843, 4842, 4815, 4788, 4787, 4722, 4710, 4709, 4707, 4694, 4637, 4636, 4535, 4509, 4508, 4506, 4505, 4467, 4457, 4456, 4455, 4454, 4453, 4429, 4361, 4313, 4312, 4311, 4299, 4293, 4292, 4291, 4290, 4289, 4206, 4123, 4122, 4121, 4120, 4119, 4020, 4019, 4016, 4014, 3987, 3981, 3980, 3979, 3978, 3977, 3949, 3948, 3947, 3945, 3944, 3909, 3876, 3856, 3844, 3800, 3799, 3798, 3797, 3796, 3795, 3749, 3748, 3717, 3699, 3698, 3685, 3684, 3683, 3682, 3589, 3588, 3578, 3577, 3574, 3573, 3572, 3568, 3567, 3566, 3565, 3543, 3542, 3540, 3539, 3488, 3434, 3433, 3432, 3416, 3415, 3414, 3411, 3404, 3397, 3396, 3395, 3339, 3216, 3210, 3209, 3206, 3204, 2998, 2992, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2851, 2850, 2839, 2838, 2530, 2442, 2441, 2394, 2393, 2392, 2384, 2382, 2381, 2380, 2379, 2377, 2355, 2334, 2332, 2331, 2287, 2160, 2159, 2151, 2125, 2124, 2122, 2040, 2039, 2038, 1967, 1612, 1605, 1281, 1275, 968, 697, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
3412
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
970.000 ₫
Special Price
945.000 ₫
5944
-
-
-
-
-
-
Giá thường:
290.000 ₫
Special Price
250.000 ₫
5687
-
-
-
-
Giá thường:
40.000 ₫
Special Price
30.000 ₫
5413
-
-
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:
260.000 ₫
Special Price
182.000 ₫
5069
-
Giá thường:
200.000 ₫
Special Price
126.000 ₫
5052