2024-06-05 01:00:01 -- 將會員中心id寫入data-lake
2024-06-05 01:00:01 -- 
            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-06-04%';
        
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394071'
                WHERE ordernumber = 'P180604110527290' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392131'
                WHERE ordernumber = 'P200604111106657' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394073'
                WHERE ordernumber = 'P200604111310323' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392131'
                WHERE ordernumber = 'P200604111348597' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120327'
                WHERE ordernumber = 'P200604111438546' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139543'
                WHERE ordernumber = 'P200604111552616' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231324'
                WHERE ordernumber = 'P180604111717897' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249085'
                WHERE ordernumber = 'P190604112520245' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394078'
                WHERE ordernumber = 'P180604112712966' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107950'
                WHERE ordernumber = 'P180604112837357' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394079'
                WHERE ordernumber = 'P710604112859116' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253962'
                WHERE ordernumber = 'P180604112923819' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394080'
                WHERE ordernumber = 'P200604112932930' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394081'
                WHERE ordernumber = 'P420604113114732' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328514'
                WHERE ordernumber = 'P200604113422630' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289706'
                WHERE ordernumber = 'P200604113524218' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394083'
                WHERE ordernumber = 'P420604113633622' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391544'
                WHERE ordernumber = 'P420604113715241' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394082'
                WHERE ordernumber = 'P420604113742162' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394084'
                WHERE ordernumber = 'P180604113945150' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394085'
                WHERE ordernumber = 'P200604114048520' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394086'
                WHERE ordernumber = 'P420604114251372' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394084'
                WHERE ordernumber = 'P180604114502705' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394084'
                WHERE ordernumber = 'P180604114542461' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394088'
                WHERE ordernumber = 'P420604114631253' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129362'
                WHERE ordernumber = 'P420604115017242' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390343'
                WHERE ordernumber = 'P420604115117693' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394089'
                WHERE ordernumber = 'P190604115152765' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394090'
                WHERE ordernumber = 'P420604115220907' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235519'
                WHERE ordernumber = 'P180604120207721' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394091'
                WHERE ordernumber = 'P420604120259441' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P200604120410324' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391887'
                WHERE ordernumber = 'P200604120629865' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393519'
                WHERE ordernumber = 'P200604121153184' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394092'
                WHERE ordernumber = 'P180604121313546' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394072'
                WHERE ordernumber = 'P420604121432476' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394093'
                WHERE ordernumber = 'P200604121502473' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286929'
                WHERE ordernumber = 'P200604122203541' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394097'
                WHERE ordernumber = 'P630604123010179' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '76247'
                WHERE ordernumber = 'P180604123514604' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385766'
                WHERE ordernumber = 'P630604123554467' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332122'
                WHERE ordernumber = 'P180604124159537' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366139'
                WHERE ordernumber = 'P420604124634966' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237758'
                WHERE ordernumber = 'P180604124858269' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389529'
                WHERE ordernumber = 'P420604124930824' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394102'
                WHERE ordernumber = 'P630604125218642' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393929'
                WHERE ordernumber = 'P200604125334740' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143188'
                WHERE ordernumber = 'P180604125444955' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394103'
                WHERE ordernumber = 'P200604125529978' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94248'
                WHERE ordernumber = 'P200604125700434' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394104'
                WHERE ordernumber = 'P630604125704184' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394105'
                WHERE ordernumber = 'P200604130007623' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394107'
                WHERE ordernumber = 'P630604130202519' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343961'
                WHERE ordernumber = 'P200604130232251' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394109'
                WHERE ordernumber = 'P420604130432366' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378449'
                WHERE ordernumber = 'P420604130810625' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390071'
                WHERE ordernumber = 'P420604131129731' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180604131444231' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394113'
                WHERE ordernumber = 'P180604131627993' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394114'
                WHERE ordernumber = 'P200604131650911' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394115'
                WHERE ordernumber = 'P200604131748458' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180604131835873' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394117'
                WHERE ordernumber = 'P420604131943235' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394115'
                WHERE ordernumber = 'P200604132119405' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98265'
                WHERE ordernumber = 'P180604132206187' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394120'
                WHERE ordernumber = 'P420604132635467' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394121'
                WHERE ordernumber = 'P420604132740258' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242982'
                WHERE ordernumber = 'P200604133520592' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394124'
                WHERE ordernumber = 'P780604133812375' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394127'
                WHERE ordernumber = 'P180604134110416' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180604134146441' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200604134214954' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '144274'
                WHERE ordernumber = 'P200604135020279' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394130'
                WHERE ordernumber = 'P420604135036803' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394131'
                WHERE ordernumber = 'P200604135117729' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282471'
                WHERE ordernumber = 'P710604135423303' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394133'
                WHERE ordernumber = 'P190604135505234' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394134'
                WHERE ordernumber = 'P180604135529790' 
            
2024-06-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394135'
                WHERE ordernumber = 'P200604135620548' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394137'
                WHERE ordernumber = 'P200604135735743' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361177'
                WHERE ordernumber = 'P180604135807553' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218910'
                WHERE ordernumber = 'P200604140221625' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394139'
                WHERE ordernumber = 'P200604140552472' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297405'
                WHERE ordernumber = 'P200604140658674' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394142'
                WHERE ordernumber = 'P420604141519613' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121380'
                WHERE ordernumber = 'P200604141944579' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350993'
                WHERE ordernumber = 'P180604142013867' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394143'
                WHERE ordernumber = 'P180604142506415' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394144'
                WHERE ordernumber = 'P420604142622738' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394146'
                WHERE ordernumber = 'P180604142706138' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281268'
                WHERE ordernumber = 'P200604142754915' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394148'
                WHERE ordernumber = 'P200604143022505' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394147'
                WHERE ordernumber = 'P420604143024281' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393993'
                WHERE ordernumber = 'P200604143130313' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394149'
                WHERE ordernumber = 'P180604143319810' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394151'
                WHERE ordernumber = 'P180604143854518' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384309'
                WHERE ordernumber = 'P200604143944380' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385731'
                WHERE ordernumber = 'P630604144021952' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394152'
                WHERE ordernumber = 'P200604144306857' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219667'
                WHERE ordernumber = 'P200604144434244' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99397'
                WHERE ordernumber = 'P420604144602696' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150084'
                WHERE ordernumber = 'P630604144746963' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180604144906186' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288090'
                WHERE ordernumber = 'P180604145042868' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394157'
                WHERE ordernumber = 'P200604145209423' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394158'
                WHERE ordernumber = 'P420604145344524' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394159'
                WHERE ordernumber = 'P200604145345829' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341057'
                WHERE ordernumber = 'P190604150456730' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393960'
                WHERE ordernumber = 'P420604150535756' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394161'
                WHERE ordernumber = 'P420604150645710' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109673'
                WHERE ordernumber = 'P180604150901786' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394162'
                WHERE ordernumber = 'P200604150939339' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26395'
                WHERE ordernumber = 'P420604151250800' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26395'
                WHERE ordernumber = 'P420604151621629' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227737'
                WHERE ordernumber = 'P180604151820118' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420604152046362' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142359'
                WHERE ordernumber = 'P180604152624278' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211642'
                WHERE ordernumber = 'P180604153053283' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394135'
                WHERE ordernumber = 'P200604153213241' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394167'
                WHERE ordernumber = 'P200604153433439' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303531'
                WHERE ordernumber = 'P180604153624367' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219550'
                WHERE ordernumber = 'P200604153733614' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394169'
                WHERE ordernumber = 'P420604153850735' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394170'
                WHERE ordernumber = 'P180604154014922' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394172'
                WHERE ordernumber = 'P180604154152264' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P190604154514138' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394173'
                WHERE ordernumber = 'P200604154552582' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P180604154614413' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P180604154654918' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394174'
                WHERE ordernumber = 'P420604154746773' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394174'
                WHERE ordernumber = 'P420604154949793' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394175'
                WHERE ordernumber = 'P180604154949856' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394174'
                WHERE ordernumber = 'P420604155115640' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16'
                WHERE ordernumber = 'P180604155231801' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394176'
                WHERE ordernumber = 'P710604155426831' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16'
                WHERE ordernumber = 'P180604155535525' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394177'
                WHERE ordernumber = 'P420604160003972' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394178'
                WHERE ordernumber = 'P420604160125170' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319508'
                WHERE ordernumber = 'P420604160204547' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389586'
                WHERE ordernumber = 'P200604160739792' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392574'
                WHERE ordernumber = 'P420604161654339' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394179'
                WHERE ordernumber = 'P180604161735201' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333352'
                WHERE ordernumber = 'P420604162147657' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394181'
                WHERE ordernumber = 'P190604162355175' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394182'
                WHERE ordernumber = 'P190604162704196' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341084'
                WHERE ordernumber = 'P200604162704347' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310642'
                WHERE ordernumber = 'P710604162928319' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357276'
                WHERE ordernumber = 'P190604163004533' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336070'
                WHERE ordernumber = 'P180604163632622' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394185'
                WHERE ordernumber = 'P710604163725510' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394186'
                WHERE ordernumber = 'P180604163956281' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394187'
                WHERE ordernumber = 'P420604164113956' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132813'
                WHERE ordernumber = 'P180604164424856' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394188'
                WHERE ordernumber = 'P630604164642706' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394189'
                WHERE ordernumber = 'P180604164703465' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394189'
                WHERE ordernumber = 'P180604165008212' 
            
2024-06-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394191'
                WHERE ordernumber = 'P420604165546544' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325358'
                WHERE ordernumber = 'P420604165623258' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394192'
                WHERE ordernumber = 'P710604165741751' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394193'
                WHERE ordernumber = 'P420604165820287' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394194'
                WHERE ordernumber = 'P200604170731460' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394156'
                WHERE ordernumber = 'P200604170934839' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377658'
                WHERE ordernumber = 'P420604170957475' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165442'
                WHERE ordernumber = 'P200604171438681' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394197'
                WHERE ordernumber = 'P200604171937649' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287257'
                WHERE ordernumber = 'P180604172621781' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394202'
                WHERE ordernumber = 'P420604172645122' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212418'
                WHERE ordernumber = 'P180604172927292' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383533'
                WHERE ordernumber = 'P180604173534990' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394206'
                WHERE ordernumber = 'P420604174557565' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103806'
                WHERE ordernumber = 'P180604174731992' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173298'
                WHERE ordernumber = 'P710604174949633' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326783'
                WHERE ordernumber = 'P200604175234409' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394209'
                WHERE ordernumber = 'P420604175422198' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394210'
                WHERE ordernumber = 'P200604175427186' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394211'
                WHERE ordernumber = 'P200604175613546' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394212'
                WHERE ordernumber = 'P200604175758723' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394213'
                WHERE ordernumber = 'P630604180000357' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313158'
                WHERE ordernumber = 'P420604180105946' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304578'
                WHERE ordernumber = 'P420604180242142' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394216'
                WHERE ordernumber = 'P420604180352687' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394217'
                WHERE ordernumber = 'P200604180735337' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105426'
                WHERE ordernumber = 'P200604180812286' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394218'
                WHERE ordernumber = 'P200604180951649' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394219'
                WHERE ordernumber = 'P180604181307841' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394220'
                WHERE ordernumber = 'P420604181411542' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394223'
                WHERE ordernumber = 'P420604181524744' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394224'
                WHERE ordernumber = 'P180604181643702' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '193713'
                WHERE ordernumber = 'P420604181727913' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393554'
                WHERE ordernumber = 'P420604181904915' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394222'
                WHERE ordernumber = 'P200604182018894' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394225'
                WHERE ordernumber = 'P420604182345955' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305740'
                WHERE ordernumber = 'P200604182417712' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104875'
                WHERE ordernumber = 'P190604182506456' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394226'
                WHERE ordernumber = 'P420604182625831' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394227'
                WHERE ordernumber = 'P420604182722489' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337722'
                WHERE ordernumber = 'P630604182826258' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220787'
                WHERE ordernumber = 'P780604182921989' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262581'
                WHERE ordernumber = 'P190604183204698' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394228'
                WHERE ordernumber = 'P200604183243763' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394231'
                WHERE ordernumber = 'P190604183558388' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260853'
                WHERE ordernumber = 'P180604184014470' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394233'
                WHERE ordernumber = 'P200604184114647' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200604184740474' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268404'
                WHERE ordernumber = 'P200604184914709' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P190604185339131' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394234'
                WHERE ordernumber = 'P200604185422789' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394235'
                WHERE ordernumber = 'P630604185742567' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105194'
                WHERE ordernumber = 'P190604185749607' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304242'
                WHERE ordernumber = 'P420604185946149' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394236'
                WHERE ordernumber = 'P420604190139969' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394238'
                WHERE ordernumber = 'P200604190631810' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394229'
                WHERE ordernumber = 'P710604190910334' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394239'
                WHERE ordernumber = 'P200604191420333' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135173'
                WHERE ordernumber = 'P200604191850510' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394240'
                WHERE ordernumber = 'P200604192244808' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394241'
                WHERE ordernumber = 'P200604192703585' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394242'
                WHERE ordernumber = 'P590604192808349' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286225'
                WHERE ordernumber = 'P200604192838295' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335163'
                WHERE ordernumber = 'P200604193001378' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388844'
                WHERE ordernumber = 'P630604193147621' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394243'
                WHERE ordernumber = 'P190604194103617' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394244'
                WHERE ordernumber = 'P200604194359988' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394245'
                WHERE ordernumber = 'P200604194532913' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394246'
                WHERE ordernumber = 'P200604194720152' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297641'
                WHERE ordernumber = 'P190604194814967' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394247'
                WHERE ordernumber = 'P200604194838190' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '83896'
                WHERE ordernumber = 'P200604195054111' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394248'
                WHERE ordernumber = 'P200604195303477' 
            
2024-06-05 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394250'
                WHERE ordernumber = 'P710604202238119' 
            
2024-06-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394254'
                WHERE ordernumber = 'P710604204345885' 
            
2024-06-05 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '345661'
                WHERE ordernumber = 'P630604211043837'