SELECT
    ss.id as shippingId,
    i.id as invoiceId,
    i.invoiceStatusId as statusId,
    s.name as statusName
FROM SupplierShipping ss
    JOIN InvoiceGroup ig ON ss.invoiceGroupId = ig.id
    JOIN InvoiceGroupInvoice igi ON ig.id = igi.invoiceGroupId
    JOIN Invoice i ON igi.invoiceId = i.id
    JOIN InvoiceStatus s ON i.invoiceStatusId = s.id
WHERE s.id = 2;