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(546, 684, 936, 940, 968, 1115, 1158, 1436, 1471, 1567, 1591, 1685, 1706, 1785, 1852, 1863, 1967, 1998, 1999, 2038, 2039, 2040, 2145, 2146, 2147, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2530, 2777, 2778, 2781, 2782, 2789, 2812, 2813, 2824, 2841, 2842, 2843, 2845, 2846, 2847, 2870, 2871, 2872, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 2940, 2941, 2972, 2975, 2976, 2977, 2978, 2979, 2980, 2981, 3109, 3127, 3155, 3158, 3159, 3170, 3171, 3180, 3182, 3258, 3261, 3262, 3265, 3267, 3276, 3277, 3278, 3280, 3281, 3292, 3293, 3294, 3299, 3301, 3308, 3314, 3315, 3318, 3319, 3322, 3323, 3327, 3328, 3331, 3332, 3353, 3364, 3365, 3368, 3397, 3406, 3407, 3412, 3413, 3414, 3422, 3435, 3437, 3440, 3441, 3443, 3444, 3445, 3448, 3525, 3531, 3532, 3551, 3553, 3554, 3555, 3557, 3558, 3559, 3561, 3562, 3564, 3581, 3582, 3584, 3600, 3623, 3660, 3661, 3664, 3665, 3666, 3674, 3681, 3682, 3684, 3685, 3689, 3697, 3698, 3699, 3709, 3724, 3753, 3755, 3764, 3775, 3800, 3841, 3842, 3854, 3857, 3858, 3859, 3900, 3901, 3915, 3917, 3939, 3940, 3947, 3948, 3949, 3951, 3953, 3954, 3955, 3961, 3962, 3977, 3978, 3980, 3981, 3987, 3996, 4019, 4020, 4021, 4025, 4026, 4027, 4028, 4029, 4031, 4032, 4034, 4052, 4053, 4086, 4087, 4088, 4089, 4106, 4109, 4110, 4111, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4139, 4140, 4141, 4157, 4186, 4189, 4190, 4191, 4196, 4225, 4244, 4246, 4253, 4254, 4255, 4256, 4257, 4258, 4260, 4261, 4289, 4290, 4291, 4292, 4307, 4314, 4344, 4345, 4346, 4347, 4348, 4359, 4360, 4362, 4364, 4369, 4375, 4387, 4388, 4389, 4390, 4391, 4392, 4393, 4394, 4396, 4397, 4403, 4404, 4405, 4406, 4409, 4410, 4411, 4412, 4417, 4418, 4419, 4430, 4431, 4432, 4433, 4443, 4449, 4450, 4451, 4452, 4453, 4473, 4478, 4480, 4520, 4521, 4522, 4523, 4535, 4597, 4599, 4600, 4601, 4602, 4603, 4604, 4605, 4606, 4607, 4608, 4609, 4635, 4642, 4650, 4651, 4652, 4653, 4654, 4671, 4679, 4686, 4717, 4718, 4719, 4720, 4721, 4730, 4731, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4788, 4815, 4817, 4818, 4819, 4820, 4821, 4822, 4823, 4824, 4825, 4828, 4829, 4830, 4862, 4879, 4888, 4889, 4890, 4893, 4894, 4895, 4898, 4899, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4917, 4918, 4919, 4921, 4923, 4930, 4931, 4932, 4939, 4940, 4941, 4942, 4943, 4944, 4945, 4947, 4948, 4949, 4950, 4951, 4952, 4953, 4954, 4955, 4956, 4957, 4958, 4959, 4960, 4961, 4962, 4966, 4970, 4971, 4972, 4973, 4974, 4975, 4978, 4998, 5000, 5001, 5002, 5003, 5008, 5009, 5010, 5011, 5012, 5013, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5043, 5047, 5049, 5050, 5051, 5059, 5071, 5084, 5085, 5086, 5088, 5089, 5094, 5095, 5096, 5104, 5105, 5106, 5107, 5108, 5114, 5123, 5136, 5144, 5147, 5148, 5149, 5150, 5154, 5169, 5172, 5189, 5190, 5197, 5198, 5199, 5200, 5201, 5202, 5203, 5204, 5205, 5211, 5234, 5235, 5236, 5237, 5242, 5246, 5277, 5278, 5279, 5285, 5287, 5288, 5289, 5290, 5296, 5297, 5298, 5299, 5300, 5316, 5318, 5354, 5433, 5434, 5435, 5450, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5468, 5494, 5498, 5505, 5506, 5507, 5516, 5517, 5518, 5519, 5520, 5521, 5522, 5523, 5529, 5534, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5597, 5607, 5611, 5707, 5710, 5712, 5713, 5714, 5715, 5737, 5738, 5739, 5740, 5742, 5750, 5751, 5752, 5768, 5769, 5770, 5810, 5811, 5812, 5813, 5814, 5815, 5835, 5836, 5838, 5886, 5946, 5947, 5948, 5949, 5950, 6021, 6043, 6044, 6045, 6046, 6047, 6050, 6058, 6059, 6060, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6080, 6081, 6084, 6096, 6134, 6135, 6136, 6200, 6211, 6223, 6224, 6249, 6250, 6251, 6252, 6268, 6271, 6272, 6360, 6427, 6428, 6429, 6504, 6559, 6579, 6580, 6581, 6695, 6696, 6697, 6731, 6732, 6733, 6734, 6735, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6754, 6766, 6773, 6774, 6775, 6784, 6785, 6786, 6787, 6788, 6789, 6790, 6791, 6794, 6795, 6799, 6800, 6803, 6804, 6805, 6807, 6808, 6809, 6810, 6811, 6812, 6823, 6836, 6837, 6838, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6868, 6869, 6870, 6871, 6872, 6873, 6874, 6875, 6878, 6879, 6880, 6881, 6882, 6883, 6884, 6885, 6891, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6900, 6901, 6906, 6929, 6930, 6931, 6975, 6976, 6977, 6989, 6991, 6992, 6993, 6994, 6995, 6996, 7009, 7010, 7011, 7030, 7031, 7032)) ORDER BY FIELD(`e`.`entity_id`, 5038, 5037, 5036, 5204, 5203, 5202, 5585, 5584, 5043, 5003, 6906, 6901, 6900, 6898, 6897, 6896, 6895, 6866, 6865, 6859, 6851, 6774, 6741, 5583, 5582, 5581, 5051, 5033, 5029, 5028, 5027, 5013, 5010, 5009, 5008, 4952, 4950, 4948, 4947, 4911, 4910, 4909, 4908, 4907, 4906, 4895, 4893, 4823, 4822, 4411, 4387, 4260, 4256, 4109, 3262, 3261, 2464, 2463, 2461, 2452, 1158, 940, 7032, 7031, 7030, 7011, 7010, 7009, 6996, 6995, 6994, 6993, 6992, 6991, 6989, 6977, 6976, 6975, 6931, 6930, 6929, 6894, 6893, 6892, 6891, 6885, 6884, 6883, 6882, 6881, 6880, 6879, 6878, 6875, 6874, 6873, 6872, 6871, 6870, 6869, 6868, 6867, 6864, 6863, 6862, 6861, 6860, 6858, 6857, 6856, 6855, 6854, 6853, 6852, 6837, 6836, 6823, 6812, 6809, 6808, 6805, 6803, 6799, 6795, 6794, 6791, 6790, 6789, 6788, 6787, 6786, 6785, 6784, 6775, 6773, 6754, 6743, 6739, 6738, 6733, 6732, 6731, 6697, 6696, 6695, 6581, 6580, 6579, 6559, 6429, 6428, 6427, 6360, 6224, 6223, 6211, 6200, 6077, 6076, 6074, 5838, 5836, 5835, 5815, 5814, 5813, 5811, 5810, 5769, 5768, 5752, 5751, 5750, 5742, 5715, 5714, 5713, 5712, 5710, 5707, 5611, 5607, 5597, 5534, 5498, 5494, 5461, 5298, 5199, 5114, 5050, 5034, 5026, 5025, 5002, 5001, 4974, 4973, 4970, 4945, 4940, 4923, 4919, 4862, 4830, 4829, 4828, 4731, 4730, 4654, 4653, 4652, 4651, 4650, 4433, 4430, 4418, 4412, 4375, 4360, 4257, 4141, 4140, 4139, 4106, 4086, 4052, 4032, 4028, 4027, 3917, 3915, 3842, 3841, 3753, 3681, 3582, 3413, 3412, 3314, 3258, 2976, 2941, 2845, 2841, 2147, 2146, 2145, 1999, 1998, 1863, 1852, 1785, 1685, 1591, 1471, 1436, 1115, 936, 546, 6838, 6811, 6810, 6807, 6804, 6800, 6766, 6740, 6737, 6736, 6735, 6734, 6504, 6272, 6271, 6268, 6252, 6251, 6250, 6249, 6136, 6135, 6134, 6096, 6084, 6081, 6080, 6075, 6073, 6072, 6071, 6070, 6069, 6060, 6059, 6058, 6050, 6047, 6046, 6045, 6044, 6043, 6021, 5950, 5949, 5948, 5947, 5946, 5886, 5812, 5770, 5740, 5739, 5738, 5737, 5586, 5538, 5529, 5523, 5522, 5521, 5520, 5519, 5518, 5517, 5516, 5507, 5506, 5505, 5468, 5463, 5462, 5460, 5459, 5458, 5457, 5450, 5435, 5434, 5433, 5354, 5318, 5316, 5300, 5299, 5297, 5296, 5290, 5289, 5288, 5287, 5285, 5279, 5278, 5277, 5246, 5242, 5237, 5236, 5235, 5234, 5211, 5205, 5201, 5200, 5198, 5197, 5190, 5189, 5172, 5169, 5154, 5150, 5149, 5148, 5147, 5144, 5136, 5123, 5108, 5107, 5106, 5105, 5104, 5096, 5095, 5094, 5089, 5088, 5086, 5085, 5084, 5071, 5059, 5049, 5047, 5039, 5035, 5030, 5024, 5012, 5011, 5000, 4998, 4978, 4975, 4972, 4971, 4966, 4962, 4961, 4960, 4959, 4958, 4957, 4956, 4955, 4954, 4953, 4951, 4949, 4944, 4943, 4942, 4941, 4939, 4932, 4931, 4930, 4921, 4918, 4917, 4914, 4913, 4912, 4899, 4898, 4894, 4890, 4889, 4888, 4879, 4825, 4824, 4821, 4820, 4819, 4818, 4817, 4815, 4788, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4721, 4720, 4719, 4718, 4717, 4686, 4679, 4671, 4642, 4635, 4609, 4608, 4607, 4606, 4605, 4604, 4603, 4602, 4601, 4600, 4599, 4597, 4535, 4523, 4522, 4521, 4520, 4480, 4478, 4473, 4453, 4452, 4451, 4450, 4449, 4443, 4432, 4431, 4419, 4417, 4410, 4409, 4406, 4405, 4404, 4403, 4397, 4396, 4394, 4393, 4392, 4391, 4390, 4389, 4388, 4369, 4364, 4362, 4359, 4348, 4347, 4346, 4345, 4344, 4314, 4307, 4292, 4291, 4290, 4289, 4261, 4258, 4255, 4254, 4253, 4246, 4244, 4225, 4196, 4191, 4190, 4189, 4186, 4157, 4125, 4124, 4123, 4122, 4121, 4120, 4119, 4118, 4117, 4116, 4115, 4111, 4110, 4089, 4088, 4087, 4053, 4034, 4031, 4029, 4026, 4025, 4021, 4020, 4019, 3996, 3987, 3981, 3980, 3978, 3977, 3962, 3961, 3955, 3954, 3953, 3951, 3949, 3948, 3947, 3940, 3939, 3901, 3900, 3859, 3858, 3857, 3854, 3800, 3775, 3764, 3755, 3724, 3709, 3699, 3698, 3697, 3689, 3685, 3684, 3682, 3674, 3666, 3665, 3664, 3661, 3660, 3623, 3600, 3584, 3581, 3564, 3562, 3561, 3559, 3558, 3557, 3555, 3554, 3553, 3551, 3532, 3531, 3525, 3448, 3445, 3444, 3443, 3441, 3440, 3437, 3435, 3422, 3414, 3407, 3406, 3397, 3368, 3365, 3364, 3353, 3332, 3331, 3328, 3327, 3323, 3322, 3319, 3318, 3315, 3308, 3301, 3299, 3294, 3293, 3292, 3281, 3280, 3278, 3277, 3276, 3267, 3265, 3182, 3180, 3171, 3170, 3159, 3158, 3155, 3127, 3109, 2981, 2980, 2979, 2978, 2977, 2975, 2972, 2940, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2872, 2871, 2870, 2847, 2846, 2843, 2842, 2824, 2813, 2812, 2789, 2782, 2781, 2778, 2777, 2530, 2460, 2458, 2457, 2449, 2040, 2039, 2038, 1967, 1706, 1567, 968, 684) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5202
-
-
Giá thường:
280.000 ₫
Special Price
120.000 ₫
5043
-
Giá thường:
220.000 ₫
Special Price
126.000 ₫
5003
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
260.000 ₫
Special Price
220.000 ₫
5051
-
Giá thường:
290.000 ₫
Special Price
260.000 ₫
5033
-
Giá thường:
290.000 ₫
Special Price
100.000 ₫
5027
-
Giá thường:
250.000 ₫
Special Price
140.000 ₫
5008
-
Giá thường:
220.000 ₫
Special Price
165.000 ₫
4950
-
Giá thường:
380.000 ₫
Special Price
320.000 ₫
4947
-
-
-
Giá thường:
180.000 ₫
Special Price
140.000 ₫
4893
-
Giá thường:
180.000 ₫
Special Price
110.000 ₫
4822
-
Giá thường:
470.000 ₫
Special Price
294.000 ₫
4411
-
Giá thường:
800.000 ₫
Special Price
780.000 ₫
4387
-
Giá thường:
250.000 ₫
Special Price
150.000 ₫
4260
-
Giá thường:
250.000 ₫
Special Price
150.000 ₫
4256
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
-
Giá thường:
390.000 ₫
Special Price
273.000 ₫
940
-
-