2024-09-11 01:00:02 -- 將會員中心id寫入data-lake
2024-09-11 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-09-10%';
        
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365738'
                WHERE ordernumber = 'P630910101746948' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250272'
                WHERE ordernumber = 'P630910101749268' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420343'
                WHERE ordernumber = 'P420910110207754' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420340'
                WHERE ordernumber = 'P190910110242210' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420340'
                WHERE ordernumber = 'P190910110346992' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420337'
                WHERE ordernumber = 'P200910110348538' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420337'
                WHERE ordernumber = 'P200910110511134' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420255'
                WHERE ordernumber = 'P420910110637233' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311876'
                WHERE ordernumber = 'P180910110639399' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420344'
                WHERE ordernumber = 'P200910110658762' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420326'
                WHERE ordernumber = 'P190910110703751' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420910110751213' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238244'
                WHERE ordernumber = 'P190910110751412' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P200910110852865' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379322'
                WHERE ordernumber = 'P420910110910791' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420103'
                WHERE ordernumber = 'P200910111617644' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419674'
                WHERE ordernumber = 'P180910111638756' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411391'
                WHERE ordernumber = 'P190910111646969' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411391'
                WHERE ordernumber = 'P190910111706378' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338091'
                WHERE ordernumber = 'P180910111831453' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159563'
                WHERE ordernumber = 'P190910111839803' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159563'
                WHERE ordernumber = 'P190910111914765' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420346'
                WHERE ordernumber = 'P190910112209746' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332953'
                WHERE ordernumber = 'P420910112221887' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364567'
                WHERE ordernumber = 'P180910112252641' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332953'
                WHERE ordernumber = 'P420910112314303' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293592'
                WHERE ordernumber = 'P200910112320873' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303987'
                WHERE ordernumber = 'P190910112407305' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339096'
                WHERE ordernumber = 'P180910112635868' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333459'
                WHERE ordernumber = 'P190910112751860' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420347'
                WHERE ordernumber = 'P180910112927374' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337254'
                WHERE ordernumber = 'P420910113451589' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230353'
                WHERE ordernumber = 'P190910113451779' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420348'
                WHERE ordernumber = 'P180910113517737' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '420348'
                WHERE ordernumber = 'P180910113551941' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271216'
                WHERE ordernumber = 'P190910113826135' 
            
2024-09-11 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395528'
                WHERE ordernumber = 'P420910114042852' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200910114150962' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311960'
                WHERE ordernumber = 'P200910114601446' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420349'
                WHERE ordernumber = 'P190910114644856' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334056'
                WHERE ordernumber = 'P200910114650352' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420352'
                WHERE ordernumber = 'P180910114739652' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420360'
                WHERE ordernumber = 'P200910114751706' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311960'
                WHERE ordernumber = 'P200910114822691' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79058'
                WHERE ordernumber = 'P420910114915380' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200910114943776' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111239'
                WHERE ordernumber = 'P190910115011829' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406529'
                WHERE ordernumber = 'P180910115137374' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420362'
                WHERE ordernumber = 'P200910115158689' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404035'
                WHERE ordernumber = 'P420910115231520' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420351'
                WHERE ordernumber = 'P420910115750806' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416914'
                WHERE ordernumber = 'P180910115813282' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351315'
                WHERE ordernumber = 'P180910115833933' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420351'
                WHERE ordernumber = 'P420910115834705' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420357'
                WHERE ordernumber = 'P420910115920122' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420357'
                WHERE ordernumber = 'P420910120000404' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338179'
                WHERE ordernumber = 'P180910120545816' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415254'
                WHERE ordernumber = 'P200910120604648' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419317'
                WHERE ordernumber = 'P180910120734646' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420369'
                WHERE ordernumber = 'P420910121028933' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119802'
                WHERE ordernumber = 'P190910121251915' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220138'
                WHERE ordernumber = 'P180910121513403' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113700'
                WHERE ordernumber = 'P200910121759259' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138016'
                WHERE ordernumber = 'P630910121947140' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '171879'
                WHERE ordernumber = 'P180910122130281' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266458'
                WHERE ordernumber = 'P420910122138479' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420350'
                WHERE ordernumber = 'P190910122248903' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420373'
                WHERE ordernumber = 'P180910122331792' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420350'
                WHERE ordernumber = 'P190910122400984' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220805'
                WHERE ordernumber = 'P180910122505259' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420190'
                WHERE ordernumber = 'P420910122517660' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420368'
                WHERE ordernumber = 'P190910122520459' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232318'
                WHERE ordernumber = 'P180910122556321' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420367'
                WHERE ordernumber = 'P190910122609732' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418372'
                WHERE ordernumber = 'P200910122643872' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420376'
                WHERE ordernumber = 'P180910122656717' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420371'
                WHERE ordernumber = 'P190910122749322' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420374'
                WHERE ordernumber = 'P180910122751237' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305054'
                WHERE ordernumber = 'P190910122912615' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '197299'
                WHERE ordernumber = 'P180910123018529' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164430'
                WHERE ordernumber = 'P200910123038676' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420375'
                WHERE ordernumber = 'P190910123237234' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233524'
                WHERE ordernumber = 'P190910123514595' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420381'
                WHERE ordernumber = 'P420910123518474' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415115'
                WHERE ordernumber = 'P180910123536416' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396563'
                WHERE ordernumber = 'P190910123613461' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386641'
                WHERE ordernumber = 'P200910123731510' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232805'
                WHERE ordernumber = 'P180910124045728' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420383'
                WHERE ordernumber = 'P420910124058681' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298669'
                WHERE ordernumber = 'P200910124128171' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420383'
                WHERE ordernumber = 'P420910124140193' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416914'
                WHERE ordernumber = 'P190910124229566' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420384'
                WHERE ordernumber = 'P180910124243470' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420385'
                WHERE ordernumber = 'P420910124341877' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420386'
                WHERE ordernumber = 'P200910124404335' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420388'
                WHERE ordernumber = 'P420910124514311' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323650'
                WHERE ordernumber = 'P180910124539313' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244978'
                WHERE ordernumber = 'P420910124550910' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420382'
                WHERE ordernumber = 'P190910124603656' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420389'
                WHERE ordernumber = 'P420910124702551' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410264'
                WHERE ordernumber = 'P180910124718912' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287769'
                WHERE ordernumber = 'P200910124721598' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110215'
                WHERE ordernumber = 'P180910124852511' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420390'
                WHERE ordernumber = 'P180910125105443' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '2252'
                WHERE ordernumber = 'P420910125209604' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306047'
                WHERE ordernumber = 'P180910125539737' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416678'
                WHERE ordernumber = 'P190910125610846' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420394'
                WHERE ordernumber = 'P180910125834608' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P190910125959606' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28825'
                WHERE ordernumber = 'P420910130008298' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300812'
                WHERE ordernumber = 'P200910130125790' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88401'
                WHERE ordernumber = 'P200910130338893' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364214'
                WHERE ordernumber = 'P180910130917371' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420395'
                WHERE ordernumber = 'P420910131125839' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106024'
                WHERE ordernumber = 'P180910131600381' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353917'
                WHERE ordernumber = 'P180910131800362' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420398'
                WHERE ordernumber = 'P200910131918298' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304013'
                WHERE ordernumber = 'P190910132252210' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304013'
                WHERE ordernumber = 'P190910132350738' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287860'
                WHERE ordernumber = 'P190910132647699' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83903'
                WHERE ordernumber = 'P200910132929621' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411674'
                WHERE ordernumber = 'P420910132953607' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250272'
                WHERE ordernumber = 'P200910133052984' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304013'
                WHERE ordernumber = 'P180910133132985' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383731'
                WHERE ordernumber = 'P190910133255161' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420401'
                WHERE ordernumber = 'P200910133641910' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97293'
                WHERE ordernumber = 'P420910133725908' 
            
2024-09-11 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P180910133815822' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420330'
                WHERE ordernumber = 'P190910133828155' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238653'
                WHERE ordernumber = 'P200910133833745' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326263'
                WHERE ordernumber = 'P420910133848550' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239380'
                WHERE ordernumber = 'P180910133928364' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326263'
                WHERE ordernumber = 'P420910134002332' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220311'
                WHERE ordernumber = 'P190910134118755' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420403'
                WHERE ordernumber = 'P420910134212122' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397361'
                WHERE ordernumber = 'P200910134252359' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143087'
                WHERE ordernumber = 'P200910134545337' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283778'
                WHERE ordernumber = 'P180910134822595' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369557'
                WHERE ordernumber = 'P420910134929646' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387524'
                WHERE ordernumber = 'P180910135251379' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240458'
                WHERE ordernumber = 'P180910135329355' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420321'
                WHERE ordernumber = 'P180910135716629' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420407'
                WHERE ordernumber = 'P420910135751662' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339666'
                WHERE ordernumber = 'P420910135842246' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315305'
                WHERE ordernumber = 'P200910140258644' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P420910140651444' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396619'
                WHERE ordernumber = 'P180910140931935' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94310'
                WHERE ordernumber = 'P200910141248770' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417515'
                WHERE ordernumber = 'P200910141436678' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415703'
                WHERE ordernumber = 'P420910141444249' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143539'
                WHERE ordernumber = 'P420910141534289' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420411'
                WHERE ordernumber = 'P180910142200743' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100118'
                WHERE ordernumber = 'P200910142555299' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180910142710471' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418430'
                WHERE ordernumber = 'P420910142831224' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207216'
                WHERE ordernumber = 'P190910143308271' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290592'
                WHERE ordernumber = 'P200910143309594' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284936'
                WHERE ordernumber = 'P180910143405788' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399288'
                WHERE ordernumber = 'P200910143432332' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309074'
                WHERE ordernumber = 'P180910143458509' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401915'
                WHERE ordernumber = 'P420910143459572' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373935'
                WHERE ordernumber = 'P180910143537555' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312082'
                WHERE ordernumber = 'P180910144017374' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312082'
                WHERE ordernumber = 'P180910144050879' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240410'
                WHERE ordernumber = 'P180910144246890' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420416'
                WHERE ordernumber = 'P420910144301440' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392592'
                WHERE ordernumber = 'P200910144429569' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402062'
                WHERE ordernumber = 'P180910144446439' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399030'
                WHERE ordernumber = 'P420910144819781' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420421'
                WHERE ordernumber = 'P200910145027951' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316361'
                WHERE ordernumber = 'P180910145047553' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341045'
                WHERE ordernumber = 'P200910145118765' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406005'
                WHERE ordernumber = 'P180910145644868' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405129'
                WHERE ordernumber = 'P180910145742448' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410124'
                WHERE ordernumber = 'P200910150016270' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240384'
                WHERE ordernumber = 'P200910150137458' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276738'
                WHERE ordernumber = 'P180910150627998' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113332'
                WHERE ordernumber = 'P180910150819904' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312299'
                WHERE ordernumber = 'P630910150838275' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173536'
                WHERE ordernumber = 'P630910150943820' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420424'
                WHERE ordernumber = 'P180910151116465' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126787'
                WHERE ordernumber = 'P200910151217221' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420426'
                WHERE ordernumber = 'P420910151244518' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353493'
                WHERE ordernumber = 'P200910151449928' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387163'
                WHERE ordernumber = 'P180910151517722' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214934'
                WHERE ordernumber = 'P200910151853892' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406975'
                WHERE ordernumber = 'P180910152503878' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420427'
                WHERE ordernumber = 'P180910152554928' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420428'
                WHERE ordernumber = 'P420910152624287' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108170'
                WHERE ordernumber = 'P180910152654185' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P180910152726573' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317774'
                WHERE ordernumber = 'P180910152757234' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392825'
                WHERE ordernumber = 'P180910152842903' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100714'
                WHERE ordernumber = 'P180910152929447' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420431'
                WHERE ordernumber = 'P420910153011574' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100714'
                WHERE ordernumber = 'P180910153023356' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411287'
                WHERE ordernumber = 'P180910153405429' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99956'
                WHERE ordernumber = 'P200910153442657' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337912'
                WHERE ordernumber = 'P730910153634362' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293798'
                WHERE ordernumber = 'P180910153642795' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420433'
                WHERE ordernumber = 'P180910154051546' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391265'
                WHERE ordernumber = 'P180910154122318' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159756'
                WHERE ordernumber = 'P180910154524991' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420429'
                WHERE ordernumber = 'P200910154659714' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420435'
                WHERE ordernumber = 'P180910154702585' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99903'
                WHERE ordernumber = 'P180910155123967' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238452'
                WHERE ordernumber = 'P180910155848806' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420438'
                WHERE ordernumber = 'P200910155918992' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402774'
                WHERE ordernumber = 'P420910160103638' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213485'
                WHERE ordernumber = 'P630910160201954' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409456'
                WHERE ordernumber = 'P200910160557491' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353917'
                WHERE ordernumber = 'P180910161244169' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420442'
                WHERE ordernumber = 'P420910161525148' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420443'
                WHERE ordernumber = 'P200910161648803' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414299'
                WHERE ordernumber = 'P180910161725229' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294778'
                WHERE ordernumber = 'P180910162719797' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119508'
                WHERE ordernumber = 'P180910162805620' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420446'
                WHERE ordernumber = 'P200910163415233' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412912'
                WHERE ordernumber = 'P180910163938449' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164905'
                WHERE ordernumber = 'P180910164033302' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415842'
                WHERE ordernumber = 'P420910164038747' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420450'
                WHERE ordernumber = 'P420910170607688' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283834'
                WHERE ordernumber = 'P200910170951403' 
            
2024-09-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81550'
                WHERE ordernumber = 'P180910173046308' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333455'
                WHERE ordernumber = 'P420910173235657' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200910175126160' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407988'
                WHERE ordernumber = 'P200910175526945' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294959'
                WHERE ordernumber = 'P420910175619238' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321391'
                WHERE ordernumber = 'P180910175909224' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91003'
                WHERE ordernumber = 'P180910180320539' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64829'
                WHERE ordernumber = 'P200910180605183' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230319'
                WHERE ordernumber = 'P200910181000126' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236649'
                WHERE ordernumber = 'P180910181156520' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233829'
                WHERE ordernumber = 'P200910181326644' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303674'
                WHERE ordernumber = 'P180910181648497' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354370'
                WHERE ordernumber = 'P630910181755694' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420457'
                WHERE ordernumber = 'P420910182002150' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399743'
                WHERE ordernumber = 'P180910182518166' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139829'
                WHERE ordernumber = 'P180910182733350' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407766'
                WHERE ordernumber = 'P420910183012764' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '151947'
                WHERE ordernumber = 'P180910183635513' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419239'
                WHERE ordernumber = 'P180910184346730' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396014'
                WHERE ordernumber = 'P180910184440798' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420463'
                WHERE ordernumber = 'P420910184504970' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310320'
                WHERE ordernumber = 'P200910185147734' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380792'
                WHERE ordernumber = 'P200910190105314' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380792'
                WHERE ordernumber = 'P200910190150595' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '247872'
                WHERE ordernumber = 'P190910190255207' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413855'
                WHERE ordernumber = 'P180910190309143' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303033'
                WHERE ordernumber = 'P180910190956809' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420468'
                WHERE ordernumber = 'P200910192640958' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '419529'
                WHERE ordernumber = 'P180910192642786' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301294'
                WHERE ordernumber = 'P180910193258198' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '420472'
                WHERE ordernumber = 'P200910194446250' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '322467'
                WHERE ordernumber = 'P180910195054998' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279618'
                WHERE ordernumber = 'P180910195418732' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398973'
                WHERE ordernumber = 'P630910211716553' 
            
2024-09-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398973'
                WHERE ordernumber = 'P630910211857599'