2024-02-28 01:00:01 -- 將會員中心id寫入data-lake
2024-02-28 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-27%';
        
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379089'
                WHERE ordernumber = 'P180227110428357' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379090'
                WHERE ordernumber = 'P420227110549777' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379086'
                WHERE ordernumber = 'P180227110553724' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235072'
                WHERE ordernumber = 'P190227110708114' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379091'
                WHERE ordernumber = 'P180227110833684' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331904'
                WHERE ordernumber = 'P190227111020852' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '144544'
                WHERE ordernumber = 'P180227111031686' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379092'
                WHERE ordernumber = 'P180227111131834' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379083'
                WHERE ordernumber = 'P180227111355921' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200227111431763' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379094'
                WHERE ordernumber = 'P420227111625918' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346628'
                WHERE ordernumber = 'P180227111722183' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379095'
                WHERE ordernumber = 'P180227111847657' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355315'
                WHERE ordernumber = 'P180227112244837' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379096'
                WHERE ordernumber = 'P420227112642868' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '153894'
                WHERE ordernumber = 'P200227112756352' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337850'
                WHERE ordernumber = 'P420227112935940' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379098'
                WHERE ordernumber = 'P200227114118414' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379099'
                WHERE ordernumber = 'P200227114157676' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114534'
                WHERE ordernumber = 'P180227114224670' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128312'
                WHERE ordernumber = 'P200227114234923' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379101'
                WHERE ordernumber = 'P180227114434150' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364397'
                WHERE ordernumber = 'P180227115635719' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379103'
                WHERE ordernumber = 'P200227115716409' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379104'
                WHERE ordernumber = 'P200227120214399' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379106'
                WHERE ordernumber = 'P180227120543749' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '125988'
                WHERE ordernumber = 'P180227120927906' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367839'
                WHERE ordernumber = 'P420227121302738' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '58075'
                WHERE ordernumber = 'P200227122246209' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '144076'
                WHERE ordernumber = 'P190227122259840' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379108'
                WHERE ordernumber = 'P180227122355535' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '85093'
                WHERE ordernumber = 'P420227122821259' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245917'
                WHERE ordernumber = 'P180227122826387' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98922'
                WHERE ordernumber = 'P200227123201472' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259538'
                WHERE ordernumber = 'P420227123637367' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '103465'
                WHERE ordernumber = 'P200227123656930' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379109'
                WHERE ordernumber = 'P180227124103678' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239426'
                WHERE ordernumber = 'P180227124542834' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379110'
                WHERE ordernumber = 'P420227124839491' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326263'
                WHERE ordernumber = 'P420227125013462' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273658'
                WHERE ordernumber = 'P200227125230817' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350960'
                WHERE ordernumber = 'P420227125323114' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104000'
                WHERE ordernumber = 'P200227125343878' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258867'
                WHERE ordernumber = 'P200227130327832' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420227130522771' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379114'
                WHERE ordernumber = 'P180227130546963' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379116'
                WHERE ordernumber = 'P200227130906779' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266177'
                WHERE ordernumber = 'P420227132013934' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '184559'
                WHERE ordernumber = 'P180227132217220' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P180227132652750' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378922'
                WHERE ordernumber = 'P420227133439286' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365059'
                WHERE ordernumber = 'P180227133737961' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379121'
                WHERE ordernumber = 'P420227134148481' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379122'
                WHERE ordernumber = 'P200227134155499' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379123'
                WHERE ordernumber = 'P200227134259321' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379124'
                WHERE ordernumber = 'P200227134631423' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80921'
                WHERE ordernumber = 'P200227135022867' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365140'
                WHERE ordernumber = 'P420227135053389' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298290'
                WHERE ordernumber = 'P420227135158217' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363344'
                WHERE ordernumber = 'P200227135206195' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379126'
                WHERE ordernumber = 'P200227135347173' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379127'
                WHERE ordernumber = 'P420227140019546' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276469'
                WHERE ordernumber = 'P200227140421595' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308062'
                WHERE ordernumber = 'P200227141108409' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379124'
                WHERE ordernumber = 'P200227141208507' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379128'
                WHERE ordernumber = 'P200227142300851' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379129'
                WHERE ordernumber = 'P420227142626697' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379131'
                WHERE ordernumber = 'P180227143201145' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379130'
                WHERE ordernumber = 'P420227143202161' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379132'
                WHERE ordernumber = 'P180227143443395' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379133'
                WHERE ordernumber = 'P180227143954138' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377418'
                WHERE ordernumber = 'P180227144243429' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200227145710357' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379138'
                WHERE ordernumber = 'P180227150733208' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379127'
                WHERE ordernumber = 'P420227150855960' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180227151234665' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378959'
                WHERE ordernumber = 'P180227151910906' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379147'
                WHERE ordernumber = 'P420227151953121' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379148'
                WHERE ordernumber = 'P180227152115346' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379149'
                WHERE ordernumber = 'P180227152244428' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379153'
                WHERE ordernumber = 'P180227153425513' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345519'
                WHERE ordernumber = 'P190227153552146' 
            
2024-02-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379156'
                WHERE ordernumber = 'P200227153628646' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379158'
                WHERE ordernumber = 'P180227154003587' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351084'
                WHERE ordernumber = 'P200227154020361' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235347'
                WHERE ordernumber = 'P420227154129488' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213908'
                WHERE ordernumber = 'P420227154234391' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345178'
                WHERE ordernumber = 'P190227154854735' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379160'
                WHERE ordernumber = 'P180227155053694' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280107'
                WHERE ordernumber = 'P190227155240929' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379163'
                WHERE ordernumber = 'P420227155256952' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222823'
                WHERE ordernumber = 'P180227155530694' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379168'
                WHERE ordernumber = 'P180227155823612' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267209'
                WHERE ordernumber = 'P200227155933563' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326343'
                WHERE ordernumber = 'P180227160932224' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375848'
                WHERE ordernumber = 'P180227161500308' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379174'
                WHERE ordernumber = 'P200227161747396' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379175'
                WHERE ordernumber = 'P180227162023387' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379176'
                WHERE ordernumber = 'P180227162415461' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111677'
                WHERE ordernumber = 'P180227162727843' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317272'
                WHERE ordernumber = 'P420227163040141' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379178'
                WHERE ordernumber = 'P180227163228263' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379179'
                WHERE ordernumber = 'P200227163357489' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281262'
                WHERE ordernumber = 'P180227163833324' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379181'
                WHERE ordernumber = 'P420227163946666' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379184'
                WHERE ordernumber = 'P180227164639352' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379179'
                WHERE ordernumber = 'P200227163357489' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P180227165145974' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379185'
                WHERE ordernumber = 'P180227165530874' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379185'
                WHERE ordernumber = 'P180227165628368' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P180227165834135' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379186'
                WHERE ordernumber = 'P200227165956377' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358693'
                WHERE ordernumber = 'P180227170119204' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379187'
                WHERE ordernumber = 'P180227170301679' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379188'
                WHERE ordernumber = 'P420227170611762' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379190'
                WHERE ordernumber = 'P420227170759323' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379192'
                WHERE ordernumber = 'P180227171027258' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379193'
                WHERE ordernumber = 'P180227171115812' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167671'
                WHERE ordernumber = 'P180227171910339' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137509'
                WHERE ordernumber = 'P180227172256142' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334577'
                WHERE ordernumber = 'P200227172326743' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129318'
                WHERE ordernumber = 'P180227172527709' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379197'
                WHERE ordernumber = 'P200227172816397' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379198'
                WHERE ordernumber = 'P180227173137611' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290904'
                WHERE ordernumber = 'P200227173809601' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379199'
                WHERE ordernumber = 'P180227174025487' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81662'
                WHERE ordernumber = 'P190227174047280' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374128'
                WHERE ordernumber = 'P200227174141645' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379201'
                WHERE ordernumber = 'P180227174422494' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290904'
                WHERE ordernumber = 'P200227174446727' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379202'
                WHERE ordernumber = 'P200227174710140' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379203'
                WHERE ordernumber = 'P180227174927154' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379205'
                WHERE ordernumber = 'P190227175042532' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379204'
                WHERE ordernumber = 'P180227175103269' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129242'
                WHERE ordernumber = 'P420227175545471' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379206'
                WHERE ordernumber = 'P420227175649960' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379208'
                WHERE ordernumber = 'P200227180331174' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379209'
                WHERE ordernumber = 'P420227180555538' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379210'
                WHERE ordernumber = 'P420227181017950' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379212'
                WHERE ordernumber = 'P180227181311443' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286707'
                WHERE ordernumber = 'P200227181334224' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339987'
                WHERE ordernumber = 'P200227181722695' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97938'
                WHERE ordernumber = 'P200227181814936' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379213'
                WHERE ordernumber = 'P420227182023699' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353559'
                WHERE ordernumber = 'P180227182112300' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339987'
                WHERE ordernumber = 'P200227182117622' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379215'
                WHERE ordernumber = 'P200227182759764' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379214'
                WHERE ordernumber = 'P420227182931662' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51812'
                WHERE ordernumber = 'P200227182943310' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282492'
                WHERE ordernumber = 'P200227183307422' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144213'
                WHERE ordernumber = 'P180227183323138' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85019'
                WHERE ordernumber = 'P180227183354387' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379216'
                WHERE ordernumber = 'P420227183546362' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317600'
                WHERE ordernumber = 'P180227183834817' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379217'
                WHERE ordernumber = 'P420227184118428' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239180'
                WHERE ordernumber = 'P190227184253892' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379218'
                WHERE ordernumber = 'P190227184659344' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379219'
                WHERE ordernumber = 'P200227184728185' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377388'
                WHERE ordernumber = 'P200227184815849' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379220'
                WHERE ordernumber = 'P190227185007387' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379221'
                WHERE ordernumber = 'P200227185033839' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379038'
                WHERE ordernumber = 'P200227185552619' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379222'
                WHERE ordernumber = 'P190227185953307' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275763'
                WHERE ordernumber = 'P200227191147124' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379224'
                WHERE ordernumber = 'P200227191444687' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96442'
                WHERE ordernumber = 'P190227191450268' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200227191529449' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217790'
                WHERE ordernumber = 'P190227191641397' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P200227191801952' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275763'
                WHERE ordernumber = 'P200227192204434' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353569'
                WHERE ordernumber = 'P200227192247224' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352456'
                WHERE ordernumber = 'P190227192422524' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379191'
                WHERE ordernumber = 'P200227192901977' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379191'
                WHERE ordernumber = 'P200227192921935' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103523'
                WHERE ordernumber = 'P190227193043261' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226246'
                WHERE ordernumber = 'P190227193124484' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P190227193301568' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352456'
                WHERE ordernumber = 'P190227193527228' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239413'
                WHERE ordernumber = 'P200227193537934' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101781'
                WHERE ordernumber = 'P190227193649672' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P190227194247243' 
            
2024-02-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379225'
                WHERE ordernumber = 'P420227195354924'