2024-06-14 01:00:01 -- 將會員中心id寫入data-lake
2024-06-14 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-06-13%';
        
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311501'
                WHERE ordernumber = 'P420613110214479' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163217'
                WHERE ordernumber = 'P200613110411248' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395807'
                WHERE ordernumber = 'P200613110554688' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392337'
                WHERE ordernumber = 'P190613111050824' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140451'
                WHERE ordernumber = 'P180613111236893' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208793'
                WHERE ordernumber = 'P180613111613560' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395809'
                WHERE ordernumber = 'P420613111916999' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '41425'
                WHERE ordernumber = 'P180613112339789' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395809'
                WHERE ordernumber = 'P420613112400918' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167062'
                WHERE ordernumber = 'P180613112543529' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '129423'
                WHERE ordernumber = 'P190613112635804' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244978'
                WHERE ordernumber = 'P420613112635861' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395811'
                WHERE ordernumber = 'P180613112750900' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390329'
                WHERE ordernumber = 'P200613112805684' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131573'
                WHERE ordernumber = 'P190613112820601' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347375'
                WHERE ordernumber = 'P180613113203701' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393907'
                WHERE ordernumber = 'P180613113354417' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214718'
                WHERE ordernumber = 'P180613113505362' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395812'
                WHERE ordernumber = 'P420613114305944' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392608'
                WHERE ordernumber = 'P420613114352758' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395813'
                WHERE ordernumber = 'P420613114817739' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395815'
                WHERE ordernumber = 'P180613115215463' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119335'
                WHERE ordernumber = 'P190613115234127' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337854'
                WHERE ordernumber = 'P200613115707412' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131825'
                WHERE ordernumber = 'P180613115917119' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180613120442984' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216899'
                WHERE ordernumber = 'P200613120617936' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269457'
                WHERE ordernumber = 'P180613120756430' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395817'
                WHERE ordernumber = 'P180613120926293' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395819'
                WHERE ordernumber = 'P200613121023111' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355950'
                WHERE ordernumber = 'P180613121243839' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240855'
                WHERE ordernumber = 'P200613121435140' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218511'
                WHERE ordernumber = 'P200613121654309' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245056'
                WHERE ordernumber = 'P200613122045179' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106386'
                WHERE ordernumber = 'P180613122343590' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80513'
                WHERE ordernumber = 'P200613122422526' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395820'
                WHERE ordernumber = 'P200613122540157' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395822'
                WHERE ordernumber = 'P200613123320389' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119231'
                WHERE ordernumber = 'P200613123425374' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395823'
                WHERE ordernumber = 'P180613123428229' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320976'
                WHERE ordernumber = 'P180613123630175' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395824'
                WHERE ordernumber = 'P420613123923218' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211099'
                WHERE ordernumber = 'P200613124729200' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395826'
                WHERE ordernumber = 'P420613124842364' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395827'
                WHERE ordernumber = 'P420613125200388' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395828'
                WHERE ordernumber = 'P180613125356247' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '152905'
                WHERE ordernumber = 'P180613125708734' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395829'
                WHERE ordernumber = 'P420613130048861' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395830'
                WHERE ordernumber = 'P420613130215153' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390114'
                WHERE ordernumber = 'P630613130308857' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395831'
                WHERE ordernumber = 'P420613130410925' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376026'
                WHERE ordernumber = 'P180613130809648' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371010'
                WHERE ordernumber = 'P190613131023390' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381865'
                WHERE ordernumber = 'P200613131129155' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395833'
                WHERE ordernumber = 'P200613131422459' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98541'
                WHERE ordernumber = 'P180613131633270' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367490'
                WHERE ordernumber = 'P420613131702538' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395834'
                WHERE ordernumber = 'P200613132300325' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180613132628588' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104147'
                WHERE ordernumber = 'P180613134425260' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299086'
                WHERE ordernumber = 'P180613134537849' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395836'
                WHERE ordernumber = 'P780613135216257' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P200613135302828' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124258'
                WHERE ordernumber = 'P780613135609485' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395837'
                WHERE ordernumber = 'P180613140528153' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395818'
                WHERE ordernumber = 'P180613140752240' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395839'
                WHERE ordernumber = 'P420613141621812' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395840'
                WHERE ordernumber = 'P200613141709619' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200613141808790' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395841'
                WHERE ordernumber = 'P180613142458953' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237270'
                WHERE ordernumber = 'P780613142622420' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P180613142752877' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395842'
                WHERE ordernumber = 'P190613142935600' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395843'
                WHERE ordernumber = 'P420613143004619' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395844'
                WHERE ordernumber = 'P420613143255595' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395847'
                WHERE ordernumber = 'P180613143720290' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232096'
                WHERE ordernumber = 'P420613144252773' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395849'
                WHERE ordernumber = 'P200613144316379' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395846'
                WHERE ordernumber = 'P180613144555425' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232096'
                WHERE ordernumber = 'P420613144710693' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395852'
                WHERE ordernumber = 'P180613145341549' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389253'
                WHERE ordernumber = 'P180613145535722' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395853'
                WHERE ordernumber = 'P200613150109517' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360375'
                WHERE ordernumber = 'P420613150141464' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376279'
                WHERE ordernumber = 'P190613150310183' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378722'
                WHERE ordernumber = 'P180613150946642' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395856'
                WHERE ordernumber = 'P780613152206187' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390180'
                WHERE ordernumber = 'P180613152302730' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314742'
                WHERE ordernumber = 'P420613152428125' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310323'
                WHERE ordernumber = 'P200613152715998' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395857'
                WHERE ordernumber = 'P780613152722924' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395858'
                WHERE ordernumber = 'P420613153621502' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394393'
                WHERE ordernumber = 'P190613153931125' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391760'
                WHERE ordernumber = 'P180613154522929' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395860'
                WHERE ordernumber = 'P180613154820603' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395861'
                WHERE ordernumber = 'P200613154929679' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326171'
                WHERE ordernumber = 'P180613155202522' 
            
2024-06-14 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '35016'
                WHERE ordernumber = 'P200613155319481' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395862'
                WHERE ordernumber = 'P200613160032799' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395008'
                WHERE ordernumber = 'P780613160101392' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395863'
                WHERE ordernumber = 'P180613160228923' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180613160328413' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395864'
                WHERE ordernumber = 'P180613160633807' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379472'
                WHERE ordernumber = 'P200613161028734' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122424'
                WHERE ordernumber = 'P180613161439346' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316726'
                WHERE ordernumber = 'P190613161514641' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80965'
                WHERE ordernumber = 'P180613161738923' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329885'
                WHERE ordernumber = 'P420613161853340' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395866'
                WHERE ordernumber = 'P180613162126634' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378146'
                WHERE ordernumber = 'P780613162403527' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395868'
                WHERE ordernumber = 'P180613162424753' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395867'
                WHERE ordernumber = 'P200613162432433' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212373'
                WHERE ordernumber = 'P180613163006979' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98529'
                WHERE ordernumber = 'P190613163112769' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395623'
                WHERE ordernumber = 'P180613163236949' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182042'
                WHERE ordernumber = 'P200613163255350' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395869'
                WHERE ordernumber = 'P180613163328296' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395873'
                WHERE ordernumber = 'P180613164758803' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395436'
                WHERE ordernumber = 'P200613165249406' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155008'
                WHERE ordernumber = 'P200613165902990' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395874'
                WHERE ordernumber = 'P180613170414215' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315281'
                WHERE ordernumber = 'P180613170629595' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389934'
                WHERE ordernumber = 'P420613170809262' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395875'
                WHERE ordernumber = 'P420613171005929' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308346'
                WHERE ordernumber = 'P200613171030322' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367308'
                WHERE ordernumber = 'P180613172129618' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395877'
                WHERE ordernumber = 'P420613172457436' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395878'
                WHERE ordernumber = 'P200613172646675' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395879'
                WHERE ordernumber = 'P780613172743612' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393625'
                WHERE ordernumber = 'P180613172928446' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395880'
                WHERE ordernumber = 'P200613172942768' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302780'
                WHERE ordernumber = 'P200613173054640' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209572'
                WHERE ordernumber = 'P180613173159358' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164340'
                WHERE ordernumber = 'P200613173243858' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395674'
                WHERE ordernumber = 'P420613173846825' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395881'
                WHERE ordernumber = 'P180613174447154' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395882'
                WHERE ordernumber = 'P200613174505115' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '1110'
                WHERE ordernumber = 'P190613174532960' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395883'
                WHERE ordernumber = 'P420613174912669' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283585'
                WHERE ordernumber = 'P200613174944389' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395884'
                WHERE ordernumber = 'P420613175016763' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283585'
                WHERE ordernumber = 'P200613175044779' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343050'
                WHERE ordernumber = 'P180613175120115' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395885'
                WHERE ordernumber = 'P420613175218834' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395886'
                WHERE ordernumber = 'P200613175315786' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395887'
                WHERE ordernumber = 'P420613175559894' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131558'
                WHERE ordernumber = 'P180613180155300' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395888'
                WHERE ordernumber = 'P180613180454970' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395889'
                WHERE ordernumber = 'P200613180757133' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P180613180917197' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382707'
                WHERE ordernumber = 'P420613180931942' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89106'
                WHERE ordernumber = 'P200613181103381' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395890'
                WHERE ordernumber = 'P200613181209111' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395892'
                WHERE ordernumber = 'P420613181625770' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395893'
                WHERE ordernumber = 'P200613181838521' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394994'
                WHERE ordernumber = 'P420613181914699' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395893'
                WHERE ordernumber = 'P200613181920821' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58538'
                WHERE ordernumber = 'P420613182031567' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387816'
                WHERE ordernumber = 'P630613182202739' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130508'
                WHERE ordernumber = 'P180613182352687' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395816'
                WHERE ordernumber = 'P420613182354445' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395895'
                WHERE ordernumber = 'P780613182402927' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395897'
                WHERE ordernumber = 'P200613182423167' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386388'
                WHERE ordernumber = 'P630613182647845' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395898'
                WHERE ordernumber = 'P420613182717925' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41427'
                WHERE ordernumber = 'P190613182718241' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395340'
                WHERE ordernumber = 'P180613182837693' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302195'
                WHERE ordernumber = 'P420613183008523' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395900'
                WHERE ordernumber = 'P420613183223167' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395899'
                WHERE ordernumber = 'P780613183319232' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332081'
                WHERE ordernumber = 'P200613183435412' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39164'
                WHERE ordernumber = 'P420613183452881' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395901'
                WHERE ordernumber = 'P420613183737278' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271193'
                WHERE ordernumber = 'P180613183841518' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395902'
                WHERE ordernumber = 'P420613183928368' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295357'
                WHERE ordernumber = 'P200613184505351' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395904'
                WHERE ordernumber = 'P200613184603964' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388916'
                WHERE ordernumber = 'P420613184727697' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344787'
                WHERE ordernumber = 'P190613185113659' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395906'
                WHERE ordernumber = 'P190613185353589' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395907'
                WHERE ordernumber = 'P420613185520619' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384498'
                WHERE ordernumber = 'P190613185643610' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284679'
                WHERE ordernumber = 'P190613190453818' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395908'
                WHERE ordernumber = 'P200613190535198' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395909'
                WHERE ordernumber = 'P190613190621522' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395149'
                WHERE ordernumber = 'P780613190755579' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282484'
                WHERE ordernumber = 'P190613190842548' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395910'
                WHERE ordernumber = 'P200613190846495' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200613190959140' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395911'
                WHERE ordernumber = 'P200613191101354' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395912'
                WHERE ordernumber = 'P200613191201657' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200613191452223' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395912'
                WHERE ordernumber = 'P200613191740918' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190613191755302' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247277'
                WHERE ordernumber = 'P200613191838961' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220663'
                WHERE ordernumber = 'P190613192031353' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395913'
                WHERE ordernumber = 'P190613192218484' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395915'
                WHERE ordernumber = 'P200613192345587' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395914'
                WHERE ordernumber = 'P190613192421740' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386366'
                WHERE ordernumber = 'P590613193835471' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231102'
                WHERE ordernumber = 'P200613194029783' 
            
2024-06-14 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395919'
                WHERE ordernumber = 'P780613195312129' 
            
2024-06-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146845'
                WHERE ordernumber = 'P590613200508452' 
            
2024-06-14 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '146845'
                WHERE ordernumber = 'P590613200519314'