2024-09-21 01:00:02 -- 將會員中心id寫入data-lake
2024-09-21 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-09-20%';
        
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421865'
                WHERE ordernumber = 'P200920110453315' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421866'
                WHERE ordernumber = 'P180920111040804' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388252'
                WHERE ordernumber = 'P180920111635732' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100271'
                WHERE ordernumber = 'P180920111747384' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386762'
                WHERE ordernumber = 'P420920111826224' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339696'
                WHERE ordernumber = 'P180920111927599' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180920112114475' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P200920112319878' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362321'
                WHERE ordernumber = 'P180920112417276' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421869'
                WHERE ordernumber = 'P420920112538978' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421870'
                WHERE ordernumber = 'P180920112704272' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421871'
                WHERE ordernumber = 'P180920112743448' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420802'
                WHERE ordernumber = 'P180920112807849' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421872'
                WHERE ordernumber = 'P180920112857263' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421873'
                WHERE ordernumber = 'P180920113005626' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398583'
                WHERE ordernumber = 'P180920113139644' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398583'
                WHERE ordernumber = 'P180920113232579' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395897'
                WHERE ordernumber = 'P420920113807527' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306886'
                WHERE ordernumber = 'P200920113949644' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336131'
                WHERE ordernumber = 'P420920114047833' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421874'
                WHERE ordernumber = 'P180920114106155' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P420920114323731' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315629'
                WHERE ordernumber = 'P420920114405170' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421875'
                WHERE ordernumber = 'P180920114444357' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421877'
                WHERE ordernumber = 'P420920114947642' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314651'
                WHERE ordernumber = 'P180920115147252' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216091'
                WHERE ordernumber = 'P180920115455801' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318939'
                WHERE ordernumber = 'P420920115941257' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200920121007880' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102656'
                WHERE ordernumber = 'P180920121624542' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421878'
                WHERE ordernumber = 'P190920121706391' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '197126'
                WHERE ordernumber = 'P420920121759170' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421725'
                WHERE ordernumber = 'P180920121821209' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421725'
                WHERE ordernumber = 'P180920121844741' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421879'
                WHERE ordernumber = 'P180920122018521' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421880'
                WHERE ordernumber = 'P190920122034317' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '59152'
                WHERE ordernumber = 'P180920122253719' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420920122516904' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421881'
                WHERE ordernumber = 'P180920122616689' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419643'
                WHERE ordernumber = 'P200920122710922' 
            
2024-09-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421882'
                WHERE ordernumber = 'P180920122809927' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421574'
                WHERE ordernumber = 'P420920123149367' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421574'
                WHERE ordernumber = 'P420920123318648' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421884'
                WHERE ordernumber = 'P180920123722583' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421885'
                WHERE ordernumber = 'P200920123751561' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409196'
                WHERE ordernumber = 'P190920123901806' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300581'
                WHERE ordernumber = 'P200920124208922' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421886'
                WHERE ordernumber = 'P180920124229415' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137450'
                WHERE ordernumber = 'P190920124317712' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381169'
                WHERE ordernumber = 'P190920124556800' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381169'
                WHERE ordernumber = 'P180920124709487' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236953'
                WHERE ordernumber = 'P200920125211530' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396555'
                WHERE ordernumber = 'P420920125317644' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250051'
                WHERE ordernumber = 'P180920125430403' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421888'
                WHERE ordernumber = 'P200920125555477' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421889'
                WHERE ordernumber = 'P420920125658538' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396926'
                WHERE ordernumber = 'P180920125833711' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421890'
                WHERE ordernumber = 'P180920130033775' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421892'
                WHERE ordernumber = 'P180920130421590' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421894'
                WHERE ordernumber = 'P200920130923890' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421893'
                WHERE ordernumber = 'P420920130932772' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421895'
                WHERE ordernumber = 'P420920131048446' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421897'
                WHERE ordernumber = 'P710920131340189' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421891'
                WHERE ordernumber = 'P200920131844278' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244081'
                WHERE ordernumber = 'P180920132158188' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421899'
                WHERE ordernumber = 'P710920132855536' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421900'
                WHERE ordernumber = 'P200920133133250' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421900'
                WHERE ordernumber = 'P200920133135697' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404754'
                WHERE ordernumber = 'P180920133214997' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276466'
                WHERE ordernumber = 'P200920133216446' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387626'
                WHERE ordernumber = 'P200920133300442' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421904'
                WHERE ordernumber = 'P710920133907777' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316531'
                WHERE ordernumber = 'P200920134010942' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255104'
                WHERE ordernumber = 'P180920134107477' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421905'
                WHERE ordernumber = 'P200920134149172' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421907'
                WHERE ordernumber = 'P180920134737163' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421908'
                WHERE ordernumber = 'P420920134858543' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421909'
                WHERE ordernumber = 'P180920135143387' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180920135712512' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180920135744855' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180920135809188' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180920135848867' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421910'
                WHERE ordernumber = 'P190920135853477' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400458'
                WHERE ordernumber = 'P180920135924790' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206533'
                WHERE ordernumber = 'P710920135927818' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421912'
                WHERE ordernumber = 'P180920140106941' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421913'
                WHERE ordernumber = 'P190920140123224' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421914'
                WHERE ordernumber = 'P180920140501341' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421915'
                WHERE ordernumber = 'P200920140614517' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421916'
                WHERE ordernumber = 'P180920140633907' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421917'
                WHERE ordernumber = 'P180920140804991' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330705'
                WHERE ordernumber = 'P420920140854806' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421918'
                WHERE ordernumber = 'P420920141108207' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421919'
                WHERE ordernumber = 'P420920141352648' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421921'
                WHERE ordernumber = 'P420920141500429' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420571'
                WHERE ordernumber = 'P180920141522151' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399840'
                WHERE ordernumber = 'P420920141542952' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418775'
                WHERE ordernumber = 'P190920141747645' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421922'
                WHERE ordernumber = 'P180920141824740' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418775'
                WHERE ordernumber = 'P190920141848511' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415284'
                WHERE ordernumber = 'P180920141904209' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421923'
                WHERE ordernumber = 'P200920141930342' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '11462'
                WHERE ordernumber = 'P180920142031325' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344728'
                WHERE ordernumber = 'P180920142123941' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421898'
                WHERE ordernumber = 'P710920142139518' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419176'
                WHERE ordernumber = 'P190920142356412' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421813'
                WHERE ordernumber = 'P180920142615905' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398151'
                WHERE ordernumber = 'P420920143042286' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421926'
                WHERE ordernumber = 'P200920143110133' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421740'
                WHERE ordernumber = 'P420920143440175' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421928'
                WHERE ordernumber = 'P200920143629831' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222112'
                WHERE ordernumber = 'P180920143756501' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421929'
                WHERE ordernumber = 'P190920143859206' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81864'
                WHERE ordernumber = 'P180920144443707' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289789'
                WHERE ordernumber = 'P200920144522350' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416396'
                WHERE ordernumber = 'P420920144817254' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317371'
                WHERE ordernumber = 'P180920144918255' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421931'
                WHERE ordernumber = 'P420920144930335' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275416'
                WHERE ordernumber = 'P200920145703477' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421935'
                WHERE ordernumber = 'P200920145816701' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421936'
                WHERE ordernumber = 'P180920145858725' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421937'
                WHERE ordernumber = 'P200920150130303' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421938'
                WHERE ordernumber = 'P180920150142907' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421939'
                WHERE ordernumber = 'P180920150341438' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395955'
                WHERE ordernumber = 'P420920150516461' 
            
2024-09-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366398'
                WHERE ordernumber = 'P420920150844758' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421940'
                WHERE ordernumber = 'P180920150857520' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421942'
                WHERE ordernumber = 'P420920152058276' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421944'
                WHERE ordernumber = 'P180920152213227' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421943'
                WHERE ordernumber = 'P190920152302656' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411656'
                WHERE ordernumber = 'P190920152439319' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403138'
                WHERE ordernumber = 'P200920152452490' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421944'
                WHERE ordernumber = 'P180920152558711' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421946'
                WHERE ordernumber = 'P180920152732651' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233357'
                WHERE ordernumber = 'P730920152852625' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421947'
                WHERE ordernumber = 'P180920152929581' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421948'
                WHERE ordernumber = 'P420920153158654' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379356'
                WHERE ordernumber = 'P180920153201943' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321047'
                WHERE ordernumber = 'P180920153629261' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421951'
                WHERE ordernumber = 'P180920153925474' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381351'
                WHERE ordernumber = 'P200920153949386' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421950'
                WHERE ordernumber = 'P710920154027326' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421951'
                WHERE ordernumber = 'P180920154028542' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421399'
                WHERE ordernumber = 'P180920154225129' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421952'
                WHERE ordernumber = 'P190920154437357' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '194186'
                WHERE ordernumber = 'P190920154534118' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310663'
                WHERE ordernumber = 'P180920154613600' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421932'
                WHERE ordernumber = 'P190920154642209' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421953'
                WHERE ordernumber = 'P420920155108986' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354844'
                WHERE ordernumber = 'P200920155228978' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251701'
                WHERE ordernumber = 'P180920155233159' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421954'
                WHERE ordernumber = 'P180920155402451' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419686'
                WHERE ordernumber = 'P200920155519141' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421956'
                WHERE ordernumber = 'P420920155707690' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P180920155744424' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350077'
                WHERE ordernumber = 'P180920155855518' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234976'
                WHERE ordernumber = 'P200920160017379' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234976'
                WHERE ordernumber = 'P200920160528910' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421959'
                WHERE ordernumber = 'P180920161025527' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387973'
                WHERE ordernumber = 'P710920161656832' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286520'
                WHERE ordernumber = 'P180920161736604' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107221'
                WHERE ordernumber = 'P180920161918546' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421962'
                WHERE ordernumber = 'P710920162007277' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421963'
                WHERE ordernumber = 'P200920162046597' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421964'
                WHERE ordernumber = 'P180920162152675' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255362'
                WHERE ordernumber = 'P180920162621752' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421965'
                WHERE ordernumber = 'P180920162844591' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389324'
                WHERE ordernumber = 'P180920162943196' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265685'
                WHERE ordernumber = 'P200920163005735' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421968'
                WHERE ordernumber = 'P200920163327358' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421969'
                WHERE ordernumber = 'P420920163339315' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389324'
                WHERE ordernumber = 'P180920163442896' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421971'
                WHERE ordernumber = 'P200920163634155' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421972'
                WHERE ordernumber = 'P200920164115346' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P180920164506938' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421643'
                WHERE ordernumber = 'P200920164757128' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421643'
                WHERE ordernumber = 'P200920164859973' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421974'
                WHERE ordernumber = 'P710920165218505' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421977'
                WHERE ordernumber = 'P180920165546747' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292549'
                WHERE ordernumber = 'P630920165723403' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93619'
                WHERE ordernumber = 'P180920165930544' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206912'
                WHERE ordernumber = 'P190920165935448' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421978'
                WHERE ordernumber = 'P190920170019988' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421979'
                WHERE ordernumber = 'P180920170238805' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114144'
                WHERE ordernumber = 'P180920170314660' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81124'
                WHERE ordernumber = 'P420920170350118' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421980'
                WHERE ordernumber = 'P710920170645983' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340625'
                WHERE ordernumber = 'P180920170728857' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58071'
                WHERE ordernumber = 'P710920170817471' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421981'
                WHERE ordernumber = 'P710920171453892' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421983'
                WHERE ordernumber = 'P200920173242855' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421984'
                WHERE ordernumber = 'P180920173641317' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421985'
                WHERE ordernumber = 'P180920174348843' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421988'
                WHERE ordernumber = 'P420920175112478' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421989'
                WHERE ordernumber = 'P180920175232935' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420920175254694' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421990'
                WHERE ordernumber = 'P180920175338125' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249668'
                WHERE ordernumber = 'P420920175433688' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384170'
                WHERE ordernumber = 'P180920175504313' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91119'
                WHERE ordernumber = 'P180920175722291' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421991'
                WHERE ordernumber = 'P420920175757930' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421994'
                WHERE ordernumber = 'P180920180049965' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421993'
                WHERE ordernumber = 'P200920180056664' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421987'
                WHERE ordernumber = 'P730920180153383' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421995'
                WHERE ordernumber = 'P180920180215780' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306209'
                WHERE ordernumber = 'P180920180321250' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421995'
                WHERE ordernumber = 'P180920180404456' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421996'
                WHERE ordernumber = 'P710920180404657' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421997'
                WHERE ordernumber = 'P180920181056143' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421998'
                WHERE ordernumber = 'P200920181231404' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245143'
                WHERE ordernumber = 'P200920181350514' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422000'
                WHERE ordernumber = 'P710920181701677' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422001'
                WHERE ordernumber = 'P200920181728421' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422001'
                WHERE ordernumber = 'P200920181846284' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422002'
                WHERE ordernumber = 'P180920181859471' 
            
2024-09-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367024'
                WHERE ordernumber = 'P180920182026991' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200920182210332' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '150183'
                WHERE ordernumber = 'P180920182502629' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391559'
                WHERE ordernumber = 'P200920182550711' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422004'
                WHERE ordernumber = 'P420920182744631' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306888'
                WHERE ordernumber = 'P180920182922337' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422005'
                WHERE ordernumber = 'P180920183115699' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422007'
                WHERE ordernumber = 'P180920183243193' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422006'
                WHERE ordernumber = 'P200920183411955' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422008'
                WHERE ordernumber = 'P200920183848562' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114014'
                WHERE ordernumber = 'P180920184049583' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422009'
                WHERE ordernumber = 'P180920184711251' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '252502'
                WHERE ordernumber = 'P180920185002761' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414910'
                WHERE ordernumber = 'P200920185109601' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237232'
                WHERE ordernumber = 'P190920185202293' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320713'
                WHERE ordernumber = 'P420920185224742' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '134258'
                WHERE ordernumber = 'P190920185451862' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422011'
                WHERE ordernumber = 'P200920185812184' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331449'
                WHERE ordernumber = 'P190920190213966' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '331900'
                WHERE ordernumber = 'P190920190440314' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422013'
                WHERE ordernumber = 'P200920190521231' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354201'
                WHERE ordernumber = 'P190920190549210' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291067'
                WHERE ordernumber = 'P200920190644500' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P190920190706297' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422014'
                WHERE ordernumber = 'P190920190902888' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422015'
                WHERE ordernumber = 'P190920191018927' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271196'
                WHERE ordernumber = 'P190920191123527' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422017'
                WHERE ordernumber = 'P190920191432743' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422016'
                WHERE ordernumber = 'P710920191450882' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '77799'
                WHERE ordernumber = 'P190920191625916' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422018'
                WHERE ordernumber = 'P710920191932973' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422020'
                WHERE ordernumber = 'P190920192931447' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422020'
                WHERE ordernumber = 'P190920193011191' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422019'
                WHERE ordernumber = 'P730920193124615' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422021'
                WHERE ordernumber = 'P190920193211510' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418273'
                WHERE ordernumber = 'P200920193221825' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105529'
                WHERE ordernumber = 'P190920193330708' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422019'
                WHERE ordernumber = 'P730920193357173' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422022'
                WHERE ordernumber = 'P200920193601548' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63648'
                WHERE ordernumber = 'P730920193635362' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422024'
                WHERE ordernumber = 'P190920193918485' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422025'
                WHERE ordernumber = 'P710920195051759' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422026'
                WHERE ordernumber = 'P200920195200934' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422026'
                WHERE ordernumber = 'P200920195343443' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422028'
                WHERE ordernumber = 'P200920195501396' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227161'
                WHERE ordernumber = 'P200920195528887' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422027'
                WHERE ordernumber = 'P710920195543237' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380334'
                WHERE ordernumber = 'P200920195712439' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422029'
                WHERE ordernumber = 'P710920200446697' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422031'
                WHERE ordernumber = 'P730920201821867' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268960'
                WHERE ordernumber = 'P730920203749655' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422033'
                WHERE ordernumber = 'P710920204250677' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422034'
                WHERE ordernumber = 'P710920204537599' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '422044'
                WHERE ordernumber = 'P710920214612719' 
            
2024-09-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '142468'
                WHERE ordernumber = 'P730920222458427'