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(588, 697, 699, 719, 1230, 1276, 1676, 1685, 1714, 1717, 1750, 1931, 1932, 1967, 2000, 2001, 2002, 2003, 2004, 2024, 2025, 2031, 2038, 2041, 2042, 2043, 2044, 2046, 2047, 2048, 2059, 2061, 2062, 2063, 2064, 2065, 2075, 2076, 2077, 2078, 2080, 2081, 2082, 2083, 2085, 2086, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2105, 2106, 2108, 2111, 2113, 2114, 2116, 2118, 2120, 2121, 2122, 2124, 2125, 2132, 2139, 2141, 2142, 2145, 2146, 2147, 2148, 2151, 2153, 2159, 2160, 2163, 2175, 2181, 2183, 2184, 2190, 2191, 2198, 2199, 2200, 2205, 2216, 2217, 2218, 2219, 2223, 2231, 2240, 2245, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2283, 2284, 2285, 2287, 2293, 2294, 2300, 2301, 2302, 2305, 2306, 2307, 2308, 2318, 2320, 2321, 2322, 2326, 2331, 2332, 2334, 2355, 2360, 2361, 2362, 2363, 2371, 2373, 2375, 2379, 2380, 2381, 2382, 2391, 2407, 2426, 2430, 2431, 2432, 2433, 2434, 2438, 2439, 2441, 2442, 2446, 2467, 2468, 2470, 2471, 2472, 2473, 2474, 2479, 2481, 2483, 2484, 2487, 2490, 2491, 2492, 2493, 2494, 2495, 2496, 2497, 2498, 2503, 2504, 2508, 2512, 2513, 2517, 2528, 2530, 2533, 2534, 2535, 2536, 2537, 2538, 2554, 2559, 2560, 2561, 2563, 2569, 2570, 2571, 2572, 2577, 2586, 2588, 2589, 2601, 2602, 2603, 2604, 2615, 2616, 2617, 2674, 2675, 2676, 2696, 2710, 2711, 2712, 2713, 2755, 2756, 2796, 2798, 2799, 2800, 2802, 2803, 2821, 2822, 2824, 2832, 2833, 2838, 2839, 2841, 2842, 2843, 2845, 2846, 2847, 2864, 2865, 2866, 2867, 2868, 2878, 2879, 2880, 2882, 2883, 2884, 2886, 2887, 2888, 2889, 2890, 2908, 2909, 2931, 2937, 2938, 2940, 2941, 2967, 2968, 2969, 2983, 2986, 2987, 2992, 2995, 2996, 2998, 3014, 3109, 3121, 3190, 3191, 3192, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3202, 3205, 3207, 3210, 3214, 3215, 3228, 3258, 3289, 3293, 3295, 3299, 3300, 3301, 3310, 3321, 3324, 3325, 3329, 3332, 3338, 3342, 3345, 3353, 3354, 3357, 3358, 3367, 3368, 3386, 3389, 3390, 3391, 3392, 3393, 3401, 3402, 3403, 3406, 3407, 3415, 3418, 3432, 3433, 3434, 3435, 3437, 3448, 3456, 3458, 3469, 3470, 3471, 3477, 3478, 3479, 3480, 3481, 3496, 3498, 3499, 3500, 3539, 3540, 3542, 3544, 3547, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3587, 3588, 3589, 3592, 3593, 3610, 3611, 3612, 3653, 3655, 3674, 3679, 3685, 3696, 3697, 3698, 3699, 3715, 3721, 3722, 3723, 3725, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3733, 3734, 3735, 3736, 3737, 3738, 3747, 3749, 3757, 3773, 3790, 3791, 3792, 3793, 3794, 3822, 3823, 3824, 3825, 3826, 3827, 3828, 3829, 3830, 3837, 3838, 3839, 3840, 3848, 3850, 3851, 3854, 3855, 3857, 3861, 3862, 3863, 3864, 3865, 3875, 3876, 3879, 3883, 3884, 3908, 3909, 3940, 3955, 3975, 3976, 3980, 3982, 3984, 3985, 3986, 3987, 3988, 3989, 3994, 4005, 4006, 4007, 4022, 4023, 4024, 4040, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4049, 4050, 4051, 4052, 4061, 4092, 4105, 4107, 4108, 4113, 4148, 4149, 4150, 4151, 4152, 4153, 4154, 4155, 4156, 4157, 4166, 4167, 4168, 4177, 4178, 4179, 4181, 4188, 4189, 4190, 4191, 4192, 4194, 4195, 4198, 4199, 4200, 4201, 4210, 4211, 4212, 4247, 4248, 4249, 4250, 4251, 4252, 4262, 4274, 4275, 4276, 4281, 4290, 4302, 4303, 4304, 4305, 4306, 4307, 4321, 4334, 4335, 4336, 4337, 4338, 4339, 4340, 4341, 4342, 4349, 4350, 4352, 4353, 4354, 4355, 4363, 4368, 4396, 4397, 4403, 4412, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4466, 4468, 4469, 4470, 4471, 4472, 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, 4530, 4540, 4548, 4549, 4550, 4551, 4553, 4554, 4555, 4556, 4557, 4558, 4567, 4568, 4569, 4575, 4594, 4597, 4602, 4603, 4604, 4605, 4609, 4636, 4637, 4638, 4639, 4640, 4641, 4644, 4645, 4646, 4647, 4648, 4649, 4665, 4717, 4718, 4719, 4720, 4721, 4749, 4750, 4751, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4770, 4771, 4772, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4800, 4801, 4802, 4803, 4804, 4805, 4806, 4807, 4808, 4809, 4810, 4822, 4823, 4824, 4825, 4826, 4834, 4835, 4836, 4837, 4841, 4844, 4845, 4847, 4879, 4888, 4889, 4890, 4904, 4905, 4986, 4987, 4988, 4999, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5025, 5026, 5032, 5035, 5042, 5078, 5080, 5086, 5090, 5091, 5104, 5105, 5106, 5107, 5109, 5111, 5112, 5114, 5117, 5124, 5129, 5130, 5131, 5134, 5136, 5142, 5147, 5162, 5163, 5164, 5165, 5166, 5172, 5173, 5184, 5185, 5186, 5188, 5191, 5192, 5193, 5280, 5281, 5282, 5283, 5286, 5299, 5312, 5331, 5339, 5343, 5351, 5352, 5353, 5354, 5358, 5385, 5386, 5387, 5392, 5393, 5395, 5409, 5412, 5414, 5415, 5416, 5462, 5463, 5468, 5476, 5481, 5486, 5488, 5491, 5492, 5493, 5499, 5500, 5501, 5502, 5503, 5525, 5526, 5527, 5541, 5586, 5587, 5588, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5637, 5638, 5647, 5648, 5649, 5650, 5663, 5664, 5665, 5666, 5673, 5674, 5675, 5676, 5677, 5678, 5679, 5697, 5698, 5703, 5708, 5709, 5721, 5722, 5723, 5724, 5734, 5735, 5736, 5743, 5744, 5745, 5746, 5753, 5762, 5770, 5773, 5810, 5811, 5812, 5813, 5814, 5815, 5821, 5822, 5823, 5824, 5834, 5838, 5861, 5862, 5863, 5885, 5886, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5919, 6024, 6029, 6030, 6031, 6032, 6040, 6041, 6043, 6044, 6045, 6046, 6047, 6059, 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, 6175, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208, 6209, 6212, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6285, 6322, 6358, 6391, 6392, 6393, 6394, 6398, 6399, 6400, 6401, 6405, 6474, 6486, 6488, 6489, 6491, 6507, 6514, 6515, 6516, 6560, 6561, 6562, 6563, 6564, 6565, 6577, 6582, 6583, 6584, 6585, 6586, 6605, 6606, 6612, 6613, 6614, 6625, 6626, 6627, 6628, 6629, 6630, 6631, 6632, 6633, 6634, 6635, 6648, 6649, 6650, 6651, 6652, 6653, 6663, 6664, 6665, 6666, 6667, 6672, 6673, 6674, 6675, 6676, 6714, 6715, 6716, 6717, 6718, 6719, 6731, 6732, 6733, 6734, 6735, 6736, 6737, 6738, 6743, 6767, 6774, 6786, 6813, 6814, 6838, 6856, 6859, 6860, 6861, 6862, 6863, 6864, 6880, 6881, 6882, 6883, 6889, 6890, 6914, 6915, 6916, 6917, 6921, 6922, 6923, 6924, 6925, 6926, 6929, 6930, 6931, 6932, 6948, 6958, 6959, 6960, 6964, 6965, 6966, 6967, 6968, 6969, 6978, 6979, 6980, 6989, 7000, 7001, 7012, 7023, 7024, 7025, 7026, 7027, 7028, 7029)) ORDER BY FIELD(`e`.`entity_id`, 3994, 7012, 7001, 6889, 6883, 6882, 6881, 6880, 6738, 6733, 6732, 6731, 6716, 6653, 6652, 6651, 6650, 6649, 6648, 6614, 6613, 6612, 6606, 6605, 5736, 5735, 5734, 5392, 5353, 5352, 5351, 4498, 4493, 4490, 4489, 4262, 4092, 3738, 3735, 3324, 2941, 2710, 2617, 2615, 2559, 2554, 2483, 2473, 2472, 2468, 2373, 2371, 2245, 2231, 2216, 2153, 2148, 2147, 2146, 2145, 2064, 2042, 7029, 7027, 7026, 7025, 7024, 7023, 7000, 6989, 6980, 6979, 6978, 6969, 6968, 6967, 6966, 6965, 6964, 6960, 6959, 6958, 6948, 6932, 6931, 6930, 6929, 6926, 6925, 6924, 6923, 6922, 6921, 6917, 6916, 6915, 6914, 6890, 6864, 6863, 6862, 6861, 6860, 6859, 6856, 6814, 6813, 6786, 6774, 6767, 6743, 6719, 6718, 6715, 6714, 6676, 6674, 6673, 6672, 6667, 6666, 6665, 6664, 6663, 6635, 6634, 6633, 6632, 6631, 6630, 6629, 6628, 6627, 6626, 6625, 6586, 6585, 6584, 6583, 6582, 6565, 6564, 6563, 6562, 6561, 6560, 6516, 6515, 6514, 6507, 6491, 6489, 6488, 6486, 6474, 6405, 6401, 6400, 6399, 6398, 6394, 6391, 6358, 6322, 6285, 6221, 6219, 6218, 6217, 6216, 6215, 6214, 6213, 6212, 6208, 6207, 6206, 6204, 6203, 6202, 6201, 6079, 6078, 6041, 5902, 5901, 5900, 5897, 5896, 5862, 5861, 5838, 5834, 5815, 5814, 5813, 5811, 5810, 5724, 5723, 5722, 5721, 5698, 5697, 5675, 5674, 5673, 5666, 5665, 5664, 5663, 5648, 5647, 5623, 5622, 5620, 5617, 5614, 5612, 5611, 5609, 5607, 5500, 5499, 5488, 5481, 5393, 5358, 5339, 5130, 5129, 5114, 5112, 5111, 5032, 5026, 5025, 5019, 5018, 4988, 4986, 4823, 4822, 4807, 4805, 4763, 4750, 4749, 4645, 4644, 4641, 4640, 4639, 4638, 4569, 4568, 4567, 4556, 4555, 4553, 4540, 4501, 4499, 4496, 4494, 4491, 4422, 4418, 4412, 4306, 4305, 4250, 4249, 4200, 4198, 4178, 4177, 4168, 4166, 4108, 4052, 4050, 4049, 3908, 3731, 3730, 3729, 3726, 3696, 3679, 3612, 3610, 3481, 3480, 3479, 3478, 3456, 3358, 3354, 3345, 3258, 3228, 3215, 3207, 3205, 3121, 2845, 2841, 2712, 2538, 2493, 2487, 2481, 2446, 2407, 2391, 2275, 2273, 2271, 2269, 2265, 2252, 2251, 2096, 2095, 2083, 2078, 2048, 2044, 2031, 2024, 1685, 1676, 1230, 7028, 6838, 6737, 6736, 6735, 6734, 6717, 6675, 6577, 6393, 6392, 6220, 6209, 6205, 6175, 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, 6059, 6047, 6046, 6045, 6044, 6043, 6040, 6032, 6031, 6030, 6029, 6024, 5919, 5899, 5898, 5886, 5885, 5863, 5824, 5823, 5822, 5821, 5812, 5773, 5770, 5762, 5753, 5746, 5745, 5744, 5743, 5709, 5708, 5703, 5679, 5678, 5677, 5676, 5650, 5649, 5638, 5637, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5610, 5608, 5588, 5587, 5586, 5541, 5527, 5526, 5525, 5503, 5502, 5501, 5493, 5492, 5491, 5486, 5476, 5468, 5463, 5462, 5416, 5415, 5414, 5412, 5409, 5395, 5387, 5386, 5385, 5354, 5343, 5331, 5312, 5299, 5286, 5283, 5282, 5281, 5280, 5193, 5192, 5191, 5188, 5186, 5185, 5184, 5173, 5172, 5166, 5165, 5164, 5163, 5162, 5147, 5142, 5136, 5134, 5131, 5124, 5117, 5109, 5107, 5106, 5105, 5104, 5091, 5090, 5086, 5080, 5078, 5042, 5035, 5021, 5020, 5007, 5006, 5005, 5004, 4999, 4987, 4905, 4904, 4890, 4889, 4888, 4879, 4847, 4845, 4844, 4841, 4837, 4836, 4835, 4834, 4826, 4825, 4824, 4810, 4809, 4808, 4806, 4804, 4803, 4802, 4801, 4800, 4798, 4797, 4796, 4795, 4794, 4793, 4792, 4791, 4790, 4772, 4771, 4770, 4764, 4762, 4761, 4760, 4759, 4758, 4757, 4756, 4755, 4754, 4751, 4721, 4720, 4719, 4718, 4717, 4665, 4649, 4648, 4647, 4646, 4637, 4636, 4609, 4605, 4604, 4603, 4602, 4597, 4594, 4575, 4558, 4557, 4554, 4551, 4550, 4549, 4548, 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, 4472, 4471, 4470, 4469, 4468, 4466, 4452, 4451, 4450, 4449, 4448, 4447, 4446, 4445, 4444, 4423, 4421, 4420, 4419, 4417, 4403, 4397, 4396, 4368, 4363, 4355, 4354, 4353, 4352, 4350, 4349, 4342, 4341, 4340, 4339, 4338, 4337, 4336, 4335, 4334, 4321, 4307, 4304, 4303, 4302, 4290, 4281, 4276, 4275, 4274, 4252, 4251, 4248, 4247, 4212, 4211, 4210, 4201, 4199, 4195, 4194, 4192, 4191, 4190, 4189, 4188, 4181, 4179, 4167, 4157, 4156, 4155, 4154, 4153, 4152, 4151, 4150, 4149, 4148, 4113, 4107, 4105, 4061, 4051, 4048, 4047, 4046, 4045, 4044, 4043, 4042, 4041, 4040, 4024, 4023, 4022, 4007, 4006, 4005, 3989, 3988, 3987, 3986, 3985, 3984, 3982, 3980, 3976, 3975, 3955, 3940, 3909, 3884, 3883, 3879, 3876, 3875, 3865, 3864, 3863, 3862, 3861, 3857, 3855, 3854, 3851, 3850, 3848, 3840, 3839, 3838, 3837, 3830, 3829, 3828, 3827, 3826, 3825, 3824, 3823, 3822, 3794, 3793, 3792, 3791, 3790, 3773, 3757, 3749, 3747, 3737, 3736, 3734, 3733, 3732, 3728, 3727, 3725, 3723, 3722, 3721, 3715, 3699, 3698, 3697, 3685, 3674, 3655, 3653, 3611, 3593, 3592, 3589, 3588, 3587, 3571, 3570, 3569, 3568, 3567, 3566, 3565, 3547, 3544, 3542, 3540, 3539, 3500, 3499, 3498, 3496, 3477, 3471, 3470, 3469, 3458, 3448, 3437, 3435, 3434, 3433, 3432, 3418, 3415, 3407, 3406, 3403, 3402, 3401, 3393, 3392, 3391, 3390, 3389, 3386, 3368, 3367, 3357, 3353, 3342, 3338, 3332, 3329, 3325, 3321, 3310, 3301, 3300, 3299, 3295, 3293, 3289, 3214, 3210, 3202, 3200, 3199, 3198, 3197, 3196, 3195, 3194, 3193, 3192, 3191, 3190, 3109, 3014, 2998, 2996, 2995, 2992, 2987, 2986, 2983, 2969, 2968, 2967, 2940, 2938, 2937, 2931, 2909, 2908, 2890, 2889, 2888, 2887, 2886, 2884, 2883, 2882, 2880, 2879, 2878, 2868, 2867, 2866, 2865, 2864, 2847, 2846, 2843, 2842, 2839, 2838, 2833, 2832, 2824, 2822, 2821, 2803, 2802, 2800, 2799, 2798, 2796, 2756, 2755, 2713, 2711, 2696, 2676, 2675, 2674, 2616, 2604, 2603, 2602, 2601, 2589, 2588, 2586, 2577, 2572, 2571, 2570, 2569, 2563, 2561, 2560, 2537, 2536, 2535, 2534, 2533, 2530, 2528, 2517, 2513, 2512, 2508, 2504, 2503, 2498, 2497, 2496, 2495, 2494, 2492, 2491, 2490, 2484, 2479, 2474, 2471, 2470, 2467, 2442, 2441, 2439, 2438, 2434, 2433, 2432, 2431, 2430, 2426, 2382, 2381, 2380, 2379, 2375, 2363, 2362, 2361, 2360, 2355, 2334, 2332, 2331, 2326, 2322, 2321, 2320, 2318, 2308, 2307, 2306, 2305, 2302, 2301, 2300, 2294, 2293, 2287, 2285, 2284, 2283, 2278, 2277, 2276, 2274, 2272, 2270, 2268, 2267, 2266, 2263, 2262, 2261, 2260, 2259, 2258, 2257, 2256, 2255, 2254, 2253, 2240, 2223, 2219, 2218, 2217, 2205, 2200, 2199, 2198, 2191, 2190, 2184, 2183, 2181, 2175, 2163, 2160, 2159, 2151, 2142, 2141, 2139, 2132, 2125, 2124, 2122, 2121, 2120, 2118, 2116, 2114, 2113, 2111, 2108, 2106, 2105, 2101, 2100, 2099, 2098, 2097, 2094, 2093, 2092, 2086, 2085, 2082, 2081, 2080, 2077, 2076, 2075, 2065, 2063, 2062, 2061, 2059, 2047, 2046, 2043, 2041, 2038, 2025, 2004, 2003, 2002, 2001, 2000, 1967, 1932, 1931, 1750, 1717, 1714, 1276, 719, 699, 697, 588) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
1.680.000 ₫
Special Price
1.580.000 ₫
4262
-
Giá thường:
1.680.000 ₫
Special Price
1.580.000 ₫
4092
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
3735
-
Giá thường:
1.500.000 ₫
Special Price
1.050.000 ₫
2710
-
Giá thường:
250.000 ₫
Special Price
175.000 ₫
2615
-
-
Giá thường:
110.000 ₫
Special Price
77.000 ₫
2371
-
-
Giá thường:
320.000 ₫
Special Price
224.000 ₫
2145
-
Giá thường:
200.000 ₫
Special Price
140.000 ₫
2064
-
Giá thường:
220.000 ₫
Special Price
154.000 ₫
2042
-
-
-
-
-
-
-