2025-03-08 01:00:02 -- 將會員中心id寫入data-lake
2025-03-08 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-03-07%';
        
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '457139'
                WHERE ordernumber = 'P2503070000019' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459779'
                WHERE ordernumber = 'P2503070000020' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435768'
                WHERE ordernumber = 'P2503070000021' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459596'
                WHERE ordernumber = 'P2503070000022' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459780'
                WHERE ordernumber = 'P2503070000027' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459782'
                WHERE ordernumber = 'P2503070000029' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459781'
                WHERE ordernumber = 'P2503070000030' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459783'
                WHERE ordernumber = 'P2503070000031' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267151'
                WHERE ordernumber = 'P2503070000034' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459783'
                WHERE ordernumber = 'P2503070000035' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384251'
                WHERE ordernumber = 'P2503070000036' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459784'
                WHERE ordernumber = 'P2503070000037' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459785'
                WHERE ordernumber = 'P2503070000038' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459596'
                WHERE ordernumber = 'P2503070000040' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328345'
                WHERE ordernumber = 'P2503070000041' 
            
2025-03-08 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '459786'
                WHERE ordernumber = 'P2503070000044' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295106'
                WHERE ordernumber = 'P2503070000045' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410014'
                WHERE ordernumber = 'P2503070000047' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P2503070000048' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396028'
                WHERE ordernumber = 'P2503070000049' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99506'
                WHERE ordernumber = 'P2503070000050' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99506'
                WHERE ordernumber = 'P2503070000051' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459626'
                WHERE ordernumber = 'P2503070000052' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459788'
                WHERE ordernumber = 'P2503070000054' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '455311'
                WHERE ordernumber = 'P2503070000055' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102338'
                WHERE ordernumber = 'P2503070000058' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130800'
                WHERE ordernumber = 'P2503070000061' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459791'
                WHERE ordernumber = 'P2503070000062' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2503070000065' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459792'
                WHERE ordernumber = 'P2503070000068' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '458734'
                WHERE ordernumber = 'P2503070000069' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459794'
                WHERE ordernumber = 'P2503070000070' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459793'
                WHERE ordernumber = 'P2503070000071' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459795'
                WHERE ordernumber = 'P2503070000073' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459796'
                WHERE ordernumber = 'P2503070000074' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268446'
                WHERE ordernumber = 'P2503070000075' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459797'
                WHERE ordernumber = 'P2503070000077' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376366'
                WHERE ordernumber = 'P2503070000078' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459798'
                WHERE ordernumber = 'P2503070000083' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459799'
                WHERE ordernumber = 'P2503070000084' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459800'
                WHERE ordernumber = 'P2503070000090' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279451'
                WHERE ordernumber = 'P2503070000092' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294889'
                WHERE ordernumber = 'P2503070000099' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253769'
                WHERE ordernumber = 'P2503070000100' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422144'
                WHERE ordernumber = 'P2503070000103' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399685'
                WHERE ordernumber = 'P2503070000104' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52118'
                WHERE ordernumber = 'P2503070000105' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459802'
                WHERE ordernumber = 'P2503070000107' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296850'
                WHERE ordernumber = 'P2503070000109' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459790'
                WHERE ordernumber = 'P2503070000116' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459804'
                WHERE ordernumber = 'P2503070000119' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459807'
                WHERE ordernumber = 'P2503070000126' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459805'
                WHERE ordernumber = 'P2503070000127' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343703'
                WHERE ordernumber = 'P2503070000128' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459801'
                WHERE ordernumber = 'P2503070000130' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459808'
                WHERE ordernumber = 'P2503070000131' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459513'
                WHERE ordernumber = 'P2503070000132' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P2503070000133' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459809'
                WHERE ordernumber = 'P2503070000135' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459810'
                WHERE ordernumber = 'P2503070000137' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '59256'
                WHERE ordernumber = 'P2503070000138' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459811'
                WHERE ordernumber = 'P2503070000144' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '453283'
                WHERE ordernumber = 'P2503070000145' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459812'
                WHERE ordernumber = 'P2503070000147' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P2503070000150' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105694'
                WHERE ordernumber = 'P2503070000155' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459815'
                WHERE ordernumber = 'P2503070000156' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384597'
                WHERE ordernumber = 'P2503070000157' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238978'
                WHERE ordernumber = 'P2503070000163' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P2503070000164' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381834'
                WHERE ordernumber = 'P2503070000166' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303338'
                WHERE ordernumber = 'P2503070000167' 
            
2025-03-08 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '459817'
                WHERE ordernumber = 'P2503070000168' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459816'
                WHERE ordernumber = 'P2503070000170' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281545'
                WHERE ordernumber = 'P2503070000172' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459818'
                WHERE ordernumber = 'P2503070000174' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459820'
                WHERE ordernumber = 'P2503070000178' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459821'
                WHERE ordernumber = 'P2503070000179' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459819'
                WHERE ordernumber = 'P2503070000182' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P2503070000183' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380454'
                WHERE ordernumber = 'P2503070000184' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P2503070000185' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459820'
                WHERE ordernumber = 'P2503070000187' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459820'
                WHERE ordernumber = 'P2503070000188' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '458273'
                WHERE ordernumber = 'P2503070000189' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459823'
                WHERE ordernumber = 'P2503070000191' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459824'
                WHERE ordernumber = 'P2503070000193' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459825'
                WHERE ordernumber = 'P2503070000196' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217554'
                WHERE ordernumber = 'P2503070000197' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418898'
                WHERE ordernumber = 'P2503070000198' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236244'
                WHERE ordernumber = 'P2503070000204' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459827'
                WHERE ordernumber = 'P2503070000208' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459828'
                WHERE ordernumber = 'P2503070000210' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459826'
                WHERE ordernumber = 'P2503070000212' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148717'
                WHERE ordernumber = 'P2503070000214' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310414'
                WHERE ordernumber = 'P2503070000215' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459829'
                WHERE ordernumber = 'P2503070000216' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394340'
                WHERE ordernumber = 'P2503070000218' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459830'
                WHERE ordernumber = 'P2503070000219' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '456148'
                WHERE ordernumber = 'P2503070000222' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P2503070000224' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459831'
                WHERE ordernumber = 'P2503070000227' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459832'
                WHERE ordernumber = 'P2503070000230' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459833'
                WHERE ordernumber = 'P2503070000231' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364605'
                WHERE ordernumber = 'P2503070000233' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137581'
                WHERE ordernumber = 'P2503070000234' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '120521'
                WHERE ordernumber = 'P2503070000235' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66828'
                WHERE ordernumber = 'P2503070000238' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '46581'
                WHERE ordernumber = 'P2503070000239' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116210'
                WHERE ordernumber = 'P2503070000243' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116210'
                WHERE ordernumber = 'P2503070000244' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457095'
                WHERE ordernumber = 'P2503070000245' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66828'
                WHERE ordernumber = 'P2503070000249' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459837'
                WHERE ordernumber = 'P2503070000251' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66828'
                WHERE ordernumber = 'P2503070000252' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66828'
                WHERE ordernumber = 'P2503070000253' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '457793'
                WHERE ordernumber = 'P2503070000255' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99048'
                WHERE ordernumber = 'P2503070000257' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459838'
                WHERE ordernumber = 'P2503070000259' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459839'
                WHERE ordernumber = 'P2503070000261' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459841'
                WHERE ordernumber = 'P2503070000265' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459842'
                WHERE ordernumber = 'P2503070000266' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396609'
                WHERE ordernumber = 'P2503070000268' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380932'
                WHERE ordernumber = 'P2503070000269' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459843'
                WHERE ordernumber = 'P2503070000270' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '455052'
                WHERE ordernumber = 'P2503070000271' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276843'
                WHERE ordernumber = 'P2503070000273' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459844'
                WHERE ordernumber = 'P2503070000274' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459164'
                WHERE ordernumber = 'P2503070000279' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '459164'
                WHERE ordernumber = 'P2503070000281' 
            
2025-03-08 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '454099'
                WHERE ordernumber = 'P2503070000282' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459845'
                WHERE ordernumber = 'P2503070000283' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459840'
                WHERE ordernumber = 'P2503070000285' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408026'
                WHERE ordernumber = 'P2503070000287' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459846'
                WHERE ordernumber = 'P2503070000288' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230919'
                WHERE ordernumber = 'P2503070000293' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125508'
                WHERE ordernumber = 'P2503070000296' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459847'
                WHERE ordernumber = 'P2503070000299' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223258'
                WHERE ordernumber = 'P2503070000303' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '456311'
                WHERE ordernumber = 'P2503070000302' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426798'
                WHERE ordernumber = 'P2503070000300' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '137217'
                WHERE ordernumber = 'P2503070000306' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285590'
                WHERE ordernumber = 'P2503070000307' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459848'
                WHERE ordernumber = 'P2503070000308' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457373'
                WHERE ordernumber = 'P2503070000310' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431730'
                WHERE ordernumber = 'P2503070000311' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423712'
                WHERE ordernumber = 'P2503070000313' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459851'
                WHERE ordernumber = 'P2503070000314' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457947'
                WHERE ordernumber = 'P2503070000321' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459852'
                WHERE ordernumber = 'P2503070000322' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P2503070000328' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '431365'
                WHERE ordernumber = 'P2503070000330' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171252'
                WHERE ordernumber = 'P2503070000334' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384260'
                WHERE ordernumber = 'P2503070000336' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '234726'
                WHERE ordernumber = 'P2503070000340' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459853'
                WHERE ordernumber = 'P2503070000343' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313293'
                WHERE ordernumber = 'P2503070000344' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209488'
                WHERE ordernumber = 'P2503070000347' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459849'
                WHERE ordernumber = 'P2503070000348' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93158'
                WHERE ordernumber = 'P2503070000349' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99549'
                WHERE ordernumber = 'P2503070000350' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226753'
                WHERE ordernumber = 'P2503070000351' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '35985'
                WHERE ordernumber = 'P2503070000353' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459856'
                WHERE ordernumber = 'P2503070000355' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289137'
                WHERE ordernumber = 'P2503070000356' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459857'
                WHERE ordernumber = 'P2503070000360' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459858'
                WHERE ordernumber = 'P2503070000364' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402601'
                WHERE ordernumber = 'P2503070000367' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459860'
                WHERE ordernumber = 'P2503070000369' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459859'
                WHERE ordernumber = 'P2503070000371' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459855'
                WHERE ordernumber = 'P2503070000373' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128332'
                WHERE ordernumber = 'P2503070000375' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105856'
                WHERE ordernumber = 'P2503070000377' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289137'
                WHERE ordernumber = 'P2503070000382' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459861'
                WHERE ordernumber = 'P2503070000384' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220826'
                WHERE ordernumber = 'P2503070000387' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459862'
                WHERE ordernumber = 'P2503070000388' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291489'
                WHERE ordernumber = 'P2503070000392' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P2503070000397' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '148683'
                WHERE ordernumber = 'P2503070000403' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459863'
                WHERE ordernumber = 'P2503070000407' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '457595'
                WHERE ordernumber = 'P2503070000411' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95192'
                WHERE ordernumber = 'P2503070000412' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459575'
                WHERE ordernumber = 'P2503070000414' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296871'
                WHERE ordernumber = 'P2503070000432' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P2503070000435' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459865'
                WHERE ordernumber = 'P2503070000439' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459865'
                WHERE ordernumber = 'P2503070000441' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331823'
                WHERE ordernumber = 'P2503070000450' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249104'
                WHERE ordernumber = 'P2503070000451' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351724'
                WHERE ordernumber = 'P2503070000455' 
            
2025-03-08 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '459868'
                WHERE ordernumber = 'P2503070000456' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459869'
                WHERE ordernumber = 'P2503070000457' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459870'
                WHERE ordernumber = 'P2503070000458' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459867'
                WHERE ordernumber = 'P2503070000460' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459871'
                WHERE ordernumber = 'P2503070000461' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459872'
                WHERE ordernumber = 'P2503070000469' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '166466'
                WHERE ordernumber = 'P2503070000472' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '421995'
                WHERE ordernumber = 'P2503070000475' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459875'
                WHERE ordernumber = 'P2503070000476' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459874'
                WHERE ordernumber = 'P2503070000477' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '249104'
                WHERE ordernumber = 'P2503070000478' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '388995'
                WHERE ordernumber = 'P2503070000479' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459876'
                WHERE ordernumber = 'P2503070000480' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341121'
                WHERE ordernumber = 'P2503070000481' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '313565'
                WHERE ordernumber = 'P2503070000483' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459725'
                WHERE ordernumber = 'P2503070000484' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459878'
                WHERE ordernumber = 'P2503070000486' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '115574'
                WHERE ordernumber = 'P2503070000487' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459879'
                WHERE ordernumber = 'P2503070000489' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304583'
                WHERE ordernumber = 'P2503070000491' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459878'
                WHERE ordernumber = 'P2503070000492' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459880'
                WHERE ordernumber = 'P2503070000493' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '256779'
                WHERE ordernumber = 'P2503070000494' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459882'
                WHERE ordernumber = 'P2503070000496' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459883'
                WHERE ordernumber = 'P2503070000497' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '242527'
                WHERE ordernumber = 'P2503070000498' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459884'
                WHERE ordernumber = 'P2503070000499' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459885'
                WHERE ordernumber = 'P2503070000503' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '435448'
                WHERE ordernumber = 'P2503070000504' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459886'
                WHERE ordernumber = 'P2503070000506' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459889'
                WHERE ordernumber = 'P2503070000515' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459887'
                WHERE ordernumber = 'P2503070000516' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '208484'
                WHERE ordernumber = 'P2503070000517' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '83943'
                WHERE ordernumber = 'P2503070000526' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459890'
                WHERE ordernumber = 'P2503070000527' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '114397'
                WHERE ordernumber = 'P2503070000529' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '420793'
                WHERE ordernumber = 'P2503070000533' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '219936'
                WHERE ordernumber = 'P2503070000539' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459891'
                WHERE ordernumber = 'P2503070000541' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P2503070000544' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459892'
                WHERE ordernumber = 'P2503070000547' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459893'
                WHERE ordernumber = 'P2503070000550' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '333134'
                WHERE ordernumber = 'P2503070000551' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '445025'
                WHERE ordernumber = 'P2503070000554' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459894'
                WHERE ordernumber = 'P2503070000556' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '456683'
                WHERE ordernumber = 'P2503070000558' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '128419'
                WHERE ordernumber = 'P2503070000560' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459895'
                WHERE ordernumber = 'P2503070000562' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346820'
                WHERE ordernumber = 'P2503070000565' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304079'
                WHERE ordernumber = 'P2503070000566' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459898'
                WHERE ordernumber = 'P2503070000571' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459899'
                WHERE ordernumber = 'P2503070000573' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '308117'
                WHERE ordernumber = 'P2503070000574' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459900'
                WHERE ordernumber = 'P2503070000578' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341046'
                WHERE ordernumber = 'P2503070000583' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '438834'
                WHERE ordernumber = 'P2503070000584' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459901'
                WHERE ordernumber = 'P2503070000585' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '223891'
                WHERE ordernumber = 'P2503070000590' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '247906'
                WHERE ordernumber = 'P2503070000592' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '428519'
                WHERE ordernumber = 'P2503070000593' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459902'
                WHERE ordernumber = 'P2503070000601' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '457390'
                WHERE ordernumber = 'P2503070000602' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '288124'
                WHERE ordernumber = 'P2503070000603' 
            
2025-03-08 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '459903'
                WHERE ordernumber = 'P2503070000608' 
            
2025-03-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '211931'
                WHERE ordernumber = 'P2503070000609' 
            
2025-03-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '459905'
                WHERE ordernumber = 'P2503070000611' 
            
2025-03-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '276436'
                WHERE ordernumber = 'P2503070000612' 
            
2025-03-08 01:00:07 -- 
                UPDATE `omo_order_list` SET userId = '459907'
                WHERE ordernumber = 'P2503070000620'