08/06/2025 10:36:55.0324 1575 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 = 12 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 08/06/2025 10:50:14.2563 550 ms. EXEC: insert into movtransit (traUseId,traCreation,traStatus,traUID,traYear,traDateTime,traCode,traType,traClass,traIdTerminal,traDirection,traPlate,traEnabled,traDisableTime,traAreId,traNotes,traBadge,traCarId,traTarId) VALUES (0,'2025-06-08 10:50:13','V',5592310650638150,2025,'2025-06-08 10:50:13','458143901300327005012999',1,2,16,'I','',1,0,1,'','0230003957463',25,0) 08/06/2025 15:57:56.8871 515 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (4915728118050410,5072332980524820,2025,'2025-06-08 15:57:56',' Data: 6/8/2025 3:57:46 PM Codice: 458145072300327005012999 Ingresso: 6/8/2025 2:05:23 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 100.00 KES ______________________________ Pagato: 100.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500603851 ',0) 08/06/2025 18:12:02.5662 691 ms. EXEC: update abbCards set carLastDate = '2025-06-08 18:12:01',carLastDirection='O' where carStatus='V' and carId = 14 08/06/2025 18:22:22.6111 541 ms. EXEC: update payReceipt set recCreation = '2025-06-08 18:22:22',recModify = '2025-06-08 18:22:22',recUseId=0,recStatus='V' where recId = 386583