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(593, 594, 683, 933, 1045, 1094, 1270, 1275, 1299, 1591, 1597, 1605, 1612, 1617, 1634, 1759, 1844, 2025, 2085, 2086, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2151, 2153, 2159, 2160, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2351, 2442, 2446, 2528, 2563, 2569, 2570, 2571, 2572, 2615, 2616, 2617, 2696, 2850, 2851, 2937, 2938, 2995, 2996, 2998, 3204, 3206, 3207, 3208, 3209, 3210, 3214, 3215, 3216, 3217, 3237, 3238, 3239, 3258, 3261, 3283, 3285, 3314, 3324, 3325, 3331, 3332, 3336, 3337, 3338, 3341, 3347, 3359, 3360, 3361, 3364, 3395, 3488, 3489, 3490, 3491, 3492, 3494, 3496, 3498, 3499, 3500, 3529, 3530, 3533, 3534, 3536, 3537, 3539, 3540, 3542, 3547, 3570, 3582, 3611, 3619, 3625, 3642, 3643, 3681, 3682, 3683, 3684, 3700, 3711, 3719, 3720, 3756, 3757, 3758, 3837, 3838, 3839, 3840, 3850, 3851, 3855, 3856, 3866, 3867, 3868, 3869, 3889, 3895, 3900, 3901, 3922, 3923, 3924, 3956, 3958, 3959, 3962, 4000, 4001, 4002, 4014, 4016, 4019, 4020, 4025, 4031, 4032, 4034, 4037, 4038, 4045, 4050, 4053, 4069, 4098, 4099, 4100, 4114, 4124, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4176, 4177, 4178, 4179, 4181, 4186, 4201, 4204, 4206, 4218, 4244, 4245, 4256, 4257, 4258, 4260, 4302, 4303, 4304, 4317, 4360, 4361, 4381, 4382, 4383, 4384, 4385, 4386, 4388, 4409, 4410, 4411, 4419, 4420, 4421, 4422, 4424, 4425, 4426, 4427, 4428, 4430, 4431, 4439, 4455, 4463, 4465, 4478, 4485, 4496, 4511, 4519, 4524, 4525, 4526, 4527, 4553, 4554, 4555, 4556, 4557, 4558, 4588, 4606, 4607, 4608, 4628, 4629, 4630, 4635, 4640, 4641, 4642, 4656, 4657, 4658, 4659, 4660, 4661, 4662, 4663, 4671, 4672, 4676, 4678, 4684, 4700, 4712, 4717, 4738, 4789, 4818, 4819, 4820, 4821, 4838, 4849, 4850, 4851, 4852, 4853, 4878, 4880, 4881, 4882, 4888, 4889, 4890, 4921, 4930, 4931, 4932, 4939, 4942, 4943, 4944, 4947, 4948, 4949, 4950, 4951, 4952, 4953, 4954, 4968, 4977, 4981, 4986, 4987, 4988, 4995, 4996, 4997, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5032, 5043, 5048, 5120, 5123, 5143, 5153, 5157, 5158, 5159, 5176, 5189, 5194, 5195, 5196, 5197, 5198, 5209, 5215, 5227, 5274, 5294, 5296, 5300, 5307, 5310, 5311, 5313, 5319, 5321, 5322, 5323, 5327, 5328, 5329, 5330, 5331, 5358, 5362, 5363, 5364, 5387, 5410, 5413, 5425, 5444, 5445, 5459, 5461, 5474, 5485, 5486, 5498, 5499, 5504, 5505, 5534, 5537, 5538, 5539, 5540, 5541, 5550, 5551, 5552, 5563, 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, 5647, 5648, 5649, 5650, 5652, 5663, 5664, 5665, 5666, 5674, 5703, 5708, 5709, 5713, 5714, 5715, 5737, 5738, 5739, 5740, 5743, 5744, 5745, 5746, 5753, 5755, 5756, 5757, 5758, 5759, 5774, 5779, 5784, 5788, 5792, 5793, 5794, 5795, 5796, 5797, 5798, 5799, 5801, 5802, 5803, 5804, 5805, 5806, 5807, 5813, 5814, 5815, 5820, 5821, 5822, 5823, 5824, 5828, 5841, 5843, 5844, 5845, 5846, 5847, 5848, 5849, 5850, 5851, 5852, 5853, 5854, 5891, 5892, 5893, 5894, 5895, 5906, 5911, 5949, 5950, 5957, 5958, 6024, 6058, 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, 6117, 6121, 6130, 6131, 6132, 6133, 6135, 6153, 6179, 6200, 6205, 6206, 6207, 6208, 6209, 6224, 6233, 6234, 6235, 6264, 6265, 6266, 6273, 6274, 6275, 6276, 6278, 6279, 6280, 6290, 6293, 6294, 6295, 6296, 6297, 6298, 6299, 6306, 6307, 6336, 6337, 6338, 6339, 6344, 6345, 6346, 6347, 6349, 6354, 6363, 6369, 6370, 6371, 6403, 6427, 6428, 6430, 6443, 6445, 6446, 6452, 6453, 6454, 6455, 6456, 6459, 6492, 6493, 6494, 6495, 6507, 6561, 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, 6681, 6682, 6683, 6694, 6697, 6735, 6736, 6751, 6752, 6753, 6763, 6769, 6774, 6793, 6796, 6797, 6798, 6815, 6816, 6817, 6818, 6821, 6822, 6823, 6826, 6830, 6886, 6887, 6888, 6889, 6890, 6904, 6914, 6915, 6916, 6917, 6920, 6932, 6977, 6981, 6982, 6983, 6984, 6985, 6986, 6987, 6999, 7003, 7008)) ORDER BY FIELD(`e`.`entity_id`, 6987, 6986, 6985, 6984, 6983, 6982, 6769, 6427, 5759, 5564, 4384, 7008, 7003, 6999, 6981, 6977, 6932, 6920, 6917, 6916, 6915, 6914, 6904, 6890, 6889, 6888, 6887, 6886, 6830, 6826, 6823, 6822, 6821, 6818, 6817, 6815, 6798, 6797, 6796, 6793, 6774, 6763, 6752, 6751, 6697, 6694, 6660, 6659, 6658, 6657, 6656, 6655, 6654, 6653, 6652, 6651, 6650, 6649, 6648, 6647, 6646, 6645, 6643, 6642, 6641, 6640, 6639, 6638, 6637, 6635, 6634, 6633, 6632, 6631, 6630, 6629, 6628, 6627, 6626, 6625, 6561, 6507, 6495, 6494, 6493, 6492, 6453, 6452, 6446, 6443, 6430, 6428, 6403, 6363, 6354, 6347, 6346, 6345, 6344, 6339, 6338, 6337, 6336, 6307, 6306, 6290, 6276, 6274, 6273, 6235, 6234, 6233, 6224, 6208, 6207, 6206, 6200, 6133, 6132, 6131, 6087, 6086, 6083, 6082, 5895, 5894, 5893, 5892, 5891, 5853, 5851, 5845, 5843, 5828, 5820, 5815, 5814, 5813, 5788, 5784, 5779, 5715, 5714, 5713, 5674, 5666, 5665, 5664, 5663, 5648, 5647, 5623, 5622, 5620, 5617, 5614, 5612, 5611, 5609, 5607, 5563, 5534, 5499, 5498, 5474, 5461, 5445, 5425, 5413, 5358, 5329, 5328, 5327, 5215, 5209, 5048, 5043, 5032, 5019, 5018, 4988, 4986, 4977, 4952, 4950, 4948, 4947, 4851, 4850, 4849, 4789, 4641, 4640, 4556, 4555, 4553, 4519, 4496, 4465, 4430, 4425, 4424, 4422, 4411, 4385, 4382, 4381, 4360, 4260, 4257, 4256, 4178, 4177, 4176, 4173, 4169, 4114, 4050, 4032, 4002, 4001, 3720, 3719, 3711, 3681, 3625, 3619, 3582, 3536, 3530, 3324, 3314, 3285, 3261, 3258, 3215, 3208, 3207, 2617, 2615, 2446, 2252, 2251, 2153, 2096, 2095, 1844, 1634, 1617, 1597, 1591, 1299, 1094, 933, 683, 594, 593, 6816, 6753, 6736, 6735, 6683, 6682, 6681, 6644, 6459, 6456, 6455, 6454, 6445, 6371, 6370, 6369, 6349, 6299, 6298, 6297, 6296, 6295, 6294, 6293, 6280, 6279, 6278, 6275, 6266, 6265, 6264, 6209, 6205, 6179, 6153, 6135, 6130, 6121, 6117, 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, 6058, 6024, 5958, 5957, 5950, 5949, 5911, 5906, 5854, 5852, 5850, 5849, 5848, 5847, 5846, 5844, 5841, 5824, 5823, 5822, 5821, 5807, 5806, 5805, 5804, 5803, 5802, 5801, 5799, 5798, 5797, 5796, 5795, 5794, 5793, 5792, 5774, 5758, 5757, 5756, 5755, 5753, 5746, 5745, 5744, 5743, 5740, 5739, 5738, 5737, 5709, 5708, 5703, 5652, 5650, 5649, 5633, 5630, 5629, 5628, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5610, 5608, 5588, 5587, 5552, 5551, 5550, 5541, 5540, 5539, 5538, 5537, 5505, 5504, 5486, 5485, 5459, 5444, 5410, 5387, 5364, 5363, 5362, 5331, 5330, 5323, 5322, 5321, 5319, 5313, 5311, 5310, 5307, 5300, 5296, 5294, 5274, 5227, 5198, 5197, 5196, 5195, 5194, 5189, 5176, 5159, 5158, 5157, 5153, 5143, 5123, 5120, 5021, 5020, 5007, 5006, 5005, 5004, 4997, 4996, 4995, 4987, 4981, 4968, 4954, 4953, 4951, 4949, 4944, 4943, 4942, 4939, 4932, 4931, 4930, 4921, 4890, 4889, 4888, 4882, 4881, 4880, 4878, 4853, 4852, 4838, 4821, 4820, 4819, 4818, 4738, 4717, 4712, 4700, 4684, 4678, 4676, 4672, 4671, 4663, 4662, 4661, 4660, 4659, 4658, 4657, 4656, 4642, 4635, 4630, 4629, 4628, 4608, 4607, 4606, 4588, 4558, 4557, 4554, 4527, 4526, 4525, 4524, 4511, 4485, 4478, 4463, 4455, 4439, 4431, 4428, 4427, 4426, 4421, 4420, 4419, 4410, 4409, 4388, 4386, 4383, 4361, 4317, 4304, 4303, 4302, 4258, 4245, 4244, 4218, 4206, 4204, 4201, 4186, 4181, 4179, 4175, 4174, 4172, 4171, 4170, 4124, 4100, 4099, 4098, 4069, 4053, 4045, 4038, 4037, 4034, 4031, 4025, 4020, 4019, 4016, 4014, 4000, 3962, 3959, 3958, 3956, 3924, 3923, 3922, 3901, 3900, 3895, 3889, 3869, 3868, 3867, 3866, 3856, 3855, 3851, 3850, 3840, 3839, 3838, 3837, 3758, 3757, 3756, 3700, 3684, 3683, 3682, 3643, 3642, 3611, 3570, 3547, 3542, 3540, 3539, 3537, 3534, 3533, 3529, 3500, 3499, 3498, 3496, 3494, 3492, 3491, 3490, 3489, 3488, 3395, 3364, 3361, 3360, 3359, 3347, 3341, 3338, 3337, 3336, 3332, 3331, 3325, 3283, 3239, 3238, 3237, 3217, 3216, 3214, 3210, 3209, 3206, 3204, 2998, 2996, 2995, 2938, 2937, 2851, 2850, 2696, 2616, 2572, 2571, 2570, 2569, 2563, 2528, 2442, 2351, 2263, 2262, 2261, 2260, 2259, 2258, 2257, 2256, 2255, 2254, 2253, 2160, 2159, 2151, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2101, 2100, 2099, 2098, 2097, 2094, 2093, 2092, 2086, 2085, 2025, 1759, 1612, 1605, 1275, 1270, 1045) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6430
-
-
-
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6307
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6306
-
-
-