UPDATE `products` P1 INNER JOIN `products` P2 ON P1.Image = P2.Image AND P1.Language = 'en' AND P2.Language = 'bg' SET P1.ID = P2.ID, P1.UploadID = P2.UploadID