SELECT pinstruction.pinstruction_id, pinstruction.referenceno, pinstruction.receiptno, pinstruction.prdcovstart, pinstruction.prdcovend,
pinstruction.profileid, pinstruction.pserviceid, pinstruction.noofauth, pinstruction.checkers, pinstruction.amount, pstat.item paymentstatus,
 pinstruction.records, pinstruction.createdate, createdby.username createdby, pinstruction.updatedate, updatedby.username updatedby,
pinstruction.remarks, pdocument.piid doc_id, pdocument.ofilename, pdocument.sfilename, pdocument.remarks pdremarks, dstat.item documentstatus,
 fileformats.fformat format, institution.instname corpname, atmcard.bankid, atmcard.cardno FROM pinstruction INNER JOIN egovlookup pstat
ON pstat.lookup_id = pinstruction.status LEFT JOIN pdocument ON pdocument.piid = pinstruction.pinstruction_id LEFT JOIN egovlookup dstat
ON dstat.lookup_id = pdocument.status LEFT JOIN fileformats ON fileformats.ff_id = pdocument.format INNER JOIN users createdby
ON createdby.user_id = pinstruction.createdby INNER JOIN users updatedby ON updatedby.user_id = pinstruction.updatedby
LEFT JOIN profile ON profile.profile_id = pinstruction.profileid LEFT JOIN corporate ON corporate.corp_id = profile.corpid
LEFT JOIN institution ON institution.institution_id = corporate.corp_id LEFT JOIN agencymembership ON agencymembership.agencymem_id = profile.agencymemid
LEFT JOIN atmcard ON atmcard.atmcard_id = pinstruction.atmcardid LEFT JOIN settlement ON pinstruction.referenceno = settlement.pirefno
WHERE pinstruction.active = 'Y' AND pinstruction.pserviceid = 43