2024-03-29 01:00:02 -- 將會員中心id寫入data-lake
2024-03-29 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-03-28%';
        
2024-03-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200328110220821' 
            
2024-03-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300420'
                WHERE ordernumber = 'P590328110544927' 
            
2024-03-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253163'
                WHERE ordernumber = 'P200328110625170' 
            
2024-03-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180328110642326' 
            
2024-03-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P180328110940443' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P200328111258315' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99807'
                WHERE ordernumber = 'P180328111420666' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241534'
                WHERE ordernumber = 'P180328111907318' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '44719'
                WHERE ordernumber = 'P180328112001401' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290852'
                WHERE ordernumber = 'P180328112448797' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93911'
                WHERE ordernumber = 'P180328113000856' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383423'
                WHERE ordernumber = 'P180328113212476' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383422'
                WHERE ordernumber = 'P420328113215431' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383421'
                WHERE ordernumber = 'P420328113501756' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383425'
                WHERE ordernumber = 'P180328113510152' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383423'
                WHERE ordernumber = 'P180328113909256' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383426'
                WHERE ordernumber = 'P180328114154174' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128183'
                WHERE ordernumber = 'P180328114526389' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P180328114707483' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383429'
                WHERE ordernumber = 'P180328115731631' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420328115910150' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383431'
                WHERE ordernumber = 'P200328120230597' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383432'
                WHERE ordernumber = 'P200328120455289' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383434'
                WHERE ordernumber = 'P420328120850396' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381436'
                WHERE ordernumber = 'P420328121141979' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336973'
                WHERE ordernumber = 'P420328121539566' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383420'
                WHERE ordernumber = 'P180328121854590' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93159'
                WHERE ordernumber = 'P200328121857363' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280261'
                WHERE ordernumber = 'P190328121937880' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378098'
                WHERE ordernumber = 'P200328122101327' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383438'
                WHERE ordernumber = 'P420328122152397' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383439'
                WHERE ordernumber = 'P200328122241351' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353546'
                WHERE ordernumber = 'P190328122915647' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383441'
                WHERE ordernumber = 'P200328123556706' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383442'
                WHERE ordernumber = 'P420328123704597' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382202'
                WHERE ordernumber = 'P420328123907421' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383443'
                WHERE ordernumber = 'P200328123958979' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383137'
                WHERE ordernumber = 'P420328124103840' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383444'
                WHERE ordernumber = 'P190328124247276' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383445'
                WHERE ordernumber = 'P420328124453895' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123569'
                WHERE ordernumber = 'P200328124604855' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322169'
                WHERE ordernumber = 'P190328124647615' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380164'
                WHERE ordernumber = 'P190328125011551' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383446'
                WHERE ordernumber = 'P200328125523280' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383447'
                WHERE ordernumber = 'P420328125609311' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P420328125656255' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345087'
                WHERE ordernumber = 'P420328130103930' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296950'
                WHERE ordernumber = 'P420328130223710' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358974'
                WHERE ordernumber = 'P190328130934149' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102338'
                WHERE ordernumber = 'P200328131023938' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P190328131255301' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P190328131443699' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357985'
                WHERE ordernumber = 'P190328131851833' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380278'
                WHERE ordernumber = 'P200328131932877' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131180'
                WHERE ordernumber = 'P190328132052428' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P190328132138261' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382039'
                WHERE ordernumber = 'P200328132422366' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284522'
                WHERE ordernumber = 'P200328132618748' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360735'
                WHERE ordernumber = 'P190328132727990' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351591'
                WHERE ordernumber = 'P200328132746738' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383450'
                WHERE ordernumber = 'P190328133034289' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382589'
                WHERE ordernumber = 'P200328133131288' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380431'
                WHERE ordernumber = 'P200328133237702' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380431'
                WHERE ordernumber = 'P200328133317306' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383451'
                WHERE ordernumber = 'P190328133627362' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381554'
                WHERE ordernumber = 'P420328133637890' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383239'
                WHERE ordernumber = 'P190328133913620' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P200328134016744' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90212'
                WHERE ordernumber = 'P200328134154764' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143625'
                WHERE ordernumber = 'P190328135007807' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282226'
                WHERE ordernumber = 'P190328135106975' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383453'
                WHERE ordernumber = 'P200328135159586' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383455'
                WHERE ordernumber = 'P190328135402713' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284326'
                WHERE ordernumber = 'P200328135418691' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380303'
                WHERE ordernumber = 'P190328135847670' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383318'
                WHERE ordernumber = 'P200328140011212' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96141'
                WHERE ordernumber = 'P190328140025369' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62816'
                WHERE ordernumber = 'P190328140257983' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251294'
                WHERE ordernumber = 'P200328140452308' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98566'
                WHERE ordernumber = 'P200328140540823' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345997'
                WHERE ordernumber = 'P190328140554728' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383457'
                WHERE ordernumber = 'P190328140902790' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P200328141234338' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359064'
                WHERE ordernumber = 'P200328141717853' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293529'
                WHERE ordernumber = 'P420328141728355' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282261'
                WHERE ordernumber = 'P200328142122474' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383459'
                WHERE ordernumber = 'P190328142754307' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312200'
                WHERE ordernumber = 'P190328143202788' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383460'
                WHERE ordernumber = 'P190328143341321' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310126'
                WHERE ordernumber = 'P190328143830982' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383461'
                WHERE ordernumber = 'P420328144402765' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160201'
                WHERE ordernumber = 'P190328144433884' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102149'
                WHERE ordernumber = 'P200328144641421' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383464'
                WHERE ordernumber = 'P420328144659647' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383155'
                WHERE ordernumber = 'P190328144726114' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383465'
                WHERE ordernumber = 'P420328144810179' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379122'
                WHERE ordernumber = 'P420328145440902' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379719'
                WHERE ordernumber = 'P190328145525869' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383467'
                WHERE ordernumber = 'P190328150409322' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380541'
                WHERE ordernumber = 'P200328150434625' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379572'
                WHERE ordernumber = 'P420328150634926' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383468'
                WHERE ordernumber = 'P200328150944333' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356227'
                WHERE ordernumber = 'P190328151014607' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376466'
                WHERE ordernumber = 'P190328151139153' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344170'
                WHERE ordernumber = 'P190328151518201' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383367'
                WHERE ordernumber = 'P420328151609767' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378170'
                WHERE ordernumber = 'P420328151950121' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383470'
                WHERE ordernumber = 'P190328152002675' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383471'
                WHERE ordernumber = 'P190328152142860' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92619'
                WHERE ordernumber = 'P190328152259647' 
            
2024-03-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383472'
                WHERE ordernumber = 'P420328152346343' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251511'
                WHERE ordernumber = 'P190328152358144' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370238'
                WHERE ordernumber = 'P200328152430513' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P190328152530887' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383473'
                WHERE ordernumber = 'P190328152656895' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350039'
                WHERE ordernumber = 'P190328153355478' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255893'
                WHERE ordernumber = 'P190328153704180' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287144'
                WHERE ordernumber = 'P200328154104256' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314823'
                WHERE ordernumber = 'P190328154153507' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383475'
                WHERE ordernumber = 'P200328154811473' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367889'
                WHERE ordernumber = 'P420328160151218' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381096'
                WHERE ordernumber = 'P180328160211251' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218996'
                WHERE ordernumber = 'P190328160221228' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383476'
                WHERE ordernumber = 'P420328160301727' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279298'
                WHERE ordernumber = 'P190328160706174' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299257'
                WHERE ordernumber = 'P200328161454500' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240001'
                WHERE ordernumber = 'P190328162010120' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383477'
                WHERE ordernumber = 'P190328162155223' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383478'
                WHERE ordernumber = 'P420328162405581' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96773'
                WHERE ordernumber = 'P200328162429407' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383480'
                WHERE ordernumber = 'P420328162516732' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383481'
                WHERE ordernumber = 'P420328162703354' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281400'
                WHERE ordernumber = 'P190328162729689' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383483'
                WHERE ordernumber = 'P200328162828245' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383484'
                WHERE ordernumber = 'P190328162943643' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383485'
                WHERE ordernumber = 'P180328163030578' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382477'
                WHERE ordernumber = 'P420328163251998' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114430'
                WHERE ordernumber = 'P190328163703717' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247096'
                WHERE ordernumber = 'P190328163855416' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383487'
                WHERE ordernumber = 'P190328164636660' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383486'
                WHERE ordernumber = 'P590328164826914' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383489'
                WHERE ordernumber = 'P420328165034587' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383057'
                WHERE ordernumber = 'P190328165058431' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383490'
                WHERE ordernumber = 'P420328165208442' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P190328165313250' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383482'
                WHERE ordernumber = 'P190328165434780' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383488'
                WHERE ordernumber = 'P200328165527579' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383491'
                WHERE ordernumber = 'P190328165850701' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383482'
                WHERE ordernumber = 'P190328165930172' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382896'
                WHERE ordernumber = 'P190328170212684' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383492'
                WHERE ordernumber = 'P590328170600228' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244657'
                WHERE ordernumber = 'P200328170625963' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250500'
                WHERE ordernumber = 'P200328171123351' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382282'
                WHERE ordernumber = 'P420328171248273' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381730'
                WHERE ordernumber = 'P200328172457753' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275676'
                WHERE ordernumber = 'P200328172726998' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278213'
                WHERE ordernumber = 'P190328173128217' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277408'
                WHERE ordernumber = 'P200328173143834' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383494'
                WHERE ordernumber = 'P200328173453712' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383496'
                WHERE ordernumber = 'P190328173554159' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162963'
                WHERE ordernumber = 'P200328173649115' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383497'
                WHERE ordernumber = 'P200328173835156' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248746'
                WHERE ordernumber = 'P200328174014847' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119261'
                WHERE ordernumber = 'P200328174114484' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383394'
                WHERE ordernumber = 'P190328174304137' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140723'
                WHERE ordernumber = 'P190328174352138' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102459'
                WHERE ordernumber = 'P190328174623700' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102459'
                WHERE ordernumber = 'P190328174658131' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383500'
                WHERE ordernumber = 'P200328174930498' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248746'
                WHERE ordernumber = 'P200328175110514' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383246'
                WHERE ordernumber = 'P190328175141668' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293984'
                WHERE ordernumber = 'P200328175158847' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383501'
                WHERE ordernumber = 'P200328175258859' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93652'
                WHERE ordernumber = 'P200328175334554' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370898'
                WHERE ordernumber = 'P200328175431248' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383502'
                WHERE ordernumber = 'P190328175539972' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251703'
                WHERE ordernumber = 'P180328175608820' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328200'
                WHERE ordernumber = 'P190328180401643' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301654'
                WHERE ordernumber = 'P190328181113191' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383503'
                WHERE ordernumber = 'P190328181601198' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357242'
                WHERE ordernumber = 'P190328181802832' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190328181925518' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P190328182131467' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383504'
                WHERE ordernumber = 'P190328182522704' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383505'
                WHERE ordernumber = 'P190328182802235' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P200328182946603' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349116'
                WHERE ordernumber = 'P190328183337537' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128501'
                WHERE ordernumber = 'P190328183733326' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117528'
                WHERE ordernumber = 'P200328183840299' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383507'
                WHERE ordernumber = 'P190328183858606' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167494'
                WHERE ordernumber = 'P200328183940685' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383508'
                WHERE ordernumber = 'P420328184037514' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383510'
                WHERE ordernumber = 'P200328184044624' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383509'
                WHERE ordernumber = 'P190328184058191' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114753'
                WHERE ordernumber = 'P200328184240529' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383506'
                WHERE ordernumber = 'P190328184419680' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232545'
                WHERE ordernumber = 'P200328184522353' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381224'
                WHERE ordernumber = 'P420328184708250' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383511'
                WHERE ordernumber = 'P190328184929175' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383512'
                WHERE ordernumber = 'P420328185158410' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383144'
                WHERE ordernumber = 'P190328185254180' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341741'
                WHERE ordernumber = 'P190328185548711' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161008'
                WHERE ordernumber = 'P190328185713558' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342259'
                WHERE ordernumber = 'P200328185831994' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383513'
                WHERE ordernumber = 'P190328185850368' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383515'
                WHERE ordernumber = 'P200328190147949' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383516'
                WHERE ordernumber = 'P200328190416739' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270643'
                WHERE ordernumber = 'P200328190455190' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278222'
                WHERE ordernumber = 'P190328191016276' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383517'
                WHERE ordernumber = 'P420328191055542' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96759'
                WHERE ordernumber = 'P200328191938294' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383450'
                WHERE ordernumber = 'P190328192228367' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382379'
                WHERE ordernumber = 'P420328192303669' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245507'
                WHERE ordernumber = 'P420328192413508' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96739'
                WHERE ordernumber = 'P190328192945517' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154268'
                WHERE ordernumber = 'P200328193118956' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221484'
                WHERE ordernumber = 'P200328193250305' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211931'
                WHERE ordernumber = 'P200328193751720' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383520'
                WHERE ordernumber = 'P420328195303672' 
            
2024-03-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383524'
                WHERE ordernumber = 'P590328203920967' 
            
2024-03-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383527'
                WHERE ordernumber = 'P590328212507973'