✅ DB connected!!<br>🗑️ Older than 7 days records deleted successfully!<br>✅ Data inserted successfully! Rows inserted: 0<br><br>
SELECT TP.recuring_inappplan_id, TCS.*, tmp.record_id
FROM tbl_customer_subscriptions AS TCS
JOIN tbl_packages AS TP ON TCS.package_id = TP.id
JOIN (
    SELECT record_id
    FROM temp_lac
    WHERE processed_at IS NULL OR processed_at <= NOW() - INTERVAL 4 HOUR
    ORDER BY record_id ASC
    LIMIT 20
) AS tmp ON TCS.id = tmp.record_id
GROUP BY TCS.gateway_subscription_id
ORDER BY TCS.id DESC
<pre>Array
(
    [recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
    [id] => 33775
    [app_id] => 5013
    [order_id] => 14606
    [mandate_id] => 
    [merchant_id] => 
    [mandate_token] => 
    [payment_method_type] => 
    [payer_vpa] => 
    [txn_type] => 
    [trans_id] => GPA.3354-5934-7732-61007
    [pg_ref_id] => GPA.3354-5934-7732-61007
    [device_id] => 0
    [gateway_subscription_id] => GPA.3354-5934-7732-61007
    [pg_payment_data] => {"acknowledgementState":1,"autoRenewing":true,"autoResumeTimeMillis":null,"cancelReason":null,"countryCode":"US","developerPayload":"ack-by-backend","emailAddress":null,"expiryTimeMillis":"1785199460544","externalAccountId":null,"familyName":null,"givenName":null,"kind":"androidpublisher#subscriptionPurchase","linkedPurchaseToken":null,"obfuscatedExternalAccountId":"14606","obfuscatedExternalProfileId":"44695","orderId":"GPA.3354-5934-7732-61007..1","paymentState":1,"priceAmountMicros":"3990000","priceCurrencyCode":"USD","profileId":null,"profileName":null,"promotionCode":null,"promotionType":null,"purchaseType":null,"startTimeMillis":"1779324260544","userCancellationTimeMillis":null}
    [channel] => 
    [package_id] => 228
    [package_title] => Monthly
    [package_code] => 
    [package_type] => 0
    [package_mode] => OTT
    [price] => 3.99
    [u_price] => 0.00
    [basic_amount] => 0.00
    [tax_amt] => 0
    [subscriber_id] => 44695
    [msisdn] => 
    [role_type] => 0
    [gateway_type] => 3
    [pg_name] => google_inapp_purchase
    [pg_mode] => 
    [region_type] => 0
    [local_user] => 0
    [state_code] => 0
    [period] => Month
    [period_interval] => 1
    [trial_period] => 
    [trial_length] => 0
    [subscription_type] => 0
    [output_video_limit] => 0
    [additional_cost_per_unit] => 0
    [no_videos] => 0
    [no_plays] => 0
    [status] => 2
    [ack_status] => 0
    [platform] => cron
    [purchase_type] => RENEWED
    [extended_status] => 0
    [start_date] => 2026-05-21 00:44:20
    [end_date] => 2026-07-28 00:44:20
    [autorenew] => 1
    [currency_id] => 4
    [currency] => USD
    [u_currency] => 
    [created] => 2026-06-28 00:50:02
    [updated_at] => 2026-06-28 00:50:05
    [is_cancelled] => 0
    [cancelled_at] => 
    [deactivation_type] => 
    [deactivation_date] => 
    [renewal_date] => 
    [renewal_count] => 0
    [mandate_revoke] => 0
    [recurring] => 0
    [purchase_token] => igghkaldggfmplbpceimjnek.AO-J1Oxb-Zpnl0W7Js7J-TRzs3NelZW54JUPI1zJd0CCmeTqJx0MxAofim-iwN_rh10X5F2Da04A-WrLFWeK1vongjWTAMxXTg
    [package_name] => 
    [email_sent] => 0
    [back_dated] => 0
    [record_id] => 33775
)
</pre><h3>Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: igghkaldggfmplbpceimjnek.AO-J1Oxb-Zpnl0W7Js7J-TRzs3NelZW54JUPI1zJd0CCmeTqJx0MxAofim-iwN_rh10X5F2Da04A-WrLFWeK1vongjWTAMxXTg</h3>Price : 3.99 <br>priceCurrency : USD <br>Start Date: 2026-05-21 00:44:20<br>End Date: 2026-07-28 00:44:20<br>Original Order ID: GPA.3354-5934-7732-61007..1<br>Trimmed Order ID: GPA.3354-5934-7732-61007<br><br>================ Subscription Update or Skip ================ <br>
                    SELECT *
                    FROM tbl_customer_subscriptions 
                    WHERE subscriber_id = '44695' 
                      AND `status` IN ('2','3') 
                      AND pg_name = 'google_inapp_purchase'  
                    ORDER BY id DESC
                    LIMIT 1
                <br><br>✅ No update needed, just mark processed_at in temp_lac.<br><br>
                            UPDATE temp_lac 
                            SET processed_at = NOW()
                            WHERE record_id = '33775'
                        <pre>Array
(
    [recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
    [id] => 32302
    [app_id] => 5013
    [order_id] => 13334
    [mandate_id] => 
    [merchant_id] => 
    [mandate_token] => 
    [payment_method_type] => 
    [payer_vpa] => 
    [txn_type] => 
    [trans_id] => GPA.3377-6907-4662-64762
    [pg_ref_id] => GPA.3377-6907-4662-64762
    [device_id] => 0
    [gateway_subscription_id] => GPA.3377-6907-4662-64762
    [pg_payment_data] => {"acknowledgementState":1,"autoRenewing":true,"autoResumeTimeMillis":null,"cancelReason":null,"countryCode":"US","developerPayload":"ack-by-backend","emailAddress":null,"expiryTimeMillis":"1784723789969","externalAccountId":null,"familyName":null,"givenName":null,"kind":"androidpublisher#subscriptionPurchase","linkedPurchaseToken":null,"obfuscatedExternalAccountId":"13335","obfuscatedExternalProfileId":"42824","orderId":"GPA.3377-6907-4662-64762..2","paymentState":1,"priceAmountMicros":"3990000","priceCurrencyCode":"USD","profileId":null,"profileName":null,"promotionCode":null,"promotionType":null,"purchaseType":null,"startTimeMillis":"1776083448435","userCancellationTimeMillis":null}
    [channel] => 
    [package_id] => 228
    [package_title] => Monthly
    [package_code] => 
    [package_type] => 0
    [package_mode] => OTT
    [price] => 3.99
    [u_price] => 0.00
    [basic_amount] => 0.00
    [tax_amt] => 0
    [subscriber_id] => 42824
    [msisdn] => 
    [role_type] => 0
    [gateway_type] => 3
    [pg_name] => google_inapp_purchase
    [pg_mode] => 
    [region_type] => 0
    [local_user] => 0
    [state_code] => 0
    [period] => Month
    [period_interval] => 1
    [trial_period] => 
    [trial_length] => 0
    [subscription_type] => 0
    [output_video_limit] => 0
    [additional_cost_per_unit] => 0
    [no_videos] => 0
    [no_plays] => 0
    [status] => 2
    [ack_status] => 0
    [platform] => cron
    [purchase_type] => RENEWED
    [extended_status] => 0
    [start_date] => 2026-04-13 12:30:48
    [end_date] => 2026-07-22 12:36:29
    [autorenew] => 1
    [currency_id] => 4
    [currency] => USD
    [u_currency] => 
    [created] => 2026-06-22 12:50:02
    [updated_at] => 2026-06-22 12:50:04
    [is_cancelled] => 0
    [cancelled_at] => 
    [deactivation_type] => 
    [deactivation_date] => 
    [renewal_date] => 
    [renewal_count] => 0
    [mandate_revoke] => 0
    [recurring] => 0
    [purchase_token] => llihledckccgclgdhhgcanlg.AO-J1OyEms8gxv5BrouOH3jWKsjfm5D8xcz2_hWDyqWF5tzBpJ0BTeHCos5YpVYtrrTdFvWK33XNSKk4-n-eLSYOV2a8Ny1lgA
    [package_name] => 
    [email_sent] => 0
    [back_dated] => 0
    [record_id] => 32302
)
</pre><h3>Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: llihledckccgclgdhhgcanlg.AO-J1OyEms8gxv5BrouOH3jWKsjfm5D8xcz2_hWDyqWF5tzBpJ0BTeHCos5YpVYtrrTdFvWK33XNSKk4-n-eLSYOV2a8Ny1lgA</h3>Price : 3.99 <br>priceCurrency : USD <br>Start Date: 2026-04-13 12:30:48<br>End Date: 2026-07-22 12:36:29<br>Original Order ID: GPA.3377-6907-4662-64762..2<br>Trimmed Order ID: GPA.3377-6907-4662-64762<br><br>================ Subscription Update or Skip ================ <br>
                    SELECT *
                    FROM tbl_customer_subscriptions 
                    WHERE subscriber_id = '42824' 
                      AND `status` IN ('2','3') 
                      AND pg_name = 'google_inapp_purchase'  
                    ORDER BY id DESC
                    LIMIT 1
                <br><br>✅ No update needed, just mark processed_at in temp_lac.<br><br>
                            UPDATE temp_lac 
                            SET processed_at = NOW()
                            WHERE record_id = '32302'
                        <pre>Array
(
    [recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
    [id] => 32294
    [app_id] => 5013
    [order_id] => 17798
    [mandate_id] => 
    [merchant_id] => 
    [mandate_token] => 
    [payment_method_type] => 
    [payer_vpa] => 
    [txn_type] => 
    [trans_id] => GPA.3380-6698-6491-68419
    [pg_ref_id] => GPA.3380-6698-6491-68419
    [device_id] => 1
    [gateway_subscription_id] => GPA.3380-6698-6491-68419
    [pg_payment_data] => 
    [channel] => 
    [package_id] => 228
    [package_title] => Monthly
    [package_code] => 
    [package_type] => 0
    [package_mode] => OTT
    [price] => 3.99
    [u_price] => 0.00
    [basic_amount] => 0.00
    [tax_amt] => 0
    [subscriber_id] => 47595
    [msisdn] => 
    [role_type] => 0
    [gateway_type] => 3
    [pg_name] => google_inapp_purchase
    [pg_mode] => 
    [region_type] => 0
    [local_user] => 0
    [state_code] => 0
    [period] => Month
    [period_interval] => 1
    [trial_period] => 
    [trial_length] => 
    [subscription_type] => 0
    [output_video_limit] => 0
    [additional_cost_per_unit] => 0
    [no_videos] => 
    [no_plays] => 
    [status] => 7
    [ack_status] => 0
    [platform] => platform
    [purchase_type] => PURCHASED
    [extended_status] => 0
    [start_date] => 2026-06-22 11:27:22
    [end_date] => 2026-06-29 11:27:22
    [autorenew] => 1
    [currency_id] => 4
    [currency] => USD
    [u_currency] => 
    [created] => 2026-06-22 11:27:01
    [updated_at] => 2026-06-29 11:30:56
    [is_cancelled] => 0
    [cancelled_at] => 
    [deactivation_type] => 
    [deactivation_date] => 
    [renewal_date] => 
    [renewal_count] => 0
    [mandate_revoke] => 0
    [recurring] => 0
    [purchase_token] => mflpkgeaocgbacigjmpcbdbb.AO-J1OwoQa5WckQKHG6KlJAezJsehR33X2qKgG9EE4T0rj7g91uWo4-m0TrqrMOi1gSJxqNPOBdwQtSo1NyP20pynM1ADP3FbA
    [package_name] => 
    [email_sent] => 0
    [back_dated] => 0
    [record_id] => 32294
)
</pre><h3>Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: mflpkgeaocgbacigjmpcbdbb.AO-J1OwoQa5WckQKHG6KlJAezJsehR33X2qKgG9EE4T0rj7g91uWo4-m0TrqrMOi1gSJxqNPOBdwQtSo1NyP20pynM1ADP3FbA</h3>Price : 3.99 <br>priceCurrency : USD <br>Start Date: 2026-06-22 11:27:22<br>End Date: 2026-06-29 11:27:22<br>Original Order ID: GPA.3380-6698-6491-68419<br>Trimmed Order ID: GPA.3380-6698-6491-68419<br><br>================ Subscription Update or Skip ================ <br>
                    SELECT *
                    FROM tbl_customer_subscriptions 
                    WHERE subscriber_id = '47595' 
                      AND `status` IN ('2','3') 
                      AND pg_name = 'google_inapp_purchase'  
                    ORDER BY id DESC
                    LIMIT 1
                <pre>Array
(
    [recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
    [id] => 32213
    [app_id] => 5013
    [order_id] => 17784
    [mandate_id] => 
    [merchant_id] => 
    [mandate_token] => 
    [payment_method_type] => 
    [payer_vpa] => 
    [txn_type] => 
    [trans_id] => GPA.3345-2771-8906-21151
    [pg_ref_id] => GPA.3345-2771-8906-21151
    [device_id] => 1
    [gateway_subscription_id] => GPA.3345-2771-8906-21151
    [pg_payment_data] => 
    [channel] => 
    [package_id] => 228
    [package_title] => Monthly
    [package_code] => 
    [package_type] => 0
    [package_mode] => OTT
    [price] => 3.99
    [u_price] => 0.00
    [basic_amount] => 0.00
    [tax_amt] => 0
    [subscriber_id] => 47973
    [msisdn] => 
    [role_type] => 0
    [gateway_type] => 3
    [pg_name] => google_inapp_purchase
    [pg_mode] => 
    [region_type] => 0
    [local_user] => 0
    [state_code] => 0
    [period] => Month
    [period_interval] => 1
    [trial_period] => 
    [trial_length] => 
    [subscription_type] => 0
    [output_video_limit] => 0
    [additional_cost_per_unit] => 0
    [no_videos] => 
    [no_plays] => 
    [status] => 7
    [ack_status] => 0
    [platform] => platform
    [purchase_type] => PURCHASED
    [extended_status] => 0
    [start_date] => 2026-06-22 03:26:30
    [end_date] => 2026-06-29 03:26:30
    [autorenew] => 1
    [currency_id] => 4
    [currency] => USD
    [u_currency] => 
    [created] => 2026-06-22 03:25:49
    [updated_at] => 2026-06-29 03:30:02
    [is_cancelled] => 0
    [cancelled_at] => 
    [deactivation_type] => 
    [deactivation_date] => 
    [renewal_date] => 
    [renewal_count] => 0
    [mandate_revoke] => 0
    [recurring] => 0
    [purchase_token] => pglpadbflembaggbpjmmlggk.AO-J1OxjxiKSL_vVzhzm1T-ZSRyqHhQJQXZ4lBuETTrJqQ89C0hZ1W0CXTZZedj0ExqEukED9ifA_OTXE_uk53q_oJV9-ri9Bw
    [package_name] => 
    [email_sent] => 0
    [back_dated] => 0
    [record_id] => 32213
)
</pre><h3>Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: pglpadbflembaggbpjmmlggk.AO-J1OxjxiKSL_vVzhzm1T-ZSRyqHhQJQXZ4lBuETTrJqQ89C0hZ1W0CXTZZedj0ExqEukED9ifA_OTXE_uk53q_oJV9-ri9Bw</h3>Price : 3.99 <br>priceCurrency : USD <br>Start Date: 2026-06-22 03:26:30<br>End Date: 2026-07-29 03:26:30<br>Original Order ID: GPA.3345-2771-8906-21151..0<br>Trimmed Order ID: GPA.3345-2771-8906-21151<br><br>================ Subscription Update or Skip ================ <br>
                    SELECT *
                    FROM tbl_customer_subscriptions 
                    WHERE subscriber_id = '47973' 
                      AND `status` IN ('2','3') 
                      AND pg_name = 'google_inapp_purchase'  
                    ORDER BY id DESC
                    LIMIT 1
                <br><br>✅ No update needed, just mark processed_at in temp_lac.<br><br>
                            UPDATE temp_lac 
                            SET processed_at = NOW()
                            WHERE record_id = '32213'
                        <pre>Array
(
    [recuring_inappplan_id] => com.maz.combo587.rec.1month.3.99usd
    [id] => 25362
    [app_id] => 5013
    [order_id] => 14467
    [mandate_id] => 
    [merchant_id] => 
    [mandate_token] => 
    [payment_method_type] => 
    [payer_vpa] => 
    [txn_type] => 
    [trans_id] => GPA.3368-4912-0604-06646
    [pg_ref_id] => GPA.3368-4912-0604-06646
    [device_id] => 0
    [gateway_subscription_id] => GPA.3368-4912-0604-06646
    [pg_payment_data] => {"acknowledgementState":1,"autoRenewing":true,"autoResumeTimeMillis":null,"cancelReason":null,"countryCode":"US","developerPayload":"ack-by-backend","emailAddress":null,"expiryTimeMillis":"1782144501731","externalAccountId":null,"familyName":null,"givenName":null,"kind":"androidpublisher#subscriptionPurchase","linkedPurchaseToken":null,"obfuscatedExternalAccountId":null,"obfuscatedExternalProfileId":null,"orderId":"GPA.3368-4912-0604-06646..0","paymentState":1,"priceAmountMicros":"3990000","priceCurrencyCode":"USD","profileId":null,"profileName":null,"promotionCode":null,"promotionType":null,"purchaseType":null,"startTimeMillis":"1778861301731","userCancellationTimeMillis":null}
    [channel] => 
    [package_id] => 228
    [package_title] => Monthly
    [package_code] => 
    [package_type] => 0
    [package_mode] => OTT
    [price] => 3.99
    [u_price] => 0.00
    [basic_amount] => 0.00
    [tax_amt] => 0
    [subscriber_id] => 44513
    [msisdn] => 
    [role_type] => 0
    [gateway_type] => 3
    [pg_name] => google_inapp_purchase
    [pg_mode] => 
    [region_type] => 0
    [local_user] => 0
    [state_code] => 0
    [period] => Month
    [period_interval] => 1
    [trial_period] => 
    [trial_length] => 0
    [subscription_type] => 0
    [output_video_limit] => 0
    [additional_cost_per_unit] => 0
    [no_videos] => 0
    [no_plays] => 0
    [status] => 7
    [ack_status] => 0
    [platform] => cron
    [purchase_type] => RENEWED
    [extended_status] => 0
    [start_date] => 2026-05-15 16:08:21
    [end_date] => 2026-06-22 16:08:21
    [autorenew] => 1
    [currency_id] => 4
    [currency] => USD
    [u_currency] => 
    [created] => 2026-05-22 19:30:02
    [updated_at] => 2026-06-22 16:10:03
    [is_cancelled] => 0
    [cancelled_at] => 
    [deactivation_type] => 
    [deactivation_date] => 
    [renewal_date] => 
    [renewal_count] => 0
    [mandate_revoke] => 0
    [recurring] => 0
    [purchase_token] => eoaejkfoeopjdfnghmiimajg.AO-J1Ow-xoD2Tlo6ANyqPBaNV417xpYsRr1eFqPCaT2EGe11LrfR1s9k5XEbvHJ7vQcCOVVlo4vTGBMpFK16Yl6uRC_ovJK2ww
    [package_name] => 
    [email_sent] => 0
    [back_dated] => 0
    [record_id] => 25362
)
</pre><h3>Checking: com.maz.combo587 | Product: com.maz.combo587.rec.1month.3.99usd | Token: eoaejkfoeopjdfnghmiimajg.AO-J1Ow-xoD2Tlo6ANyqPBaNV417xpYsRr1eFqPCaT2EGe11LrfR1s9k5XEbvHJ7vQcCOVVlo4vTGBMpFK16Yl6uRC_ovJK2ww</h3>Price : 3.99 <br>priceCurrency : USD <br>Start Date: 2026-05-15 16:08:21<br>End Date: 2026-07-22 16:08:21<br>Original Order ID: GPA.3368-4912-0604-06646..1<br>Trimmed Order ID: GPA.3368-4912-0604-06646<br><br>================ Subscription Update or Skip ================ <br>
                    SELECT *
                    FROM tbl_customer_subscriptions 
                    WHERE subscriber_id = '44513' 
                      AND `status` IN ('2','3') 
                      AND pg_name = 'google_inapp_purchase'  
                    ORDER BY id DESC
                    LIMIT 1
                <br><br>✅ No update needed, just mark processed_at in temp_lac.<br><br>
                            UPDATE temp_lac 
                            SET processed_at = NOW()
                            WHERE record_id = '25362'
                        <br><br>✅ Script finished.