select pc."VpNr" as "PartnerVPNR", pc."PartnerName" as "PartnerPartnerName", pcqse."VpNr" as "QsVPNR", pcqse."VsNr" as "QSVSNR", pcqse."FileUploadId" as "QsUploadId", 

       fu."FileName" as "Dateiname", 

       urec."VPNR" as "UploadVPNR", urec."VP Name" as "UploadPartnerName"

  from "Partner" pc 

   left outer join "QsEintrag" pcqse on pcqse."VpNr"=pc."VpNr"

     left outer join "{{otable}}" urec on urec."UPLOADID"=pcqse."FileUploadId" and urec."VPNR"=pcqse."VpNr"

     left outer join "FileUpload" fu on fu."Id"=pcqse."FileUploadId"

 where pc."PartnerName" like concat('%',chr(65533),'%') and pcqse."FileUploadId" is not null