6 MONTHS CONSISTENCY: TOP 100 TXNS txn level data

with base as 
    (SELECT A.sender, B.city as tenant_city
    , A.landlord
    , IF(C.phone_number IS NOT NULL, C.phone_number, NULL) AS landlord_phoneno
    , IF(CC.primary_vpa IS NOT NULL, CC.primary_vpa, NULL) AS landlord_vpa
    , IF(C.user_id IS NOT NULL, C.user_id, CC.user_id) as landlord_user_id
    , IF(D.city IS NOT NULL, D.city, DD.city) as landlord_city
    , A.txn_id, A.amt, A.CC, A.txnTime, A.month, A.day
    FROM
        (select distinct eventdata_merchantcontext_contactid as landlord
        , eventdata_transactionid AS txn_id
        ,eventdata_sender as sender
        ,eventdata_senderphone
        ,eventdata_totaltransactionamount as amt
        ,eventdata_senderglobalcardid as CC
        ,`time` AS txnTime, month, day
        from foxtrot_stream.payment_backend_transact
        where 0 = 0
        and year = 2022 and month >= 8
        and eventtype = 'PAYMENT'
        and eventdata_status = 'COMPLETED'
        and eventdata_receiveruser = 'PHONEPERENTPAYMENT'
        and eventdata_sendertype = 'INTERNAL_USER'
        AND eventdata_workflowtype = 'CONSUMER_TO_MERCHANT'
        AND eventdata_receiversubtype = 'ONLINE_MERCHANT'
        AND eventdata_receivertypeinrequest = 'MERCHANT'
        AND eventdata_receivertype = 'MERCHANT'
        AND ((LENGTH(eventdata_merchantcontext_contactid) = 10) OR (eventdata_merchantcontext_contactid LIKE '%@ybl') OR (eventdata_merchantcontext_contactid LIKE '%@ibl') OR (eventdata_merchantcontext_contactid LIKE '%@axl')))A
    INNER JOIN
        (SELECT DISTINCT user_id, city FROM edw_shared.user_dimension WHERE city IS NOT NULL)B
    ON A.sender = B.user_id
    LEFT JOIN
        (SELECT DISTINCT user_ext_id AS user_id, phone_number
        FROM users.users
        WHERE blacklisted = 0)C
    ON A.landlord = C.phone_number 
    LEFT JOIN
        (SELECT DISTINCT user_ext_id AS user_id, primary_vpa 
        FROM users.users
        WHERE blacklisted = 0)CC
    ON A.landlord = CC.primary_vpa
    LEFT JOIN
        (SELECT DISTINCT user_id, city FROM edw_shared.user_dimension WHERE city IS NOT NULL)D
    ON C.user_id = D.user_id
    LEFT JOIN
        (SELECT DISTINCT user_id, city FROM edw_shared.user_dimension WHERE city IS NOT NULL)DD
    ON CC.user_id = DD.user_id)
    
SELECT DISTINCT landlord_user_id as landlord_userid
, sender as tenant_userid
, txn_id, amt, CC
, '2022' as year, month, day, txnTime
, landlord_city
, tenant_city
FROM base
WHERE landlord_user_id IN ()