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, 936, 940, 1158, 1591, 1685, 1706, 1785, 1863, 1998, 1999, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2812, 2813, 2824, 2841, 2842, 2843, 2845, 2846, 2847, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 3109, 3127, 3155, 3158, 3159, 3170, 3171, 3180, 3182, 3258, 3261, 3262, 3265, 3267, 3276, 3277, 3281, 3294, 3299, 3301, 3308, 3314, 3315, 3318, 3319, 3322, 3323, 3327, 3328, 3331, 3332, 3353, 3364, 3422, 3435, 3437, 3440, 3445, 3525, 3531, 3532, 3551, 3553, 3554, 3555, 3557, 3558, 3559, 3561, 3562, 3564, 3582, 3623, 3709, 3724, 3764, 3951, 3961, 3962, 3987, 4019, 4020, 4021, 4025, 4027, 4028, 4029, 4031, 4032, 4034, 4086, 4087, 4088, 4089, 4106, 4109, 4110, 4125, 4139, 4140, 4141, 4186, 4225, 4244, 4246, 4253, 4254, 4255, 4256, 4257, 4258, 4260, 4261, 4344, 4345, 4346, 4347, 4348, 4359, 4360, 4362, 4364, 4375, 4387, 4388, 4389, 4390, 4391, 4392, 4393, 4394, 4396, 4397, 4403, 4404, 4405, 4406, 4409, 4410, 4411, 4412, 4417, 4418, 4430, 4431, 4432, 4433, 4449, 4450, 4451, 4452, 4520, 4521, 4522, 4523, 4597, 4602, 4603, 4604, 4605, 4609, 4650, 4651, 4652, 4653, 4654, 4679, 4717, 4718, 4719, 4720, 4721, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4815, 4817, 4818, 4819, 4820, 4821, 4822, 4823, 4824, 4825, 4828, 4829, 4830, 4862, 4879, 4893, 4894, 4895, 4899, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4917, 4918, 4919, 4921, 4923, 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, 5104, 5105, 5106, 5107, 5108, 5114, 5123, 5136, 5169, 5197, 5198, 5199, 5200, 5201, 5202, 5203, 5204, 5205, 5242, 5246, 5285, 5287, 5288, 5289, 5290, 5296, 5297, 5298, 5299, 5300, 5316, 5318, 5450, 5468, 5506, 5516, 5523, 5529, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5597, 5835, 5836, 5946, 5947, 5948, 5949, 5950, 6021, 6044, 6045, 6046, 6047, 6050, 6200, 6268, 6734, 6735, 6736, 6737, 6738, 6739, 6740, 6741, 6743, 6774, 6775, 6784, 6785, 6786, 6787, 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, 6884, 6885, 6891, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6900, 6901, 6906, 6975, 6976, 6977, 6989, 6991, 6992, 6993)) ORDER BY FIELD(`e`.`entity_id`, 5038, 5037, 5036, 5204, 5203, 5202, 5586, 5585, 5584, 5043, 5003, 6906, 6901, 6900, 6898, 6897, 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, 940, 6993, 6992, 6991, 6989, 6977, 6976, 6975, 6896, 6895, 6894, 6893, 6892, 6891, 6885, 6884, 6879, 6878, 6875, 6874, 6873, 6872, 6871, 6870, 6869, 6868, 6867, 6866, 6865, 6864, 6863, 6862, 6861, 6860, 6859, 6858, 6857, 6856, 6855, 6854, 6853, 6852, 6851, 6837, 6836, 6823, 6787, 6786, 6785, 6784, 6775, 6774, 6743, 6741, 6739, 6738, 6268, 6200, 5836, 5835, 5597, 5298, 5246, 5199, 5114, 5050, 5034, 5026, 5025, 5002, 5001, 4974, 4973, 4970, 4945, 4940, 4923, 4919, 4862, 4830, 4829, 4828, 4654, 4653, 4652, 4651, 4650, 4433, 4430, 4418, 4412, 4375, 4360, 4257, 4141, 4140, 4139, 4106, 4086, 4032, 4028, 4027, 3582, 3314, 3258, 2845, 2841, 1999, 1998, 1863, 1785, 1685, 1591, 1158, 936, 546, 6838, 6740, 6737, 6736, 6735, 6734, 6050, 6047, 6046, 6045, 6044, 6021, 5950, 5949, 5948, 5947, 5946, 5538, 5529, 5523, 5516, 5506, 5468, 5450, 5318, 5316, 5300, 5299, 5297, 5296, 5290, 5289, 5288, 5287, 5285, 5242, 5205, 5201, 5200, 5198, 5197, 5169, 5136, 5123, 5108, 5107, 5106, 5105, 5104, 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, 4921, 4918, 4917, 4914, 4913, 4912, 4899, 4894, 4879, 4825, 4824, 4821, 4820, 4819, 4818, 4817, 4815, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4721, 4720, 4719, 4718, 4717, 4679, 4609, 4605, 4604, 4603, 4602, 4597, 4523, 4522, 4521, 4520, 4452, 4451, 4450, 4449, 4432, 4431, 4417, 4410, 4409, 4406, 4405, 4404, 4403, 4397, 4396, 4394, 4393, 4392, 4391, 4390, 4389, 4388, 4364, 4362, 4359, 4348, 4347, 4346, 4345, 4344, 4261, 4258, 4255, 4254, 4253, 4246, 4244, 4225, 4186, 4125, 4110, 4089, 4088, 4087, 4034, 4031, 4029, 4025, 4021, 4020, 4019, 3987, 3962, 3961, 3951, 3764, 3724, 3709, 3623, 3564, 3562, 3561, 3559, 3558, 3557, 3555, 3554, 3553, 3551, 3532, 3531, 3525, 3445, 3440, 3437, 3435, 3422, 3364, 3353, 3332, 3331, 3328, 3327, 3323, 3322, 3319, 3318, 3315, 3308, 3301, 3299, 3294, 3281, 3277, 3276, 3267, 3265, 3182, 3180, 3171, 3170, 3159, 3158, 3155, 3127, 3109, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2847, 2846, 2843, 2842, 2824, 2813, 2812, 2460, 2458, 2457, 2449, 1706) 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
-
-
-
-
-
-
-
-
-
-
-