18/05/2025 12:01:51.8081 1820 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 18/05/2025 16:20:47.0175 539 ms. EXEC: insert into payReceipt (recTraUID,recPayUID,recYear,recDateTime,recText,recInvalid) VALUES (5714295277529930,4631172010782490,2025,'2025-05-18 16:20:46',' Data: 5/18/2025 4:18:15 PM Codice: 457934561200327005012999 Ingresso: 5/18/2025 12:40:12 PM Targa: Categoria: Cars Area: The Mall Varco: Entry 2 ______________________________ Da Pagare: 200.00 KES ______________________________ Pagato: 200.00 KES __________ Resto: 0.00 KES Tipo: Contanti Pagato su: Manual Cashier 2 # 2500603246 ',0) 18/05/2025 20:53:53.1103 618 ms. EXEC: update tabArea set areFreePark = areFreePark - 1 where areId = 1