2024-06-04 01:00:01 -- 將會員中心id寫入data-lake
2024-06-04 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-03%';
        
2024-06-04 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180603110150188' 
            
2024-06-04 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '137475'
                WHERE ordernumber = 'P200603110156611' 
            
2024-06-04 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '393867'
                WHERE ordernumber = 'P630603110336891' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P200603110435475' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354182'
                WHERE ordernumber = 'P180603110458986' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349554'
                WHERE ordernumber = 'P190603110630219' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369255'
                WHERE ordernumber = 'P180603110658994' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133909'
                WHERE ordernumber = 'P190603110800819' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393869'
                WHERE ordernumber = 'P710603110808535' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237374'
                WHERE ordernumber = 'P180603110837639' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344536'
                WHERE ordernumber = 'P190603110939939' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393870'
                WHERE ordernumber = 'P420603111033393' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393871'
                WHERE ordernumber = 'P630603111149937' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393872'
                WHERE ordernumber = 'P420603111245223' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287111'
                WHERE ordernumber = 'P200603111246648' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283342'
                WHERE ordernumber = 'P420603111418210' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390329'
                WHERE ordernumber = 'P200603111921291' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391898'
                WHERE ordernumber = 'P180603112303953' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392606'
                WHERE ordernumber = 'P180603112348347' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274730'
                WHERE ordernumber = 'P710603113013467' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393874'
                WHERE ordernumber = 'P420603113032223' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110695'
                WHERE ordernumber = 'P180603113112521' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342428'
                WHERE ordernumber = 'P420603113249765' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P200603113431125' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380586'
                WHERE ordernumber = 'P420603113535804' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '173213'
                WHERE ordernumber = 'P180603113730281' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200603114746528' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380586'
                WHERE ordernumber = 'P420603114916738' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346678'
                WHERE ordernumber = 'P200603114921356' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393879'
                WHERE ordernumber = 'P200603115137238' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393880'
                WHERE ordernumber = 'P200603115529290' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390489'
                WHERE ordernumber = 'P420603115811336' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239817'
                WHERE ordernumber = 'P200603120410898' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393884'
                WHERE ordernumber = 'P420603120853320' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393885'
                WHERE ordernumber = 'P200603121605338' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356275'
                WHERE ordernumber = 'P180603121913487' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393887'
                WHERE ordernumber = 'P420603122050626' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393888'
                WHERE ordernumber = 'P780603122254488' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393891'
                WHERE ordernumber = 'P420603122743261' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348972'
                WHERE ordernumber = 'P180603123102912' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393892'
                WHERE ordernumber = 'P420603123307873' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299637'
                WHERE ordernumber = 'P710603124102968' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343205'
                WHERE ordernumber = 'P200603124321943' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393896'
                WHERE ordernumber = 'P420603124538341' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393845'
                WHERE ordernumber = 'P420603124642478' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393898'
                WHERE ordernumber = 'P200603125932590' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180603125954153' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63005'
                WHERE ordernumber = 'P200603130231602' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293456'
                WHERE ordernumber = 'P200603130707124' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P200603131035883' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337926'
                WHERE ordernumber = 'P200603131131372' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P200603131347892' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393902'
                WHERE ordernumber = 'P190603131859366' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392791'
                WHERE ordernumber = 'P420603132035201' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393904'
                WHERE ordernumber = 'P200603132048376' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393903'
                WHERE ordernumber = 'P200603132257115' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393906'
                WHERE ordernumber = 'P420603132259553' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136082'
                WHERE ordernumber = 'P200603132610312' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393907'
                WHERE ordernumber = 'P190603132651461' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304155'
                WHERE ordernumber = 'P630603132941465' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304155'
                WHERE ordernumber = 'P630603132944186' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P200603133053403' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393909'
                WHERE ordernumber = 'P780603133206833' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393910'
                WHERE ordernumber = 'P420603133711610' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393911'
                WHERE ordernumber = 'P180603133840414' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393911'
                WHERE ordernumber = 'P180603133920378' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393824'
                WHERE ordernumber = 'P420603134031697' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393824'
                WHERE ordernumber = 'P420603134122311' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393913'
                WHERE ordernumber = 'P200603134201460' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393914'
                WHERE ordernumber = 'P420603134256299' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393915'
                WHERE ordernumber = 'P200603134312404' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180603134542986' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393915'
                WHERE ordernumber = 'P200603134717625' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393916'
                WHERE ordernumber = 'P420603134924664' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393917'
                WHERE ordernumber = 'P420603135203592' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393919'
                WHERE ordernumber = 'P420603135450260' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158200'
                WHERE ordernumber = 'P200603135453921' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393918'
                WHERE ordernumber = 'P710603135525959' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200603135630555' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393920'
                WHERE ordernumber = 'P180603140056975' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393922'
                WHERE ordernumber = 'P420603140147174' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393925'
                WHERE ordernumber = 'P190603141316837' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393924'
                WHERE ordernumber = 'P180603141332979' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393881'
                WHERE ordernumber = 'P420603141424347' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393926'
                WHERE ordernumber = 'P420603141630151' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393927'
                WHERE ordernumber = 'P180603141727197' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '71938'
                WHERE ordernumber = 'P180603141921473' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393881'
                WHERE ordernumber = 'P420603142149261' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393881'
                WHERE ordernumber = 'P420603142219213' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264763'
                WHERE ordernumber = 'P200603142233457' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393851'
                WHERE ordernumber = 'P190603142437898' 
            
2024-06-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393929'
                WHERE ordernumber = 'P200603142715836' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129674'
                WHERE ordernumber = 'P180603142825116' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390975'
                WHERE ordernumber = 'P200603144108772' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265522'
                WHERE ordernumber = 'P180603144146218' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363631'
                WHERE ordernumber = 'P630603144203865' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393933'
                WHERE ordernumber = 'P420603144227817' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393935'
                WHERE ordernumber = 'P200603144640861' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390448'
                WHERE ordernumber = 'P420603145006642' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393936'
                WHERE ordernumber = 'P190603145006553' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393937'
                WHERE ordernumber = 'P200603145022176' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393939'
                WHERE ordernumber = 'P180603145521208' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44001'
                WHERE ordernumber = 'P420603145752633' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344320'
                WHERE ordernumber = 'P420603150038695' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393942'
                WHERE ordernumber = 'P200603151102436' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132769'
                WHERE ordernumber = 'P420603151353495' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348769'
                WHERE ordernumber = 'P630603151637288' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393759'
                WHERE ordernumber = 'P180603151655657' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390773'
                WHERE ordernumber = 'P200603151812607' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180603151926666' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393944'
                WHERE ordernumber = 'P200603151942829' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313262'
                WHERE ordernumber = 'P200603152058178' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393945'
                WHERE ordernumber = 'P420603152109497' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393946'
                WHERE ordernumber = 'P780603152524370' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393947'
                WHERE ordernumber = 'P200603152739847' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391348'
                WHERE ordernumber = 'P180603152803369' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207570'
                WHERE ordernumber = 'P190603152810704' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390886'
                WHERE ordernumber = 'P420603152817919' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393948'
                WHERE ordernumber = 'P200603152833671' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393950'
                WHERE ordernumber = 'P190603153341515' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P180603153525233' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372760'
                WHERE ordernumber = 'P420603153607116' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382109'
                WHERE ordernumber = 'P420603154449216' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382109'
                WHERE ordernumber = 'P420603155211143' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159448'
                WHERE ordernumber = 'P200603155419202' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393955'
                WHERE ordernumber = 'P420603155722628' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200603160030787' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393956'
                WHERE ordernumber = 'P710603160148243' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393957'
                WHERE ordernumber = 'P200603160401276' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '37630'
                WHERE ordernumber = 'P200603160501115' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231270'
                WHERE ordernumber = 'P200603160529484' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393952'
                WHERE ordernumber = 'P710603160617140' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393959'
                WHERE ordernumber = 'P190603160757961' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393960'
                WHERE ordernumber = 'P420603160951372' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393821'
                WHERE ordernumber = 'P200603161025460' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319584'
                WHERE ordernumber = 'P190603161132185' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224465'
                WHERE ordernumber = 'P200603161136404' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393952'
                WHERE ordernumber = 'P710603161149978' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367908'
                WHERE ordernumber = 'P200603161356863' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393963'
                WHERE ordernumber = 'P200603161542359' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393965'
                WHERE ordernumber = 'P200603161826576' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393966'
                WHERE ordernumber = 'P420603161920587' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393967'
                WHERE ordernumber = 'P420603162148642' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393968'
                WHERE ordernumber = 'P190603162334296' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351997'
                WHERE ordernumber = 'P200603162357747' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393969'
                WHERE ordernumber = 'P780603162552261' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339788'
                WHERE ordernumber = 'P200603162635793' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330020'
                WHERE ordernumber = 'P180603163044661' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393970'
                WHERE ordernumber = 'P200603163219290' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200603163403232' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393971'
                WHERE ordernumber = 'P180603163547972' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110354'
                WHERE ordernumber = 'P180603163904393' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331583'
                WHERE ordernumber = 'P420603164250828' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139849'
                WHERE ordernumber = 'P180603164928793' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393975'
                WHERE ordernumber = 'P200603165156412' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372327'
                WHERE ordernumber = 'P200603165400129' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393976'
                WHERE ordernumber = 'P420603165927489' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391755'
                WHERE ordernumber = 'P200603165958875' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276251'
                WHERE ordernumber = 'P200603170458712' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393980'
                WHERE ordernumber = 'P200603170619274' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317774'
                WHERE ordernumber = 'P180603170807288' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393982'
                WHERE ordernumber = 'P710603171144775' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393981'
                WHERE ordernumber = 'P200603171354982' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146133'
                WHERE ordernumber = 'P200603171452281' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99861'
                WHERE ordernumber = 'P190603171711297' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393984'
                WHERE ordernumber = 'P180603171807344' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393985'
                WHERE ordernumber = 'P200603172026271' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393986'
                WHERE ordernumber = 'P420603172309338' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393987'
                WHERE ordernumber = 'P180603172448797' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '178946'
                WHERE ordernumber = 'P420603172658426' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392621'
                WHERE ordernumber = 'P780603172806167' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387111'
                WHERE ordernumber = 'P200603172945763' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200908'
                WHERE ordernumber = 'P200603173102363' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393988'
                WHERE ordernumber = 'P180603173153281' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94857'
                WHERE ordernumber = 'P200603173533269' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149153'
                WHERE ordernumber = 'P200603173610366' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393991'
                WHERE ordernumber = 'P200603173919898' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393972'
                WHERE ordernumber = 'P200603174204626' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96208'
                WHERE ordernumber = 'P180603174332621' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393993'
                WHERE ordernumber = 'P200603174453142' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393994'
                WHERE ordernumber = 'P180603174956260' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180603175106196' 
            
2024-06-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208492'
                WHERE ordernumber = 'P180603175456680' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393997'
                WHERE ordernumber = 'P420603175531168' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200603175539271' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166469'
                WHERE ordernumber = 'P780603175626623' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200603175657760' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157398'
                WHERE ordernumber = 'P180603175937534' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278251'
                WHERE ordernumber = 'P200603180012552' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393999'
                WHERE ordernumber = 'P420603180311522' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124590'
                WHERE ordernumber = 'P190603180446721' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93809'
                WHERE ordernumber = 'P200603180757639' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100460'
                WHERE ordernumber = 'P180603181018288' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390102'
                WHERE ordernumber = 'P200603181438431' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375522'
                WHERE ordernumber = 'P180603181529302' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394000'
                WHERE ordernumber = 'P630603181756425' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394001'
                WHERE ordernumber = 'P180603181909929' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394002'
                WHERE ordernumber = 'P200603182109485' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394003'
                WHERE ordernumber = 'P200603182248592' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333919'
                WHERE ordernumber = 'P180603182257603' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394005'
                WHERE ordernumber = 'P420603182519354' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394006'
                WHERE ordernumber = 'P420603182756838' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394007'
                WHERE ordernumber = 'P190603183000425' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278468'
                WHERE ordernumber = 'P190603183416923' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394008'
                WHERE ordernumber = 'P710603183422922' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166785'
                WHERE ordernumber = 'P180603183444320' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P180603183758319' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374275'
                WHERE ordernumber = 'P420603183952353' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394010'
                WHERE ordernumber = 'P200603184147849' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200603184422264' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200603184513570' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350920'
                WHERE ordernumber = 'P190603184627563' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103395'
                WHERE ordernumber = 'P200603184821663' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394012'
                WHERE ordernumber = 'P200603185658872' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394013'
                WHERE ordernumber = 'P200603185821827' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394014'
                WHERE ordernumber = 'P190603190259760' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211555'
                WHERE ordernumber = 'P190603190812497' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394015'
                WHERE ordernumber = 'P710603190848838' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394016'
                WHERE ordernumber = 'P190603190956795' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283570'
                WHERE ordernumber = 'P200603191004649' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219973'
                WHERE ordernumber = 'P190603191117459' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290463'
                WHERE ordernumber = 'P200603191229772' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394015'
                WHERE ordernumber = 'P710603191237343' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200603191351276' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394018'
                WHERE ordernumber = 'P200603191555416' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394019'
                WHERE ordernumber = 'P200603191728808' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394020'
                WHERE ordernumber = 'P200603191903954' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235273'
                WHERE ordernumber = 'P200603192711928' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392913'
                WHERE ordernumber = 'P200603192846296' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394023'
                WHERE ordernumber = 'P200603193136711' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394021'
                WHERE ordernumber = 'P780603193138523' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158562'
                WHERE ordernumber = 'P200603193512785' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394024'
                WHERE ordernumber = 'P200603193954862' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286003'
                WHERE ordernumber = 'P200603194055211' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350930'
                WHERE ordernumber = 'P200603194153959' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394025'
                WHERE ordernumber = 'P200603194253309' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387332'
                WHERE ordernumber = 'P200603194906413' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389071'
                WHERE ordernumber = 'P200603195021294' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391408'
                WHERE ordernumber = 'P710603202951520' 
            
2024-06-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394032'
                WHERE ordernumber = 'P630603211724347'