2024-08-27 01:00:02 -- 將會員中心id寫入data-lake
2024-08-27 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-08-26%';
        
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P180826110231748' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413945'
                WHERE ordernumber = 'P200826110240565' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407903'
                WHERE ordernumber = 'P420826110402236' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200826110521277' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333321'
                WHERE ordernumber = 'P180826110640955' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282963'
                WHERE ordernumber = 'P180826110734238' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154616'
                WHERE ordernumber = 'P200826110825753' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413001'
                WHERE ordernumber = 'P420826111033634' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413950'
                WHERE ordernumber = 'P180826111044390' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289725'
                WHERE ordernumber = 'P200826111142536' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P200826111351607' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190826111437717' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413958'
                WHERE ordernumber = 'P180826111659391' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408327'
                WHERE ordernumber = 'P420826111810339' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408327'
                WHERE ordernumber = 'P420826111913162' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94355'
                WHERE ordernumber = 'P180826112020802' 
            
2024-08-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394604'
                WHERE ordernumber = 'P180826112254851' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P190826112308999' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413962'
                WHERE ordernumber = 'P420826112507182' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315976'
                WHERE ordernumber = 'P200826112517717' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94355'
                WHERE ordernumber = 'P180826112609673' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394547'
                WHERE ordernumber = 'P190826112655654' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247870'
                WHERE ordernumber = 'P200826112728947' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315976'
                WHERE ordernumber = 'P200826112825924' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413972'
                WHERE ordernumber = 'P190826112953408' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413973'
                WHERE ordernumber = 'P200826113043700' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180826113112441' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408191'
                WHERE ordernumber = 'P190826113221859' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328262'
                WHERE ordernumber = 'P190826113253619' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385132'
                WHERE ordernumber = 'P190826113354453' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221026'
                WHERE ordernumber = 'P180826113534954' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413980'
                WHERE ordernumber = 'P420826113605827' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413982'
                WHERE ordernumber = 'P420826113714993' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248874'
                WHERE ordernumber = 'P180826113756474' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265677'
                WHERE ordernumber = 'P190826113801955' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413068'
                WHERE ordernumber = 'P420826114240171' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413989'
                WHERE ordernumber = 'P180826114306537' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309763'
                WHERE ordernumber = 'P200826114400773' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413991'
                WHERE ordernumber = 'P180826114406186' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413993'
                WHERE ordernumber = 'P180826114613932' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413068'
                WHERE ordernumber = 'P420826115028262' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413997'
                WHERE ordernumber = 'P180826115742585' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413998'
                WHERE ordernumber = 'P180826115910672' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296876'
                WHERE ordernumber = 'P420826120008640' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243427'
                WHERE ordernumber = 'P190826120016480' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396409'
                WHERE ordernumber = 'P630826120208879' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414000'
                WHERE ordernumber = 'P190826120358421' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413937'
                WHERE ordernumber = 'P180826120520501' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413937'
                WHERE ordernumber = 'P180826120546924' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333379'
                WHERE ordernumber = 'P190826120647279' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380454'
                WHERE ordernumber = 'P180826120732367' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232816'
                WHERE ordernumber = 'P200826120924282' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414004'
                WHERE ordernumber = 'P200826121049988' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399365'
                WHERE ordernumber = 'P190826121111777' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414005'
                WHERE ordernumber = 'P420826121111701' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409942'
                WHERE ordernumber = 'P180826121241244' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410422'
                WHERE ordernumber = 'P190826121340537' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414009'
                WHERE ordernumber = 'P420826121347645' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414012'
                WHERE ordernumber = 'P420826121743141' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200826122225470' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96336'
                WHERE ordernumber = 'P190826122451592' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277350'
                WHERE ordernumber = 'P190826122603824' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409404'
                WHERE ordernumber = 'P200826123020381' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303481'
                WHERE ordernumber = 'P180826123444711' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397181'
                WHERE ordernumber = 'P180826123613169' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412933'
                WHERE ordernumber = 'P420826123635845' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303481'
                WHERE ordernumber = 'P180826123702628' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412933'
                WHERE ordernumber = 'P420826123711236' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414024'
                WHERE ordernumber = 'P420826124029414' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P190826124334634' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '333379'
                WHERE ordernumber = 'P190826124503486' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158636'
                WHERE ordernumber = 'P190826125218414' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414028'
                WHERE ordernumber = 'P200826125439941' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414034'
                WHERE ordernumber = 'P200826125616357' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243284'
                WHERE ordernumber = 'P420826125858361' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414036'
                WHERE ordernumber = 'P190826130142658' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P190826130356355' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130945'
                WHERE ordernumber = 'P180826130740968' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414039'
                WHERE ordernumber = 'P420826130749650' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100788'
                WHERE ordernumber = 'P180826131037862' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414041'
                WHERE ordernumber = 'P190826131104178' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414043'
                WHERE ordernumber = 'P180826131150227' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411444'
                WHERE ordernumber = 'P420826131534352' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374487'
                WHERE ordernumber = 'P200826131559967' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401701'
                WHERE ordernumber = 'P420826131819465' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379361'
                WHERE ordernumber = 'P190826131931790' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230692'
                WHERE ordernumber = 'P190826132143166' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414049'
                WHERE ordernumber = 'P420826132317852' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414050'
                WHERE ordernumber = 'P420826132436165' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414052'
                WHERE ordernumber = 'P200826132511292' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414055'
                WHERE ordernumber = 'P190826132957309' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414057'
                WHERE ordernumber = 'P200826133237129' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414049'
                WHERE ordernumber = 'P420826133509270' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414066'
                WHERE ordernumber = 'P190826133726831' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414064'
                WHERE ordernumber = 'P200826133819296' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381521'
                WHERE ordernumber = 'P190826134237794' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404832'
                WHERE ordernumber = 'P190826134448162' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209723'
                WHERE ordernumber = 'P190826134806321' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414073'
                WHERE ordernumber = 'P200826134832165' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414075'
                WHERE ordernumber = 'P190826134918911' 
            
2024-08-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414078'
                WHERE ordernumber = 'P190826135402753' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414080'
                WHERE ordernumber = 'P190826135525407' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412741'
                WHERE ordernumber = 'P420826135536620' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411246'
                WHERE ordernumber = 'P190826135735395' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414085'
                WHERE ordernumber = 'P420826135821893' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414087'
                WHERE ordernumber = 'P190826135927547' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414088'
                WHERE ordernumber = 'P190826140344737' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326272'
                WHERE ordernumber = 'P190826140523762' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414094'
                WHERE ordernumber = 'P180826140758579' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414094'
                WHERE ordernumber = 'P180826141016389' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216895'
                WHERE ordernumber = 'P180826141426715' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399512'
                WHERE ordernumber = 'P200826142503448' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414106'
                WHERE ordernumber = 'P190826143019559' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420826143124376' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414107'
                WHERE ordernumber = 'P180826143219636' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381109'
                WHERE ordernumber = 'P190826143443653' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132376'
                WHERE ordernumber = 'P190826143816182' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260400'
                WHERE ordernumber = 'P190826144036914' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414115'
                WHERE ordernumber = 'P190826144156372' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229255'
                WHERE ordernumber = 'P180826144230784' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414117'
                WHERE ordernumber = 'P180826144400634' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125992'
                WHERE ordernumber = 'P190826144539606' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105989'
                WHERE ordernumber = 'P200826144851279' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302578'
                WHERE ordernumber = 'P420826145145317' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414124'
                WHERE ordernumber = 'P180826145252942' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302578'
                WHERE ordernumber = 'P420826145253466' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225828'
                WHERE ordernumber = 'P420826145500369' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414127'
                WHERE ordernumber = 'P180826145535630' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302841'
                WHERE ordernumber = 'P200826145648829' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413357'
                WHERE ordernumber = 'P420826145724608' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308742'
                WHERE ordernumber = 'P180826145808661' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247088'
                WHERE ordernumber = 'P420826145845453' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414128'
                WHERE ordernumber = 'P180826150009318' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335758'
                WHERE ordernumber = 'P200826150043286' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208509'
                WHERE ordernumber = 'P180826150126226' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255897'
                WHERE ordernumber = 'P180826150320942' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311253'
                WHERE ordernumber = 'P200826150407255' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396545'
                WHERE ordernumber = 'P420826150432155' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360498'
                WHERE ordernumber = 'P200826150759884' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414136'
                WHERE ordernumber = 'P420826150953654' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410336'
                WHERE ordernumber = 'P420826151104634' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414141'
                WHERE ordernumber = 'P190826151611436' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P190826151704654' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392584'
                WHERE ordernumber = 'P420826152007504' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285018'
                WHERE ordernumber = 'P180826152049172' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414144'
                WHERE ordernumber = 'P420826152153616' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414146'
                WHERE ordernumber = 'P190826152316160' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414147'
                WHERE ordernumber = 'P190826152431822' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414152'
                WHERE ordernumber = 'P190826153013777' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231253'
                WHERE ordernumber = 'P190826153258706' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P200826154047644' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414161'
                WHERE ordernumber = 'P190826154241744' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414163'
                WHERE ordernumber = 'P200826154455336' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392809'
                WHERE ordernumber = 'P190826154702714' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414167'
                WHERE ordernumber = 'P190826155043886' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414167'
                WHERE ordernumber = 'P190826155605309' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411067'
                WHERE ordernumber = 'P420826160128390' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399640'
                WHERE ordernumber = 'P190826160205427' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123399'
                WHERE ordernumber = 'P200826160633526' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276029'
                WHERE ordernumber = 'P190826160732818' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414174'
                WHERE ordernumber = 'P180826160800874' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349493'
                WHERE ordernumber = 'P190826161244413' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349493'
                WHERE ordernumber = 'P190826161338932' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391779'
                WHERE ordernumber = 'P420826162456536' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414185'
                WHERE ordernumber = 'P420826162547521' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238636'
                WHERE ordernumber = 'P200826162713131' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414187'
                WHERE ordernumber = 'P420826162728403' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106056'
                WHERE ordernumber = 'P200826162825504' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30391'
                WHERE ordernumber = 'P190826163006807' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414193'
                WHERE ordernumber = 'P180826163545111' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P190826163941671' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229212'
                WHERE ordernumber = 'P180826164448581' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228414'
                WHERE ordernumber = 'P180826164721182' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414202'
                WHERE ordernumber = 'P420826164727799' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414202'
                WHERE ordernumber = 'P420826164816877' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355470'
                WHERE ordernumber = 'P200826164843655' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414204'
                WHERE ordernumber = 'P190826164852355' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414208'
                WHERE ordernumber = 'P420826165127867' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337343'
                WHERE ordernumber = 'P200826165339920' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236613'
                WHERE ordernumber = 'P180826165343848' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384264'
                WHERE ordernumber = 'P420826165724272' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401796'
                WHERE ordernumber = 'P180826170101467' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401448'
                WHERE ordernumber = 'P180826170306149' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P180826170712312' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414215'
                WHERE ordernumber = 'P420826170722593' 
            
2024-08-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105394'
                WHERE ordernumber = 'P180826170812232' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '412295'
                WHERE ordernumber = 'P180826171105673' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388584'
                WHERE ordernumber = 'P420826171619112' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414223'
                WHERE ordernumber = 'P200826172037596' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324640'
                WHERE ordernumber = 'P180826172223187' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409248'
                WHERE ordernumber = 'P420826172231797' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93668'
                WHERE ordernumber = 'P420826172452176' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414228'
                WHERE ordernumber = 'P200826172749177' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414226'
                WHERE ordernumber = 'P180826172837935' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414231'
                WHERE ordernumber = 'P200826173312944' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414233'
                WHERE ordernumber = 'P200826173541227' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414234'
                WHERE ordernumber = 'P180826173608480' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414237'
                WHERE ordernumber = 'P200826173701561' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414238'
                WHERE ordernumber = 'P420826173717695' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414240'
                WHERE ordernumber = 'P180826173917745' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414235'
                WHERE ordernumber = 'P180826174129245' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414235'
                WHERE ordernumber = 'P180826174202596' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414243'
                WHERE ordernumber = 'P200826174306324' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406743'
                WHERE ordernumber = 'P420826174337726' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100581'
                WHERE ordernumber = 'P190826174501489' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413184'
                WHERE ordernumber = 'P200826174751819' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414245'
                WHERE ordernumber = 'P190826175051375' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299266'
                WHERE ordernumber = 'P200826175121954' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285183'
                WHERE ordernumber = 'P190826175254199' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '122253'
                WHERE ordernumber = 'P190826175447474' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413074'
                WHERE ordernumber = 'P180826175648257' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414250'
                WHERE ordernumber = 'P190826175706937' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '132578'
                WHERE ordernumber = 'P180826175933865' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306209'
                WHERE ordernumber = 'P180826180334443' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391388'
                WHERE ordernumber = 'P190826180419754' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414254'
                WHERE ordernumber = 'P420826180444679' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414256'
                WHERE ordernumber = 'P200826180628992' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396832'
                WHERE ordernumber = 'P190826180651196' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406763'
                WHERE ordernumber = 'P180826180828787' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371704'
                WHERE ordernumber = 'P420826180932370' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414258'
                WHERE ordernumber = 'P200826181009542' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378789'
                WHERE ordernumber = 'P200826181222449' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414263'
                WHERE ordernumber = 'P420826181858311' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218028'
                WHERE ordernumber = 'P200826182359152' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407512'
                WHERE ordernumber = 'P420826182444125' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413988'
                WHERE ordernumber = 'P200826182454822' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '226988'
                WHERE ordernumber = 'P180826182559811' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414266'
                WHERE ordernumber = 'P200826182757708' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414268'
                WHERE ordernumber = 'P420826182801787' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285107'
                WHERE ordernumber = 'P200826182923221' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254496'
                WHERE ordernumber = 'P180826182931434' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396276'
                WHERE ordernumber = 'P200826183146891' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393541'
                WHERE ordernumber = 'P630826183343198' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406351'
                WHERE ordernumber = 'P180826183612436' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406351'
                WHERE ordernumber = 'P180826183644945' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406351'
                WHERE ordernumber = 'P180826183742334' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265715'
                WHERE ordernumber = 'P420826183919833' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341104'
                WHERE ordernumber = 'P420826184404318' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286628'
                WHERE ordernumber = 'P200826184501187' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341104'
                WHERE ordernumber = 'P420826185035930' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '249257'
                WHERE ordernumber = 'P200826185055808' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414277'
                WHERE ordernumber = 'P420826185346606' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253357'
                WHERE ordernumber = 'P200826185520496' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414280'
                WHERE ordernumber = 'P200826185704487' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '408149'
                WHERE ordernumber = 'P420826185729441' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '176708'
                WHERE ordernumber = 'P200826190307271' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406774'
                WHERE ordernumber = 'P190826190929182' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319782'
                WHERE ordernumber = 'P200826191235706' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P200826191356132' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414290'
                WHERE ordernumber = 'P200826191713488' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '126699'
                WHERE ordernumber = 'P190826192109683' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414297'
                WHERE ordernumber = 'P190826192530995' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '115842'
                WHERE ordernumber = 'P190826192638641' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393465'
                WHERE ordernumber = 'P190826192704259' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414299'
                WHERE ordernumber = 'P190826192829559' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397910'
                WHERE ordernumber = 'P190826192915666' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414302'
                WHERE ordernumber = 'P190826193534512' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304627'
                WHERE ordernumber = 'P200826193544444' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '178120'
                WHERE ordernumber = 'P190826193734621' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414304'
                WHERE ordernumber = 'P190826193919949' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414306'
                WHERE ordernumber = 'P190826194148506' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236690'
                WHERE ordernumber = 'P190826194246364' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404633'
                WHERE ordernumber = 'P190826194356803' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414307'
                WHERE ordernumber = 'P200826194439486' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414308'
                WHERE ordernumber = 'P190826194553859' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414309'
                WHERE ordernumber = 'P200826194605287' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P200826194757339' 
            
2024-08-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '14692'
                WHERE ordernumber = 'P190826195250541'