2024-12-22 01:00:02 -- 將會員中心id寫入data-lake
2024-12-22 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-21%';
        
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435833'
                WHERE ordernumber = 'P2412210000019' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429836'
                WHERE ordernumber = 'P2412210000021' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '12268'
                WHERE ordernumber = 'P2412210000024' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437728'
                WHERE ordernumber = 'P2412210000026' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248158'
                WHERE ordernumber = 'P2412210000029' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278660'
                WHERE ordernumber = 'P2412210000030' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230510'
                WHERE ordernumber = 'P2412210000032' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433514'
                WHERE ordernumber = 'P2412210000033' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241588'
                WHERE ordernumber = 'P2412210000035' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287344'
                WHERE ordernumber = 'P2412210000039' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96916'
                WHERE ordernumber = 'P2412210000043' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253661'
                WHERE ordernumber = 'P2412210000044' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437726'
                WHERE ordernumber = 'P2412210000046' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430685'
                WHERE ordernumber = 'P2412210000047' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '190208'
                WHERE ordernumber = 'P2412210000049' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211556'
                WHERE ordernumber = 'P2412210000050' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435555'
                WHERE ordernumber = 'P2412210000052' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278305'
                WHERE ordernumber = 'P2412210000053' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398173'
                WHERE ordernumber = 'P2412210000056' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381949'
                WHERE ordernumber = 'P2412210000060' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437729'
                WHERE ordernumber = 'P2412210000061' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437731'
                WHERE ordernumber = 'P2412210000063' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364942'
                WHERE ordernumber = 'P2412210000066' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51992'
                WHERE ordernumber = 'P2412210000069' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437734'
                WHERE ordernumber = 'P2412210000071' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437733'
                WHERE ordernumber = 'P2412210000077' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101822'
                WHERE ordernumber = 'P2412210000078' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437737'
                WHERE ordernumber = 'P2412210000088' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405596'
                WHERE ordernumber = 'P2412210000089' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437736'
                WHERE ordernumber = 'P2412210000091' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351884'
                WHERE ordernumber = 'P2412210000092' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281618'
                WHERE ordernumber = 'P2412210000093' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P2412210000099' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P2412210000101' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102830'
                WHERE ordernumber = 'P2412210000102' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437740'
                WHERE ordernumber = 'P2412210000103' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328854'
                WHERE ordernumber = 'P2412210000104' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437741'
                WHERE ordernumber = 'P2412210000105' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354088'
                WHERE ordernumber = 'P2412210000106' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318585'
                WHERE ordernumber = 'P2412210000108' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437742'
                WHERE ordernumber = 'P2412210000110' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412210000111' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240697'
                WHERE ordernumber = 'P2412210000113' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262406'
                WHERE ordernumber = 'P2412210000115' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437745'
                WHERE ordernumber = 'P2412210000117' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412210000118' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412210000125' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437748'
                WHERE ordernumber = 'P2412210000128' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435494'
                WHERE ordernumber = 'P2412210000130' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229132'
                WHERE ordernumber = 'P2412210000133' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437752'
                WHERE ordernumber = 'P2412210000136' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240565'
                WHERE ordernumber = 'P2412210000141' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435494'
                WHERE ordernumber = 'P2412210000143' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437754'
                WHERE ordernumber = 'P2412210000159' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437597'
                WHERE ordernumber = 'P2412210000161' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334257'
                WHERE ordernumber = 'P2412210000163' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265578'
                WHERE ordernumber = 'P2412210000164' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115645'
                WHERE ordernumber = 'P2412210000166' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437760'
                WHERE ordernumber = 'P2412210000167' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437755'
                WHERE ordernumber = 'P2412210000169' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437762'
                WHERE ordernumber = 'P2412210000170' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282242'
                WHERE ordernumber = 'P2412210000174' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437759'
                WHERE ordernumber = 'P2412210000175' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437763'
                WHERE ordernumber = 'P2412210000177' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227936'
                WHERE ordernumber = 'P2412210000179' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372679'
                WHERE ordernumber = 'P2412210000181' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149777'
                WHERE ordernumber = 'P2412210000182' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372679'
                WHERE ordernumber = 'P2412210000183' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437766'
                WHERE ordernumber = 'P2412210000188' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437764'
                WHERE ordernumber = 'P2412210000190' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207724'
                WHERE ordernumber = 'P2412210000191' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437768'
                WHERE ordernumber = 'P2412210000194' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429428'
                WHERE ordernumber = 'P2412210000198' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437766'
                WHERE ordernumber = 'P2412210000199' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437753'
                WHERE ordernumber = 'P2412210000201' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436977'
                WHERE ordernumber = 'P2412210000205' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278567'
                WHERE ordernumber = 'P2412210000209' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437771'
                WHERE ordernumber = 'P2412210000214' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437773'
                WHERE ordernumber = 'P2412210000223' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437774'
                WHERE ordernumber = 'P2412210000227' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437775'
                WHERE ordernumber = 'P2412210000230' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437776'
                WHERE ordernumber = 'P2412210000234' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375648'
                WHERE ordernumber = 'P2412210000238' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437779'
                WHERE ordernumber = 'P2412210000239' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437777'
                WHERE ordernumber = 'P2412210000243' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218999'
                WHERE ordernumber = 'P2412210000248' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437780'
                WHERE ordernumber = 'P2412210000253' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169457'
                WHERE ordernumber = 'P2412210000265' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437783'
                WHERE ordernumber = 'P2412210000267' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '151368'
                WHERE ordernumber = 'P2412210000275' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217861'
                WHERE ordernumber = 'P2412210000279' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431988'
                WHERE ordernumber = 'P2412210000283' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154455'
                WHERE ordernumber = 'P2412210000284' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423430'
                WHERE ordernumber = 'P2412210000285' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437787'
                WHERE ordernumber = 'P2412210000288' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369636'
                WHERE ordernumber = 'P2412210000289' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437790'
                WHERE ordernumber = 'P2412210000293' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97090'
                WHERE ordernumber = 'P2412210000295' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369783'
                WHERE ordernumber = 'P2412210000296' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301109'
                WHERE ordernumber = 'P2412210000298' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437791'
                WHERE ordernumber = 'P2412210000299' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407043'
                WHERE ordernumber = 'P2412210000301' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437788'
                WHERE ordernumber = 'P2412210000305' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437792'
                WHERE ordernumber = 'P2412210000308' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437796'
                WHERE ordernumber = 'P2412210000313' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434768'
                WHERE ordernumber = 'P2412210000314' 
            
2024-12-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420013'
                WHERE ordernumber = 'P2412210000315' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259084'
                WHERE ordernumber = 'P2412210000316' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433834'
                WHERE ordernumber = 'P2412210000321' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220919'
                WHERE ordernumber = 'P2412210000324' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P2412210000325' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400597'
                WHERE ordernumber = 'P2412210000327' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437797'
                WHERE ordernumber = 'P2412210000330' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373353'
                WHERE ordernumber = 'P2412210000334' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '178925'
                WHERE ordernumber = 'P2412210000339' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248361'
                WHERE ordernumber = 'P2412210000340' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81651'
                WHERE ordernumber = 'P2412210000345' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368116'
                WHERE ordernumber = 'P2412210000347' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265522'
                WHERE ordernumber = 'P2412210000350' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217676'
                WHERE ordernumber = 'P2412210000351' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437800'
                WHERE ordernumber = 'P2412210000352' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437802'
                WHERE ordernumber = 'P2412210000353' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437803'
                WHERE ordernumber = 'P2412210000354' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276598'
                WHERE ordernumber = 'P2412210000356' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437804'
                WHERE ordernumber = 'P2412210000357' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280049'
                WHERE ordernumber = 'P2412210000359' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437801'
                WHERE ordernumber = 'P2412210000361' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396494'
                WHERE ordernumber = 'P2412210000368' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376532'
                WHERE ordernumber = 'P2412210000373' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434252'
                WHERE ordernumber = 'P2412210000375' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436977'
                WHERE ordernumber = 'P2412210000376' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '433186'
                WHERE ordernumber = 'P2412210000378' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384691'
                WHERE ordernumber = 'P2412210000379' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373335'
                WHERE ordernumber = 'P2412210000381' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159650'
                WHERE ordernumber = 'P2412210000382' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437809'
                WHERE ordernumber = 'P2412210000384' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437808'
                WHERE ordernumber = 'P2412210000386' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431549'
                WHERE ordernumber = 'P2412210000387' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P2412210000391' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437810'
                WHERE ordernumber = 'P2412210000393' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142180'
                WHERE ordernumber = 'P2412210000397' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387207'
                WHERE ordernumber = 'P2412210000398' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419693'
                WHERE ordernumber = 'P2412210000399' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437813'
                WHERE ordernumber = 'P2412210000401' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309283'
                WHERE ordernumber = 'P2412210000407' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81662'
                WHERE ordernumber = 'P2412210000408' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437814'
                WHERE ordernumber = 'P2412210000409' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138288'
                WHERE ordernumber = 'P2412210000414' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437818'
                WHERE ordernumber = 'P2412210000416' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437821'
                WHERE ordernumber = 'P2412210000422' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437817'
                WHERE ordernumber = 'P2412210000424' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379760'
                WHERE ordernumber = 'P2412210000425' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2412210000426' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P2412210000427' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416851'
                WHERE ordernumber = 'P2412210000428' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437824'
                WHERE ordernumber = 'P2412210000432' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437825'
                WHERE ordernumber = 'P2412210000435' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209239'
                WHERE ordernumber = 'P2412210000441' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258248'
                WHERE ordernumber = 'P2412210000446' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437833'
                WHERE ordernumber = 'P2412210000450' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437834'
                WHERE ordernumber = 'P2412210000452' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437818'
                WHERE ordernumber = 'P2412210000453' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437835'
                WHERE ordernumber = 'P2412210000454' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437836'
                WHERE ordernumber = 'P2412210000458' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262344'
                WHERE ordernumber = 'P2412210000465' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388931'
                WHERE ordernumber = 'P2412210000468' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380616'
                WHERE ordernumber = 'P2412210000469' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85500'
                WHERE ordernumber = 'P2412210000471' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P2412210000474' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437839'
                WHERE ordernumber = 'P2412210000478' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436598'
                WHERE ordernumber = 'P2412210000479' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423437'
                WHERE ordernumber = 'P2412210000486' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437841'
                WHERE ordernumber = 'P2412210000488' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437840'
                WHERE ordernumber = 'P2412210000490' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264742'
                WHERE ordernumber = 'P2412210000491' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391529'
                WHERE ordernumber = 'P2412210000496' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437842'
                WHERE ordernumber = 'P2412210000497' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217292'
                WHERE ordernumber = 'P2412210000498' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P2412210000499' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437843'
                WHERE ordernumber = 'P2412210000500' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280616'
                WHERE ordernumber = 'P2412210000511' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437844'
                WHERE ordernumber = 'P2412210000514' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437846'
                WHERE ordernumber = 'P2412210000516' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437847'
                WHERE ordernumber = 'P2412210000518' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437849'
                WHERE ordernumber = 'P2412210000520' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362842'
                WHERE ordernumber = 'P2412210000522' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437850'
                WHERE ordernumber = 'P2412210000521' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351710'
                WHERE ordernumber = 'P2412210000523' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152935'
                WHERE ordernumber = 'P2412210000525' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257654'
                WHERE ordernumber = 'P2412210000528' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401933'
                WHERE ordernumber = 'P2412210000531' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '184810'
                WHERE ordernumber = 'P2412210000537' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437851'
                WHERE ordernumber = 'P2412210000538' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437855'
                WHERE ordernumber = 'P2412210000546' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238586'
                WHERE ordernumber = 'P2412210000549' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P2412210000553' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239719'
                WHERE ordernumber = 'P2412210000556' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285600'
                WHERE ordernumber = 'P2412210000558' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437856'
                WHERE ordernumber = 'P2412210000560' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233434'
                WHERE ordernumber = 'P2412210000562' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437859'
                WHERE ordernumber = 'P2412210000564' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437860'
                WHERE ordernumber = 'P2412210000568' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315957'
                WHERE ordernumber = 'P2412210000571' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437865'
                WHERE ordernumber = 'P2412210000573' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437864'
                WHERE ordernumber = 'P2412210000575' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315957'
                WHERE ordernumber = 'P2412210000576' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422480'
                WHERE ordernumber = 'P2412210000577' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437866'
                WHERE ordernumber = 'P2412210000578' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437867'
                WHERE ordernumber = 'P2412210000581' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437869'
                WHERE ordernumber = 'P2412210000594' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437870'
                WHERE ordernumber = 'P2412210000599' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P2412210000600' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437874'
                WHERE ordernumber = 'P2412210000602' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437871'
                WHERE ordernumber = 'P2412210000603' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437875'
                WHERE ordernumber = 'P2412210000606' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437878'
                WHERE ordernumber = 'P2412210000611' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '431499'
                WHERE ordernumber = 'P2412210000612' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437880'
                WHERE ordernumber = 'P2412210000613' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437879'
                WHERE ordernumber = 'P2412210000614' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425761'
                WHERE ordernumber = 'P2412210000615' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140350'
                WHERE ordernumber = 'P2412210000620' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437882'
                WHERE ordernumber = 'P2412210000621' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437883'
                WHERE ordernumber = 'P2412210000630' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368810'
                WHERE ordernumber = 'P2412210000632' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '151774'
                WHERE ordernumber = 'P2412210000641' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437886'
                WHERE ordernumber = 'P2412210000648' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255362'
                WHERE ordernumber = 'P2412210000653' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290609'
                WHERE ordernumber = 'P2412210000656' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437887'
                WHERE ordernumber = 'P2412210000661' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437888'
                WHERE ordernumber = 'P2412210000662' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437890'
                WHERE ordernumber = 'P2412210000666' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437891'
                WHERE ordernumber = 'P2412210000668' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437892'
                WHERE ordernumber = 'P2412210000670' 
            
2024-12-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223821'
                WHERE ordernumber = 'P2412210000672' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385841'
                WHERE ordernumber = 'P2412210000681' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337221'
                WHERE ordernumber = 'P2412210000682' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437894'
                WHERE ordernumber = 'P2412210000684' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P2412210000690' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246602'
                WHERE ordernumber = 'P2412210000693' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307185'
                WHERE ordernumber = 'P2412210000694' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437899'
                WHERE ordernumber = 'P2412210000697' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437900'
                WHERE ordernumber = 'P2412210000699' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437896'
                WHERE ordernumber = 'P2412210000708' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437897'
                WHERE ordernumber = 'P2412210000711' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437898'
                WHERE ordernumber = 'P2412210000719' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437897'
                WHERE ordernumber = 'P2412210000720' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402269'
                WHERE ordernumber = 'P2412210000729' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343618'
                WHERE ordernumber = 'P2412210000734' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437908'
                WHERE ordernumber = 'P2412210000742' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263148'
                WHERE ordernumber = 'P2412210000744' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333626'
                WHERE ordernumber = 'P2412210000747' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '206722'
                WHERE ordernumber = 'P2412210000749' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437438'
                WHERE ordernumber = 'P2412210000751' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437437'
                WHERE ordernumber = 'P2412210000753' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333626'
                WHERE ordernumber = 'P2412210000757' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '432118'
                WHERE ordernumber = 'P2412210000758' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428946'
                WHERE ordernumber = 'P2412210000760' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '123995'
                WHERE ordernumber = 'P2412210000762' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436878'
                WHERE ordernumber = 'P2412210000764' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437909'
                WHERE ordernumber = 'P2412210000765' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436878'
                WHERE ordernumber = 'P2412210000766' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346591'
                WHERE ordernumber = 'P2412210000767' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437911'
                WHERE ordernumber = 'P2412210000768' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437913'
                WHERE ordernumber = 'P2412210000773' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '436761'
                WHERE ordernumber = 'P2412210000782' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407952'
                WHERE ordernumber = 'P2412210000786' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '266404'
                WHERE ordernumber = 'P2412210000789' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166977'
                WHERE ordernumber = 'P2412210000790' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '51141'
                WHERE ordernumber = 'P2412210000795' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '435694'
                WHERE ordernumber = 'P2412210000800' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414719'
                WHERE ordernumber = 'P2412210000801' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401847'
                WHERE ordernumber = 'P2412210000809' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401847'
                WHERE ordernumber = 'P2412210000819' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437918'
                WHERE ordernumber = 'P2412210000822' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120318'
                WHERE ordernumber = 'P2412210000825' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P2412210000830' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '433468'
                WHERE ordernumber = 'P2412210000840' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94585'
                WHERE ordernumber = 'P2412210000843' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431889'
                WHERE ordernumber = 'P2412210000846' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437922'
                WHERE ordernumber = 'P2412210000850' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437926'
                WHERE ordernumber = 'P2412210000861' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437928'
                WHERE ordernumber = 'P2412210000866' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '425312'
                WHERE ordernumber = 'P2412210000872' 
            
2024-12-22 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '437933'
                WHERE ordernumber = 'P2412210000876'