2024-04-18 01:00:02 -- 將會員中心id寫入data-lake
2024-04-18 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-04-17%';
        
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385792'
                WHERE ordernumber = 'P630417104102701' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287930'
                WHERE ordernumber = 'P180417110750975' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381946'
                WHERE ordernumber = 'P200417111141792' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219047'
                WHERE ordernumber = 'P630417111204372' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385795'
                WHERE ordernumber = 'P180417111307878' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211900'
                WHERE ordernumber = 'P190417111614229' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385796'
                WHERE ordernumber = 'P180417111840619' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385797'
                WHERE ordernumber = 'P200417112159492' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384671'
                WHERE ordernumber = 'P200417112334854' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385800'
                WHERE ordernumber = 'P420417112826724' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378938'
                WHERE ordernumber = 'P180417113049858' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385801'
                WHERE ordernumber = 'P200417113118164' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385803'
                WHERE ordernumber = 'P200417113712619' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385803'
                WHERE ordernumber = 'P200417113921505' 
            
2024-04-18 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385804'
                WHERE ordernumber = 'P200417114410609' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30618'
                WHERE ordernumber = 'P180417114458131' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385805'
                WHERE ordernumber = 'P180417114603245' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385806'
                WHERE ordernumber = 'P420417114950428' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385277'
                WHERE ordernumber = 'P180417115227440' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385807'
                WHERE ordernumber = 'P180417115440965' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385809'
                WHERE ordernumber = 'P200417120106902' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298277'
                WHERE ordernumber = 'P190417120355876' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364603'
                WHERE ordernumber = 'P180417121219351' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385811'
                WHERE ordernumber = 'P200417121335435' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385812'
                WHERE ordernumber = 'P190417121454126' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86183'
                WHERE ordernumber = 'P200417121716239' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384028'
                WHERE ordernumber = 'P180417122618840' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309133'
                WHERE ordernumber = 'P200417122712448' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382970'
                WHERE ordernumber = 'P420417122822587' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P180417123208192' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207279'
                WHERE ordernumber = 'P180417123426240' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180417123551511' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385817'
                WHERE ordernumber = 'P200417124351378' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385819'
                WHERE ordernumber = 'P590417124749456' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385820'
                WHERE ordernumber = 'P630417124803742' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385822'
                WHERE ordernumber = 'P200417125704762' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385823'
                WHERE ordernumber = 'P630417125824742' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286502'
                WHERE ordernumber = 'P200417130139395' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327755'
                WHERE ordernumber = 'P420417130843476' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385825'
                WHERE ordernumber = 'P180417131807299' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385826'
                WHERE ordernumber = 'P180417132351378' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385828'
                WHERE ordernumber = 'P630417132711716' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385827'
                WHERE ordernumber = 'P180417132725848' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385829'
                WHERE ordernumber = 'P200417132859679' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139638'
                WHERE ordernumber = 'P420417133245640' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385831'
                WHERE ordernumber = 'P180417133947543' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385832'
                WHERE ordernumber = 'P180417134513637' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385833'
                WHERE ordernumber = 'P630417134702224' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279508'
                WHERE ordernumber = 'P180417135008287' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385834'
                WHERE ordernumber = 'P180417135207892' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125565'
                WHERE ordernumber = 'P630417135550129' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385835'
                WHERE ordernumber = 'P420417140240267' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299674'
                WHERE ordernumber = 'P420417140638295' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231679'
                WHERE ordernumber = 'P180417140939195' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385836'
                WHERE ordernumber = 'P420417141052574' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385837'
                WHERE ordernumber = 'P180417141207566' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127026'
                WHERE ordernumber = 'P630417141333183' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384671'
                WHERE ordernumber = 'P200417141643861' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385838'
                WHERE ordernumber = 'P630417142553866' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214660'
                WHERE ordernumber = 'P180417142724186' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200417142843480' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385839'
                WHERE ordernumber = 'P180417143208685' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385839'
                WHERE ordernumber = 'P180417143452216' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255201'
                WHERE ordernumber = 'P200417144055380' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295437'
                WHERE ordernumber = 'P200417144206295' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385840'
                WHERE ordernumber = 'P420417144343199' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41046'
                WHERE ordernumber = 'P200417144421245' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274520'
                WHERE ordernumber = 'P200417145025372' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265656'
                WHERE ordernumber = 'P200417145414211' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385841'
                WHERE ordernumber = 'P200417145547979' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385842'
                WHERE ordernumber = 'P200417150210991' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289942'
                WHERE ordernumber = 'P200417150617947' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115220'
                WHERE ordernumber = 'P200417150713800' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385843'
                WHERE ordernumber = 'P190417150726361' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P190417150840700' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345880'
                WHERE ordernumber = 'P420417151026282' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156121'
                WHERE ordernumber = 'P180417151504388' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385845'
                WHERE ordernumber = 'P180417151708119' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213908'
                WHERE ordernumber = 'P420417152040246' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385846'
                WHERE ordernumber = 'P630417152509979' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285902'
                WHERE ordernumber = 'P200417152636733' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359018'
                WHERE ordernumber = 'P180417152729606' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385847'
                WHERE ordernumber = 'P180417152929967' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P200417152930773' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385849'
                WHERE ordernumber = 'P420417153038388' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366683'
                WHERE ordernumber = 'P190417153046742' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385850'
                WHERE ordernumber = 'P180417153122968' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285902'
                WHERE ordernumber = 'P200417153134721' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385851'
                WHERE ordernumber = 'P200417153253942' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385852'
                WHERE ordernumber = 'P180417153318185' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P190417153453229' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200417153619640' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355262'
                WHERE ordernumber = 'P200417153708684' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385854'
                WHERE ordernumber = 'P180417153723112' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '13352'
                WHERE ordernumber = 'P420417153857333' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '191997'
                WHERE ordernumber = 'P630417154249936' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381205'
                WHERE ordernumber = 'P420417154500918' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385857'
                WHERE ordernumber = 'P630417155413302' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P630417155715289' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251296'
                WHERE ordernumber = 'P180417155749301' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385858'
                WHERE ordernumber = 'P630417160057744' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283272'
                WHERE ordernumber = 'P190417160212978' 
            
2024-04-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380845'
                WHERE ordernumber = 'P180417160307997' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385860'
                WHERE ordernumber = 'P420417160425180' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166765'
                WHERE ordernumber = 'P630417160453569' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281400'
                WHERE ordernumber = 'P190417160553849' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297806'
                WHERE ordernumber = 'P420417160924868' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281654'
                WHERE ordernumber = 'P180417161425331' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361247'
                WHERE ordernumber = 'P200417161652845' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385864'
                WHERE ordernumber = 'P420417162445797' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262592'
                WHERE ordernumber = 'P200417162524656' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94344'
                WHERE ordernumber = 'P180417162535660' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200417162704374' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384789'
                WHERE ordernumber = 'P420417163226766' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369358'
                WHERE ordernumber = 'P420417163416779' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385865'
                WHERE ordernumber = 'P630417163422549' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P190417163548769' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385867'
                WHERE ordernumber = 'P200417163855114' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385101'
                WHERE ordernumber = 'P420417164151519' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385869'
                WHERE ordernumber = 'P180417164335122' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385867'
                WHERE ordernumber = 'P200417164619275' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248612'
                WHERE ordernumber = 'P180417164745719' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384789'
                WHERE ordernumber = 'P420417164937306' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385870'
                WHERE ordernumber = 'P180417165447540' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385871'
                WHERE ordernumber = 'P180417165640931' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '193603'
                WHERE ordernumber = 'P420417165705412' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299527'
                WHERE ordernumber = 'P200417165750777' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163259'
                WHERE ordernumber = 'P200417170005462' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275266'
                WHERE ordernumber = 'P180417170301427' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420417171503972' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385874'
                WHERE ordernumber = 'P200417171510465' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385873'
                WHERE ordernumber = 'P420417171645992' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313276'
                WHERE ordernumber = 'P180417172004908' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P180417172105118' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273045'
                WHERE ordernumber = 'P200417172243969' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P180417172317389' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385875'
                WHERE ordernumber = 'P200417172846533' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385876'
                WHERE ordernumber = 'P200417173336246' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385877'
                WHERE ordernumber = 'P200417173728971' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369174'
                WHERE ordernumber = 'P420417174538423' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101802'
                WHERE ordernumber = 'P200417174943407' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385879'
                WHERE ordernumber = 'P420417175739945' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363008'
                WHERE ordernumber = 'P590417175753995' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385880'
                WHERE ordernumber = 'P180417175844150' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307065'
                WHERE ordernumber = 'P180417181531283' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124116'
                WHERE ordernumber = 'P180417182033835' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321225'
                WHERE ordernumber = 'P180417182210128' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297312'
                WHERE ordernumber = 'P420417182411336' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242927'
                WHERE ordernumber = 'P180417182927357' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339888'
                WHERE ordernumber = 'P420417183001992' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385883'
                WHERE ordernumber = 'P420417183628780' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385884'
                WHERE ordernumber = 'P420417183830349' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132169'
                WHERE ordernumber = 'P180417183925216' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P190417183950754' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200417190015971' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385886'
                WHERE ordernumber = 'P200417190406445' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212615'
                WHERE ordernumber = 'P200417190637419' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385887'
                WHERE ordernumber = 'P200417190812346' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385888'
                WHERE ordernumber = 'P200417191001813' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221129'
                WHERE ordernumber = 'P190417191006873' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385889'
                WHERE ordernumber = 'P190417191306348' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348658'
                WHERE ordernumber = 'P190417191501229' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385891'
                WHERE ordernumber = 'P190417191706798' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385892'
                WHERE ordernumber = 'P200417191825179' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299615'
                WHERE ordernumber = 'P190417191853674' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385893'
                WHERE ordernumber = 'P190417192035824' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385894'
                WHERE ordernumber = 'P190417192146930' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385895'
                WHERE ordernumber = 'P190417192319283' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385896'
                WHERE ordernumber = 'P200417192618808' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385897'
                WHERE ordernumber = 'P190417192712465' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385898'
                WHERE ordernumber = 'P200417192717776' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385899'
                WHERE ordernumber = 'P190417193009330' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385900'
                WHERE ordernumber = 'P420417193811495' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200417193959497' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385902'
                WHERE ordernumber = 'P190417194114143' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277813'
                WHERE ordernumber = 'P200417194119477' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385901'
                WHERE ordernumber = 'P190417194146164' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333591'
                WHERE ordernumber = 'P200417194307576' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385899'
                WHERE ordernumber = 'P190417194639787' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385903'
                WHERE ordernumber = 'P630417195018918' 
            
2024-04-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385904'
                WHERE ordernumber = 'P200417195301863'