2024-06-17 01:00:01 -- 將會員中心id寫入data-lake
2024-06-17 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-16%';
        
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138937'
                WHERE ordernumber = 'P630616100612800' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389445'
                WHERE ordernumber = 'P630616101421121' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396231'
                WHERE ordernumber = 'P200616110423129' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200616110617508' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396233'
                WHERE ordernumber = 'P180616110648825' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229003'
                WHERE ordernumber = 'P200616110652978' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345125'
                WHERE ordernumber = 'P180616110739323' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305962'
                WHERE ordernumber = 'P190616110758985' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396221'
                WHERE ordernumber = 'P200616110854810' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396234'
                WHERE ordernumber = 'P420616111016911' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393664'
                WHERE ordernumber = 'P420616111233312' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396236'
                WHERE ordernumber = 'P190616111406311' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396238'
                WHERE ordernumber = 'P180616111432364' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396237'
                WHERE ordernumber = 'P200616111450720' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250902'
                WHERE ordernumber = 'P200616111829138' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373255'
                WHERE ordernumber = 'P420616112323508' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302949'
                WHERE ordernumber = 'P420616112509906' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396239'
                WHERE ordernumber = 'P200616112905725' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396240'
                WHERE ordernumber = 'P200616113040776' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111567'
                WHERE ordernumber = 'P180616113730731' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396242'
                WHERE ordernumber = 'P190616113751819' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224684'
                WHERE ordernumber = 'P190616114048572' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396243'
                WHERE ordernumber = 'P190616114233473' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396244'
                WHERE ordernumber = 'P180616114534129' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396245'
                WHERE ordernumber = 'P190616114713717' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396246'
                WHERE ordernumber = 'P200616114858681' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371883'
                WHERE ordernumber = 'P190616115016329' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396247'
                WHERE ordernumber = 'P190616115157301' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269626'
                WHERE ordernumber = 'P200616115236428' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396211'
                WHERE ordernumber = 'P190616115520244' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396249'
                WHERE ordernumber = 'P190616120243531' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217501'
                WHERE ordernumber = 'P190616120555734' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396250'
                WHERE ordernumber = 'P200616120700520' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121657'
                WHERE ordernumber = 'P180616120908805' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354447'
                WHERE ordernumber = 'P180616121209642' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211838'
                WHERE ordernumber = 'P180616121345683' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396251'
                WHERE ordernumber = 'P780616121803136' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396252'
                WHERE ordernumber = 'P190616122021360' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347468'
                WHERE ordernumber = 'P200616122219713' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396253'
                WHERE ordernumber = 'P420616122637511' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396254'
                WHERE ordernumber = 'P420616123121186' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396255'
                WHERE ordernumber = 'P420616123500372' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313605'
                WHERE ordernumber = 'P200616123547653' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242915'
                WHERE ordernumber = 'P190616123952512' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396256'
                WHERE ordernumber = 'P200616124005836' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264848'
                WHERE ordernumber = 'P190616124107679' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396257'
                WHERE ordernumber = 'P190616124250851' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393056'
                WHERE ordernumber = 'P420616124251630' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375564'
                WHERE ordernumber = 'P420616124518641' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396259'
                WHERE ordernumber = 'P780616125205839' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230343'
                WHERE ordernumber = 'P200616125634691' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396260'
                WHERE ordernumber = 'P420616130259873' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '132901'
                WHERE ordernumber = 'P190616130333900' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396261'
                WHERE ordernumber = 'P420616130639931' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236098'
                WHERE ordernumber = 'P190616130840652' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347809'
                WHERE ordernumber = 'P190616131101864' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396262'
                WHERE ordernumber = 'P190616131718833' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396263'
                WHERE ordernumber = 'P190616131832523' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396264'
                WHERE ordernumber = 'P420616131837983' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245890'
                WHERE ordernumber = 'P180616132258493' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396230'
                WHERE ordernumber = 'P180616132431943' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111386'
                WHERE ordernumber = 'P180616132545981' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396266'
                WHERE ordernumber = 'P180616132712202' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396268'
                WHERE ordernumber = 'P200616133251742' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206261'
                WHERE ordernumber = 'P180616133259700' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261293'
                WHERE ordernumber = 'P200616133402955' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P200616133514983' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396269'
                WHERE ordernumber = 'P180616133617247' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396270'
                WHERE ordernumber = 'P780616133837601' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280380'
                WHERE ordernumber = 'P180616133841886' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280380'
                WHERE ordernumber = 'P180616134001300' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396272'
                WHERE ordernumber = 'P180616134223315' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396273'
                WHERE ordernumber = 'P180616134343307' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396271'
                WHERE ordernumber = 'P190616134415730' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396275'
                WHERE ordernumber = 'P180616134511987' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396276'
                WHERE ordernumber = 'P420616134616505' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389529'
                WHERE ordernumber = 'P420616134844797' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396277'
                WHERE ordernumber = 'P180616134925246' 
            
2024-06-17 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396278'
                WHERE ordernumber = 'P420616135339674' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396279'
                WHERE ordernumber = 'P180616135649772' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117509'
                WHERE ordernumber = 'P180616140238302' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200616140352366' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396281'
                WHERE ordernumber = 'P200616140701796' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396283'
                WHERE ordernumber = 'P420616140949842' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396284'
                WHERE ordernumber = 'P420616141431624' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304571'
                WHERE ordernumber = 'P180616141554502' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396285'
                WHERE ordernumber = 'P180616141714306' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244637'
                WHERE ordernumber = 'P200616141936786' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396287'
                WHERE ordernumber = 'P180616142247349' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396288'
                WHERE ordernumber = 'P420616142319973' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396289'
                WHERE ordernumber = 'P420616142431718' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396290'
                WHERE ordernumber = 'P420616142529525' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396291'
                WHERE ordernumber = 'P420616142649395' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388932'
                WHERE ordernumber = 'P630616142745115' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396292'
                WHERE ordernumber = 'P420616142853498' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396293'
                WHERE ordernumber = 'P420616143113602' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396294'
                WHERE ordernumber = 'P190616143302564' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165061'
                WHERE ordernumber = 'P420616143306996' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289556'
                WHERE ordernumber = 'P180616143340486' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396296'
                WHERE ordernumber = 'P420616143433736' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388053'
                WHERE ordernumber = 'P200616143520738' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396298'
                WHERE ordernumber = 'P190616143913462' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118795'
                WHERE ordernumber = 'P420616143936669' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396299'
                WHERE ordernumber = 'P180616144207208' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396280'
                WHERE ordernumber = 'P590616144423494' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396300'
                WHERE ordernumber = 'P180616144558114' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364413'
                WHERE ordernumber = 'P190616144859234' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396301'
                WHERE ordernumber = 'P180616144924838' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420616145231172' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396302'
                WHERE ordernumber = 'P780616145808412' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210382'
                WHERE ordernumber = 'P200616145811187' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396303'
                WHERE ordernumber = 'P420616145937609' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '17237'
                WHERE ordernumber = 'P180616150224694' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396305'
                WHERE ordernumber = 'P180616150447832' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396306'
                WHERE ordernumber = 'P190616150607665' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394679'
                WHERE ordernumber = 'P420616151125311' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396307'
                WHERE ordernumber = 'P420616151314292' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P180616151530820' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396309'
                WHERE ordernumber = 'P200616151538399' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254066'
                WHERE ordernumber = 'P780616151706238' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275764'
                WHERE ordernumber = 'P420616151842514' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316411'
                WHERE ordernumber = 'P200616151938738' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396311'
                WHERE ordernumber = 'P420616152651116' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396312'
                WHERE ordernumber = 'P180616152830446' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396313'
                WHERE ordernumber = 'P180616153154890' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396314'
                WHERE ordernumber = 'P190616153227158' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P180616153507660' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396317'
                WHERE ordernumber = 'P190616153603301' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396318'
                WHERE ordernumber = 'P180616153634638' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384907'
                WHERE ordernumber = 'P200616154006291' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334975'
                WHERE ordernumber = 'P420616154236280' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396320'
                WHERE ordernumber = 'P420616154510203' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396322'
                WHERE ordernumber = 'P180616155231631' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396324'
                WHERE ordernumber = 'P200616155541391' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396325'
                WHERE ordernumber = 'P420616155807648' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396310'
                WHERE ordernumber = 'P420616160118998' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396326'
                WHERE ordernumber = 'P200616160130322' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229352'
                WHERE ordernumber = 'P180616160210710' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389559'
                WHERE ordernumber = 'P420616160248962' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347603'
                WHERE ordernumber = 'P200616160416719' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396327'
                WHERE ordernumber = 'P200616160521445' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396209'
                WHERE ordernumber = 'P420616160636154' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396328'
                WHERE ordernumber = 'P780616161030276' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160358'
                WHERE ordernumber = 'P200616161200527' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393389'
                WHERE ordernumber = 'P420616161319525' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396329'
                WHERE ordernumber = 'P180616161427562' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396329'
                WHERE ordernumber = 'P180616161617602' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396331'
                WHERE ordernumber = 'P180616162120504' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396333'
                WHERE ordernumber = 'P180616162527275' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396334'
                WHERE ordernumber = 'P190616162605516' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396335'
                WHERE ordernumber = 'P780616162643193' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396336'
                WHERE ordernumber = 'P180616162808460' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396337'
                WHERE ordernumber = 'P420616163150785' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107384'
                WHERE ordernumber = 'P420616163656412' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207236'
                WHERE ordernumber = 'P190616163850128' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396338'
                WHERE ordernumber = 'P420616164141468' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297230'
                WHERE ordernumber = 'P420616164228991' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396340'
                WHERE ordernumber = 'P180616164356340' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143799'
                WHERE ordernumber = 'P190616164501466' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396341'
                WHERE ordernumber = 'P180616164611677' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338769'
                WHERE ordernumber = 'P420616164617389' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396342'
                WHERE ordernumber = 'P180616165159897' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396343'
                WHERE ordernumber = 'P180616165656178' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396345'
                WHERE ordernumber = 'P180616170547649' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396346'
                WHERE ordernumber = 'P180616170708245' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396347'
                WHERE ordernumber = 'P180616171405357' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396348'
                WHERE ordernumber = 'P180616171737655' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392029'
                WHERE ordernumber = 'P200616172037637' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396349'
                WHERE ordernumber = 'P180616172152541' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384979'
                WHERE ordernumber = 'P200616172518308' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396350'
                WHERE ordernumber = 'P200616172638380' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396351'
                WHERE ordernumber = 'P420616172930432' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396352'
                WHERE ordernumber = 'P200616173612420' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200616174055424' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396353'
                WHERE ordernumber = 'P180616174348276' 
            
2024-06-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139595'
                WHERE ordernumber = 'P780616174455674' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396354'
                WHERE ordernumber = 'P780616174914608' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395168'
                WHERE ordernumber = 'P420616175151922' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396356'
                WHERE ordernumber = 'P180616175642636' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396360'
                WHERE ordernumber = 'P200616180418187' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396361'
                WHERE ordernumber = 'P420616180944697' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396363'
                WHERE ordernumber = 'P180616181203342' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344911'
                WHERE ordernumber = 'P180616181244725' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375510'
                WHERE ordernumber = 'P180616181342822' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P180616181445261' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396362'
                WHERE ordernumber = 'P190616181415274' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375510'
                WHERE ordernumber = 'P180616181705806' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396364'
                WHERE ordernumber = 'P420616181841298' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396365'
                WHERE ordernumber = 'P200616181912867' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371729'
                WHERE ordernumber = 'P180616183131992' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251920'
                WHERE ordernumber = 'P200616183303533' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396366'
                WHERE ordernumber = 'P200616183522275' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396367'
                WHERE ordernumber = 'P200616183804543' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384438'
                WHERE ordernumber = 'P200616183959401' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225197'
                WHERE ordernumber = 'P180616184123544' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384231'
                WHERE ordernumber = 'P200616184616551' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396369'
                WHERE ordernumber = 'P780616184720267' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396370'
                WHERE ordernumber = 'P190616184754348' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395400'
                WHERE ordernumber = 'P200616184932599' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321276'
                WHERE ordernumber = 'P190616185739377' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276459'
                WHERE ordernumber = 'P190616190243115' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396372'
                WHERE ordernumber = 'P190616190635262' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396373'
                WHERE ordernumber = 'P200616190903821' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310730'
                WHERE ordernumber = 'P200616191325359' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396374'
                WHERE ordernumber = 'P630616191457887' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396375'
                WHERE ordernumber = 'P200616191617369' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288531'
                WHERE ordernumber = 'P630616191747795' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396376'
                WHERE ordernumber = 'P200616191846443' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372068'
                WHERE ordernumber = 'P200616192357522' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350442'
                WHERE ordernumber = 'P190616193405421' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384794'
                WHERE ordernumber = 'P780616194707323' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396378'
                WHERE ordernumber = 'P630616195056669' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396378'
                WHERE ordernumber = 'P630616195100138' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396379'
                WHERE ordernumber = 'P190616195157591' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396380'
                WHERE ordernumber = 'P190616195821129' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396381'
                WHERE ordernumber = 'P780616201128534' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396383'
                WHERE ordernumber = 'P630616204135434' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396384'
                WHERE ordernumber = 'P630616205111284' 
            
2024-06-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246371'
                WHERE ordernumber = 'P780616205113112'