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(950, 1600, 1696, 1736, 1740, 1989, 2379, 2380, 2381, 2382, 2721, 2777, 2778, 2781, 2782, 2789, 2886, 2887, 2888, 2889, 2890, 3099, 3339, 3448, 3460, 3573, 3595, 3689, 3700, 3893, 3902, 3918, 3920, 3921, 3922, 3923, 3924, 3939, 3940, 3942, 3944, 3945, 3969, 3970, 4003, 4107, 4108, 4113, 4119, 4121, 4122, 4123, 4196, 4207, 4210, 4211, 4212, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4331, 4332, 4333, 4336, 4337, 4338, 4339, 4340, 4341, 4419, 4420, 4421, 4422, 4423, 4424, 4425, 4426, 4427, 4428, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4458, 4463, 4465, 4515, 4516, 4517, 4518, 4519, 4540, 4544, 4556, 4570, 4572, 4573, 4574, 4575, 4616, 4624, 4625, 4626, 4627, 4628, 4629, 4630, 4697, 4699, 4701, 4732, 4735, 4745, 4749, 4770, 4771, 4772, 4780, 4787, 4853, 4854, 4856, 4857, 4858, 4861, 4969, 5030, 5045, 5103, 5107, 5122, 5156, 5169, 5170, 5174, 5221, 5228, 5239, 5240, 5241, 5263, 5266, 5284, 5285, 5290, 5292, 5293, 5296, 5299, 5301, 5305, 5307, 5308, 5310, 5311, 5312, 5313, 5314, 5327, 5341, 5343, 5350, 5357, 5383, 5391, 5393, 5395, 5396, 5400, 5407, 5432, 5447, 5455, 5473, 5498, 5515, 5534, 5607, 5611, 5640, 5641, 5642, 5694, 5696, 5700, 5701, 5702, 5707, 5710, 5712, 5713, 5714, 5715, 5730, 5750, 5751, 5752, 5810, 5811, 5812, 5813, 5814, 5815, 5830, 5833, 5835, 5879, 5880, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5908, 5909, 5910, 5911, 5912, 5913, 5914, 5915, 5917, 5918, 5919, 5920, 5921, 5922, 5923, 5924, 5925, 5926, 5927, 5928, 5936, 5937, 5938, 5939, 5940, 5941, 5942, 5944, 5946, 5947, 5948, 5949, 5950, 5951, 5952, 5953, 5954, 5955, 5956, 5957, 5958, 5981, 5982, 5983, 5984, 5985, 5986, 5987, 5988, 5989, 5990, 5991, 5992, 5993, 5994, 5995, 5999, 6000, 6002, 6003, 6005, 6009, 6010, 6035, 6039, 6040, 6041, 6052, 6053, 6147, 6148, 6150, 6151, 6152, 6153, 6169, 6172, 6184, 6185, 6186, 6187, 6191, 6192, 6193, 6201, 6202, 6203, 6204, 6205, 6212, 6213, 6214, 6215, 6216, 6217, 6218, 6219, 6220, 6221, 6223, 6224, 6230, 6231, 6232, 6284, 6293, 6294, 6295, 6296, 6297, 6298, 6299, 6303, 6304, 6305, 6310, 6311, 6317, 6318, 6319, 6320, 6321, 6322, 6323, 6330, 6332, 6333, 6348, 6349, 6350, 6351, 6356, 6369, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6377, 6391, 6392, 6393, 6394, 6395, 6396, 6427, 6428, 6429, 6437, 6438, 6439, 6459, 6460, 6463, 6470, 6477, 6478, 6479, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6534, 6535, 6536, 6537, 6538, 6539, 6540, 6541, 6542, 6543, 6559, 6579, 6580, 6581, 6587, 6588, 6589, 6590, 6594, 6595, 6598, 6599, 6600, 6601, 6602, 6603, 6604, 6616, 6617, 6619, 6645, 6648, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6663, 6664, 6665, 6666, 6667, 6672, 6673, 6674, 6675, 6676, 6677, 6699, 6700, 6701, 6702, 6703, 6704, 6707, 6708, 6709, 6710, 6711, 6712, 6713, 6731, 6732, 6733, 6741, 6742, 6755, 6769, 6770, 6775, 6788, 6794, 6795, 6799, 6800, 6801, 6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811, 6812, 6836, 6837, 6838, 6907, 6908, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6942, 6943, 6944, 6948, 6949, 6950, 6951, 6952, 6957, 6962, 6964, 6965, 6966, 6967, 6968, 6969, 6978, 6979, 6980, 6989, 6994, 6995, 6996, 7005, 7009, 7010, 7011, 7012, 7013, 7014, 7015, 7016, 7017, 7018, 7019, 7020, 7021, 7023, 7024, 7025, 7026, 7027, 7028, 7029)) ORDER BY FIELD(`e`.`entity_id`, 7018, 7015, 7014, 7013, 7012, 6952, 6951, 6949, 6806, 6802, 6733, 6732, 6713, 6711, 6710, 6707, 6703, 6589, 6588, 6311, 6169, 6041, 6035, 6000, 5730, 5702, 5700, 5455, 5432, 5393, 5357, 4422, 6996, 6995, 6994, 6980, 6979, 6978, 6969, 6968, 6967, 6966, 6965, 6964, 6921, 6920, 6919, 6918, 6917, 6916, 6915, 6914, 6913, 6912, 6911, 6812, 6809, 6808, 6803, 6799, 6795, 6731, 6677, 6599, 6595, 6581, 6580, 6579, 6559, 6429, 6428, 6427, 6396, 6395, 6356, 6148, 6147, 6002, 5752, 5751, 5750, 5715, 5714, 5713, 5712, 5327, 4556, 4544, 4540, 5815, 5814, 5811, 3099, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7011, 7010, 7009, 7005, 6989, 6962, 6957, 6948, 6944, 6943, 6942, 6926, 6925, 6924, 6923, 6922, 6910, 6908, 6907, 6837, 6836, 6794, 6788, 6775, 6770, 6769, 6755, 6742, 6741, 6702, 6701, 6699, 6676, 6674, 6673, 6666, 6663, 6660, 6658, 6657, 6656, 6655, 6654, 6653, 6652, 6651, 6650, 6649, 6648, 6645, 6604, 6603, 6602, 6601, 6543, 6542, 6541, 6540, 6539, 6538, 6537, 6536, 6534, 6525, 6524, 6523, 6522, 6521, 6520, 6519, 6518, 6517, 6479, 6477, 6439, 6438, 6437, 6394, 6391, 6377, 6376, 6375, 6351, 6350, 6349, 6348, 6322, 6321, 6320, 6319, 6317, 6230, 6224, 6223, 6221, 6219, 6218, 6217, 6216, 6215, 6214, 6213, 6212, 6204, 6203, 6202, 6201, 6193, 6192, 6191, 6010, 6009, 5992, 5990, 5944, 5926, 5925, 5924, 5923, 5922, 5921, 5920, 5918, 5915, 5914, 5913, 5912, 5906, 5903, 5902, 5901, 5900, 5899, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5880, 5835, 5830, 5813, 5810, 5710, 5707, 5611, 5607, 5534, 5396, 5350, 5266, 5263, 5228, 5045, 4780, 4749, 4735, 4519, 4517, 4515, 4465, 4425, 4424, 4332, 4325, 4324, 4323, 4322, 4285, 4284, 4283, 4282, 4280, 4108, 2721, 1989, 7021, 7020, 7019, 7017, 7016, 6950, 6838, 6811, 6810, 6807, 6805, 6804, 6801, 6800, 6712, 6709, 6708, 6704, 6700, 6675, 6672, 6667, 6665, 6664, 6659, 6619, 6617, 6616, 6600, 6598, 6594, 6590, 6587, 6535, 6478, 6470, 6463, 6460, 6459, 6393, 6392, 6374, 6373, 6372, 6371, 6370, 6369, 6333, 6332, 6330, 6323, 6318, 6310, 6305, 6304, 6303, 6299, 6298, 6297, 6296, 6295, 6294, 6293, 6284, 6232, 6231, 6220, 6205, 6187, 6186, 6185, 6184, 6172, 6153, 6152, 6151, 6150, 6053, 6052, 6040, 6039, 6005, 6003, 5999, 5995, 5994, 5993, 5991, 5989, 5988, 5987, 5986, 5985, 5984, 5983, 5982, 5981, 5958, 5957, 5956, 5955, 5954, 5953, 5952, 5951, 5950, 5949, 5948, 5947, 5946, 5942, 5941, 5940, 5939, 5938, 5937, 5936, 5928, 5927, 5919, 5917, 5911, 5910, 5909, 5908, 5905, 5904, 5898, 5890, 5889, 5888, 5879, 5833, 5812, 5701, 5696, 5694, 5642, 5641, 5640, 5515, 5498, 5473, 5447, 5407, 5400, 5395, 5391, 5383, 5343, 5341, 5314, 5313, 5312, 5311, 5310, 5308, 5307, 5305, 5301, 5299, 5296, 5293, 5292, 5290, 5285, 5284, 5241, 5240, 5239, 5221, 5174, 5170, 5169, 5156, 5122, 5107, 5103, 5030, 4969, 4861, 4858, 4857, 4856, 4854, 4853, 4787, 4772, 4771, 4770, 4745, 4732, 4701, 4699, 4697, 4630, 4629, 4628, 4627, 4626, 4625, 4624, 4616, 4575, 4574, 4573, 4572, 4570, 4518, 4516, 4463, 4458, 4452, 4451, 4450, 4449, 4448, 4447, 4446, 4445, 4444, 4428, 4427, 4426, 4423, 4421, 4420, 4419, 4341, 4340, 4339, 4338, 4337, 4336, 4333, 4331, 4329, 4328, 4327, 4326, 4281, 4279, 4278, 4277, 4276, 4275, 4274, 4273, 4272, 4271, 4270, 4269, 4268, 4212, 4211, 4210, 4207, 4196, 4123, 4122, 4121, 4119, 4113, 4107, 4003, 3970, 3969, 3945, 3944, 3942, 3940, 3939, 3924, 3923, 3922, 3921, 3920, 3918, 3902, 3893, 3700, 3689, 3595, 3573, 3460, 3448, 3339, 2890, 2889, 2888, 2887, 2886, 2789, 2782, 2781, 2778, 2777, 2382, 2381, 2380, 2379, 1740, 1736, 1696, 1600, 950) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Từ:
136.000 ₫
Đến:
661.000 ₫
5393
-
Kèm theo
- Túi đựng quà sang trọng
-
Từ:
179.000 ₫
Đến:
475.000 ₫
4422
-
-
-
-
-
-