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, 684, 697, 968, 1115, 1158, 1275, 1281, 1436, 1471, 1567, 1605, 1612, 1617, 1852, 1967, 1999, 2038, 2039, 2040, 2122, 2124, 2125, 2145, 2146, 2147, 2287, 2331, 2332, 2334, 2355, 2377, 2379, 2380, 2381, 2382, 2384, 2391, 2392, 2393, 2394, 2395, 2530, 2721, 2777, 2778, 2781, 2782, 2789, 2838, 2839, 2850, 2851, 2863, 2870, 2871, 2872, 2940, 2941, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 2992, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3278, 3280, 3292, 3293, 3365, 3368, 3395, 3396, 3397, 3404, 3406, 3407, 3409, 3410, 3411, 3412, 3413, 3414, 3415, 3416, 3432, 3433, 3434, 3435, 3437, 3440, 3441, 3443, 3444, 3448, 3488, 3543, 3572, 3573, 3574, 3577, 3578, 3581, 3584, 3587, 3588, 3589, 3600, 3660, 3661, 3664, 3665, 3666, 3674, 3681, 3682, 3683, 3684, 3685, 3689, 3697, 3698, 3699, 3711, 3717, 3718, 3719, 3720, 3753, 3755, 3775, 3800, 3841, 3842, 3844, 3854, 3857, 3858, 3859, 3876, 3900, 3901, 3908, 3909, 3915, 3917, 3939, 3940, 3944, 3945, 3947, 3948, 3949, 3951, 3953, 3954, 3955, 3961, 3962, 3977, 3978, 3979, 3980, 3981, 3987, 3996, 4025, 4026, 4027, 4052, 4053, 4092, 4093, 4111, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4157, 4189, 4190, 4191, 4196, 4206, 4226, 4228, 4229, 4230, 4262, 4289, 4290, 4291, 4292, 4293, 4299, 4307, 4309, 4310, 4311, 4312, 4313, 4314, 4369, 4375, 4376, 4377, 4390, 4391, 4392, 4393, 4394, 4396, 4397, 4419, 4429, 4443, 4453, 4454, 4455, 4456, 4457, 4461, 4467, 4473, 4478, 4480, 4498, 4520, 4521, 4522, 4523, 4535, 4599, 4600, 4601, 4602, 4603, 4604, 4605, 4606, 4607, 4608, 4609, 4635, 4636, 4637, 4638, 4639, 4642, 4653, 4655, 4671, 4686, 4694, 4700, 4730, 4731, 4738, 4767, 4784, 4788, 4842, 4843, 4845, 4849, 4850, 4851, 4852, 4879, 4888, 4889, 4890, 4898, 4912, 4913, 4914, 4930, 4931, 4932, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5036, 5037, 5038, 5044, 5046, 5073, 5085, 5086, 5088, 5089, 5094, 5095, 5096, 5109, 5123, 5134, 5144, 5147, 5148, 5149, 5150, 5154, 5168, 5172, 5189, 5190, 5211, 5234, 5235, 5236, 5237, 5255, 5277, 5278, 5279, 5291, 5334, 5354, 5433, 5434, 5435, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5468, 5491, 5494, 5498, 5505, 5506, 5507, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5534, 5607, 5611, 5625, 5626, 5627, 5687, 5707, 5710, 5712, 5713, 5714, 5715, 5737, 5738, 5739, 5740, 5742, 5750, 5751, 5752, 5768, 5769, 5770, 5810, 5811, 5812, 5813, 5814, 5815, 5829, 5831, 5832, 5838, 5886, 5912, 5913, 5914, 5915, 5917, 5921, 5922, 5923, 5924, 5947, 5949, 5970, 5971, 5972, 6043, 6058, 6059, 6060, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6080, 6081, 6084, 6096, 6123, 6124, 6125, 6126, 6127, 6134, 6135, 6136, 6144, 6151, 6152, 6153, 6154, 6155, 6156, 6186, 6211, 6223, 6224, 6249, 6250, 6251, 6252, 6267, 6271, 6272, 6300, 6301, 6302, 6339, 6340, 6341, 6342, 6343, 6344, 6345, 6346, 6347, 6348, 6349, 6350, 6351, 6360, 6427, 6428, 6429, 6504, 6559, 6579, 6580, 6581, 6656, 6695, 6696, 6697, 6701, 6731, 6732, 6733, 6741, 6754, 6766, 6773, 6774, 6788, 6789, 6790, 6791, 6794, 6795, 6799, 6800, 6803, 6804, 6805, 6807, 6808, 6809, 6810, 6811, 6812, 6827, 6847, 6848, 6851, 6855, 6859, 6865, 6866, 6880, 6881, 6882, 6883, 6895, 6896, 6918, 6919, 6920, 6921, 6929, 6930, 6931, 6978, 6979, 6980, 6994, 6995, 6996, 7009, 7010, 7011, 7023, 7024, 7025, 7026, 7027, 7028, 7029, 7030, 7031, 7032, 7038)) ORDER BY FIELD(`e`.`entity_id`, 2976, 1115, 2941, 3842, 3841, 3413, 3412, 6429, 6345, 6341, 5815, 5752, 5751, 5750, 5713, 5712, 5498, 5038, 5037, 5036, 4730, 3681, 7038, 7032, 7031, 7030, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7011, 7010, 7009, 6996, 6995, 6994, 6980, 6979, 6978, 6931, 6930, 6929, 6921, 6920, 6919, 6918, 6896, 6895, 6883, 6882, 6881, 6880, 6866, 6865, 6859, 6855, 6851, 6848, 6847, 6827, 6812, 6809, 6808, 6805, 6803, 6799, 6795, 6794, 6791, 6790, 6789, 6788, 6774, 6773, 6766, 6754, 6741, 6733, 6732, 6731, 6701, 6697, 6696, 6695, 6656, 6581, 6580, 6579, 6559, 6428, 6427, 6360, 6351, 6350, 6348, 6347, 6346, 6344, 6343, 6342, 6340, 6339, 6302, 6301, 6300, 6224, 6223, 6211, 6156, 6154, 6077, 6076, 6074, 5924, 5923, 5922, 5921, 5915, 5914, 5913, 5912, 5838, 5832, 5831, 5829, 5814, 5813, 5811, 5810, 5742, 5715, 5714, 5710, 5707, 5687, 5626, 5625, 5611, 5607, 5534, 5494, 5461, 5334, 5044, 4993, 4992, 4989, 4851, 4850, 4849, 4767, 4731, 4655, 4653, 4639, 4638, 4498, 4461, 4377, 4376, 4375, 4310, 4309, 4262, 4230, 4229, 4228, 4226, 4093, 4092, 4052, 4027, 3917, 3915, 3908, 3753, 3720, 3719, 3718, 3711, 3410, 3409, 3215, 3208, 3207, 3205, 2721, 2395, 2391, 2147, 2146, 2145, 1999, 1852, 1617, 1471, 1436, 1158, 6811, 6810, 6807, 6804, 6800, 6504, 6349, 6272, 6271, 6267, 6252, 6251, 6250, 6249, 6186, 6155, 6153, 6152, 6151, 6144, 6136, 6135, 6134, 6127, 6126, 6125, 6124, 6123, 6096, 6084, 6081, 6080, 6075, 6073, 6072, 6071, 6070, 6069, 6060, 6059, 6058, 6043, 5972, 5971, 5970, 5949, 5947, 5917, 5886, 5812, 5770, 5769, 5768, 5740, 5739, 5738, 5737, 5627, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5507, 5506, 5505, 5491, 5468, 5463, 5462, 5460, 5459, 5458, 5457, 5435, 5434, 5433, 5354, 5291, 5279, 5278, 5277, 5255, 5237, 5236, 5235, 5234, 5211, 5190, 5189, 5172, 5168, 5154, 5150, 5149, 5148, 5147, 5144, 5134, 5123, 5109, 5096, 5095, 5094, 5089, 5088, 5086, 5085, 5073, 5046, 4999, 4994, 4991, 4990, 4932, 4931, 4930, 4914, 4913, 4912, 4898, 4890, 4889, 4888, 4879, 4852, 4845, 4843, 4842, 4788, 4784, 4738, 4700, 4694, 4686, 4671, 4642, 4637, 4636, 4635, 4609, 4608, 4607, 4606, 4605, 4604, 4603, 4602, 4601, 4600, 4599, 4535, 4523, 4522, 4521, 4520, 4480, 4478, 4473, 4467, 4457, 4456, 4455, 4454, 4453, 4443, 4429, 4419, 4397, 4396, 4394, 4393, 4392, 4391, 4390, 4369, 4314, 4313, 4312, 4311, 4307, 4299, 4293, 4292, 4291, 4290, 4289, 4206, 4196, 4191, 4190, 4189, 4157, 4125, 4124, 4123, 4122, 4121, 4120, 4119, 4118, 4117, 4116, 4115, 4111, 4053, 4026, 4025, 3996, 3987, 3981, 3980, 3979, 3978, 3977, 3962, 3961, 3955, 3954, 3953, 3951, 3949, 3948, 3947, 3945, 3944, 3940, 3939, 3909, 3901, 3900, 3876, 3859, 3858, 3857, 3854, 3844, 3800, 3775, 3755, 3717, 3699, 3698, 3697, 3689, 3685, 3684, 3683, 3682, 3674, 3666, 3665, 3664, 3661, 3660, 3600, 3589, 3588, 3587, 3584, 3581, 3578, 3577, 3574, 3573, 3572, 3543, 3488, 3448, 3444, 3443, 3441, 3440, 3437, 3435, 3434, 3433, 3432, 3416, 3415, 3414, 3411, 3407, 3406, 3404, 3397, 3396, 3395, 3368, 3365, 3293, 3292, 3280, 3278, 3216, 3210, 3209, 3206, 3204, 2992, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2872, 2871, 2870, 2863, 2851, 2850, 2839, 2838, 2789, 2782, 2781, 2778, 2777, 2530, 2394, 2393, 2392, 2384, 2382, 2381, 2380, 2379, 2377, 2355, 2334, 2332, 2331, 2287, 2125, 2124, 2122, 2040, 2039, 2038, 1967, 1612, 1605, 1567, 1281, 1275, 968, 697, 684, 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:
580.000 ₫
Special Price
550.000 ₫
6429
-
-
-
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-