EW 520 then LA 5786 at Barcelona
Cologne → Barcelona → Palma de Mallorca
Timetable, Barcelona time
16:50EW 520 from Cologne at the gate
11:20LA 5786 to Palma de Mallorca leaves the gate
18 h 30 apart on the timetable, overnight
LA 5786 leaves 18 h 30 after EW 520 arrives on the timetable: more than half a day, so not a connection we count.