2024-12-04 01:00:02 -- 將會員中心id寫入data-lake
2024-12-04 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-12-03%';
        
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400858'
                WHERE ordernumber = 'P2412030000192' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395651'
                WHERE ordernumber = 'P2412030000277' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432944'
                WHERE ordernumber = 'P2412030000430' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P2412030000573' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432945'
                WHERE ordernumber = 'P2412030000664' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132930'
                WHERE ordernumber = 'P2412030001043' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432948'
                WHERE ordernumber = 'P2412030001140' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432949'
                WHERE ordernumber = 'P2412030001365' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432950'
                WHERE ordernumber = 'P2412030001415' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432419'
                WHERE ordernumber = 'P2412030001784' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432951'
                WHERE ordernumber = 'P2412030001982' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432953'
                WHERE ordernumber = 'P2412030002168' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351886'
                WHERE ordernumber = 'P2412030002450' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P2412030002646' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227164'
                WHERE ordernumber = 'P2412030002851' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99566'
                WHERE ordernumber = 'P2412030002944' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2412030003057' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432955'
                WHERE ordernumber = 'P2412030003390' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432956'
                WHERE ordernumber = 'P2412030003416' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432958'
                WHERE ordernumber = 'P2412030003557' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94715'
                WHERE ordernumber = 'P2412030003675' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432960'
                WHERE ordernumber = 'P2412030003874' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130049'
                WHERE ordernumber = 'P2412030004566' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388110'
                WHERE ordernumber = 'P2412030004740' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380883'
                WHERE ordernumber = 'P2412030005017' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104000'
                WHERE ordernumber = 'P2412030005126' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428132'
                WHERE ordernumber = 'P2412030005231' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432968'
                WHERE ordernumber = 'P2412030005324' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432970'
                WHERE ordernumber = 'P2412030005469' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263996'
                WHERE ordernumber = 'P2412030005559' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432029'
                WHERE ordernumber = 'P2412030005674' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103922'
                WHERE ordernumber = 'P2412030005778' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432971'
                WHERE ordernumber = 'P2412030005856' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430352'
                WHERE ordernumber = 'P2412030005919' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345528'
                WHERE ordernumber = 'P2412030006142' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P2412030006226' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304075'
                WHERE ordernumber = 'P2412030006613' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320776'
                WHERE ordernumber = 'P2412030006711' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270246'
                WHERE ordernumber = 'P2412030006890' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426962'
                WHERE ordernumber = 'P2412030006958' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432976'
                WHERE ordernumber = 'P2412030007039' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417993'
                WHERE ordernumber = 'P2412030007274' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270246'
                WHERE ordernumber = 'P2412030007372' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432977'
                WHERE ordernumber = 'P2412030007452' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247609'
                WHERE ordernumber = 'P2412030007629' 
            
2024-12-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P2412030007769' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206819'
                WHERE ordernumber = 'P2412030007812' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56139'
                WHERE ordernumber = 'P2412030007983' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432983'
                WHERE ordernumber = 'P2412030008127' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432984'
                WHERE ordernumber = 'P2412030008331' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56139'
                WHERE ordernumber = 'P2412030008482' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432979'
                WHERE ordernumber = 'P2412030008544' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389121'
                WHERE ordernumber = 'P2412030008844' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P2412030008939' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432987'
                WHERE ordernumber = 'P2412030009018' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399190'
                WHERE ordernumber = 'P2412030009131' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432989'
                WHERE ordernumber = 'P2412030009393' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119626'
                WHERE ordernumber = 'P2412030009460' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277866'
                WHERE ordernumber = 'P2412030009575' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278619'
                WHERE ordernumber = 'P2412030009822' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432991'
                WHERE ordernumber = 'P2412030010061' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401452'
                WHERE ordernumber = 'P2412030010344' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432997'
                WHERE ordernumber = 'P2412030010556' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432996'
                WHERE ordernumber = 'P2412030010657' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432998'
                WHERE ordernumber = 'P2412030010825' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432998'
                WHERE ordernumber = 'P2412030011184' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430910'
                WHERE ordernumber = 'P2412030011319' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388790'
                WHERE ordernumber = 'P2412030011570' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433001'
                WHERE ordernumber = 'P2412030011672' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433003'
                WHERE ordernumber = 'P2412030011886' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402345'
                WHERE ordernumber = 'P2412030011996' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433003'
                WHERE ordernumber = 'P2412030012092' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433005'
                WHERE ordernumber = 'P2412030012132' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433007'
                WHERE ordernumber = 'P2412030012296' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433009'
                WHERE ordernumber = 'P2412030012536' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433010'
                WHERE ordernumber = 'P2412030012647' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333642'
                WHERE ordernumber = 'P2412030012783' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433012'
                WHERE ordernumber = 'P2412030012870' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433013'
                WHERE ordernumber = 'P2412030012971' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289480'
                WHERE ordernumber = 'P2412030013151' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119317'
                WHERE ordernumber = 'P2412030013254' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433017'
                WHERE ordernumber = 'P2412030013319' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384252'
                WHERE ordernumber = 'P2412030013462' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119317'
                WHERE ordernumber = 'P2412030013647' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396933'
                WHERE ordernumber = 'P2412030013772' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433018'
                WHERE ordernumber = 'P2412030013962' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433018'
                WHERE ordernumber = 'P2412030014044' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248360'
                WHERE ordernumber = 'P2412030014272' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433021'
                WHERE ordernumber = 'P2412030014383' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429060'
                WHERE ordernumber = 'P2412030014599' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433022'
                WHERE ordernumber = 'P2412030014793' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433025'
                WHERE ordernumber = 'P2412030014819' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429950'
                WHERE ordernumber = 'P2412030014949' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399985'
                WHERE ordernumber = 'P2412030015045' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433026'
                WHERE ordernumber = 'P2412030015120' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386263'
                WHERE ordernumber = 'P2412030015538' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380354'
                WHERE ordernumber = 'P2412030015774' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433028'
                WHERE ordernumber = 'P2412030015863' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P2412030016175' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224399'
                WHERE ordernumber = 'P2412030016444' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430852'
                WHERE ordernumber = 'P2412030016567' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424677'
                WHERE ordernumber = 'P2412030016681' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431159'
                WHERE ordernumber = 'P2412030017417' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433036'
                WHERE ordernumber = 'P2412030017884' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P2412030018023' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433038'
                WHERE ordernumber = 'P2412030018188' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379215'
                WHERE ordernumber = 'P2412030018226' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433041'
                WHERE ordernumber = 'P2412030018453' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433035'
                WHERE ordernumber = 'P2412030019253' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433045'
                WHERE ordernumber = 'P2412030019369' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433046'
                WHERE ordernumber = 'P2412030019440' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298329'
                WHERE ordernumber = 'P2412030019517' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360189'
                WHERE ordernumber = 'P2412030019667' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433035'
                WHERE ordernumber = 'P2412030019794' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241446'
                WHERE ordernumber = 'P2412030019983' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235985'
                WHERE ordernumber = 'P2412030020142' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430029'
                WHERE ordernumber = 'P2412030020355' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P2412030020787' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377871'
                WHERE ordernumber = 'P2412030020880' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352656'
                WHERE ordernumber = 'P2412030020965' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421316'
                WHERE ordernumber = 'P2412030021084' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430726'
                WHERE ordernumber = 'P2412030021175' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433051'
                WHERE ordernumber = 'P2412030021218' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88060'
                WHERE ordernumber = 'P2412030021518' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284257'
                WHERE ordernumber = 'P2412030021758' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433053'
                WHERE ordernumber = 'P2412030021891' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344114'
                WHERE ordernumber = 'P2412030022041' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433054'
                WHERE ordernumber = 'P2412030022122' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253624'
                WHERE ordernumber = 'P2412030022292' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433055'
                WHERE ordernumber = 'P2412030022374' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356459'
                WHERE ordernumber = 'P2412030022559' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389003'
                WHERE ordernumber = 'P2412030022785' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251381'
                WHERE ordernumber = 'P2412030022824' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433058'
                WHERE ordernumber = 'P2412030022928' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271112'
                WHERE ordernumber = 'P2412030023254' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401881'
                WHERE ordernumber = 'P2412030023328' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271112'
                WHERE ordernumber = 'P2412030023432' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394270'
                WHERE ordernumber = 'P2412030023578' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433059'
                WHERE ordernumber = 'P2412030023691' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430660'
                WHERE ordernumber = 'P2412030023927' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403059'
                WHERE ordernumber = 'P2412030024044' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424442'
                WHERE ordernumber = 'P2412030024166' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161316'
                WHERE ordernumber = 'P2412030024212' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250603'
                WHERE ordernumber = 'P2412030024357' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433063'
                WHERE ordernumber = 'P2412030024659' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433065'
                WHERE ordernumber = 'P2412030024765' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433066'
                WHERE ordernumber = 'P2412030024948' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433065'
                WHERE ordernumber = 'P2412030025096' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340415'
                WHERE ordernumber = 'P2412030025195' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270879'
                WHERE ordernumber = 'P2412030025262' 
            
2024-12-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P2412030025397'