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(1158, 1436, 1471, 1652, 1736, 1988, 1989, 1990, 2674, 2675, 2676, 2870, 2871, 2872, 2913, 2914, 2915, 3277, 3279, 3280, 3574, 3581, 3893, 3902, 3908, 3915, 3917, 3918, 3920, 3921, 3937, 3942, 3948, 4026, 4052, 4093, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4201, 4253, 4254, 4256, 4257, 4258, 4260, 4364, 4369, 4409, 4410, 4411, 4537, 4545, 4551, 4553, 4554, 4555, 4589, 4591, 4616, 4638, 4639, 4641, 4644, 4645, 4646, 4686, 4770, 4771, 4772, 4786, 4831, 4832, 4833, 4898, 4939, 4942, 4943, 4944, 4947, 4948, 4949, 4950, 4951, 4952, 4953, 4954, 5003, 5022, 5023, 5025, 5026, 5027, 5028, 5029, 5033, 5034, 5048, 5153, 5232, 5266, 5296, 5311, 5523, 5596, 5687, 5697, 5698, 5721, 5722, 5723, 5724, 5742, 5799, 5810, 5811, 5812, 5813, 5814, 5815, 5830, 5873, 5887, 5908, 5909, 5910, 5951, 5952, 5953, 5954, 5955, 5956, 5957, 5958, 6040, 6041, 6156, 6183, 6184, 6185, 6186, 6187, 6233, 6234, 6235, 6272, 6417, 6519, 6539, 6540, 6552, 6555, 6743, 6814, 6849, 6850, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6954, 6955, 6957, 6962, 6963, 6973, 6975, 6976, 6977, 6989)) ORDER BY FIELD(`e`.`entity_id`, 6989, 6977, 6976, 6975, 6973, 6963, 6962, 6957, 6955, 6954, 6941, 6940, 6939, 6938, 6937, 6936, 6935, 6934, 6850, 6849, 6814, 6743, 6555, 6552, 6540, 6539, 6519, 6235, 6234, 6233, 6156, 6041, 5873, 5830, 5815, 5814, 5813, 5811, 5810, 5742, 5724, 5723, 5722, 5721, 5698, 5697, 5687, 5596, 5266, 5232, 5048, 5034, 5033, 5029, 5028, 5027, 5026, 5025, 5022, 5003, 4952, 4950, 4948, 4947, 4786, 4645, 4644, 4641, 4639, 4638, 4555, 4553, 4545, 4411, 4260, 4257, 4256, 4093, 4052, 3917, 3915, 3908, 2915, 2914, 2913, 1989, 1988, 1471, 1436, 1158, 6417, 6272, 6187, 6186, 6185, 6184, 6183, 6040, 5958, 5957, 5956, 5955, 5954, 5953, 5952, 5951, 5910, 5909, 5908, 5887, 5812, 5799, 5523, 5311, 5296, 5153, 5023, 4954, 4953, 4951, 4949, 4944, 4943, 4942, 4939, 4898, 4833, 4832, 4831, 4772, 4771, 4770, 4686, 4646, 4616, 4591, 4589, 4554, 4551, 4537, 4410, 4409, 4369, 4364, 4258, 4254, 4253, 4201, 4125, 4124, 4123, 4122, 4121, 4120, 4119, 4118, 4117, 4116, 4115, 4026, 3948, 3942, 3937, 3921, 3920, 3918, 3902, 3893, 3581, 3574, 3280, 3279, 3277, 2872, 2871, 2870, 2676, 2675, 2674, 1990, 1736, 1652) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5698
-
Giá thường:
1.550.000 ₫
Special Price
1.390.000 ₫
5697
-
Giá thường:
290.000 ₫
Special Price
250.000 ₫
5687
-
-
-
Giá thường:
450.000 ₫
Special Price
224.000 ₫
5048
-
Giá thường:
280.000 ₫
Special Price
190.000 ₫
5034
-
Giá thường:
290.000 ₫
Special Price
260.000 ₫
5033
-
Giá thường:
290.000 ₫
Special Price
100.000 ₫
5027
-
-
Giá thường:
140.000 ₫
Special Price
98.000 ₫
5025
-
Giá thường:
250.000 ₫
Special Price
195.000 ₫
5022
-
Giá thường:
220.000 ₫
Special Price
126.000 ₫
5003