2024-02-20 01:00:01 -- 將會員中心id寫入data-lake
2024-02-20 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-02-19%';
        
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P200219110458731' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '234876'
                WHERE ordernumber = 'P200219110736406' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378000'
                WHERE ordernumber = 'P190219110818975' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378000'
                WHERE ordernumber = 'P190219110846267' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '318093'
                WHERE ordernumber = 'P200219110939736' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378003'
                WHERE ordernumber = 'P420219111042324' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '306350'
                WHERE ordernumber = 'P190219111104672' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377447'
                WHERE ordernumber = 'P420219111159527' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '378004'
                WHERE ordernumber = 'P190219111517706' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '248970'
                WHERE ordernumber = 'P200219111715261' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '365139'
                WHERE ordernumber = 'P420219111804147' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '377418'
                WHERE ordernumber = 'P190219111929308' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '290493'
                WHERE ordernumber = 'P420219111952652' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '368915'
                WHERE ordernumber = 'P200219112337288' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '94715'
                WHERE ordernumber = 'P190219112602321' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '285699'
                WHERE ordernumber = 'P190219112643644' 
            
2024-02-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '112794'
                WHERE ordernumber = 'P200219112726428' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94715'
                WHERE ordernumber = 'P190219112957476' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84832'
                WHERE ordernumber = 'P190219113058653' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378007'
                WHERE ordernumber = 'P190219113512904' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216067'
                WHERE ordernumber = 'P190219113806395' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378009'
                WHERE ordernumber = 'P190219113910229' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284582'
                WHERE ordernumber = 'P200219114253757' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378010'
                WHERE ordernumber = 'P420219114628193' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378014'
                WHERE ordernumber = 'P200219120243706' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318092'
                WHERE ordernumber = 'P420219120401180' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242493'
                WHERE ordernumber = 'P190219120538504' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200219120600345' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106758'
                WHERE ordernumber = 'P190219120646293' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217650'
                WHERE ordernumber = 'P190219120830649' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378015'
                WHERE ordernumber = 'P190219121329383' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118999'
                WHERE ordernumber = 'P200219121332806' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378017'
                WHERE ordernumber = 'P190219121942259' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378019'
                WHERE ordernumber = 'P190219122351991' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378020'
                WHERE ordernumber = 'P190219122739355' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378021'
                WHERE ordernumber = 'P200219122916916' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372263'
                WHERE ordernumber = 'P420219123804431' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378022'
                WHERE ordernumber = 'P200219123840183' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378023'
                WHERE ordernumber = 'P420219124203649' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378024'
                WHERE ordernumber = 'P200219124233494' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378025'
                WHERE ordernumber = 'P200219124353151' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378026'
                WHERE ordernumber = 'P200219124542176' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378027'
                WHERE ordernumber = 'P190219125133728' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224147'
                WHERE ordernumber = 'P200219125146699' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378027'
                WHERE ordernumber = 'P190219125239196' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P190219125323193' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286251'
                WHERE ordernumber = 'P200219125441293' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378030'
                WHERE ordernumber = 'P200219125606433' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377999'
                WHERE ordernumber = 'P200219130311395' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378033'
                WHERE ordernumber = 'P200219130425452' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344074'
                WHERE ordernumber = 'P420219130748417' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378037'
                WHERE ordernumber = 'P420219130922811' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303332'
                WHERE ordernumber = 'P190219131222844' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154061'
                WHERE ordernumber = 'P190219131334271' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378038'
                WHERE ordernumber = 'P180219131631573' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251461'
                WHERE ordernumber = 'P180219131959233' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345079'
                WHERE ordernumber = 'P200219133728321' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378040'
                WHERE ordernumber = 'P180219133836523' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '32691'
                WHERE ordernumber = 'P200219134035315' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378041'
                WHERE ordernumber = 'P180219134306617' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '7474'
                WHERE ordernumber = 'P420219134702965' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378043'
                WHERE ordernumber = 'P180219135132874' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275056'
                WHERE ordernumber = 'P180219135600209' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275056'
                WHERE ordernumber = 'P180219135921676' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126709'
                WHERE ordernumber = 'P190219135956497' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '8776'
                WHERE ordernumber = 'P180219140037561' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200219140353439' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378044'
                WHERE ordernumber = 'P180219140946519' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378029'
                WHERE ordernumber = 'P180219141116957' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378047'
                WHERE ordernumber = 'P180219141259126' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '317268'
                WHERE ordernumber = 'P420219141404946' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376364'
                WHERE ordernumber = 'P200219141417133' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378048'
                WHERE ordernumber = 'P180219141634174' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378050'
                WHERE ordernumber = 'P200219141841959' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378051'
                WHERE ordernumber = 'P420219141956208' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378053'
                WHERE ordernumber = 'P180219142340137' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274507'
                WHERE ordernumber = 'P200219142438115' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200219142757152' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378055'
                WHERE ordernumber = 'P420219142856971' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266600'
                WHERE ordernumber = 'P180219144008322' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378057'
                WHERE ordernumber = 'P200219144307964' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378058'
                WHERE ordernumber = 'P420219144430881' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '226506'
                WHERE ordernumber = 'P200219144543362' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358067'
                WHERE ordernumber = 'P420219144651667' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378060'
                WHERE ordernumber = 'P200219145006164' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378061'
                WHERE ordernumber = 'P420219145324669' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378062'
                WHERE ordernumber = 'P420219145558638' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209206'
                WHERE ordernumber = 'P180219145630802' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270633'
                WHERE ordernumber = 'P420219150036904' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108502'
                WHERE ordernumber = 'P200219150301238' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378065'
                WHERE ordernumber = 'P420219150320998' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378066'
                WHERE ordernumber = 'P420219150447814' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378067'
                WHERE ordernumber = 'P180219150657874' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295896'
                WHERE ordernumber = 'P200219151057649' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378069'
                WHERE ordernumber = 'P190219151252739' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303065'
                WHERE ordernumber = 'P180219151347114' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64160'
                WHERE ordernumber = 'P180219151820927' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378070'
                WHERE ordernumber = 'P200219151848409' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378069'
                WHERE ordernumber = 'P190219151910140' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378071'
                WHERE ordernumber = 'P190219152248960' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275791'
                WHERE ordernumber = 'P200219152302127' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P180219152332405' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378072'
                WHERE ordernumber = 'P180219152436246' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378072'
                WHERE ordernumber = 'P180219152454368' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378073'
                WHERE ordernumber = 'P190219152700992' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378075'
                WHERE ordernumber = 'P420219153021601' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378077'
                WHERE ordernumber = 'P200219153431723' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121539'
                WHERE ordernumber = 'P200219153542481' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284948'
                WHERE ordernumber = 'P200219153746786' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366854'
                WHERE ordernumber = 'P200219153910491' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378078'
                WHERE ordernumber = 'P180219154342192' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378081'
                WHERE ordernumber = 'P200219154920504' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303396'
                WHERE ordernumber = 'P200219155026446' 
            
2024-02-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378082'
                WHERE ordernumber = 'P420219155104551' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378083'
                WHERE ordernumber = 'P420219155159655' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378084'
                WHERE ordernumber = 'P190219155302386' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172716'
                WHERE ordernumber = 'P200219155603324' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200219155941548' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276878'
                WHERE ordernumber = 'P180219160913211' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225755'
                WHERE ordernumber = 'P190219161059889' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227651'
                WHERE ordernumber = 'P190219161255815' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376965'
                WHERE ordernumber = 'P190219161443761' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378089'
                WHERE ordernumber = 'P190219161711248' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378088'
                WHERE ordernumber = 'P190219161728313' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378091'
                WHERE ordernumber = 'P200219161927487' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378092'
                WHERE ordernumber = 'P190219162016379' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378093'
                WHERE ordernumber = 'P200219162313643' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133740'
                WHERE ordernumber = 'P200219162715953' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155013'
                WHERE ordernumber = 'P420219162924999' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318639'
                WHERE ordernumber = 'P200219163036417' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378096'
                WHERE ordernumber = 'P180219163140359' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106569'
                WHERE ordernumber = 'P180219163239361' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378098'
                WHERE ordernumber = 'P200219163730328' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223075'
                WHERE ordernumber = 'P190219164008516' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378100'
                WHERE ordernumber = 'P200219164501169' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130659'
                WHERE ordernumber = 'P190219164703492' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228240'
                WHERE ordernumber = 'P190219164817495' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362432'
                WHERE ordernumber = 'P180219165213462' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274538'
                WHERE ordernumber = 'P180219165404799' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367975'
                WHERE ordernumber = 'P200219170839540' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378103'
                WHERE ordernumber = 'P420219171622538' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378108'
                WHERE ordernumber = 'P180219172621278' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378107'
                WHERE ordernumber = 'P200219172624236' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160799'
                WHERE ordernumber = 'P200219172758571' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282597'
                WHERE ordernumber = 'P200219172858837' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216679'
                WHERE ordernumber = 'P200219173012357' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378109'
                WHERE ordernumber = 'P180219173020201' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336115'
                WHERE ordernumber = 'P190219173259921' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378109'
                WHERE ordernumber = 'P180219173402453' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378110'
                WHERE ordernumber = 'P190219173435997' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378111'
                WHERE ordernumber = 'P420219173709614' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160711'
                WHERE ordernumber = 'P200219173805958' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200219174025392' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214777'
                WHERE ordernumber = 'P200219174107854' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146584'
                WHERE ordernumber = 'P180219174157863' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378112'
                WHERE ordernumber = 'P420219174734186' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295096'
                WHERE ordernumber = 'P200219174800219' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P180219174901967' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378113'
                WHERE ordernumber = 'P180219175142210' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74730'
                WHERE ordernumber = 'P420219175218611' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378114'
                WHERE ordernumber = 'P200219180145265' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P180219180241604' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378115'
                WHERE ordernumber = 'P200219180313116' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378116'
                WHERE ordernumber = 'P180219180512296' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378117'
                WHERE ordernumber = 'P190219180906686' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306886'
                WHERE ordernumber = 'P200219181624792' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377532'
                WHERE ordernumber = 'P180219181653901' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378119'
                WHERE ordernumber = 'P420219181731754' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264914'
                WHERE ordernumber = 'P180219181846178' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200219182223794' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378121'
                WHERE ordernumber = 'P180219182626400' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378121'
                WHERE ordernumber = 'P180219182915313' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P200219183416379' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378123'
                WHERE ordernumber = 'P180219183505703' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340047'
                WHERE ordernumber = 'P200219183710976' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375187'
                WHERE ordernumber = 'P200219184220240' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P180219184331432' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313581'
                WHERE ordernumber = 'P190219185141428' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349642'
                WHERE ordernumber = 'P200219185528731' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278465'
                WHERE ordernumber = 'P190219190405572' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311208'
                WHERE ordernumber = 'P200219190830302' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213525'
                WHERE ordernumber = 'P200219190950677' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P200219191507667' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332639'
                WHERE ordernumber = 'P200219192031241' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342473'
                WHERE ordernumber = 'P200219192900736' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222262'
                WHERE ordernumber = 'P190219193945995' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '4568'
                WHERE ordernumber = 'P420219194130959' 
            
2024-02-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210852'
                WHERE ordernumber = 'P190219194707901'