2024-04-29 01:00:01 -- 將會員中心id寫入data-lake
2024-04-29 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-04-28%';
        
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '29454'
                WHERE ordernumber = 'P630428101735946' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387299'
                WHERE ordernumber = 'P420428104529157' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319373'
                WHERE ordernumber = 'P200428110316724' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387302'
                WHERE ordernumber = 'P420428110508787' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387303'
                WHERE ordernumber = 'P180428110511391' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387304'
                WHERE ordernumber = 'P180428110618919' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387305'
                WHERE ordernumber = 'P180428110800958' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387306'
                WHERE ordernumber = 'P180428110913525' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387307'
                WHERE ordernumber = 'P420428111138901' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354411'
                WHERE ordernumber = 'P180428111540733' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354411'
                WHERE ordernumber = 'P180428111647143' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387309'
                WHERE ordernumber = 'P180428111741559' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241678'
                WHERE ordernumber = 'P180428111940816' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387308'
                WHERE ordernumber = 'P190428112202367' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387312'
                WHERE ordernumber = 'P180428112223433' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101826'
                WHERE ordernumber = 'P200428112458650' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376766'
                WHERE ordernumber = 'P630428112753966' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378152'
                WHERE ordernumber = 'P180428112914734' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387310'
                WHERE ordernumber = 'P180428113102756' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387310'
                WHERE ordernumber = 'P180428113139977' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246142'
                WHERE ordernumber = 'P190428113210344' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387315'
                WHERE ordernumber = 'P200428113356436' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387316'
                WHERE ordernumber = 'P190428113603359' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '233749'
                WHERE ordernumber = 'P190428114234864' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387317'
                WHERE ordernumber = 'P180428114251541' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387319'
                WHERE ordernumber = 'P190428114520582' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319593'
                WHERE ordernumber = 'P200428114530368' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387320'
                WHERE ordernumber = 'P190428114714690' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387322'
                WHERE ordernumber = 'P200428114820270' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387319'
                WHERE ordernumber = 'P190428114902651' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387323'
                WHERE ordernumber = 'P420428114928952' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95592'
                WHERE ordernumber = 'P200428115615251' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387325'
                WHERE ordernumber = 'P180428120158728' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387326'
                WHERE ordernumber = 'P200428120236535' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387326'
                WHERE ordernumber = 'P200428120657503' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387327'
                WHERE ordernumber = 'P420428121647453' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293405'
                WHERE ordernumber = 'P180428121910785' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387328'
                WHERE ordernumber = 'P420428122147585' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381817'
                WHERE ordernumber = 'P180428123022940' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200428123313558' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387330'
                WHERE ordernumber = 'P420428123747230' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '210683'
                WHERE ordernumber = 'P180428130221801' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387332'
                WHERE ordernumber = 'P200428130325927' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387333'
                WHERE ordernumber = 'P180428131301723' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387334'
                WHERE ordernumber = 'P180428131510696' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387336'
                WHERE ordernumber = 'P180428132310283' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387337'
                WHERE ordernumber = 'P630428132603418' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99941'
                WHERE ordernumber = 'P180428133254751' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387339'
                WHERE ordernumber = 'P180428133422612' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325008'
                WHERE ordernumber = 'P200428133548641' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387340'
                WHERE ordernumber = 'P200428133731816' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337557'
                WHERE ordernumber = 'P200428133816197' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387341'
                WHERE ordernumber = 'P180428134112889' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387342'
                WHERE ordernumber = 'P180428134344597' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387344'
                WHERE ordernumber = 'P190428134842554' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387346'
                WHERE ordernumber = 'P180428135022913' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262673'
                WHERE ordernumber = 'P200428135213993' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '117195'
                WHERE ordernumber = 'P180428135214369' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '136583'
                WHERE ordernumber = 'P200428135642462' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387351'
                WHERE ordernumber = 'P180428140001735' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387354'
                WHERE ordernumber = 'P180428140820989' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161497'
                WHERE ordernumber = 'P420428141458425' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387356'
                WHERE ordernumber = 'P180428141529314' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101119'
                WHERE ordernumber = 'P200428142010816' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387358'
                WHERE ordernumber = 'P190428142404285' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387359'
                WHERE ordernumber = 'P180428142424660' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269257'
                WHERE ordernumber = 'P200428142454937' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338383'
                WHERE ordernumber = 'P180428142732378' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387362'
                WHERE ordernumber = 'P200428142834216' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387363'
                WHERE ordernumber = 'P190428142947438' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387364'
                WHERE ordernumber = 'P190428143111550' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361287'
                WHERE ordernumber = 'P180428143218146' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294130'
                WHERE ordernumber = 'P190428143242861' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387230'
                WHERE ordernumber = 'P190428143531479' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384000'
                WHERE ordernumber = 'P630428143548573' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277272'
                WHERE ordernumber = 'P180428144221126' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387365'
                WHERE ordernumber = 'P180428144717840' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383870'
                WHERE ordernumber = 'P420428144822614' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387366'
                WHERE ordernumber = 'P190428144843887' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348816'
                WHERE ordernumber = 'P200428145155509' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387368'
                WHERE ordernumber = 'P200428145509322' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315644'
                WHERE ordernumber = 'P630428145913312' 
            
2024-04-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387370'
                WHERE ordernumber = 'P190428150024949' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387371'
                WHERE ordernumber = 'P180428150214334' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85639'
                WHERE ordernumber = 'P200428150249184' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387372'
                WHERE ordernumber = 'P190428150629307' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330264'
                WHERE ordernumber = 'P420428150950243' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330264'
                WHERE ordernumber = 'P420428151138870' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379326'
                WHERE ordernumber = 'P420428151408630' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180428151524117' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387368'
                WHERE ordernumber = 'P200428151822649' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387374'
                WHERE ordernumber = 'P420428152227355' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387377'
                WHERE ordernumber = 'P180428154105795' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387378'
                WHERE ordernumber = 'P420428154118909' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387379'
                WHERE ordernumber = 'P180428154311652' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387380'
                WHERE ordernumber = 'P420428154333580' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384248'
                WHERE ordernumber = 'P420428154549615' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387384'
                WHERE ordernumber = 'P420428155507878' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95365'
                WHERE ordernumber = 'P200428155546331' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '168279'
                WHERE ordernumber = 'P180428155624809' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387385'
                WHERE ordernumber = 'P420428155751320' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386605'
                WHERE ordernumber = 'P180428160212924' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387386'
                WHERE ordernumber = 'P420428161239764' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371458'
                WHERE ordernumber = 'P200428161312423' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P200428161654707' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361213'
                WHERE ordernumber = 'P180428161830266' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P200428161902155' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149224'
                WHERE ordernumber = 'P200428162637834' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387389'
                WHERE ordernumber = 'P180428163627968' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387391'
                WHERE ordernumber = 'P630428163847426' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P420428163923131' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387392'
                WHERE ordernumber = 'P180428163931393' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253511'
                WHERE ordernumber = 'P630428164416398' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387394'
                WHERE ordernumber = 'P180428164713506' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387395'
                WHERE ordernumber = 'P190428164812148' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143812'
                WHERE ordernumber = 'P180428164943514' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39185'
                WHERE ordernumber = 'P190428165334902' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381924'
                WHERE ordernumber = 'P420428165906496' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387398'
                WHERE ordernumber = 'P630428170319621' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377840'
                WHERE ordernumber = 'P200428170504466' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82924'
                WHERE ordernumber = 'P200428170616603' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387399'
                WHERE ordernumber = 'P180428170905802' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387400'
                WHERE ordernumber = 'P180428171024923' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387401'
                WHERE ordernumber = 'P200428171249537' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387402'
                WHERE ordernumber = 'P630428171312605' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387405'
                WHERE ordernumber = 'P180428171528592' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180428171701375' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P180428171951330' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387404'
                WHERE ordernumber = 'P200428172118942' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95097'
                WHERE ordernumber = 'P200428172705845' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278279'
                WHERE ordernumber = 'P180428173157340' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385040'
                WHERE ordernumber = 'P590428173344159' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172877'
                WHERE ordernumber = 'P180428173541560' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387407'
                WHERE ordernumber = 'P200428173600954' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173328'
                WHERE ordernumber = 'P200428173953913' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275266'
                WHERE ordernumber = 'P180428173957583' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272851'
                WHERE ordernumber = 'P200428174055920' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387408'
                WHERE ordernumber = 'P180428174214395' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387409'
                WHERE ordernumber = 'P200428174230699' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92319'
                WHERE ordernumber = 'P200428174334502' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306952'
                WHERE ordernumber = 'P180428174502621' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387410'
                WHERE ordernumber = 'P200428174515231' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240087'
                WHERE ordernumber = 'P630428174830797' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238603'
                WHERE ordernumber = 'P200428175125229' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381805'
                WHERE ordernumber = 'P590428175132789' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387411'
                WHERE ordernumber = 'P630428175311357' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376353'
                WHERE ordernumber = 'P180428175327487' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311867'
                WHERE ordernumber = 'P200428180055471' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387413'
                WHERE ordernumber = 'P200428180357629' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319613'
                WHERE ordernumber = 'P420428181034673' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243066'
                WHERE ordernumber = 'P630428181257443' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387414'
                WHERE ordernumber = 'P420428181505893' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387415'
                WHERE ordernumber = 'P630428181532677' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387416'
                WHERE ordernumber = 'P590428181928652' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387417'
                WHERE ordernumber = 'P200428182250557' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200428182354713' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359847'
                WHERE ordernumber = 'P200428182741613' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387418'
                WHERE ordernumber = 'P200428182926819' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371052'
                WHERE ordernumber = 'P420428183035127' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387419'
                WHERE ordernumber = 'P190428183222557' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387420'
                WHERE ordernumber = 'P190428183438893' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326370'
                WHERE ordernumber = 'P590428183753493' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387421'
                WHERE ordernumber = 'P190428184510254' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387422'
                WHERE ordernumber = 'P200428184725582' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311010'
                WHERE ordernumber = 'P200428184835657' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '54821'
                WHERE ordernumber = 'P420428185009365' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '34065'
                WHERE ordernumber = 'P200428185148651' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387423'
                WHERE ordernumber = 'P630428185621982' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387424'
                WHERE ordernumber = 'P630428185858694' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387425'
                WHERE ordernumber = 'P590428190428514' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P190428190627644' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387426'
                WHERE ordernumber = 'P200428190637368' 
            
2024-04-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368824'
                WHERE ordernumber = 'P200428190754147' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290554'
                WHERE ordernumber = 'P590428191002923' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387427'
                WHERE ordernumber = 'P630428191003882' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302195'
                WHERE ordernumber = 'P420428191054468' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64226'
                WHERE ordernumber = 'P420428191217717' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387428'
                WHERE ordernumber = 'P420428192112594' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93655'
                WHERE ordernumber = 'P200428192224843' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99955'
                WHERE ordernumber = 'P190428192908409' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387429'
                WHERE ordernumber = 'P590428193049558' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387430'
                WHERE ordernumber = 'P630428193833456' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387431'
                WHERE ordernumber = 'P200428194318298' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387433'
                WHERE ordernumber = 'P200428195203880' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387434'
                WHERE ordernumber = 'P200428195912629' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387436'
                WHERE ordernumber = 'P630428201954666' 
            
2024-04-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387440'
                WHERE ordernumber = 'P630428212819549'