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, 949, 983, 1115, 1158, 1275, 1276, 1281, 1550, 1567, 1572, 1597, 1605, 1610, 1612, 1617, 1652, 1685, 1691, 1713, 1714, 1740, 1750, 1789, 1790, 1791, 1798, 1844, 1862, 1920, 2322, 2326, 2426, 2430, 2431, 2432, 2433, 2434, 2438, 2439, 2441, 2442, 2446, 2704, 2705, 2706, 2707, 2708, 2709, 2755, 2756, 2841, 2842, 2843, 2845, 2846, 2847, 2850, 2851, 2878, 2879, 2880, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2900, 2918, 2919, 2920, 2921, 2922, 2923, 2925, 2926, 2937, 2938, 2983, 2986, 2987, 3014, 3109, 3121, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3204, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3258, 3262, 3276, 3289, 3292, 3293, 3295, 3298, 3299, 3300, 3301, 3303, 3304, 3305, 3306, 3307, 3310, 3321, 3329, 3332, 3338, 3345, 3347, 3348, 3353, 3354, 3357, 3358, 3364, 3368, 3389, 3390, 3391, 3392, 3393, 3395, 3432, 3433, 3434, 3448, 3449, 3458, 3460, 3469, 3470, 3471, 3496, 3498, 3499, 3500, 3508, 3509, 3510, 3511, 3513, 3514, 3515, 3516, 3518, 3519, 3520, 3522, 3523, 3524, 3525, 3529, 3530, 3531, 3532, 3533, 3534, 3536, 3537, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3587, 3590, 3591, 3592, 3593, 3619, 3623, 3624, 3625, 3636, 3640, 3641, 3642, 3653, 3655, 3679, 3681, 3682, 3683, 3684, 3696, 3700, 3704, 3705, 3711, 3719, 3720, 3746, 3747, 3748, 3749, 3750, 3756, 3757, 3758, 3763, 3764, 3773, 3774, 3790, 3791, 3792, 3793, 3794, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 3830, 3831, 3832, 3833, 3834, 3835, 3836, 3837, 3838, 3839, 3840, 3847, 3848, 3855, 3857, 3858, 3859, 3861, 3862, 3863, 3864, 3865, 3875, 3876, 3883, 3884, 3889, 3892, 3895, 3897, 3940, 3948, 3950, 3952, 3955, 3963, 3964, 3972, 3975, 3976, 3979, 3986, 3987, 3994, 3995, 3996, 4005, 4006, 4011, 4012, 4014, 4015, 4017, 4018, 4035, 4036, 4037, 4038, 4040, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4076, 4077, 4078, 4079, 4080, 4081, 4082, 4083, 4084, 4086, 4091, 4092, 4098, 4099, 4100, 4101, 4105, 4107, 4108, 4113, 4124, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4135, 4136, 4137, 4138, 4139, 4140, 4141, 4142, 4143, 4146, 4148, 4149, 4150, 4151, 4152, 4153, 4154, 4155, 4156, 4157, 4158, 4160, 4163, 4164, 4165, 4166, 4167, 4168, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4181, 4184, 4185, 4198, 4199, 4200, 4210, 4211, 4212, 4236, 4237, 4238, 4239, 4240, 4241, 4242, 4243, 4246, 4247, 4253, 4262, 4263, 4264, 4265, 4266, 4267, 4302, 4303, 4304, 4305, 4306, 4307, 4334, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4352, 4353, 4354, 4355, 4356, 4361, 4363, 4381, 4382, 4383, 4384, 4385, 4386, 4396, 4397, 4403, 4408, 4412, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4439, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4473, 4478, 4481, 4482, 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, 4520, 4521, 4522, 4523, 4524, 4525, 4526, 4527, 4530, 4575, 4597, 4599, 4600, 4601, 4602, 4603, 4604, 4605, 4606, 4607, 4608, 4664, 4665, 4672, 4696, 4702, 4703, 4717, 4718, 4719, 4720, 4721, 4735, 4738, 4749, 4750, 4751, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4770, 4771, 4772, 4775, 4781, 4817, 4822, 4823, 4824, 4825, 4844, 4859, 4863, 4864, 4871, 4888, 4889, 4890, 4899, 4901, 4902, 4903, 4904, 4905, 4936, 4963, 4964, 4965, 4966, 4967, 4976, 4978, 4980, 4981, 4982, 4983, 4986, 4987, 4988, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5025, 5026, 5032, 5035, 5042, 5051, 5055, 5056, 5057, 5058, 5072, 5078, 5079, 5097, 5098, 5099, 5100, 5101, 5102, 5104, 5105, 5106, 5107, 5109, 5111, 5112, 5114, 5117, 5118, 5121, 5123, 5124, 5134, 5136, 5137, 5142, 5155, 5157, 5158, 5159, 5162, 5163, 5164, 5165, 5166, 5169, 5172, 5173, 5184, 5185, 5186, 5188, 5189, 5191, 5192, 5193, 5206, 5207, 5208, 5216, 5222, 5228, 5246, 5247, 5248, 5249, 5250, 5280, 5281, 5282, 5283, 5286, 5292, 5299, 5311, 5312, 5331, 5339, 5343, 5354, 5409, 5411, 5414, 5415, 5416, 5417, 5430, 5459, 5462, 5463, 5468, 5476, 5481, 5486, 5488, 5490, 5492, 5499, 5500, 5501, 5502, 5503, 5505, 5506, 5507, 5525, 5526, 5527, 5537, 5538, 5539, 5540, 5541, 5556, 5557, 5558, 5559, 5560, 5561, 5562, 5563, 5564, 5565, 5582, 5598, 5599, 5600, 5601, 5621, 5633, 5634, 5637, 5638, 5644, 5645, 5646, 5647, 5648, 5649, 5650, 5663, 5664, 5665, 5666, 5673, 5674, 5675, 5676, 5677, 5678, 5679, 5693, 5697, 5698, 5721, 5722, 5723, 5724, 5732, 5742, 5743, 5744, 5745, 5746, 5753, 5762, 5769, 5770, 5772, 5773, 5795, 5810, 5811, 5812, 5813, 5814, 5815, 5821, 5822, 5823, 5824, 5829, 5838, 5839, 5840, 5841, 5842, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5851, 5852, 5853, 5854, 5860, 5861, 5862, 5863, 5864, 5865, 5866, 5885, 5886, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5918, 5990, 5991, 5992, 5993, 5994, 5995, 6024, 6029, 6030, 6031, 6032, 6033, 6040, 6041, 6043, 6044, 6045, 6046, 6047, 6058, 6059, 6060, 6078, 6079, 6080, 6081, 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, 6143, 6144, 6148, 6150, 6157, 6158, 6160, 6161, 6162, 6163, 6164, 6165, 6175, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6194, 6195, 6196, 6197, 6198, 6199, 6201, 6202, 6203, 6204, 6205, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6268, 6273, 6274, 6275, 6276, 6278, 6279, 6280, 6285, 6310, 6362, 6363, 6364, 6365, 6379, 6380, 6381, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6391, 6392, 6393, 6394, 6395, 6396, 6397, 6398, 6399, 6400, 6401, 6403, 6404, 6405, 6406, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6431, 6457, 6460, 6466, 6467, 6468, 6469, 6473, 6474, 6486, 6488, 6489, 6491, 6492, 6493, 6494, 6495, 6501, 6502, 6503, 6504, 6505, 6506, 6507, 6527, 6528, 6529, 6530, 6531, 6532, 6533, 6560, 6561, 6562, 6563, 6564, 6565, 6577, 6582, 6583, 6584, 6585, 6586, 6609, 6625, 6626, 6627, 6628, 6629, 6630, 6631, 6632, 6633, 6634, 6635, 6641, 6648, 6649, 6650, 6651, 6652, 6653, 6663, 6664, 6665, 6666, 6667, 6672, 6673, 6674, 6675, 6676, 6698, 6699, 6700, 6701, 6702, 6714, 6715, 6716, 6717, 6718, 6719, 6720, 6721, 6724, 6725, 6727, 6729, 6731, 6732, 6733, 6734, 6735, 6736, 6737, 6738, 6743, 6751, 6752, 6753, 6754, 6758, 6760, 6761, 6766, 6768, 6771, 6772, 6774, 6781, 6782, 6783, 6788, 6789, 6790, 6791, 6813, 6814, 6815, 6816, 6817, 6828, 6829, 6830, 6836, 6837, 6838, 6847, 6848, 6856, 6859, 6860, 6861, 6862, 6863, 6864, 6880, 6881, 6882, 6883, 6903, 6904, 6905, 6907, 6908, 6910, 6914, 6915, 6916, 6917, 6921, 6922, 6923, 6924, 6925, 6926, 6929, 6930, 6931, 6932, 6945, 6948, 6955, 6957, 6958, 6959, 6960, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6971, 6978, 6979, 6980, 6989, 7010, 7012, 7023, 7024, 7025, 7026, 7027, 7028, 7029, 7033, 7036, 7037)) ORDER BY FIELD(`e`.`entity_id`, 6204, 6203, 6202, 7033, 6813, 6738, 6716, 6653, 6652, 6651, 6650, 6649, 6648, 6507, 6491, 6489, 6488, 6486, 6457, 6431, 6405, 6221, 6219, 6218, 6217, 6216, 6201, 6195, 6194, 6177, 6079, 6078, 5862, 5861, 5811, 5810, 5698, 5697, 5648, 5647, 5488, 5481, 5114, 4763, 4750, 4749, 4493, 4490, 4306, 4305, 4168, 4146, 3995, 567, 566, 7037, 7036, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7012, 7010, 6989, 6980, 6979, 6978, 6971, 6969, 6968, 6967, 6966, 6965, 6964, 6963, 6962, 6960, 6959, 6958, 6957, 6955, 6948, 6945, 6932, 6931, 6930, 6929, 6926, 6925, 6924, 6923, 6922, 6921, 6917, 6916, 6915, 6914, 6910, 6908, 6907, 6905, 6904, 6903, 6883, 6882, 6881, 6880, 6864, 6863, 6862, 6861, 6860, 6859, 6856, 6848, 6847, 6837, 6836, 6830, 6828, 6817, 6815, 6814, 6791, 6790, 6789, 6788, 6783, 6782, 6781, 6774, 6772, 6771, 6768, 6761, 6760, 6758, 6754, 6753, 6752, 6751, 6743, 6733, 6732, 6731, 6729, 6727, 6725, 6724, 6721, 6719, 6718, 6715, 6714, 6702, 6701, 6699, 6698, 6676, 6674, 6673, 6672, 6667, 6666, 6665, 6664, 6663, 6641, 6635, 6634, 6633, 6632, 6631, 6630, 6629, 6628, 6627, 6626, 6625, 6609, 6586, 6585, 6584, 6583, 6582, 6565, 6564, 6563, 6562, 6561, 6560, 6533, 6532, 6531, 6530, 6529, 6528, 6527, 6495, 6494, 6493, 6492, 6474, 6473, 6469, 6468, 6467, 6466, 6421, 6420, 6419, 6418, 6416, 6415, 6414, 6413, 6406, 6403, 6401, 6400, 6399, 6398, 6396, 6395, 6394, 6391, 6382, 6380, 6365, 6364, 6363, 6362, 6310, 6285, 6276, 6274, 6273, 6215, 6214, 6213, 6197, 6188, 6165, 6164, 6163, 6162, 6161, 6160, 6158, 6157, 6150, 6148, 6118, 6116, 6041, 6033, 5992, 5990, 5918, 5902, 5901, 5900, 5897, 5896, 5866, 5864, 5860, 5853, 5851, 5845, 5843, 5838, 5829, 5815, 5814, 5813, 5769, 5742, 5724, 5723, 5722, 5721, 5693, 5675, 5674, 5673, 5666, 5665, 5664, 5663, 5645, 5644, 5634, 5601, 5600, 5599, 5598, 5582, 5565, 5564, 5563, 5561, 5500, 5499, 5490, 5430, 5411, 5339, 5228, 5216, 5208, 5207, 5206, 5112, 5111, 5072, 5056, 5055, 5051, 5032, 5026, 5025, 5019, 5018, 4993, 4992, 4989, 4988, 4986, 4976, 4967, 4965, 4964, 4963, 4936, 4903, 4902, 4901, 4863, 4859, 4823, 4822, 4775, 4735, 4501, 4499, 4498, 4496, 4494, 4491, 4489, 4481, 4437, 4436, 4434, 4433, 4430, 4422, 4418, 4412, 4408, 4385, 4384, 4382, 4381, 4262, 4200, 4198, 4178, 4177, 4176, 4173, 4169, 4166, 4141, 4140, 4139, 4137, 4136, 4132, 4131, 4129, 4128, 4127, 4126, 4108, 4101, 4092, 4091, 4086, 4052, 4050, 4049, 4017, 3994, 3750, 3720, 3719, 3711, 3705, 3696, 3681, 3679, 3625, 3619, 3536, 3530, 3358, 3354, 3345, 3262, 3258, 3215, 3208, 3207, 3121, 2845, 2841, 2446, 1844, 1798, 1691, 1685, 1617, 1597, 1158, 1115, 6838, 6829, 6816, 6766, 6737, 6736, 6735, 6734, 6720, 6717, 6700, 6675, 6577, 6506, 6505, 6504, 6503, 6502, 6501, 6460, 6417, 6404, 6397, 6393, 6392, 6390, 6389, 6388, 6387, 6386, 6385, 6384, 6383, 6381, 6379, 6280, 6279, 6278, 6275, 6268, 6220, 6205, 6199, 6198, 6196, 6190, 6189, 6187, 6186, 6185, 6184, 6183, 6182, 6181, 6180, 6179, 6178, 6175, 6144, 6143, 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, 6081, 6080, 6060, 6059, 6058, 6047, 6046, 6045, 6044, 6043, 6040, 6032, 6031, 6030, 6029, 6024, 5995, 5994, 5993, 5991, 5899, 5898, 5886, 5885, 5865, 5863, 5854, 5852, 5850, 5849, 5848, 5847, 5846, 5844, 5842, 5841, 5840, 5839, 5824, 5823, 5822, 5821, 5812, 5795, 5773, 5772, 5770, 5762, 5753, 5746, 5745, 5744, 5743, 5732, 5679, 5678, 5677, 5676, 5650, 5649, 5646, 5638, 5637, 5633, 5621, 5562, 5560, 5559, 5558, 5557, 5556, 5541, 5540, 5539, 5538, 5537, 5527, 5526, 5525, 5507, 5506, 5505, 5503, 5502, 5501, 5492, 5486, 5476, 5468, 5463, 5462, 5459, 5417, 5416, 5415, 5414, 5409, 5354, 5343, 5331, 5312, 5311, 5299, 5292, 5286, 5283, 5282, 5281, 5280, 5250, 5249, 5248, 5247, 5246, 5222, 5193, 5192, 5191, 5189, 5188, 5186, 5185, 5184, 5173, 5172, 5169, 5166, 5165, 5164, 5163, 5162, 5159, 5158, 5157, 5155, 5142, 5137, 5136, 5134, 5124, 5123, 5121, 5118, 5117, 5109, 5107, 5106, 5105, 5104, 5102, 5101, 5100, 5099, 5098, 5097, 5079, 5078, 5058, 5057, 5042, 5035, 5021, 5020, 5007, 5006, 5005, 5004, 4999, 4994, 4991, 4990, 4987, 4983, 4982, 4981, 4980, 4978, 4966, 4905, 4904, 4899, 4890, 4889, 4888, 4871, 4864, 4844, 4825, 4824, 4817, 4781, 4772, 4771, 4770, 4764, 4762, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4751, 4738, 4721, 4720, 4719, 4718, 4717, 4703, 4702, 4696, 4672, 4665, 4664, 4608, 4607, 4606, 4605, 4604, 4603, 4602, 4601, 4600, 4599, 4597, 4575, 4530, 4527, 4526, 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, 4482, 4478, 4473, 4452, 4451, 4450, 4449, 4448, 4447, 4446, 4445, 4444, 4439, 4438, 4435, 4432, 4431, 4423, 4421, 4420, 4419, 4417, 4403, 4397, 4396, 4386, 4383, 4363, 4361, 4356, 4355, 4354, 4353, 4352, 4342, 4341, 4340, 4339, 4338, 4337, 4336, 4334, 4307, 4304, 4303, 4302, 4267, 4266, 4265, 4264, 4263, 4253, 4247, 4246, 4243, 4242, 4241, 4240, 4239, 4238, 4237, 4236, 4212, 4211, 4210, 4199, 4185, 4184, 4181, 4179, 4175, 4174, 4172, 4171, 4170, 4167, 4165, 4164, 4163, 4160, 4158, 4157, 4156, 4155, 4154, 4153, 4152, 4151, 4150, 4149, 4148, 4143, 4142, 4138, 4135, 4130, 4124, 4113, 4107, 4105, 4100, 4099, 4098, 4084, 4083, 4082, 4081, 4080, 4079, 4078, 4077, 4076, 4051, 4048, 4047, 4046, 4045, 4044, 4043, 4042, 4041, 4040, 4038, 4037, 4036, 4035, 4018, 4015, 4014, 4012, 4011, 4006, 4005, 3996, 3987, 3986, 3979, 3976, 3975, 3972, 3964, 3963, 3955, 3952, 3950, 3948, 3940, 3897, 3895, 3892, 3889, 3884, 3883, 3876, 3875, 3865, 3864, 3863, 3862, 3861, 3859, 3858, 3857, 3855, 3848, 3847, 3840, 3839, 3838, 3837, 3836, 3835, 3834, 3833, 3832, 3831, 3830, 3829, 3828, 3827, 3826, 3825, 3824, 3823, 3822, 3794, 3793, 3792, 3791, 3790, 3774, 3773, 3764, 3763, 3758, 3757, 3756, 3749, 3748, 3747, 3746, 3704, 3700, 3684, 3683, 3682, 3655, 3653, 3642, 3641, 3640, 3636, 3624, 3623, 3593, 3592, 3591, 3590, 3587, 3571, 3570, 3569, 3568, 3567, 3566, 3565, 3537, 3534, 3533, 3532, 3531, 3529, 3525, 3524, 3523, 3522, 3520, 3519, 3518, 3516, 3515, 3514, 3513, 3511, 3510, 3509, 3508, 3500, 3499, 3498, 3496, 3471, 3470, 3469, 3460, 3458, 3449, 3448, 3434, 3433, 3432, 3395, 3393, 3392, 3391, 3390, 3389, 3368, 3364, 3357, 3353, 3348, 3347, 3338, 3332, 3329, 3321, 3310, 3307, 3306, 3305, 3304, 3303, 3301, 3300, 3299, 3298, 3295, 3293, 3292, 3289, 3276, 3216, 3210, 3209, 3206, 3204, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 3109, 3014, 2987, 2986, 2983, 2938, 2937, 2926, 2925, 2923, 2922, 2921, 2920, 2919, 2918, 2900, 2890, 2889, 2888, 2887, 2886, 2884, 2883, 2882, 2880, 2879, 2878, 2851, 2850, 2847, 2846, 2843, 2842, 2756, 2755, 2709, 2708, 2707, 2706, 2705, 2704, 2442, 2441, 2439, 2438, 2434, 2433, 2432, 2431, 2430, 2426, 2326, 2322, 1920, 1862, 1791, 1790, 1789, 1750, 1740, 1714, 1713, 1652, 1612, 1610, 1605, 1572, 1567, 1550, 1281, 1276, 1275, 983, 949, 719) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
150.000 ₫
Special Price
120.000 ₫
6078
-
-
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:
85.000 ₫
Special Price
59.000 ₫
5481
-
Giá thường:
360.000 ₫
Special Price
224.000 ₫
5114
-
-
-
Giá thường:
220.000 ₫
Special Price
130.000 ₫
4305
-
Giá thường:
180.000 ₫
Special Price
160.000 ₫
4146
-
-
-
-
-
-
-
-
-
-
-
-
-