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(546, 936, 940, 1037, 1225, 1271, 1275, 1591, 1612, 2449, 2452, 2457, 2458, 2460, 2461, 2463, 2464, 2546, 2547, 2548, 2577, 2661, 2663, 2664, 2824, 2841, 2842, 2843, 2845, 2846, 2847, 2862, 2863, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 3107, 3109, 3110, 3192, 3197, 3202, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3215, 3216, 3258, 3261, 3262, 3294, 3299, 3301, 3304, 3308, 3314, 3322, 3323, 3328, 3331, 3332, 3337, 3422, 3435, 3437, 3445, 3525, 3531, 3532, 3583, 3623, 3662, 3709, 3758, 3773, 3774, 3873, 3879, 3883, 3922, 3923, 3924, 3951, 3961, 3962, 4004, 4026, 4034, 4106, 4109, 4111, 4139, 4140, 4141, 4156, 4186, 4242, 4243, 4244, 4246, 4252, 4261, 4309, 4310, 4311, 4312, 4313, 4359, 4361, 4368, 4370, 4371, 4372, 4403, 4404, 4405, 4406, 4412, 4417, 4418, 4429, 4430, 4431, 4432, 4433, 4454, 4455, 4456, 4457, 4467, 4479, 4495, 4520, 4521, 4522, 4523, 4527, 4597, 4602, 4603, 4604, 4605, 4609, 4634, 4694, 4708, 4728, 4734, 4736, 4757, 4815, 4818, 4860, 4861, 4878, 4879, 4891, 4892, 4897, 4906, 4907, 4908, 4909, 4910, 4911, 4912, 4913, 4914, 4954, 4978, 4989, 4990, 4991, 4992, 4993, 4994, 4999, 5000, 5002, 5003, 5032, 5035, 5036, 5037, 5038, 5043, 5047, 5071, 5072, 5093, 5097, 5098, 5099, 5100, 5101, 5102, 5104, 5105, 5106, 5107, 5136, 5138, 5147, 5169, 5201, 5202, 5203, 5204, 5205, 5224, 5242, 5246, 5257, 5258, 5259, 5260, 5261, 5277, 5278, 5279, 5285, 5288, 5299, 5300, 5333, 5411, 5504, 5516, 5538, 5581, 5582, 5583, 5584, 5585, 5586, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 5620, 5621, 5622, 5623, 5624, 5625, 5626, 5627, 5635, 5673, 5674, 5675, 5694, 5875, 5888, 5889, 5890, 5891, 5892, 5893, 5894, 5895, 5896, 5897, 5898, 5899, 5900, 5901, 5902, 5903, 5904, 5905, 5906, 5908, 5909, 5910, 5911, 5918, 5925, 5926, 5927, 5936, 5939, 5942, 5946, 5947, 5948, 5949, 5950, 6021, 6069, 6076, 6080, 6134, 6135, 6136, 6200, 6205, 6243, 6268, 6440, 6441, 6442, 6443, 6444, 6486, 6488, 6489, 6491, 6507, 6565, 6626, 6630, 6708, 6709, 6734, 6735, 6736, 6737, 6741, 6743, 6774, 6863, 6869, 6897, 6898, 6900, 6901, 6906, 6989, 6991, 6992, 6993, 7002, 7003, 7004)) ORDER BY FIELD(`e`.`entity_id`, 6901, 6900, 4911, 4910, 4909, 6906, 6898, 6897, 5926, 5925, 5906, 5903, 5902, 5901, 5900, 5899, 5897, 5896, 5895, 5894, 5893, 5892, 5891, 5586, 5585, 5584, 5583, 5582, 5581, 5204, 5203, 5202, 5038, 5037, 5036, 4908, 4907, 4906, 4109, 3262, 3261, 2464, 2463, 2461, 2452, 7004, 7003, 7002, 6993, 6992, 6991, 6989, 6869, 6863, 6774, 6743, 6741, 6630, 6626, 6565, 6507, 6491, 6489, 6488, 6486, 6444, 6443, 6441, 6440, 6268, 6200, 6076, 5918, 5875, 5675, 5674, 5673, 5635, 5626, 5625, 5623, 5622, 5620, 5617, 5614, 5612, 5611, 5411, 5333, 5246, 5072, 5043, 5032, 5003, 5002, 4993, 4992, 4989, 4694, 4495, 4433, 4430, 4418, 4412, 4310, 4309, 4141, 4140, 4139, 4106, 3314, 3258, 3215, 3208, 3207, 3205, 2845, 2841, 2664, 2663, 2661, 2548, 1591, 1271, 1225, 1037, 940, 936, 546, 6737, 6736, 6735, 6734, 6709, 6708, 6442, 6243, 6205, 6136, 6135, 6134, 6080, 6069, 6021, 5950, 5949, 5948, 5947, 5946, 5942, 5939, 5936, 5927, 5911, 5910, 5909, 5908, 5905, 5904, 5898, 5890, 5889, 5888, 5694, 5627, 5624, 5621, 5619, 5618, 5616, 5615, 5613, 5538, 5516, 5504, 5300, 5299, 5288, 5285, 5279, 5278, 5277, 5261, 5260, 5259, 5258, 5257, 5242, 5224, 5205, 5201, 5169, 5147, 5138, 5136, 5107, 5106, 5105, 5104, 5102, 5101, 5100, 5099, 5098, 5097, 5093, 5071, 5047, 5035, 5000, 4999, 4994, 4991, 4990, 4978, 4954, 4914, 4913, 4912, 4897, 4892, 4891, 4879, 4878, 4861, 4860, 4818, 4815, 4757, 4736, 4734, 4728, 4708, 4634, 4609, 4605, 4604, 4603, 4602, 4597, 4527, 4523, 4522, 4521, 4520, 4479, 4467, 4457, 4456, 4455, 4454, 4432, 4431, 4429, 4417, 4406, 4405, 4404, 4403, 4372, 4371, 4370, 4368, 4361, 4359, 4313, 4312, 4311, 4261, 4252, 4246, 4244, 4243, 4242, 4186, 4156, 4111, 4034, 4026, 4004, 3962, 3961, 3951, 3924, 3923, 3922, 3883, 3879, 3873, 3774, 3773, 3758, 3709, 3662, 3623, 3583, 3532, 3531, 3525, 3445, 3437, 3435, 3422, 3337, 3332, 3331, 3328, 3323, 3322, 3308, 3304, 3301, 3299, 3294, 3216, 3210, 3209, 3206, 3204, 3202, 3197, 3192, 3110, 3109, 3107, 2904, 2903, 2902, 2901, 2900, 2899, 2898, 2863, 2862, 2847, 2846, 2843, 2842, 2824, 2577, 2547, 2546, 2460, 2458, 2457, 2449, 1612, 1275) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5202
-
Giá thường:
380.000 ₫
Special Price
145.000 ₫
5036
-
-
Giá thường:
250.000 ₫
Special Price
180.000 ₫
4109
-
Giá thường:
180.000 ₫
Special Price
126.000 ₫
3262
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
119.000 ₫
Special Price
99.000 ₫
5635
-
-
-
-
-
-
Giá thường:
280.000 ₫
Special Price
196.000 ₫
5072
-
Giá thường:
280.000 ₫
Special Price
120.000 ₫
5043