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 dimex_city_names AS r1 ON r1.id = w.sender_region_id
LEFT JOIN dimex_client_and_company_names AS client1 ON client1.id = w.sender_id
LEFT JOIN dimex_city_names AS r2 ON r2.id = w.receiver_region_id
LEFT JOIN dimex_client_and_company_names AS client2 ON client2.id = w.receiver_id