SELECT lt.LedgerTransactionNo Labno,plo.Barcodeno, DATE_FORMAT(lt.DATE,'%d-%b-%Y')DATE,GrossAmount,NetAmount,DiscountOnTotal,lt.LedgerTransactionID,pm.PName,pm.Gender,pm.Age, (select DiscountReason from f_ledgertransaction_DiscountReason t where t.ledgertransactionID=lt.ledgertransactionID Order By t.ID+1 DESC LIMIT 1)DisReason,lt.CreatedBy, (select Group_Concat(Distinct Remarks) from patient_labinvestigation_opd_remarks where  LedgerTransactionID=lt.LEdgertransactionID) Remarks, cm.Centre BookingCentre FROM f_ledgertransaction lt  INNER JOIN patient_master pm ON lt.Patient_ID=pm.Patient_ID   INNER JOIN patient_labinvestigation_OPD plo ON plo.ledgertransactionID=lt.ledgertransactionID   INNER JOIN centre_master cm ON cm.CentreID=lt.CentreID WHERE   lt.IsDiscountApproved=0 AND lt.DiscountOnTotal>0  AND lt.date>='2025-02-25 00:00:00'  AND lt.date<='2025-02-25 23:59:59' AND DiscountApprovedByID in(140)  group by lt.ledgertransactionID