SELECT w.id AS id, w.NUMBER AS waybill_number, ss.DATE AS send_date, r1.name AS sender_region, client1.name AS sender_name, client1.company_name AS sender_company_name, r2.name AS receiver_region, client2.name AS receiver_name, client2.company_name AS receiver_company_name FROM waybill w
LEFT JOIN sender_signature AS ss ON ss.id = w.sender_signature_id
LEFT JOIN (SELECT c1.id AS id, CASE WHEN c1.dimex_code IS NULL THEN c1.name ELSE c1.dimex_code END AS name FROM city c1) AS r1 ON r1.id = w.sender_region_id
LEFT JOIN (SELECT cl1.id AS id, cl1.name AS name, com1.name AS company_name FROM client cl1 LEFT JOIN company AS com1 ON cl1.company_id = com1.id) AS client1 ON client1.id = w.sender_id
LEFT JOIN (SELECT c2.id AS id, CASE WHEN c2.dimex_code IS NULL THEN c2.name ELSE c2.dimex_code END AS name FROM city c2) AS r2 ON r2.id = w.receiver_region_id
LEFT JOIN (SELECT cl2.id AS id, cl2.name AS name, com2.name AS company_name FROM client cl2 LEFT JOIN company AS com2 ON cl2.company_id = com2.id) AS client2 ON client2.id = w.receiver_id