DbExchange - Original Query

SELECT
    count(*)
FROM public.reservation AS r
         JOIN public.companyclient AS c
              ON r.companyclientid = c.companyclientid
         JOIN (SELECT r0.reservationitemid,
                      r0.adultcount,
                      r0.agreementname,
                      r0.cancellationdate,
                      r0.cancellationdescription,
                      r0.checkindate,
                      r0.checkinhour,
                      r0.checkoutdate,
                      r0.checkouthour,
                      r0.childcount,
                      r0.creationtime,
                      r0.creatoruserid,
                      r0.currencyid,
                      r0.deleteruserid,
                      r0.deletiontime,
                      r0.estimatedarrivaldate,
                      r0.estimateddeparturedate,
                      r0.externalcomments,
                      r0.externalreservationnumber,
                      r0.extrabedcount,
                      r0.extracribcount,
                      r0.gratuityreasonid,
                      r0.gratuitytypeid,
                      r0.gratuitytypename,
                      r0.integrationid,
                      r0.internalcomments,
                      r0.ischangeguest,
                      r0.isdeleted,
                      r0.ismigrated,
                      r0.isnopost,
                      r0.languagetocontact,
                      r0.lastmodificationtime,
                      r0.lastmodifieruserid,
                      r0.mealplantypeid,
                      r0.partnerreservationnumber,
                      r0.rateplanid,
                      r0.reasonid,
                      r0.receivedroomtypeid,
                      r0.receivedroomtypename,
                      r0.requestedroomtypeid,
                      r0.requestedroomtypename,
                      r0.reservationid,
                      r0.reservationidorigin,
                      r0.reservationitemcode,
                      r0.reservationitemidold,
                      r0.reservationitemstatusid,
                      r0.reservationitemuid,
                      r0.roomid,
                      r0.roomlayoutid,
                      r0.roomnumber,
                      r0.tenantid,
                      r0.uhgrouperid,
                      r0.walkin
               FROM public.reservationitem AS r0
               WHERE ((r0.tenantid = '025aa64f-67fb-4c23-b975-2b0fc3f5d65a') AND NOT (r0.isdeleted))
                 AND r0.reservationitemstatusid NOT IN (6, 3, 7, 8)) AS t ON r.reservationid = t.reservationid
         LEFT JOIN (SELECT b.billingaccountid,
                      b.billingaccountname,
                      b.billingaccounttypeid,
                      b.blocked,
                      b.businesssourceid,
                      b.companyclientid,
                      b.creationtime,
                      b.creatoruserid,
                      b.deleteruserid,
                      b.deletiontime,
                      b.enddate,
                      b.groupkey,
                      b.guestreservationitemid,
                      b.internalcomments,
                      b.invoicecomments,
                      b.isdeleted,
                      b.ismainaccount,
                      b.lastmodificationtime,
                      b.lastmodifieruserid,
                      b.marketsegmentid,
                      b.personheaderid,
                      b.propertyid,
                      b.rateplanid,
                      b.reopeningdate,
                      b.reopeningreasonid,
                      b.reservationid,
                      b.reservationitemid,
                      b.startdate,
                      b.statusid,
                      b.tenantid
               FROM public.billingaccount AS b
               WHERE ((b.propertyid = '84') AND NOT (b.isdeleted))
                 AND ((((((b.billingaccountid = b.groupkey) AND (b.companyclientid IS NOT NULL)) AND
                         (b.billingaccounttypeid = '3')) AND (b.companyclientid IS NOT NULL)) AND
                       (b.reservationid IS NOT NULL)) AND (b.statusid = '1'))) AS t0
              ON (c.companyclientid = t0.companyclientid) AND (r.reservationid = t0.reservationid)
WHERE ((r.propertyid = '84') AND NOT (r.isdeleted))
  AND (r.companyclientid IS NOT NULL);