SELECT * FROM
(
SELECT product_id, product_name,product_code,product_price,product_version
FROM product_2
ORDER BY product_version DESC LIMIT 1000000
) p
GROUP BY product_id
LIMIT 5,8
;
SELECT * FROM product_2 WHERE (product_id,product_version) IN ( SELECT product_id, MAX(product_version) FROM product_2 GROUP BY product_id );