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(566, 567, 719, 933, 1045, 1567, 1685, 1714, 1750, 1844, 2159, 2160, 2326, 2351, 2426, 2430, 2431, 2432, 2433, 2434, 2438, 2439, 2441, 2442, 2446, 2755, 2756, 2878, 2879, 2880, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2937, 2938, 2983, 2986, 2987, 3014, 3109, 3121, 3237, 3238, 3239, 3258, 3261, 3285, 3289, 3292, 3293, 3295, 3299, 3300, 3301, 3310, 3314, 3321, 3329, 3331, 3332, 3336, 3338, 3345, 3347, 3353, 3354, 3357, 3358, 3359, 3360, 3361, 3368, 3448, 3488, 3489, 3490, 3491, 3492, 3494, 3496, 3498, 3499, 3500, 3529, 3530, 3539, 3540, 3547, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3582, 3587, 3611, 3625, 3643, 3653, 3655, 3696, 3747, 3749, 3757, 3764, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 3830, 3837, 3838, 3839, 3840, 3855, 3856, 3857, 3858, 3859, 3866, 3867, 3868, 3869, 3875, 3883, 3900, 3901, 3940, 3955, 3956, 3962, 3975, 3976, 3986, 3994, 3996, 4005, 4006, 4016, 4031, 4032, 4034, 4036, 4037, 4040, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4092, 4105, 4107, 4108, 4113, 4124, 4157, 4166, 4167, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4177, 4178, 4179, 4181, 4186, 4198, 4199, 4200, 4201, 4204, 4206, 4210, 4211, 4212, 4247, 4256, 4257, 4258, 4260, 4262, 4317, 4334, 4336, 4337, 4338, 4339, 4340, 4341, 4352, 4353, 4354, 4355, 4360, 4383, 4384, 4388, 4396, 4397, 4403, 4409, 4410, 4411, 4412, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4430, 4431, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4455, 4473, 4478, 4483, 4484, 4485, 4486, 4487, 4488, 4489, 4490, 4491, 4492, 4493, 4494, 4495, 4496, 4498, 4499, 4500, 4501, 4502, 4503, 4505, 4506, 4508, 4509, 4511, 4512, 4513, 4514, 4519, 4520, 4521, 4522, 4523, 4524, 4525, 4530, 4575, 4588, 4597, 4599, 4600, 4601, 4602, 4603, 4604, 4605, 4606, 4607, 4608, 4628, 4635, 4642, 4656, 4657, 4658, 4659, 4660, 4661, 4662, 4663, 4676, 4678, 4684, 4691, 4717, 4718, 4719, 4720, 4721, 4738, 4749, 4750, 4751, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4770, 4771, 4772, 4818, 4819, 4820, 4821, 4822, 4823, 4824, 4825, 4878, 4880, 4881, 4882, 4888, 4889, 4890, 4904, 4905, 4930, 4947, 4948, 4949, 4950, 4951, 4952, 4953, 4954, 4977, 4986, 4987, 4988, 4995, 4996, 4997, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5025, 5026, 5032, 5035, 5043, 5078, 5104, 5105, 5106, 5107, 5109, 5111, 5112, 5114, 5117, 5118, 5120, 5142, 5153, 5162, 5163, 5164, 5165, 5166, 5173, 5176, 5184, 5185, 5186, 5188, 5189, 5191, 5192, 5193, 5197, 5215, 5227, 5274, 5280, 5281, 5282, 5283, 5286, 5294, 5296, 5299, 5307, 5310, 5311, 5313, 5319, 5321, 5322, 5323, 5327, 5328, 5329, 5330, 5331, 5343, 5354, 5358, 5362, 5363, 5364, 5387, 5409, 5410, 5413, 5414, 5415, 5416, 5425, 5444, 5445, 5469, 5490, 5499, 5500, 5501, 5502, 5503, 5504, 5537, 5538, 5539, 5540, 5541, 5564, 5587, 5588, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5628, 5629, 5630, 5633, 5637, 5663, 5664, 5665, 5666, 5673, 5674, 5675, 5676, 5677, 5678, 5679, 5697, 5698, 5713, 5721, 5722, 5723, 5724, 5742, 5743, 5744, 5745, 5746, 5755, 5756, 5757, 5758, 5759, 5762, 5774, 5779, 5784, 5788, 5792, 5793, 5794, 5795, 5796, 5797, 5798, 5799, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5810, 5811, 5812, 5813, 5814, 5815, 5820, 5821, 5822, 5823, 5824, 5838, 5841, 5861, 5862, 5863, 5886, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5906, 5911, 5949, 5950, 5957, 5958, 6029, 6030, 6031, 6032, 6033, 6040, 6041, 6043, 6044, 6045, 6046, 6047, 6058, 6059, 6060, 6082, 6083, 6084, 6085, 6086, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6130, 6135, 6153, 6175, 6194, 6195, 6196, 6200, 6201, 6202, 6203, 6204, 6205, 6209, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6233, 6234, 6235, 6264, 6265, 6266, 6285, 6290, 6293, 6294, 6295, 6296, 6297, 6298, 6299, 6336, 6337, 6338, 6339, 6344, 6345, 6346, 6347, 6349, 6354, 6362, 6363, 6364, 6365, 6369, 6370, 6371, 6391, 6392, 6393, 6394, 6398, 6399, 6400, 6401, 6403, 6405, 6427, 6428, 6431, 6443, 6452, 6453, 6454, 6455, 6456, 6457, 6474, 6486, 6488, 6489, 6491, 6507, 6560, 6561, 6562, 6563, 6564, 6565, 6577, 6582, 6583, 6584, 6585, 6586, 6625, 6626, 6627, 6628, 6629, 6630, 6631, 6632, 6633, 6634, 6635, 6637, 6638, 6639, 6640, 6641, 6642, 6643, 6644, 6645, 6646, 6647, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6663, 6664, 6665, 6666, 6667, 6672, 6673, 6674, 6675, 6676, 6694, 6697, 6714, 6715, 6716, 6717, 6718, 6719, 6731, 6732, 6733, 6734, 6735, 6736, 6737, 6738, 6743, 6754, 6758, 6763, 6766, 6769, 6774, 6796, 6797, 6798, 6813, 6814, 6818, 6821, 6822, 6823, 6826, 6830, 6836, 6837, 6838, 6859, 6860, 6861, 6862, 6863, 6864, 6880, 6881, 6882, 6883, 6886, 6887, 6888, 6889, 6890, 6903, 6904, 6905, 6914, 6915, 6916, 6917, 6920, 6922, 6923, 6924, 6925, 6926, 6929, 6930, 6931, 6932, 6948, 6958, 6959, 6960, 6964, 6965, 6966, 6967, 6968, 6969, 6977, 6978, 6979, 6980, 6989, 6999, 7003, 7008, 7012, 7023, 7024, 7025, 7026, 7027, 7028, 7029)) ORDER BY FIELD(`e`.`entity_id`, 6653, 6652, 6651, 6650, 6649, 6648, 6635, 6634, 6633, 6632, 6631, 6630, 6629, 6628, 6627, 6626, 6625, 5019, 5018, 4988, 4986, 3258, 6932, 6904, 6888, 6887, 6886, 6823, 6822, 6821, 6818, 6813, 6798, 6797, 6796, 6763, 6754, 6660, 6659, 6658, 6657, 6656, 6655, 6654, 6647, 6646, 6645, 6643, 6642, 6641, 6640, 6639, 6638, 6637, 6561, 6507, 6363, 6235, 6234, 6233, 5815, 5814, 5813, 5698, 5697, 5674, 5623, 5622, 5620, 5617, 5614, 5612, 5611, 5609, 5607, 5499, 5445, 5425, 5358, 5327, 5043, 4952, 4950, 4948, 4947, 4763, 4496, 4422, 4411, 4360, 4260, 4257, 4256, 4178, 4177, 4168, 4050, 4032, 3582, 3314, 3285, 2446, 1844, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7012, 7008, 7003, 6999, 6989, 6980, 6979, 6978, 6977, 6969, 6968, 6967, 6966, 6965, 6964, 6960, 6959, 6958, 6948, 6931, 6930, 6929, 6926, 6925, 6924, 6923, 6922, 6920, 6917, 6916, 6915, 6914, 6905, 6903, 6890, 6889, 6883, 6882, 6881, 6880, 6864, 6863, 6862, 6861, 6860, 6859, 6837, 6836, 6830, 6826, 6814, 6774, 6769, 6758, 6743, 6738, 6733, 6732, 6731, 6719, 6718, 6717, 6716, 6715, 6714, 6697, 6694, 6676, 6674, 6673, 6672, 6667, 6666, 6665, 6664, 6663, 6586, 6585, 6584, 6583, 6582, 6565, 6564, 6563, 6562, 6560, 6491, 6489, 6488, 6486, 6474, 6457, 6453, 6452, 6443, 6431, 6428, 6427, 6405, 6403, 6401, 6400, 6399, 6398, 6394, 6391, 6365, 6364, 6362, 6354, 6347, 6346, 6345, 6344, 6339, 6338, 6337, 6336, 6290, 6285, 6221, 6219, 6218, 6217, 6216, 6215, 6204, 6203, 6202, 6201, 6200, 6195, 6194, 6118, 6116, 6087, 6086, 6083, 6082, 6041, 6033, 5902, 5901, 5900, 5897, 5896, 5862, 5861, 5838, 5820, 5811, 5810, 5788, 5784, 5779, 5759, 5742, 5724, 5723, 5722, 5721, 5713, 5675, 5673, 5666, 5665, 5664, 5663, 5564, 5500, 5490, 5469, 5413, 5329, 5328, 5215, 5114, 5112, 5111, 5032, 5026, 5025, 4977, 4823, 4822, 4750, 4749, 4519, 4501, 4499, 4498, 4494, 4493, 4491, 4490, 4489, 4430, 4418, 4412, 4384, 4262, 4200, 4198, 4173, 4169, 4166, 4108, 4092, 4052, 4049, 3994, 3696, 3625, 3530, 3358, 3354, 3345, 3261, 3121, 1685, 933, 567, 566, 6838, 6766, 6737, 6736, 6735, 6734, 6675, 6644, 6577, 6456, 6455, 6454, 6393, 6392, 6371, 6370, 6369, 6349, 6299, 6298, 6297, 6296, 6295, 6294, 6293, 6266, 6265, 6264, 6220, 6209, 6205, 6196, 6175, 6153, 6135, 6130, 6127, 6126, 6125, 6124, 6123, 6122, 6121, 6120, 6119, 6117, 6115, 6114, 6113, 6112, 6110, 6109, 6108, 6107, 6106, 6105, 6104, 6103, 6102, 6101, 6100, 6099, 6098, 6097, 6096, 6095, 6094, 6093, 6092, 6091, 6090, 6089, 6088, 6085, 6084, 6060, 6059, 6058, 6047, 6046, 6045, 6044, 6043, 6040, 6032, 6031, 6030, 6029, 5958, 5957, 5950, 5949, 5911, 5906, 5899, 5898, 5886, 5863, 5841, 5824, 5823, 5822, 5821, 5812, 5807, 5806, 5805, 5804, 5803, 5802, 5801, 5799, 5798, 5797, 5796, 5795, 5794, 5793, 5792, 5774, 5762, 5758, 5757, 5756, 5755, 5746, 5745, 5744, 5743, 5679, 5678, 5677, 5676, 5637, 5633, 5630, 5629, 5628, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5610, 5608, 5588, 5587, 5541, 5540, 5539, 5538, 5537, 5504, 5503, 5502, 5501, 5444, 5416, 5415, 5414, 5410, 5409, 5387, 5364, 5363, 5362, 5354, 5343, 5331, 5330, 5323, 5322, 5321, 5319, 5313, 5311, 5310, 5307, 5299, 5296, 5294, 5286, 5283, 5282, 5281, 5280, 5274, 5227, 5197, 5193, 5192, 5191, 5189, 5188, 5186, 5185, 5184, 5176, 5173, 5166, 5165, 5164, 5163, 5162, 5153, 5142, 5120, 5118, 5117, 5109, 5107, 5106, 5105, 5104, 5078, 5035, 5021, 5020, 5007, 5006, 5005, 5004, 4997, 4996, 4995, 4987, 4954, 4953, 4951, 4949, 4930, 4905, 4904, 4890, 4889, 4888, 4882, 4881, 4880, 4878, 4825, 4824, 4821, 4820, 4819, 4818, 4772, 4771, 4770, 4764, 4762, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4751, 4738, 4721, 4720, 4719, 4718, 4717, 4691, 4684, 4678, 4676, 4663, 4662, 4661, 4660, 4659, 4658, 4657, 4656, 4642, 4635, 4628, 4608, 4607, 4606, 4605, 4604, 4603, 4602, 4601, 4600, 4599, 4597, 4588, 4575, 4530, 4525, 4524, 4523, 4522, 4521, 4520, 4514, 4513, 4512, 4511, 4509, 4508, 4506, 4505, 4503, 4502, 4500, 4495, 4492, 4488, 4487, 4486, 4485, 4484, 4483, 4478, 4473, 4455, 4452, 4451, 4450, 4449, 4448, 4447, 4446, 4445, 4444, 4431, 4423, 4421, 4420, 4419, 4417, 4410, 4409, 4403, 4397, 4396, 4388, 4383, 4355, 4354, 4353, 4352, 4341, 4340, 4339, 4338, 4337, 4336, 4334, 4317, 4258, 4247, 4212, 4211, 4210, 4206, 4204, 4201, 4199, 4186, 4181, 4179, 4175, 4174, 4172, 4171, 4170, 4167, 4157, 4124, 4113, 4107, 4105, 4051, 4048, 4047, 4046, 4045, 4044, 4043, 4042, 4041, 4040, 4037, 4036, 4034, 4031, 4016, 4006, 4005, 3996, 3986, 3976, 3975, 3962, 3956, 3955, 3940, 3901, 3900, 3883, 3875, 3869, 3868, 3867, 3866, 3859, 3858, 3857, 3856, 3855, 3840, 3839, 3838, 3837, 3830, 3829, 3828, 3827, 3826, 3825, 3824, 3823, 3822, 3764, 3757, 3749, 3747, 3655, 3653, 3643, 3611, 3587, 3571, 3570, 3569, 3568, 3567, 3566, 3565, 3547, 3540, 3539, 3529, 3500, 3499, 3498, 3496, 3494, 3492, 3491, 3490, 3489, 3488, 3448, 3368, 3361, 3360, 3359, 3357, 3353, 3347, 3338, 3336, 3332, 3331, 3329, 3321, 3310, 3301, 3300, 3299, 3295, 3293, 3292, 3289, 3239, 3238, 3237, 3109, 3014, 2987, 2986, 2983, 2938, 2937, 2890, 2889, 2888, 2887, 2886, 2884, 2883, 2882, 2880, 2879, 2878, 2756, 2755, 2442, 2441, 2439, 2438, 2434, 2433, 2432, 2431, 2430, 2426, 2351, 2326, 2160, 2159, 1750, 1714, 1567, 1045, 719) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
Giá thường:
250.000 ₫
Special Price
145.000 ₫
5018
-
Giá thường:
190.000 ₫
Special Price
145.000 ₫
4986
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
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:
120.000 ₫
Special Price
84.000 ₫
5499
-
-
-
Giá thường:
350.000 ₫
Special Price
290.000 ₫
5327
-
Giá thường:
280.000 ₫
Special Price
120.000 ₫
5043
-
Giá thường:
220.000 ₫
Special Price
165.000 ₫
4950
-
Giá thường:
380.000 ₫
Special Price
320.000 ₫
4947
-
-
Từ:
179.000 ₫
Đến:
475.000 ₫
4422
-
Giá thường:
470.000 ₫
Special Price
294.000 ₫
4411
-
Giá thường:
160.000 ₫
Special Price
110.000 ₫
4360
-
Giá thường:
250.000 ₫
Special Price
150.000 ₫
4260