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='SC20241102MIAMI1' LIMIT 1