SELECT Nights, Nights + 1 AS days, DATE_FORMAT(SailingDate, '%d/%m/%Y') AS data_partenza, DATE_FORMAT( DATE_ADD(SailingDate, INTERVAL Nights DAY), '%d/%m/%Y') AS data_arrivo, SailingPort, TerminationPort, ItinCode, ItinDesc, ShipName, ShipCode, CruiseId FROM msc_crociere AS c WHERE CruiseId='PR20241103HAMHAM' LIMIT 1