SELECT *
FROM (
    SELECT DISTINCT mno."ManufacturingOrderID", mno."OrderID", mno."CreationDate", mno."Comments", cli."ClientID", cli."LongName", ord."QuoteValue", ord."DeliveryDate", mno."ManufacturingOrderStateID",
    mnopd."StartDate" AS "PlannedStartDate", mnopd."EndDate" AS "PlannedSEndDate", mnopd."DeliveryDate" AS "PlannedDeliveryDate"
    FROM manufacturing."ManufacturingOrders" mno, public."Clients" cli, orders."Orders" ord, public."Clients_Orders" cli_ord, orders."OrderStates" ordst, manufacturing."ManufacturingOrdersPlannedDates" mnopd,
    manufacturing."ManufacturingItems" mni, manufacturing."ManufacturingOrders_ManufacturingItem" mno_mni
    WHERE   (mno."OrderID" = ord."OrderID") AND
            (ord."OrderID" = cli_ord."OrderID") AND
            (cli."ClientID" = cli_ord."ClientID") AND
            (mno."ManufacturingOrderID" = mnopd."ManufacturingOrderID")
) AS manorder
    CROSS JOIN LATERAL (
        SELECT COUNT(DISTINCT mni."ManufacturingItemID") AS "TotalItems", (SUM(mni."AmountProgress")/COUNT(mni."ManufacturingItemID")) AS "Progress"
        FROM manufacturing."ManufacturingOrders" mno, manufacturing."ManufacturingItems" mni, manufacturing."ManufacturingOrders_ManufacturingItem" mno_mni
        WHERE mno."ManufacturingOrderID" = manorder."ManufacturingOrderID"  AND
              mno."ManufacturingOrderID" = mno_mni."ManufacturingOrderID"   AND
              mni."ManufacturingItemID"  = mno_mni."ManufacturingItemID"    AND
              mno."ManufacturingOrderID" = manorder."ManufacturingOrderID"
        GROUP BY mno."ManufacturingOrderID"
    )  AS sumitens
;