INSERT INTO `products` (..........)
SELECT
book.ISBN,
........
collana.codiceCollana,
........
FROM
book
INNER JOIN collana ON (book.CollanaID = collana_ID)
INSERT INTO `products` (..........)
SELECT
book.ISBN,
........
collana.codiceCollana,
........
FROM
book
INNER JOIN collana ON (book.CollanaID = collana_ID)
...altri 5 anni di purga...