20250715 072727 : requested url:/gameverse/idtl/callback_itg.php
20250715 072727 : json:{"adnetid":"96014","clickid":"","dr_status":"1","encrypted_msisdn":"5i1gRZ2wSb1BO4Y9A_IcHYni-oTCtkbtMCkTpzPXbHge43nIarkWrkU=","keyword":"UNREG FUNZONE1","req_type":"unsubs","trx_id":""}
20250715 072727 : mobile encrypted_msisdn:5i1gRZ2wSb1BO4Y9A_IcHYni-oTCtkbtMCkTpzPXbHge43nIarkWrkU=
20250715 072727 : mobile keyword:UNREG FUNZONE1
20250715 072727 : mobile dr_status:1
20250715 072727 output={"msisdn":"6281213085680"}

20250715 072727 msisdn=6281213085680
20250715 072727 outsideloop msisdn=6281213085680
20250715 072727 : Querypubrenew:select  * from tbl_subscription_Telkomsel_id where msisdn='6281213085680' order by  id desc limit 1
Querydel:20250715 072727: insert into pending_delete_no_Telkomsel_id(regdate,entrydate,msisdn,OfferCode) values (now(),now(),'6281213085680','UNREG FUNZONE1')
Queryt:20250715 072727: delete from tbl_subscription_Telkomsel_id where msisdn='6281213085680'