28/07/2025 12:29:55.5421 562 ms. EXEC: update abbCards set carLastDate = '2025-07-28 12:29:54',carLastDirection='O' where carStatus='V' and carId = 13 28/07/2025 17:26:42.8720 546 ms. EXEC: update abbCards set carLastDate = '2025-07-28 17:26:42',carLastDirection='O' where carStatus='V' and carId = 82 28/07/2025 19:08:53.8213 1515 ms. OPEN: select count(payId) as Tot,0 as payUID,sum(payPayed) as payPayed,sum(payChange) as payChange,payAmount,traUIDGroup,traType,traClass,traIdTerminal,traDiscountValue,traDiscountType,traCarId,payIdEvent,payType,payCardType from payPayment LEFT join movtransit on trauid = payTraUID LEFT JOIN payReport ON repPayUID = payUID AND repStatus='V' where payStatus = 'V' and (payType='C' or payType='P') and payUseId = 9 and payIdEvent<90 and repPayUID IS NULL and (traCarId is null or traCarId=0 or traCarId in (select carId from abbCards inner join abbsubscriptions on subId= carSubId where carStatus='V' and subStatus='V' and subAbbType<>5)) group by traUIDGroup,payAmount,payIdEvent,payType,payCardType,traType,traIdTerminal,traDiscountValue,traDiscountType,traCarId order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 28/07/2025 19:10:38.2650 531 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5304616380953700,5308447878339980,2025,'2025-07-28 19:10:37',' Date: 7/28/2025 7:10:37 PM Code: 458646390900327005012999 Entry Date: 7/28/2025 5:45:09 PM Plate: Class: Cars Park: The Mall Gate: Entry 2 ______________________________ Total: 100.00 KES ______________________________ Paid: 100.00 KES __________ Change: 0.00 KES Type: Cash Dispozitiv: MPESA # 2500728035 ',0)