2025-02-23 01:00:02 -- 將會員中心id寫入data-lake
2025-02-23 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 '2025-02-22%';
        
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P2502220000024' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457447'
                WHERE ordernumber = 'P2502220000025' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212759'
                WHERE ordernumber = 'P2502220000027' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457448'
                WHERE ordernumber = 'P2502220000030' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363575'
                WHERE ordernumber = 'P2502220000033' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457386'
                WHERE ordernumber = 'P2502220000034' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127878'
                WHERE ordernumber = 'P2502220000035' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281351'
                WHERE ordernumber = 'P2502220000036' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284544'
                WHERE ordernumber = 'P2502220000042' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127910'
                WHERE ordernumber = 'P2502220000043' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457449'
                WHERE ordernumber = 'P2502220000044' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457450'
                WHERE ordernumber = 'P2502220000045' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457451'
                WHERE ordernumber = 'P2502220000047' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '440022'
                WHERE ordernumber = 'P2502220000048' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '456311'
                WHERE ordernumber = 'P2502220000049' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '441113'
                WHERE ordernumber = 'P2502220000050' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457455'
                WHERE ordernumber = 'P2502220000053' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457454'
                WHERE ordernumber = 'P2502220000054' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457453'
                WHERE ordernumber = 'P2502220000056' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435280'
                WHERE ordernumber = 'P2502220000064' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '70121'
                WHERE ordernumber = 'P2502220000065' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '76133'
                WHERE ordernumber = 'P2502220000067' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457456'
                WHERE ordernumber = 'P2502220000069' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '72616'
                WHERE ordernumber = 'P2502220000070' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365514'
                WHERE ordernumber = 'P2502220000071' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457457'
                WHERE ordernumber = 'P2502220000074' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457459'
                WHERE ordernumber = 'P2502220000077' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246986'
                WHERE ordernumber = 'P2502220000078' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381734'
                WHERE ordernumber = 'P2502220000080' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457457'
                WHERE ordernumber = 'P2502220000081' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457458'
                WHERE ordernumber = 'P2502220000083' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457461'
                WHERE ordernumber = 'P2502220000085' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457459'
                WHERE ordernumber = 'P2502220000086' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457460'
                WHERE ordernumber = 'P2502220000087' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457462'
                WHERE ordernumber = 'P2502220000093' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397430'
                WHERE ordernumber = 'P2502220000095' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457359'
                WHERE ordernumber = 'P2502220000098' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123357'
                WHERE ordernumber = 'P2502220000100' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457463'
                WHERE ordernumber = 'P2502220000105' 
            
2025-02-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457359'
                WHERE ordernumber = 'P2502220000107' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457464'
                WHERE ordernumber = 'P2502220000109' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2502220000110' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457465'
                WHERE ordernumber = 'P2502220000111' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66489'
                WHERE ordernumber = 'P2502220000113' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431778'
                WHERE ordernumber = 'P2502220000115' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457466'
                WHERE ordernumber = 'P2502220000116' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225373'
                WHERE ordernumber = 'P2502220000118' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358086'
                WHERE ordernumber = 'P2502220000119' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457467'
                WHERE ordernumber = 'P2502220000121' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P2502220000122' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457468'
                WHERE ordernumber = 'P2502220000123' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457469'
                WHERE ordernumber = 'P2502220000127' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457470'
                WHERE ordernumber = 'P2502220000129' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250413'
                WHERE ordernumber = 'P2502220000132' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388791'
                WHERE ordernumber = 'P2502220000135' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384182'
                WHERE ordernumber = 'P2502220000143' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393707'
                WHERE ordernumber = 'P2502220000148' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457475'
                WHERE ordernumber = 'P2502220000155' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457474'
                WHERE ordernumber = 'P2502220000158' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208484'
                WHERE ordernumber = 'P2502220000160' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457477'
                WHERE ordernumber = 'P2502220000164' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457477'
                WHERE ordernumber = 'P2502220000165' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457476'
                WHERE ordernumber = 'P2502220000166' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316210'
                WHERE ordernumber = 'P2502220000183' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356208'
                WHERE ordernumber = 'P2502220000184' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362228'
                WHERE ordernumber = 'P2502220000186' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P2502220000189' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457482'
                WHERE ordernumber = 'P2502220000190' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457483'
                WHERE ordernumber = 'P2502220000192' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206405'
                WHERE ordernumber = 'P2502220000197' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457485'
                WHERE ordernumber = 'P2502220000206' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457486'
                WHERE ordernumber = 'P2502220000209' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457484'
                WHERE ordernumber = 'P2502220000213' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457487'
                WHERE ordernumber = 'P2502220000216' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427114'
                WHERE ordernumber = 'P2502220000218' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95916'
                WHERE ordernumber = 'P2502220000222' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457488'
                WHERE ordernumber = 'P2502220000224' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338014'
                WHERE ordernumber = 'P2502220000226' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457490'
                WHERE ordernumber = 'P2502220000227' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366317'
                WHERE ordernumber = 'P2502220000228' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314795'
                WHERE ordernumber = 'P2502220000229' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456468'
                WHERE ordernumber = 'P2502220000230' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303089'
                WHERE ordernumber = 'P2502220000232' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457491'
                WHERE ordernumber = 'P2502220000236' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P2502220000240' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P2502220000241' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209597'
                WHERE ordernumber = 'P2502220000243' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457488'
                WHERE ordernumber = 'P2502220000244' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248290'
                WHERE ordernumber = 'P2502220000247' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102962'
                WHERE ordernumber = 'P2502220000248' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P2502220000250' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457492'
                WHERE ordernumber = 'P2502220000251' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457493'
                WHERE ordernumber = 'P2502220000255' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457494'
                WHERE ordernumber = 'P2502220000256' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421492'
                WHERE ordernumber = 'P2502220000257' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421777'
                WHERE ordernumber = 'P2502220000259' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424856'
                WHERE ordernumber = 'P2502220000260' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281097'
                WHERE ordernumber = 'P2502220000261' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424856'
                WHERE ordernumber = 'P2502220000263' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425035'
                WHERE ordernumber = 'P2502220000265' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457495'
                WHERE ordernumber = 'P2502220000266' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457496'
                WHERE ordernumber = 'P2502220000270' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289023'
                WHERE ordernumber = 'P2502220000271' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433769'
                WHERE ordernumber = 'P2502220000274' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399979'
                WHERE ordernumber = 'P2502220000275' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457497'
                WHERE ordernumber = 'P2502220000276' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457499'
                WHERE ordernumber = 'P2502220000277' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364538'
                WHERE ordernumber = 'P2502220000281' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457502'
                WHERE ordernumber = 'P2502220000283' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457501'
                WHERE ordernumber = 'P2502220000285' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457498'
                WHERE ordernumber = 'P2502220000286' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386949'
                WHERE ordernumber = 'P2502220000287' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225154'
                WHERE ordernumber = 'P2502220000289' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457503'
                WHERE ordernumber = 'P2502220000292' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457504'
                WHERE ordernumber = 'P2502220000293' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457500'
                WHERE ordernumber = 'P2502220000296' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457505'
                WHERE ordernumber = 'P2502220000298' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457506'
                WHERE ordernumber = 'P2502220000299' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129015'
                WHERE ordernumber = 'P2502220000303' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457167'
                WHERE ordernumber = 'P2502220000304' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290291'
                WHERE ordernumber = 'P2502220000305' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '456113'
                WHERE ordernumber = 'P2502220000306' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457507'
                WHERE ordernumber = 'P2502220000308' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457508'
                WHERE ordernumber = 'P2502220000309' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90513'
                WHERE ordernumber = 'P2502220000310' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457509'
                WHERE ordernumber = 'P2502220000312' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339046'
                WHERE ordernumber = 'P2502220000313' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457510'
                WHERE ordernumber = 'P2502220000314' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222370'
                WHERE ordernumber = 'P2502220000316' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421143'
                WHERE ordernumber = 'P2502220000319' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457512'
                WHERE ordernumber = 'P2502220000321' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457514'
                WHERE ordernumber = 'P2502220000323' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457515'
                WHERE ordernumber = 'P2502220000325' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457516'
                WHERE ordernumber = 'P2502220000326' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457513'
                WHERE ordernumber = 'P2502220000331' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457518'
                WHERE ordernumber = 'P2502220000334' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457519'
                WHERE ordernumber = 'P2502220000339' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457520'
                WHERE ordernumber = 'P2502220000340' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457511'
                WHERE ordernumber = 'P2502220000342' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457517'
                WHERE ordernumber = 'P2502220000343' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298387'
                WHERE ordernumber = 'P2502220000344' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345088'
                WHERE ordernumber = 'P2502220000346' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457523'
                WHERE ordernumber = 'P2502220000348' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457480'
                WHERE ordernumber = 'P2502220000350' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457480'
                WHERE ordernumber = 'P2502220000352' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457524'
                WHERE ordernumber = 'P2502220000353' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455265'
                WHERE ordernumber = 'P2502220000354' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318863'
                WHERE ordernumber = 'P2502220000355' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457527'
                WHERE ordernumber = 'P2502220000358' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457528'
                WHERE ordernumber = 'P2502220000360' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457531'
                WHERE ordernumber = 'P2502220000362' 
            
2025-02-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '457529'
                WHERE ordernumber = 'P2502220000363' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457530'
                WHERE ordernumber = 'P2502220000365' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457532'
                WHERE ordernumber = 'P2502220000366' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457166'
                WHERE ordernumber = 'P2502220000371' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457534'
                WHERE ordernumber = 'P2502220000373' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P2502220000375' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457533'
                WHERE ordernumber = 'P2502220000378' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P2502220000379' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457535'
                WHERE ordernumber = 'P2502220000384' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428327'
                WHERE ordernumber = 'P2502220000385' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '195783'
                WHERE ordernumber = 'P2502220000391' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P2502220000394' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457537'
                WHERE ordernumber = 'P2502220000395' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457540'
                WHERE ordernumber = 'P2502220000398' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457536'
                WHERE ordernumber = 'P2502220000399' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457536'
                WHERE ordernumber = 'P2502220000400' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457501'
                WHERE ordernumber = 'P2502220000401' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457538'
                WHERE ordernumber = 'P2502220000402' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457541'
                WHERE ordernumber = 'P2502220000403' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457542'
                WHERE ordernumber = 'P2502220000404' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259235'
                WHERE ordernumber = 'P2502220000406' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295875'
                WHERE ordernumber = 'P2502220000407' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457539'
                WHERE ordernumber = 'P2502220000410' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457543'
                WHERE ordernumber = 'P2502220000412' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457545'
                WHERE ordernumber = 'P2502220000417' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455987'
                WHERE ordernumber = 'P2502220000418' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457549'
                WHERE ordernumber = 'P2502220000421' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457546'
                WHERE ordernumber = 'P2502220000422' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457551'
                WHERE ordernumber = 'P2502220000425' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457547'
                WHERE ordernumber = 'P2502220000426' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457553'
                WHERE ordernumber = 'P2502220000427' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '444037'
                WHERE ordernumber = 'P2502220000429' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457552'
                WHERE ordernumber = 'P2502220000432' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457555'
                WHERE ordernumber = 'P2502220000433' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P2502220000435' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457554'
                WHERE ordernumber = 'P2502220000436' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457556'
                WHERE ordernumber = 'P2502220000437' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455015'
                WHERE ordernumber = 'P2502220000439' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457557'
                WHERE ordernumber = 'P2502220000441' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457560'
                WHERE ordernumber = 'P2502220000442' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457558'
                WHERE ordernumber = 'P2502220000445' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457555'
                WHERE ordernumber = 'P2502220000447' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457556'
                WHERE ordernumber = 'P2502220000451' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273239'
                WHERE ordernumber = 'P2502220000452' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457544'
                WHERE ordernumber = 'P2502220000455' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457563'
                WHERE ordernumber = 'P2502220000456' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433360'
                WHERE ordernumber = 'P2502220000460' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361975'
                WHERE ordernumber = 'P2502220000462' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457562'
                WHERE ordernumber = 'P2502220000465' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457561'
                WHERE ordernumber = 'P2502220000466' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457564'
                WHERE ordernumber = 'P2502220000469' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457559'
                WHERE ordernumber = 'P2502220000477' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131195'
                WHERE ordernumber = 'P2502220000478' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408482'
                WHERE ordernumber = 'P2502220000483' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457567'
                WHERE ordernumber = 'P2502220000491' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398304'
                WHERE ordernumber = 'P2502220000492' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457568'
                WHERE ordernumber = 'P2502220000496' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2502220000498' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457566'
                WHERE ordernumber = 'P2502220000499' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457569'
                WHERE ordernumber = 'P2502220000501' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352130'
                WHERE ordernumber = 'P2502220000502' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457571'
                WHERE ordernumber = 'P2502220000505' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457570'
                WHERE ordernumber = 'P2502220000506' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290485'
                WHERE ordernumber = 'P2502220000510' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P2502220000511' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457565'
                WHERE ordernumber = 'P2502220000515' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457572'
                WHERE ordernumber = 'P2502220000516' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457569'
                WHERE ordernumber = 'P2502220000517' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81934'
                WHERE ordernumber = 'P2502220000522' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457573'
                WHERE ordernumber = 'P2502220000526' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457575'
                WHERE ordernumber = 'P2502220000530' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236309'
                WHERE ordernumber = 'P2502220000531' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457576'
                WHERE ordernumber = 'P2502220000532' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457574'
                WHERE ordernumber = 'P2502220000533' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457577'
                WHERE ordernumber = 'P2502220000534' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '454253'
                WHERE ordernumber = 'P2502220000540' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457578'
                WHERE ordernumber = 'P2502220000545' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227776'
                WHERE ordernumber = 'P2502220000546' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367377'
                WHERE ordernumber = 'P2502220000548' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334936'
                WHERE ordernumber = 'P2502220000554' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424484'
                WHERE ordernumber = 'P2502220000557' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457581'
                WHERE ordernumber = 'P2502220000558' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457582'
                WHERE ordernumber = 'P2502220000560' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457583'
                WHERE ordernumber = 'P2502220000566' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311550'
                WHERE ordernumber = 'P2502220000567' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457587'
                WHERE ordernumber = 'P2502220000568' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457589'
                WHERE ordernumber = 'P2502220000569' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457591'
                WHERE ordernumber = 'P2502220000570' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457590'
                WHERE ordernumber = 'P2502220000573' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457592'
                WHERE ordernumber = 'P2502220000575' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P2502220000574' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457594'
                WHERE ordernumber = 'P2502220000577' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457595'
                WHERE ordernumber = 'P2502220000579' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172046'
                WHERE ordernumber = 'P2502220000580' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453019'
                WHERE ordernumber = 'P2502220000583' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457596'
                WHERE ordernumber = 'P2502220000588' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P2502220000591' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229899'
                WHERE ordernumber = 'P2502220000595' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457598'
                WHERE ordernumber = 'P2502220000596' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457599'
                WHERE ordernumber = 'P2502220000598' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293384'
                WHERE ordernumber = 'P2502220000602' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457600'
                WHERE ordernumber = 'P2502220000605' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394697'
                WHERE ordernumber = 'P2502220000606' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '453387'
                WHERE ordernumber = 'P2502220000611' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53497'
                WHERE ordernumber = 'P2502220000613' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259849'
                WHERE ordernumber = 'P2502220000615' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434537'
                WHERE ordernumber = 'P2502220000618' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457597'
                WHERE ordernumber = 'P2502220000622' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457601'
                WHERE ordernumber = 'P2502220000623' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457602'
                WHERE ordernumber = 'P2502220000626' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457603'
                WHERE ordernumber = 'P2502220000640' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457604'
                WHERE ordernumber = 'P2502220000642' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457605'
                WHERE ordernumber = 'P2502220000648' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457607'
                WHERE ordernumber = 'P2502220000650' 
            
2025-02-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222552'
                WHERE ordernumber = 'P2502220000654' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428482'
                WHERE ordernumber = 'P2502220000657' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457609'
                WHERE ordernumber = 'P2502220000660' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457610'
                WHERE ordernumber = 'P2502220000663' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457611'
                WHERE ordernumber = 'P2502220000668' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249000'
                WHERE ordernumber = 'P2502220000669' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353349'
                WHERE ordernumber = 'P2502220000672' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457612'
                WHERE ordernumber = 'P2502220000673' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457611'
                WHERE ordernumber = 'P2502220000676' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455135'
                WHERE ordernumber = 'P2502220000679' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260351'
                WHERE ordernumber = 'P2502220000682' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457615'
                WHERE ordernumber = 'P2502220000686' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457614'
                WHERE ordernumber = 'P2502220000688' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457615'
                WHERE ordernumber = 'P2502220000692' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '450734'
                WHERE ordernumber = 'P2502220000693' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160019'
                WHERE ordernumber = 'P2502220000697' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376573'
                WHERE ordernumber = 'P2502220000700' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457526'
                WHERE ordernumber = 'P2502220000703' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '455790'
                WHERE ordernumber = 'P2502220000704' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237179'
                WHERE ordernumber = 'P2502220000711' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424751'
                WHERE ordernumber = 'P2502220000714' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457616'
                WHERE ordernumber = 'P2502220000717' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226991'
                WHERE ordernumber = 'P2502220000719' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457618'
                WHERE ordernumber = 'P2502220000722' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P2502220000727' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '184601'
                WHERE ordernumber = 'P2502220000732' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264691'
                WHERE ordernumber = 'P2502220000733' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457617'
                WHERE ordernumber = 'P2502220000745' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137638'
                WHERE ordernumber = 'P2502220000757' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98954'
                WHERE ordernumber = 'P2502220000758' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457621'
                WHERE ordernumber = 'P2502220000764' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457619'
                WHERE ordernumber = 'P2502220000771' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291564'
                WHERE ordernumber = 'P2502220000774' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457622'
                WHERE ordernumber = 'P2502220000778' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426071'
                WHERE ordernumber = 'P2502220000785' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '438102'
                WHERE ordernumber = 'P2502220000788' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426071'
                WHERE ordernumber = 'P2502220000790' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457623'
                WHERE ordernumber = 'P2502220000796' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457623'
                WHERE ordernumber = 'P2502220000797' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237232'
                WHERE ordernumber = 'P2502220000798' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457624'
                WHERE ordernumber = 'P2502220000805' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P2502220000816' 
            
2025-02-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123046'
                WHERE ordernumber = 'P2502220000819'