2024-08-30 01:00:02 -- 將會員中心id寫入data-lake
2024-08-30 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-08-29%';
        
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91241'
                WHERE ordernumber = 'P180829110234625' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P420829110340736' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133793'
                WHERE ordernumber = 'P200829110341498' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291673'
                WHERE ordernumber = 'P180829110355400' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413441'
                WHERE ordernumber = 'P200829110457158' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415685'
                WHERE ordernumber = 'P180829110601930' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131171'
                WHERE ordernumber = 'P190829110725496' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375441'
                WHERE ordernumber = 'P190829110828984' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415691'
                WHERE ordernumber = 'P180829110942955' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402345'
                WHERE ordernumber = 'P420829111100265' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415692'
                WHERE ordernumber = 'P190829111109440' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415694'
                WHERE ordernumber = 'P200829111146917' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415695'
                WHERE ordernumber = 'P420829111245653' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265677'
                WHERE ordernumber = 'P180829111303262' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334582'
                WHERE ordernumber = 'P420829111501655' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180829111648175' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415695'
                WHERE ordernumber = 'P420829111656880' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324640'
                WHERE ordernumber = 'P190829111715581' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284320'
                WHERE ordernumber = 'P200829111720265' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415701'
                WHERE ordernumber = 'P180829112046513' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415703'
                WHERE ordernumber = 'P420829112230764' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410835'
                WHERE ordernumber = 'P190829112235747' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349590'
                WHERE ordernumber = 'P180829112302924' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324904'
                WHERE ordernumber = 'P420829112401490' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415706'
                WHERE ordernumber = 'P180829112515360' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415697'
                WHERE ordernumber = 'P190829112652745' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P180829112837810' 
            
2024-08-30 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251258'
                WHERE ordernumber = 'P190829112842371' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251258'
                WHERE ordernumber = 'P190829113219405' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415711'
                WHERE ordernumber = 'P420829113300658' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415713'
                WHERE ordernumber = 'P420829113447790' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415715'
                WHERE ordernumber = 'P190829113514941' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415716'
                WHERE ordernumber = 'P420829113603116' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415717'
                WHERE ordernumber = 'P420829113729711' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415720'
                WHERE ordernumber = 'P420829113841670' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99933'
                WHERE ordernumber = 'P200829114021238' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415717'
                WHERE ordernumber = 'P420829114055602' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415725'
                WHERE ordernumber = 'P180829114318206' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228482'
                WHERE ordernumber = 'P190829114404735' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415503'
                WHERE ordernumber = 'P190829114442119' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '27858'
                WHERE ordernumber = 'P200829114520825' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '27858'
                WHERE ordernumber = 'P200829114915812' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77385'
                WHERE ordernumber = 'P190829115016776' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415732'
                WHERE ordernumber = 'P190829115251909' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415735'
                WHERE ordernumber = 'P200829115444271' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337732'
                WHERE ordernumber = 'P200829115637361' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102338'
                WHERE ordernumber = 'P200829115727907' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168805'
                WHERE ordernumber = 'P420829115729745' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415736'
                WHERE ordernumber = 'P190829115854981' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414608'
                WHERE ordernumber = 'P420829115906922' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337732'
                WHERE ordernumber = 'P200829115934650' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415739'
                WHERE ordernumber = 'P420829120212800' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63005'
                WHERE ordernumber = 'P200829120414400' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130659'
                WHERE ordernumber = 'P190829120529715' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P200829120536267' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415746'
                WHERE ordernumber = 'P190829120917648' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249752'
                WHERE ordernumber = 'P190829121055512' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415748'
                WHERE ordernumber = 'P180829121400383' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251703'
                WHERE ordernumber = 'P180829121429746' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415749'
                WHERE ordernumber = 'P200829121656759' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304079'
                WHERE ordernumber = 'P180829122142523' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315557'
                WHERE ordernumber = 'P180829122745459' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412012'
                WHERE ordernumber = 'P180829122913286' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415756'
                WHERE ordernumber = 'P420829123128630' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415700'
                WHERE ordernumber = 'P180829123151631' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415700'
                WHERE ordernumber = 'P180829123220762' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94455'
                WHERE ordernumber = 'P180829123559615' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415765'
                WHERE ordernumber = 'P420829124109330' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415766'
                WHERE ordernumber = 'P180829124602172' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415767'
                WHERE ordernumber = 'P180829124748788' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200829124750239' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415688'
                WHERE ordernumber = 'P180829124901648' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P180829124945261' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415766'
                WHERE ordernumber = 'P180829125018132' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415771'
                WHERE ordernumber = 'P180829125204934' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369316'
                WHERE ordernumber = 'P180829125418685' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415773'
                WHERE ordernumber = 'P200829125602901' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415774'
                WHERE ordernumber = 'P180829125653997' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248217'
                WHERE ordernumber = 'P200829125705945' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415774'
                WHERE ordernumber = 'P180829125740796' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285580'
                WHERE ordernumber = 'P180829125929473' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327091'
                WHERE ordernumber = 'P180829130546348' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266459'
                WHERE ordernumber = 'P630829130551131' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415782'
                WHERE ordernumber = 'P180829130805763' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415783'
                WHERE ordernumber = 'P420829131103574' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415784'
                WHERE ordernumber = 'P180829131151505' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415785'
                WHERE ordernumber = 'P420829131243988' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408453'
                WHERE ordernumber = 'P190829131502829' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233238'
                WHERE ordernumber = 'P180829131600464' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415793'
                WHERE ordernumber = 'P200829132809211' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99512'
                WHERE ordernumber = 'P190829133028972' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297849'
                WHERE ordernumber = 'P190829133345677' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357873'
                WHERE ordernumber = 'P420829133448210' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415800'
                WHERE ordernumber = 'P180829133519440' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262054'
                WHERE ordernumber = 'P180829134438747' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97441'
                WHERE ordernumber = 'P200829134742195' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409194'
                WHERE ordernumber = 'P200829140321528' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420829140435668' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342150'
                WHERE ordernumber = 'P420829140906480' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100163'
                WHERE ordernumber = 'P180829141003844' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315557'
                WHERE ordernumber = 'P180829141545881' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411552'
                WHERE ordernumber = 'P190829142353639' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '331477'
                WHERE ordernumber = 'P190829142620599' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46834'
                WHERE ordernumber = 'P190829142701208' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415821'
                WHERE ordernumber = 'P420829142813632' 
            
2024-08-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415823'
                WHERE ordernumber = 'P190829142843633' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415824'
                WHERE ordernumber = 'P420829142958259' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281559'
                WHERE ordernumber = 'P180829143608342' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415827'
                WHERE ordernumber = 'P420829144005438' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218964'
                WHERE ordernumber = 'P420829144100730' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415829'
                WHERE ordernumber = 'P200829144121514' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415786'
                WHERE ordernumber = 'P200829144354819' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415786'
                WHERE ordernumber = 'P200829144507732' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405828'
                WHERE ordernumber = 'P200829144727703' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405828'
                WHERE ordernumber = 'P200829144841445' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415834'
                WHERE ordernumber = 'P420829144932450' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401452'
                WHERE ordernumber = 'P200829144951188' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277882'
                WHERE ordernumber = 'P200829145314610' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415837'
                WHERE ordernumber = 'P420829145433477' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218323'
                WHERE ordernumber = 'P180829150106211' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342789'
                WHERE ordernumber = 'P420829150327824' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415842'
                WHERE ordernumber = 'P420829150721226' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87737'
                WHERE ordernumber = 'P180829150739212' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415845'
                WHERE ordernumber = 'P420829150934281' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415846'
                WHERE ordernumber = 'P190829151058524' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415848'
                WHERE ordernumber = 'P190829151226563' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415849'
                WHERE ordernumber = 'P420829151449734' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407993'
                WHERE ordernumber = 'P180829151540746' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415843'
                WHERE ordernumber = 'P630829151640669' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103662'
                WHERE ordernumber = 'P180829152002722' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415850'
                WHERE ordernumber = 'P190829152103969' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339179'
                WHERE ordernumber = 'P420829152128720' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214668'
                WHERE ordernumber = 'P190829152257598' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415855'
                WHERE ordernumber = 'P190829152353595' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415152'
                WHERE ordernumber = 'P200829152906184' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415152'
                WHERE ordernumber = 'P200829153011271' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '169193'
                WHERE ordernumber = 'P180829153345312' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400715'
                WHERE ordernumber = 'P190829153554620' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415867'
                WHERE ordernumber = 'P420829153745577' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415868'
                WHERE ordernumber = 'P200829153815581' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415871'
                WHERE ordernumber = 'P180829153953116' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398013'
                WHERE ordernumber = 'P180829154038533' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415875'
                WHERE ordernumber = 'P420829154447839' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '195908'
                WHERE ordernumber = 'P180829154924806' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415879'
                WHERE ordernumber = 'P180829155013816' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415880'
                WHERE ordernumber = 'P420829155256746' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415882'
                WHERE ordernumber = 'P420829155431580' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200829155848433' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P180829160321523' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265457'
                WHERE ordernumber = 'P420829160402590' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401238'
                WHERE ordernumber = 'P180829160648125' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345049'
                WHERE ordernumber = 'P420829160651912' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248612'
                WHERE ordernumber = 'P180829160807947' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415888'
                WHERE ordernumber = 'P420829161118255' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '78136'
                WHERE ordernumber = 'P180829161313529' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313584'
                WHERE ordernumber = 'P200829161533804' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415896'
                WHERE ordernumber = 'P180829161542940' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378722'
                WHERE ordernumber = 'P180829161758356' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383205'
                WHERE ordernumber = 'P180829162007475' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334889'
                WHERE ordernumber = 'P180829162149569' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404321'
                WHERE ordernumber = 'P180829162542430' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305549'
                WHERE ordernumber = 'P420829162733145' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415209'
                WHERE ordernumber = 'P180829162836613' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409517'
                WHERE ordernumber = 'P420829163239705' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405409'
                WHERE ordernumber = 'P190829163436441' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98601'
                WHERE ordernumber = 'P200829163500828' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415906'
                WHERE ordernumber = 'P180829163614825' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415908'
                WHERE ordernumber = 'P200829163932339' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415909'
                WHERE ordernumber = 'P180829164248748' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231344'
                WHERE ordernumber = 'P180829164700764' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P420829164800135' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240030'
                WHERE ordernumber = 'P180829164949435' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415917'
                WHERE ordernumber = 'P180829165511552' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415921'
                WHERE ordernumber = 'P190829165648171' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415920'
                WHERE ordernumber = 'P200829165847360' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415923'
                WHERE ordernumber = 'P180829165855153' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414567'
                WHERE ordernumber = 'P180829165957661' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415924'
                WHERE ordernumber = 'P420829170201846' 
            
2024-08-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386512'
                WHERE ordernumber = 'P200829170318915' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '219239'
                WHERE ordernumber = 'P180829170508559' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88953'
                WHERE ordernumber = 'P180829170557278' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P200829170835488' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415930'
                WHERE ordernumber = 'P180829171359647' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415308'
                WHERE ordernumber = 'P630829171600664' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415933'
                WHERE ordernumber = 'P180829171604141' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284074'
                WHERE ordernumber = 'P180829171843971' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415934'
                WHERE ordernumber = 'P420829171915394' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415935'
                WHERE ordernumber = 'P200829171947140' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102172'
                WHERE ordernumber = 'P180829172342182' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394414'
                WHERE ordernumber = 'P200829172611353' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415943'
                WHERE ordernumber = 'P420829173236366' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415944'
                WHERE ordernumber = 'P420829173420130' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415948'
                WHERE ordernumber = 'P420829173959882' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415949'
                WHERE ordernumber = 'P180829174248332' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237560'
                WHERE ordernumber = 'P200829174544517' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P420829174720485' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349196'
                WHERE ordernumber = 'P200829174824127' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415954'
                WHERE ordernumber = 'P200829175103706' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415955'
                WHERE ordernumber = 'P200829175303493' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410244'
                WHERE ordernumber = 'P420829175317373' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415956'
                WHERE ordernumber = 'P200829175547218' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304198'
                WHERE ordernumber = 'P200829175606548' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105913'
                WHERE ordernumber = 'P200829175703205' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415960'
                WHERE ordernumber = 'P200829175920450' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404598'
                WHERE ordernumber = 'P200829180214450' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415962'
                WHERE ordernumber = 'P200829180358115' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402801'
                WHERE ordernumber = 'P180829180643157' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415964'
                WHERE ordernumber = 'P200829180719330' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P180829180744190' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415469'
                WHERE ordernumber = 'P200829181249546' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '404177'
                WHERE ordernumber = 'P420829181834392' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102422'
                WHERE ordernumber = 'P200829182016483' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396097'
                WHERE ordernumber = 'P180829183318389' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415978'
                WHERE ordernumber = 'P200829183335387' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305406'
                WHERE ordernumber = 'P200829183442683' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163421'
                WHERE ordernumber = 'P180829184043945' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163421'
                WHERE ordernumber = 'P180829184453643' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P190829184638761' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '129482'
                WHERE ordernumber = 'P200829185004929' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415982'
                WHERE ordernumber = 'P420829185044605' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217158'
                WHERE ordernumber = 'P190829185102899' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333117'
                WHERE ordernumber = 'P420829185141246' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200829185549214' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411215'
                WHERE ordernumber = 'P200829185727121' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415988'
                WHERE ordernumber = 'P190829190025620' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116975'
                WHERE ordernumber = 'P200829190129623' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267873'
                WHERE ordernumber = 'P190829190137984' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415990'
                WHERE ordernumber = 'P200829190442226' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190829190519768' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415963'
                WHERE ordernumber = 'P200829191432772' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396619'
                WHERE ordernumber = 'P190829191913701' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416000'
                WHERE ordernumber = 'P200829192018517' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416001'
                WHERE ordernumber = 'P200829192153475' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '187322'
                WHERE ordernumber = 'P200829192300906' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93476'
                WHERE ordernumber = 'P190829192732331' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415473'
                WHERE ordernumber = 'P200829193023717' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281933'
                WHERE ordernumber = 'P190829193242394' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416005'
                WHERE ordernumber = 'P200829193329445' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P190829193602885' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416008'
                WHERE ordernumber = 'P190829194311269' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416012'
                WHERE ordernumber = 'P200829194614825' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416017'
                WHERE ordernumber = 'P200829195329352' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '416022'
                WHERE ordernumber = 'P200829195450992' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '60360'
                WHERE ordernumber = 'P200829195626772' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284599'
                WHERE ordernumber = 'P200829195717503' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406781'
                WHERE ordernumber = 'P630829203033271' 
            
2024-08-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415626'
                WHERE ordernumber = 'P630829211407703'