14/03/2023 08:15:35.2546 1297 ms. OPEN: select 1 as Tot,payUID,payPayed,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 = 6 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)) order by traUIDGroup,payAmount, traType, traDiscountValue, traDiscountType 14/03/2023 10:49:55.9501 513 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/03/2023 12:48:54.3856 555 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-03-14 12:48:53','V',5109192856590690,2023,'2023-03-14 12:48:53','449974305900327005012999',2,2,2,'O','',0,'2023-03-14 12:48:53',1,'','',0) 14/03/2023 13:04:31.0563 532 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-03-14 13:04:30','V',4682389285902770,2023,'2023-03-14 13:04:30','449970000900327003229999',22,22,3,'I','',1,0,1,'','',2) 14/03/2023 13:11:01.9284 509 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1 14/03/2023 14:24:11.1790 508 ms. EXEC: update payReceipt set recCreation = '2023-03-14 14:24:10',recModify = '2023-03-14 14:24:10',recUseId=0,recStatus='V' where recId = 85753 14/03/2023 15:06:51.1352 583 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traTarId) VALUES (0,'2023-03-14 15:06:50','V',4614790817591880,2023,'2023-03-14 15:06:50','449975061500327005012999',2,2,2,'O','',0,'2023-03-14 15:06:50',1,'','',0) 14/03/2023 18:49:33.2358 934 ms. EXEC: UPDATE payCash SET casType='C' WHERE casType<>'C' AND ABS(casSingleAmount) IN (5,10,20,40); 14/03/2023 22:27:43.5480 516 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4798208241095850,4661851327925950,2023,'2023-03-14 22:27:43',' Date: 3/14/2023 10:27:42 PM Code: 449978042300327005012999 Entry Date: 3/14/2023 10:20:23 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 # 2300712528 ',0)