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(945, 1037, 1600, 1696, 1736, 1740, 1989, 1998, 1999, 2360, 2361, 2362, 2363, 2379, 2380, 2381, 2382, 2446, 2721, 2777, 2778, 2781, 2782, 2789, 2886, 2887, 2888, 2889, 2890, 3014, 3099, 3276, 3277, 3284, 3288, 3448, 3460, 3508, 3509, 3510, 3511, 3513, 3514, 3515, 3516, 3518, 3519, 3520, 3522, 3523, 3524, 3525, 3529, 3530, 3531, 3532, 3533, 3534, 3536, 3537, 3573, 3595, 3619, 3623, 3624, 3625, 3636, 3640, 3641, 3642, 3704, 3705, 3710, 3726, 3727, 3728, 3729, 3730, 3731, 3732, 3893, 3902, 3918, 3920, 3921, 3922, 3923, 3924, 3936, 3937, 3938, 3939, 3940, 3942, 3944, 3945, 3969, 3970, 4003, 4031, 4032, 4034, 4035, 4040, 4041, 4042, 4043, 4044, 4045, 4046, 4047, 4048, 4052, 4069, 4107, 4108, 4113, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4135, 4136, 4137, 4138, 4139, 4140, 4141, 4166, 4167, 4168, 4176, 4177, 4178, 4179, 4181, 4184, 4185, 4196, 4206, 4210, 4211, 4212, 4224, 4225, 4253, 4254, 4255, 4268, 4269, 4270, 4271, 4272, 4273, 4274, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4289, 4290, 4291, 4292, 4302, 4303, 4304, 4322, 4323, 4324, 4325, 4326, 4327, 4328, 4329, 4331, 4332, 4333, 4336, 4337, 4338, 4339, 4340, 4341, 4374, 4402, 4412, 4413, 4414, 4415, 4417, 4418, 4419, 4420, 4421, 4422, 4423, 4424, 4425, 4426, 4427, 4428, 4430, 4431, 4432, 4433, 4434, 4435, 4436, 4437, 4438, 4439, 4444, 4445, 4446, 4447, 4448, 4449, 4450, 4451, 4452, 4453, 4458, 4515, 4516, 4517, 4518, 4519, 4540, 4544, 4556, 4561, 4562, 4563, 4564, 4565, 4566, 4570, 4572, 4573, 4574, 4575, 4597, 4616, 4624, 4625, 4626, 4627, 4628, 4629, 4630, 4679, 4697, 4699, 4701, 4732, 4749, 4762, 4763, 4764, 4770, 4771, 4772, 4853, 4854, 4856, 4857, 4858, 4861, 4969, 4978, 4980, 4981, 4982, 4983, 4986, 4987, 4988, 4995, 4996, 4997, 5004, 5005, 5006, 5007, 5018, 5019, 5020, 5021, 5022, 5024, 5055, 5056, 5057, 5058, 5068, 5069, 5070, 5103, 5107, 5114, 5118, 5161, 5162, 5163, 5174, 5176, 5199, 5209, 5214, 5221, 5222, 5239, 5240, 5241, 5263, 5266, 5284, 5285, 5290, 5293, 5299, 5301, 5305, 5307, 5308, 5310, 5311, 5312, 5313, 5314, 5316, 5327, 5341, 5343, 5350, 5357, 5383, 5391, 5393, 5395, 5396, 5400, 5407, 5432, 5433, 5434, 5435, 5447, 5455, 5473, 5490, 5498, 5500, 5501, 5502, 5515, 5534, 5607, 5608, 5609, 5610, 5693, 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, 6049, 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, 6397, 6427, 6428, 6429, 6437, 6438, 6439, 6452, 6453, 6454, 6455, 6456, 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, 6692, 6693, 6694, 6699, 6700, 6701, 6702, 6703, 6704, 6707, 6708, 6709, 6710, 6711, 6712, 6713, 6714, 6715, 6716, 6717, 6718, 6719, 6731, 6732, 6733, 6741, 6742, 6755, 6769, 6770, 6775, 6788, 6789, 6790, 6791, 6794, 6795, 6799, 6800, 6801, 6802, 6803, 6804, 6805, 6806, 6807, 6808, 6809, 6810, 6811, 6812, 6813, 6814, 6825, 6826, 6827, 6831, 6833, 6834, 6835, 6836, 6837, 6838, 6850, 6902, 6906, 6907, 6908, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6929, 6930, 6931, 6942, 6943, 6944, 6948, 6949, 6950, 6951, 6952, 6955, 6957, 6962, 6964, 6965, 6966, 6967, 6968, 6969, 6978, 6979, 6980, 6989, 6994, 6995, 6996, 7002, 7003, 7004, 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`, 6396, 6395, 6962, 6957, 6788, 6653, 6652, 6651, 6650, 6649, 6648, 6479, 6477, 5713, 5712, 5056, 5055, 4437, 4436, 4434, 4433, 4430, 4425, 4424, 4176, 4168, 4166, 4141, 4140, 4139, 4137, 4136, 4132, 4131, 4129, 4128, 4127, 4126, 3705, 3625, 3619, 3536, 3530, 1999, 1998, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7018, 7015, 7014, 7013, 7012, 7011, 7010, 7009, 7005, 7004, 7003, 7002, 6996, 6995, 6994, 6989, 6980, 6979, 6978, 6969, 6968, 6967, 6966, 6965, 6964, 6955, 6952, 6951, 6949, 6948, 6944, 6943, 6942, 6931, 6930, 6929, 6927, 6926, 6925, 6924, 6923, 6922, 6921, 6920, 6919, 6918, 6917, 6916, 6915, 6914, 6913, 6912, 6911, 6910, 6908, 6907, 6906, 6902, 6850, 6837, 6836, 6835, 6834, 6833, 6831, 6827, 6826, 6825, 6814, 6813, 6812, 6809, 6808, 6806, 6803, 6802, 6799, 6795, 6794, 6791, 6790, 6789, 6775, 6770, 6769, 6755, 6742, 6741, 6733, 6732, 6731, 6719, 6718, 6716, 6715, 6714, 6713, 6711, 6710, 6707, 6703, 6702, 6701, 6699, 6694, 6693, 6692, 6677, 6676, 6674, 6673, 6666, 6663, 6660, 6658, 6657, 6656, 6655, 6654, 6645, 6604, 6603, 6602, 6601, 6599, 6595, 6589, 6588, 6581, 6580, 6579, 6559, 6543, 6542, 6541, 6540, 6539, 6538, 6537, 6536, 6534, 6525, 6524, 6523, 6522, 6521, 6520, 6519, 6518, 6517, 6453, 6452, 6439, 6438, 6437, 6429, 6428, 6427, 6394, 6391, 6377, 6376, 6375, 6356, 6351, 6350, 6349, 6348, 6322, 6321, 6320, 6319, 6317, 6311, 6230, 6224, 6223, 6221, 6219, 6218, 6217, 6216, 6215, 6214, 6213, 6212, 6204, 6203, 6202, 6201, 6193, 6192, 6191, 6169, 6148, 6147, 6041, 6035, 6010, 6009, 6002, 6000, 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, 5815, 5814, 5813, 5811, 5810, 5752, 5751, 5750, 5730, 5715, 5714, 5710, 5707, 5702, 5700, 5693, 5609, 5607, 5534, 5500, 5490, 5455, 5432, 5396, 5393, 5357, 5350, 5327, 5266, 5263, 5209, 5199, 5114, 5070, 5069, 5022, 5019, 5018, 4988, 4987, 4986, 4763, 4749, 4563, 4562, 4561, 4556, 4544, 4540, 4519, 4517, 4515, 4422, 4418, 4415, 4414, 4413, 4412, 4374, 4332, 4325, 4324, 4323, 4322, 4285, 4284, 4283, 4282, 4280, 4178, 4177, 4108, 4052, 4032, 3731, 3730, 3729, 3726, 3099, 2721, 2446, 1989, 1037, 7021, 7020, 7019, 7017, 7016, 6950, 6838, 6811, 6810, 6807, 6805, 6804, 6801, 6800, 6717, 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, 6456, 6455, 6454, 6397, 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, 6049, 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, 5610, 5608, 5515, 5502, 5501, 5498, 5473, 5447, 5435, 5434, 5433, 5407, 5400, 5395, 5391, 5383, 5343, 5341, 5316, 5314, 5313, 5312, 5311, 5310, 5308, 5307, 5305, 5301, 5299, 5293, 5290, 5285, 5284, 5241, 5240, 5239, 5222, 5221, 5214, 5176, 5174, 5163, 5162, 5161, 5118, 5107, 5103, 5068, 5058, 5057, 5024, 5021, 5020, 5007, 5006, 5005, 5004, 4997, 4996, 4995, 4983, 4982, 4981, 4980, 4978, 4969, 4861, 4858, 4857, 4856, 4854, 4853, 4772, 4771, 4770, 4764, 4762, 4732, 4701, 4699, 4697, 4679, 4630, 4629, 4628, 4627, 4626, 4625, 4624, 4616, 4597, 4575, 4574, 4573, 4572, 4570, 4566, 4565, 4564, 4518, 4516, 4458, 4453, 4452, 4451, 4450, 4449, 4448, 4447, 4446, 4445, 4444, 4439, 4438, 4435, 4432, 4431, 4428, 4427, 4426, 4423, 4421, 4420, 4419, 4417, 4402, 4341, 4340, 4339, 4338, 4337, 4336, 4333, 4331, 4329, 4328, 4327, 4326, 4304, 4303, 4302, 4292, 4291, 4290, 4289, 4281, 4279, 4278, 4277, 4276, 4275, 4274, 4273, 4272, 4271, 4270, 4269, 4268, 4255, 4254, 4253, 4225, 4224, 4212, 4211, 4210, 4206, 4196, 4185, 4184, 4181, 4179, 4167, 4138, 4135, 4130, 4113, 4107, 4069, 4048, 4047, 4046, 4045, 4044, 4043, 4042, 4041, 4040, 4035, 4034, 4031, 4003, 3970, 3969, 3945, 3944, 3942, 3940, 3939, 3938, 3937, 3936, 3924, 3923, 3922, 3921, 3920, 3918, 3902, 3893, 3732, 3728, 3727, 3710, 3704, 3642, 3641, 3640, 3636, 3624, 3623, 3595, 3573, 3537, 3534, 3533, 3532, 3531, 3529, 3525, 3524, 3523, 3522, 3520, 3519, 3518, 3516, 3515, 3514, 3513, 3511, 3510, 3509, 3508, 3460, 3448, 3288, 3284, 3277, 3276, 3014, 2890, 2889, 2888, 2887, 2886, 2789, 2782, 2781, 2778, 2777, 2382, 2381, 2380, 2379, 2363, 2362, 2361, 2360, 1740, 1736, 1696, 1600, 945) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
Giá thường:
450.000 ₫
Special Price
315.000 ₫
5055
Đi kèm
- Hộp gấm đựng quà
- Dây sơ cua
-
-
-
-
Giá thường:
150.000 ₫
Special Price
120.000 ₫
4166
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-