SELECT *, ............,
...........................
FROM ....
INNER JOIN ....
INNER JOIN ....
INNER JOIN cargo_card cc ON cc.id = .....
....
....
INNER JOIN transshipment t ON t.from_card_id = cc.id

UNION

SELECT *, ............,
...........................
FROM ....
INNER JOIN ....
INNER JOIN ....
INNER JOIN cargo_card cc ON cc.id = .....
....
....
INNER JOIN transshipment t ON t.to_card_id = cc.id

...
INNER JOIN transshipment t ON cc.id in (t.to_card_id,t.from_card_id)

...
INNER JOIN (select *, to_card_id as card_id from transshipment union all select *, from_card_id as card_id from transshipment) t ON cc.id =t.card_id