2024-03-16 01:00:01 -- 將會員中心id寫入data-lake
2024-03-16 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-03-15%';
        
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '111252'
                WHERE ordernumber = 'P200315110020785' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '381567'
                WHERE ordernumber = 'P180315110211570' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '273047'
                WHERE ordernumber = 'P180315110252586' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P420315110345691' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '80893'
                WHERE ordernumber = 'P200315110406161' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P200315110624375' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '381568'
                WHERE ordernumber = 'P420315110753552' 
            
2024-03-16 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '284676'
                WHERE ordernumber = 'P180315110912702' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381566'
                WHERE ordernumber = 'P180315111139520' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180315111337893' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235692'
                WHERE ordernumber = 'P180315111533175' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381569'
                WHERE ordernumber = 'P180315111751577' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '321539'
                WHERE ordernumber = 'P180315112141667' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381571'
                WHERE ordernumber = 'P180315112247358' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P200315112355923' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136223'
                WHERE ordernumber = 'P200315112504314' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381572'
                WHERE ordernumber = 'P180315112736683' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381422'
                WHERE ordernumber = 'P420315112837510' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381573'
                WHERE ordernumber = 'P420315113237966' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381574'
                WHERE ordernumber = 'P420315113441799' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381575'
                WHERE ordernumber = 'P190315113729693' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381576'
                WHERE ordernumber = 'P180315113834866' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200315113956186' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381577'
                WHERE ordernumber = 'P420315114313898' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381579'
                WHERE ordernumber = 'P200315114508238' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '165635'
                WHERE ordernumber = 'P180315114708303' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381581'
                WHERE ordernumber = 'P420315114843476' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277764'
                WHERE ordernumber = 'P180315115254241' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209443'
                WHERE ordernumber = 'P180315115532431' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211892'
                WHERE ordernumber = 'P180315120302229' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P180315120402130' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340353'
                WHERE ordernumber = 'P420315120520665' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P180315120611362' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133357'
                WHERE ordernumber = 'P420315121754844' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381585'
                WHERE ordernumber = 'P420315122716563' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285538'
                WHERE ordernumber = 'P200315122841118' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381586'
                WHERE ordernumber = 'P420315123153516' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242404'
                WHERE ordernumber = 'P180315123257654' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118072'
                WHERE ordernumber = 'P180315123820954' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380112'
                WHERE ordernumber = 'P200315124127603' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258188'
                WHERE ordernumber = 'P180315124129289' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381587'
                WHERE ordernumber = 'P180315124533174' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337747'
                WHERE ordernumber = 'P420315124855313' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381588'
                WHERE ordernumber = 'P590315125218397' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381589'
                WHERE ordernumber = 'P420315125220593' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381590'
                WHERE ordernumber = 'P200315125655149' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '135816'
                WHERE ordernumber = 'P200315130009436' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381591'
                WHERE ordernumber = 'P420315130035822' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200315130517172' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381592'
                WHERE ordernumber = 'P420315131146439' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381593'
                WHERE ordernumber = 'P420315131340470' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381594'
                WHERE ordernumber = 'P200315131434530' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314206'
                WHERE ordernumber = 'P180315131445369' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296768'
                WHERE ordernumber = 'P420315131544594' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381595'
                WHERE ordernumber = 'P200315131719855' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240415'
                WHERE ordernumber = 'P200315132200304' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381596'
                WHERE ordernumber = 'P180315132227117' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381598'
                WHERE ordernumber = 'P200315132536256' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263060'
                WHERE ordernumber = 'P200315132809971' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356625'
                WHERE ordernumber = 'P420315132821983' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118058'
                WHERE ordernumber = 'P180315133020792' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381599'
                WHERE ordernumber = 'P180315133620993' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381597'
                WHERE ordernumber = 'P590315133705904' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '215703'
                WHERE ordernumber = 'P180315133824382' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381602'
                WHERE ordernumber = 'P200315134040527' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381601'
                WHERE ordernumber = 'P420315134043412' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '49080'
                WHERE ordernumber = 'P180315134232286' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381603'
                WHERE ordernumber = 'P180315134410147' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348889'
                WHERE ordernumber = 'P200315134505883' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381604'
                WHERE ordernumber = 'P180315134545256' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381605'
                WHERE ordernumber = 'P180315135011918' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '237283'
                WHERE ordernumber = 'P180315135057432' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381606'
                WHERE ordernumber = 'P180315135332848' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381607'
                WHERE ordernumber = 'P180315135545797' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311208'
                WHERE ordernumber = 'P200315135837903' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350741'
                WHERE ordernumber = 'P200315135930982' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381608'
                WHERE ordernumber = 'P180315140126323' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381609'
                WHERE ordernumber = 'P420315140400375' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381610'
                WHERE ordernumber = 'P180315140441851' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224662'
                WHERE ordernumber = 'P180315140528924' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381611'
                WHERE ordernumber = 'P420315140636944' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P420315141002477' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381612'
                WHERE ordernumber = 'P180315141126381' 
            
2024-03-16 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381613'
                WHERE ordernumber = 'P180315141612354' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377470'
                WHERE ordernumber = 'P200315141721677' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263056'
                WHERE ordernumber = 'P180315142511712' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228579'
                WHERE ordernumber = 'P180315143041478' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381616'
                WHERE ordernumber = 'P180315143141416' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381618'
                WHERE ordernumber = 'P180315143341872' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P420315143437209' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200315143714515' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381619'
                WHERE ordernumber = 'P180315143725145' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381620'
                WHERE ordernumber = 'P420315143941225' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381622'
                WHERE ordernumber = 'P180315144309206' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90165'
                WHERE ordernumber = 'P200315144656249' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381623'
                WHERE ordernumber = 'P180315145119353' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103552'
                WHERE ordernumber = 'P180315145520113' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360021'
                WHERE ordernumber = 'P420315145652139' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381624'
                WHERE ordernumber = 'P180315145845644' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P200315150148495' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349975'
                WHERE ordernumber = 'P180315150214954' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381625'
                WHERE ordernumber = 'P200315150345243' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109758'
                WHERE ordernumber = 'P420315150358965' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180315150752791' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381626'
                WHERE ordernumber = 'P420315151338872' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381627'
                WHERE ordernumber = 'P200315151620393' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284824'
                WHERE ordernumber = 'P180315151648664' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317237'
                WHERE ordernumber = 'P180315152619155' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381629'
                WHERE ordernumber = 'P200315152626310' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206405'
                WHERE ordernumber = 'P180315152733684' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381626'
                WHERE ordernumber = 'P420315152737880' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381630'
                WHERE ordernumber = 'P200315152833271' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381632'
                WHERE ordernumber = 'P180315153001631' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381633'
                WHERE ordernumber = 'P200315153511875' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '70345'
                WHERE ordernumber = 'P180315153736940' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381634'
                WHERE ordernumber = 'P180315154754359' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226993'
                WHERE ordernumber = 'P200315155138550' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212111'
                WHERE ordernumber = 'P180315155151644' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101279'
                WHERE ordernumber = 'P200315155542560' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101279'
                WHERE ordernumber = 'P200315155644673' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381636'
                WHERE ordernumber = 'P200315155901397' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381638'
                WHERE ordernumber = 'P200315160039185' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381639'
                WHERE ordernumber = 'P180315160144918' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381640'
                WHERE ordernumber = 'P200315160248768' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381641'
                WHERE ordernumber = 'P180315160642223' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381642'
                WHERE ordernumber = 'P200315161100425' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380568'
                WHERE ordernumber = 'P200315161153781' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277921'
                WHERE ordernumber = 'P180315161411876' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96452'
                WHERE ordernumber = 'P180315161507203' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180315161628152' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95558'
                WHERE ordernumber = 'P200315161716441' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180315161731177' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P180315162129919' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379733'
                WHERE ordernumber = 'P190315162214723' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381644'
                WHERE ordernumber = 'P190315162431230' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279925'
                WHERE ordernumber = 'P180315162432607' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99617'
                WHERE ordernumber = 'P180315162700177' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365084'
                WHERE ordernumber = 'P190315162857203' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378210'
                WHERE ordernumber = 'P200315162914292' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381645'
                WHERE ordernumber = 'P180315162919774' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '56961'
                WHERE ordernumber = 'P180315163222859' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306583'
                WHERE ordernumber = 'P200315163542151' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381646'
                WHERE ordernumber = 'P180315163921993' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381647'
                WHERE ordernumber = 'P420315164159785' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348745'
                WHERE ordernumber = 'P200315164238727' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381649'
                WHERE ordernumber = 'P200315164542111' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331786'
                WHERE ordernumber = 'P420315164834921' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307336'
                WHERE ordernumber = 'P180315164946726' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320876'
                WHERE ordernumber = 'P420315165052616' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353778'
                WHERE ordernumber = 'P200315165320180' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380013'
                WHERE ordernumber = 'P420315165434659' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348013'
                WHERE ordernumber = 'P200315165541547' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381651'
                WHERE ordernumber = 'P200315165638913' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381652'
                WHERE ordernumber = 'P180315170052341' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227786'
                WHERE ordernumber = 'P200315170228208' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P180315170301952' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98694'
                WHERE ordernumber = 'P200315170423628' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381653'
                WHERE ordernumber = 'P420315170506825' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86304'
                WHERE ordernumber = 'P200315170614960' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381654'
                WHERE ordernumber = 'P180315170712693' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381655'
                WHERE ordernumber = 'P200315171525758' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346469'
                WHERE ordernumber = 'P200315171627265' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381656'
                WHERE ordernumber = 'P180315171856911' 
            
2024-03-16 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99246'
                WHERE ordernumber = 'P180315172733153' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381657'
                WHERE ordernumber = 'P180315173122800' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200315173131399' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381658'
                WHERE ordernumber = 'P180315173236352' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353441'
                WHERE ordernumber = 'P180315173408672' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285577'
                WHERE ordernumber = 'P200315173912304' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358485'
                WHERE ordernumber = 'P200315174342520' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374009'
                WHERE ordernumber = 'P180315174350802' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381659'
                WHERE ordernumber = 'P180315174721165' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381660'
                WHERE ordernumber = 'P190315175004279' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381661'
                WHERE ordernumber = 'P180315175136818' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381662'
                WHERE ordernumber = 'P190315175153373' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209467'
                WHERE ordernumber = 'P180315175631614' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381663'
                WHERE ordernumber = 'P200315180005906' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P180315180111159' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381664'
                WHERE ordernumber = 'P180315181234381' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381665'
                WHERE ordernumber = 'P200315181343135' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381666'
                WHERE ordernumber = 'P190315181444863' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381667'
                WHERE ordernumber = 'P420315181636947' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381669'
                WHERE ordernumber = 'P200315181704149' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381668'
                WHERE ordernumber = 'P180315181705609' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381670'
                WHERE ordernumber = 'P420315181807683' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381671'
                WHERE ordernumber = 'P420315182801310' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240724'
                WHERE ordernumber = 'P180315182855816' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377787'
                WHERE ordernumber = 'P180315182931968' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381674'
                WHERE ordernumber = 'P420315182959918' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381676'
                WHERE ordernumber = 'P190315183121331' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381675'
                WHERE ordernumber = 'P420315183148595' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282511'
                WHERE ordernumber = 'P190315183304885' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364393'
                WHERE ordernumber = 'P200315183455516' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381678'
                WHERE ordernumber = 'P200315184304908' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381679'
                WHERE ordernumber = 'P200315184401489' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379790'
                WHERE ordernumber = 'P190315184405590' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381680'
                WHERE ordernumber = 'P190315184846180' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299755'
                WHERE ordernumber = 'P420315184912479' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340153'
                WHERE ordernumber = 'P200315185338667' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361358'
                WHERE ordernumber = 'P190315185415317' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381681'
                WHERE ordernumber = 'P200315185431728' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361358'
                WHERE ordernumber = 'P190315185442597' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381682'
                WHERE ordernumber = 'P590315185717716' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381683'
                WHERE ordernumber = 'P190315185911449' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319110'
                WHERE ordernumber = 'P200315185933293' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380611'
                WHERE ordernumber = 'P190315190729112' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200315191026932' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103369'
                WHERE ordernumber = 'P190315191929937' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381684'
                WHERE ordernumber = 'P200315192140512' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381685'
                WHERE ordernumber = 'P200315192425612' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233236'
                WHERE ordernumber = 'P200315192542358' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359921'
                WHERE ordernumber = 'P190315192624446' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339790'
                WHERE ordernumber = 'P420315193611755' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381686'
                WHERE ordernumber = 'P200315193643475' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P190315193732482' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381687'
                WHERE ordernumber = 'P200315193746949' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381689'
                WHERE ordernumber = 'P420315193905654' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420315194016270' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381690'
                WHERE ordernumber = 'P200315194135833' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381692'
                WHERE ordernumber = 'P590315194502781' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381695'
                WHERE ordernumber = 'P590315194616981' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370569'
                WHERE ordernumber = 'P200315195539783' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78749'
                WHERE ordernumber = 'P420315195611184' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381698'
                WHERE ordernumber = 'P590315203857211' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381701'
                WHERE ordernumber = 'P590315205551937' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381702'
                WHERE ordernumber = 'P590315205907814' 
            
2024-03-16 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381704'
                WHERE ordernumber = 'P590315210811967'