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(510, 512, 515, 516, 536, 538, 539, 540, 566, 567, 568, 569, 590, 593, 594, 673, 681, 683, 685, 719, 869, 920, 950, 1028, 1030, 1032, 1048, 1092, 1094, 1132, 1201, 1202, 1262, 1299, 1308, 1634, 1651, 1727, 1750, 1758, 1759, 1760, 1768, 1777, 1811, 2444, 2445, 2741, 2778, 2782, 2964, 2965, 2966, 3009, 3161, 3376, 3616, 3617, 3644, 3646, 3649, 3650, 3651, 3656, 3660, 3661, 3662, 3664, 3665, 3666, 3689, 3700, 3735, 3736, 3737, 3738, 3740, 3761, 3762, 3776, 3777, 3778, 3779, 3780, 3781, 3782, 3783, 3784, 3785, 3795, 3796, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3806, 3845, 3846, 3860, 3870, 3871, 3872, 3953, 3954, 3973, 3974, 3975, 4000, 4001, 4002, 4091, 4092, 4093, 4094, 4095, 4096, 4114, 4239, 4262, 4302, 4303, 4304, 4305, 4306, 4307, 4357, 4358, 4359, 4408, 4461, 4579, 4582, 4583, 4584, 4585, 4625, 4626, 4627, 4655, 4670, 4672, 4734, 4736, 4787, 4815, 4900, 4901, 4902, 4903, 4904, 4905, 4994, 5038, 5124, 5132, 5139, 5140, 5141, 5145, 5146, 5160, 5184, 5185, 5186, 5192, 5193, 5206, 5207, 5208, 5226, 5451, 5452, 5453, 5454, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5534, 5539, 5540, 5541, 5550, 5551, 5552, 5553, 5554, 5578, 5579, 5580, 5633, 5651, 5652, 5653, 5654, 5655, 5656, 5680, 5681, 5682, 5683, 5684, 5685, 5686, 5687, 5688, 5689, 5690, 5692, 5695, 5697, 5698, 5704, 5705, 5706, 5707, 5710, 5717, 5718, 5749, 5754, 5767, 5799, 5809, 5857, 5858, 5859, 5912, 5913, 5914, 5944, 6052, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6086, 6087, 6137, 6139, 6140, 6141, 6146, 6156, 6223, 6224, 6230, 6231, 6253, 6254, 6255, 6256, 6267, 6277, 6306, 6307, 6308, 6309, 6407, 6408, 6409, 6410, 6411, 6412, 6423, 6424, 6425, 6426, 6427, 6428, 6429, 6430, 6501, 6502, 6503, 6504, 6505, 6506, 6744, 6745, 6774)) ORDER BY FIELD(`e`.`entity_id`, 6745, 6744, 6230, 6224, 5944, 5767, 5534, 5451, 5208, 5207, 5206, 5146, 5145, 5141, 5140, 5139, 1092, 920, 512, 6430, 6429, 6428, 6427, 6426, 6425, 6424, 6423, 6309, 6307, 6306, 6223, 6146, 5858, 5857, 5754, 5710, 5707, 5706, 5704, 5698, 5697, 5695, 5687, 5686, 5685, 5684, 5683, 5681, 5680, 5554, 5454, 5453, 5452, 5226, 5160, 4903, 4902, 4901, 4900, 4670, 4655, 4461, 4408, 4262, 4114, 4095, 4094, 4093, 4092, 4091, 3617, 2445, 2444, 1811, 1777, 1768, 1760, 1758, 1651, 1634, 1308, 1299, 1202, 1201, 1132, 1094, 1032, 1028, 683, 673, 594, 593, 590, 569, 568, 567, 566, 540, 539, 538, 510, 6774, 6410, 6156, 6087, 6086, 6083, 6082, 6079, 6078, 6077, 6076, 6074, 5914, 5913, 5912, 5461, 5038, 4358, 4357, 4306, 4305, 4096, 4002, 4001, 3785, 3784, 3738, 3735, 2965, 2964, 1262, 1030, 869, 681, 516, 6506, 6505, 6504, 6503, 6502, 6501, 6412, 6411, 6409, 6408, 6407, 6308, 6277, 6267, 6256, 6255, 6254, 6253, 6231, 6141, 6140, 6139, 6137, 6085, 6084, 6081, 6080, 6075, 6073, 6072, 6071, 6070, 6069, 6068, 6067, 6052, 5859, 5809, 5799, 5749, 5718, 5717, 5705, 5692, 5690, 5689, 5688, 5682, 5656, 5655, 5654, 5653, 5652, 5651, 5633, 5580, 5579, 5578, 5553, 5552, 5551, 5550, 5541, 5540, 5539, 5463, 5462, 5460, 5459, 5458, 5457, 5456, 5193, 5192, 5186, 5185, 5184, 5132, 5124, 4994, 4905, 4904, 4815, 4787, 4736, 4734, 4672, 4627, 4626, 4625, 4585, 4584, 4583, 4582, 4579, 4359, 4307, 4304, 4303, 4302, 4239, 4000, 3975, 3974, 3973, 3954, 3953, 3872, 3871, 3870, 3860, 3846, 3845, 3806, 3805, 3804, 3803, 3802, 3801, 3800, 3799, 3798, 3797, 3796, 3795, 3783, 3782, 3781, 3780, 3779, 3778, 3777, 3776, 3762, 3761, 3740, 3737, 3736, 3700, 3689, 3666, 3665, 3664, 3662, 3661, 3660, 3656, 3651, 3650, 3649, 3646, 3644, 3616, 3376, 3161, 3009, 2966, 2782, 2778, 2741, 1759, 1750, 1727, 1048, 950, 719, 685, 536, 515) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
6745
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
6744
-
-
-
Giá thường:
970.000 ₫
Special Price
945.000 ₫
5944
-
-
-
-
Giá thường:
480.000 ₫
Special Price
430.000 ₫
5208
-
Giá thường:
480.000 ₫
Special Price
430.000 ₫
5207
-
Giá thường:
480.000 ₫
Special Price
430.000 ₫
5206
-
Giá thường:
890.000 ₫
Special Price
790.000 ₫
5146
-
Giá thường:
890.000 ₫
Special Price
790.000 ₫
5145
-
Giá thường:
290.000 ₫
Special Price
260.000 ₫
5141
-
Giá thường:
290.000 ₫
Special Price
260.000 ₫
5140
-
Giá thường:
290.000 ₫
Special Price
260.000 ₫
5139
-
Giá thường:
420.000 ₫
Special Price
380.000 ₫
1092
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6430
-
Giá thường:
580.000 ₫
Special Price
550.000 ₫
6429
-
-
-
Giá thường:
500.000 ₫
Special Price
460.000 ₫
6426
-
Giá thường:
500.000 ₫
Special Price
460.000 ₫
6425
-
Giá thường:
500.000 ₫
Special Price
460.000 ₫
6424
-
Giá thường:
500.000 ₫
Special Price
460.000 ₫
6423
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
6309
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6307
-
Giá thường:
520.000 ₫
Special Price
495.000 ₫
6306
-
Giá thường:
820.000 ₫
Special Price
800.000 ₫
6223
-
Giá thường:
620.000 ₫
Special Price
600.000 ₫
6146
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
5858
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
5857
-
Giá thường:
340.000 ₫
Special Price
300.000 ₫
5754
-
Giá thường:
650.000 ₫
Special Price
590.000 ₫
5710
-
Giá thường:
650.000 ₫
Special Price
590.000 ₫
5707
-
Giá thường:
380.000 ₫
Special Price
350.000 ₫
5706