The new vs the old product needs to be chosen based on the "flag" .

If the product_ID or the product_ID_Group appears twice or 2 rows with 2 different flags - 0 and 1, then that is the Old product.

If the product_ID or the product_ID_Group appears only once with a flag of 0 then it is the new product.