2024-08-19 01:00:01 -- 將會員中心id寫入data-lake
2024-08-19 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-08-18%';
        
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401659'
                WHERE ordernumber = 'P630818100634797' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397719'
                WHERE ordernumber = 'P180818110144452' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332409'
                WHERE ordernumber = 'P180818110328447' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240781'
                WHERE ordernumber = 'P200818110345446' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293470'
                WHERE ordernumber = 'P190818110351391' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322776'
                WHERE ordernumber = 'P420818110521379' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386946'
                WHERE ordernumber = 'P180818110552642' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376756'
                WHERE ordernumber = 'P190818110627720' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409946'
                WHERE ordernumber = 'P180818110949585' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P190818111126729' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96452'
                WHERE ordernumber = 'P180818111144705' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346544'
                WHERE ordernumber = 'P420818111338567' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409947'
                WHERE ordernumber = 'P180818111432503' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409949'
                WHERE ordernumber = 'P420818111517346' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409951'
                WHERE ordernumber = 'P180818111723734' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409950'
                WHERE ordernumber = 'P190818111758977' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '14385'
                WHERE ordernumber = 'P420818111930330' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P180818112138424' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331749'
                WHERE ordernumber = 'P420818112230861' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230593'
                WHERE ordernumber = 'P200818112253692' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P200818112529874' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409954'
                WHERE ordernumber = 'P180818112600139' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P200818112610586' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409956'
                WHERE ordernumber = 'P200818112736257' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409958'
                WHERE ordernumber = 'P180818112933965' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409961'
                WHERE ordernumber = 'P180818113439208' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409962'
                WHERE ordernumber = 'P200818113508819' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409963'
                WHERE ordernumber = 'P420818113517259' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409964'
                WHERE ordernumber = 'P180818113557788' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409963'
                WHERE ordernumber = 'P420818113621459' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328809'
                WHERE ordernumber = 'P180818113836457' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409967'
                WHERE ordernumber = 'P190818113951426' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409968'
                WHERE ordernumber = 'P190818114415777' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409970'
                WHERE ordernumber = 'P190818114800967' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409973'
                WHERE ordernumber = 'P180818115018758' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96793'
                WHERE ordernumber = 'P200818115343271' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409975'
                WHERE ordernumber = 'P420818115411492' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409977'
                WHERE ordernumber = 'P180818115513387' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409974'
                WHERE ordernumber = 'P190818115515496' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381787'
                WHERE ordernumber = 'P180818115605587' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200818115633744' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349110'
                WHERE ordernumber = 'P180818115725704' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P190818115843261' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96793'
                WHERE ordernumber = 'P200818120010766' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409980'
                WHERE ordernumber = 'P190818120233497' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346997'
                WHERE ordernumber = 'P180818120534829' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102264'
                WHERE ordernumber = 'P190818120639440' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409984'
                WHERE ordernumber = 'P180818120816470' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409985'
                WHERE ordernumber = 'P420818120918657' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409986'
                WHERE ordernumber = 'P180818121015268' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409987'
                WHERE ordernumber = 'P180818121119223' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409988'
                WHERE ordernumber = 'P180818121351425' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '208650'
                WHERE ordernumber = 'P190818121712311' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409990'
                WHERE ordernumber = 'P180818122330673' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409991'
                WHERE ordernumber = 'P180818122459305' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409992'
                WHERE ordernumber = 'P420818122712943' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409996'
                WHERE ordernumber = 'P190818123138735' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137641'
                WHERE ordernumber = 'P180818123429247' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409998'
                WHERE ordernumber = 'P420818123448922' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409999'
                WHERE ordernumber = 'P190818123644364' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410000'
                WHERE ordernumber = 'P180818123654539' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242153'
                WHERE ordernumber = 'P200818123802230' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368910'
                WHERE ordernumber = 'P420818123856164' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263922'
                WHERE ordernumber = 'P200818124008864' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410003'
                WHERE ordernumber = 'P180818124050632' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410004'
                WHERE ordernumber = 'P420818124140223' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410006'
                WHERE ordernumber = 'P420818124408311' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410010'
                WHERE ordernumber = 'P190818124643219' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274753'
                WHERE ordernumber = 'P180818125118342' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '240649'
                WHERE ordernumber = 'P200818125218668' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410014'
                WHERE ordernumber = 'P420818125315571' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283957'
                WHERE ordernumber = 'P180818130119658' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393917'
                WHERE ordernumber = 'P420818130124824' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283615'
                WHERE ordernumber = 'P420818130236631' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410016'
                WHERE ordernumber = 'P180818130245971' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410018'
                WHERE ordernumber = 'P180818130447548' 
            
2024-08-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '410020'
                WHERE ordernumber = 'P190818130551803' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410019'
                WHERE ordernumber = 'P420818130601619' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121994'
                WHERE ordernumber = 'P180818130655223' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410024'
                WHERE ordernumber = 'P420818131614372' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410025'
                WHERE ordernumber = 'P180818131754324' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409776'
                WHERE ordernumber = 'P180818132222839' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131885'
                WHERE ordernumber = 'P180818132320886' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106382'
                WHERE ordernumber = 'P190818132547146' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P420818132619209' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P420818133414422' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254963'
                WHERE ordernumber = 'P420818133524324' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410030'
                WHERE ordernumber = 'P180818133711193' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381139'
                WHERE ordernumber = 'P200818133820279' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410032'
                WHERE ordernumber = 'P180818133826212' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410033'
                WHERE ordernumber = 'P420818134021930' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399113'
                WHERE ordernumber = 'P180818134055919' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271195'
                WHERE ordernumber = 'P190818134220833' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407628'
                WHERE ordernumber = 'P180818134426184' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410035'
                WHERE ordernumber = 'P190818134711131' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406487'
                WHERE ordernumber = 'P420818134958126' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410037'
                WHERE ordernumber = 'P420818135109497' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25778'
                WHERE ordernumber = 'P180818135255531' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410040'
                WHERE ordernumber = 'P420818135420981' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317331'
                WHERE ordernumber = 'P180818135519827' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379638'
                WHERE ordernumber = 'P200818135659458' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410042'
                WHERE ordernumber = 'P180818135907781' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160336'
                WHERE ordernumber = 'P200818140004393' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81603'
                WHERE ordernumber = 'P180818140027581' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410044'
                WHERE ordernumber = 'P420818140217609' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319892'
                WHERE ordernumber = 'P420818140319664' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390790'
                WHERE ordernumber = 'P190818140508547' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410050'
                WHERE ordernumber = 'P420818141052509' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279214'
                WHERE ordernumber = 'P420818141353451' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410052'
                WHERE ordernumber = 'P180818141456762' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410054'
                WHERE ordernumber = 'P200818141827218' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410057'
                WHERE ordernumber = 'P180818142149283' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410056'
                WHERE ordernumber = 'P180818142222190' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410058'
                WHERE ordernumber = 'P420818142245209' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368798'
                WHERE ordernumber = 'P200818142255657' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410062'
                WHERE ordernumber = 'P420818142811820' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323657'
                WHERE ordernumber = 'P180818142829967' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410063'
                WHERE ordernumber = 'P420818142925477' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410068'
                WHERE ordernumber = 'P200818143205689' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410065'
                WHERE ordernumber = 'P180818143305671' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410061'
                WHERE ordernumber = 'P180818143418385' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410071'
                WHERE ordernumber = 'P190818143602255' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410072'
                WHERE ordernumber = 'P180818143652198' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410073'
                WHERE ordernumber = 'P180818143956726' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410074'
                WHERE ordernumber = 'P200818144048782' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410075'
                WHERE ordernumber = 'P180818144141378' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P190818144333158' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410066'
                WHERE ordernumber = 'P180818144510768' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283681'
                WHERE ordernumber = 'P180818144618964' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283681'
                WHERE ordernumber = 'P180818144714198' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410079'
                WHERE ordernumber = 'P190818144726920' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406688'
                WHERE ordernumber = 'P200818144841940' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410080'
                WHERE ordernumber = 'P420818144903982' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410081'
                WHERE ordernumber = 'P420818145025461' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410082'
                WHERE ordernumber = 'P180818145125174' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327582'
                WHERE ordernumber = 'P180818145513522' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410083'
                WHERE ordernumber = 'P200818145625814' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144461'
                WHERE ordernumber = 'P180818145722358' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325123'
                WHERE ordernumber = 'P420818150004518' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410086'
                WHERE ordernumber = 'P180818150021436' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410088'
                WHERE ordernumber = 'P180818150753760' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410089'
                WHERE ordernumber = 'P190818150951258' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250249'
                WHERE ordernumber = 'P200818151121504' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200818151151647' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236540'
                WHERE ordernumber = 'P180818151237507' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410091'
                WHERE ordernumber = 'P420818151255136' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397044'
                WHERE ordernumber = 'P190818151436263' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '144322'
                WHERE ordernumber = 'P420818151602676' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410095'
                WHERE ordernumber = 'P420818151923530' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404900'
                WHERE ordernumber = 'P190818152105560' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '332122'
                WHERE ordernumber = 'P180818152143621' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410097'
                WHERE ordernumber = 'P180818152634471' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364665'
                WHERE ordernumber = 'P420818152642969' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410099'
                WHERE ordernumber = 'P190818153140797' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410098'
                WHERE ordernumber = 'P180818153310928' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410103'
                WHERE ordernumber = 'P200818153417750' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410105'
                WHERE ordernumber = 'P180818153506159' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410106'
                WHERE ordernumber = 'P180818153556650' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387484'
                WHERE ordernumber = 'P200818153623603' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410107'
                WHERE ordernumber = 'P180818153720770' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410109'
                WHERE ordernumber = 'P420818154044507' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410111'
                WHERE ordernumber = 'P180818154250872' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217658'
                WHERE ordernumber = 'P180818154910791' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270506'
                WHERE ordernumber = 'P190818154911939' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336174'
                WHERE ordernumber = 'P180818155003637' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410117'
                WHERE ordernumber = 'P420818155122178' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297233'
                WHERE ordernumber = 'P420818155326480' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348566'
                WHERE ordernumber = 'P180818155337399' 
            
2024-08-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302578'
                WHERE ordernumber = 'P420818155451353' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410120'
                WHERE ordernumber = 'P180818155719210' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410121'
                WHERE ordernumber = 'P420818160023598' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410124'
                WHERE ordernumber = 'P200818160158772' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410125'
                WHERE ordernumber = 'P420818160218789' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102264'
                WHERE ordernumber = 'P180818160420564' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235075'
                WHERE ordernumber = 'P190818160424852' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410126'
                WHERE ordernumber = 'P420818160539177' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410127'
                WHERE ordernumber = 'P190818160540402' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397518'
                WHERE ordernumber = 'P190818160924456' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407234'
                WHERE ordernumber = 'P180818161321694' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317671'
                WHERE ordernumber = 'P420818161508930' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392218'
                WHERE ordernumber = 'P200818161524673' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395050'
                WHERE ordernumber = 'P200818161610244' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318790'
                WHERE ordernumber = 'P420818161642545' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410131'
                WHERE ordernumber = 'P200818161756487' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410132'
                WHERE ordernumber = 'P180818161826839' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365459'
                WHERE ordernumber = 'P200818161954210' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410134'
                WHERE ordernumber = 'P420818162151134' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410135'
                WHERE ordernumber = 'P190818162301873' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P420818162439125' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408052'
                WHERE ordernumber = 'P200818162512895' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408052'
                WHERE ordernumber = 'P200818162515215' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410136'
                WHERE ordernumber = 'P180818162526738' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410135'
                WHERE ordernumber = 'P190818162846546' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329734'
                WHERE ordernumber = 'P420818162934897' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P190818162952323' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407234'
                WHERE ordernumber = 'P180818163111962' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410138'
                WHERE ordernumber = 'P200818163234490' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410139'
                WHERE ordernumber = 'P180818163259284' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410140'
                WHERE ordernumber = 'P190818163306866' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406483'
                WHERE ordernumber = 'P180818163400928' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410141'
                WHERE ordernumber = 'P200818163515634' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410142'
                WHERE ordernumber = 'P180818163525838' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341607'
                WHERE ordernumber = 'P420818163636661' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407234'
                WHERE ordernumber = 'P180818163714435' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215540'
                WHERE ordernumber = 'P190818163747610' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410144'
                WHERE ordernumber = 'P200818163857250' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343984'
                WHERE ordernumber = 'P180818163940429' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410145'
                WHERE ordernumber = 'P190818164344983' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409478'
                WHERE ordernumber = 'P180818164746552' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410135'
                WHERE ordernumber = 'P190818164837763' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383130'
                WHERE ordernumber = 'P420818165103444' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410149'
                WHERE ordernumber = 'P190818165509957' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410149'
                WHERE ordernumber = 'P190818165546279' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158635'
                WHERE ordernumber = 'P180818165616553' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249752'
                WHERE ordernumber = 'P180818165902286' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P190818170037524' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345244'
                WHERE ordernumber = 'P190818170105739' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410152'
                WHERE ordernumber = 'P190818170527318' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350227'
                WHERE ordernumber = 'P180818170527763' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410152'
                WHERE ordernumber = 'P190818170608801' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410156'
                WHERE ordernumber = 'P420818170834472' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410158'
                WHERE ordernumber = 'P180818171044644' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410159'
                WHERE ordernumber = 'P420818171205684' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240194'
                WHERE ordernumber = 'P190818171236818' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136470'
                WHERE ordernumber = 'P180818171407457' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410161'
                WHERE ordernumber = 'P190818171531157' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229815'
                WHERE ordernumber = 'P180818171539303' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410164'
                WHERE ordernumber = 'P180818171918998' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211965'
                WHERE ordernumber = 'P420818171929941' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249804'
                WHERE ordernumber = 'P190818172057320' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410167'
                WHERE ordernumber = 'P180818172346258' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '116016'
                WHERE ordernumber = 'P180818172712578' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410170'
                WHERE ordernumber = 'P190818173143984' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410171'
                WHERE ordernumber = 'P180818173217762' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410084'
                WHERE ordernumber = 'P180818173312148' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293682'
                WHERE ordernumber = 'P200818173406591' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393713'
                WHERE ordernumber = 'P190818173455764' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314442'
                WHERE ordernumber = 'P590818173513604' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218354'
                WHERE ordernumber = 'P200818173623982' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410175'
                WHERE ordernumber = 'P180818173634759' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410176'
                WHERE ordernumber = 'P180818173807858' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410177'
                WHERE ordernumber = 'P420818173856994' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390008'
                WHERE ordernumber = 'P180818173911521' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410179'
                WHERE ordernumber = 'P180818174027537' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410004'
                WHERE ordernumber = 'P420818174112773' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410181'
                WHERE ordernumber = 'P200818174607272' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410183'
                WHERE ordernumber = 'P420818175720858' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410186'
                WHERE ordernumber = 'P180818175930836' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410187'
                WHERE ordernumber = 'P190818175947784' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410188'
                WHERE ordernumber = 'P420818180049515' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410189'
                WHERE ordernumber = 'P180818180128577' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359049'
                WHERE ordernumber = 'P190818180130959' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362699'
                WHERE ordernumber = 'P200818180157591' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410192'
                WHERE ordernumber = 'P190818180321894' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410195'
                WHERE ordernumber = 'P180818180559575' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410196'
                WHERE ordernumber = 'P180818180725842' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '410197'
                WHERE ordernumber = 'P180818180925441' 
            
2024-08-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408115'
                WHERE ordernumber = 'P420818181321977' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400953'
                WHERE ordernumber = 'P180818181458313' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103462'
                WHERE ordernumber = 'P420818181518149' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236955'
                WHERE ordernumber = 'P420818181619674' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410199'
                WHERE ordernumber = 'P200818181629551' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410200'
                WHERE ordernumber = 'P200818181748888' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P420818182755726' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410204'
                WHERE ordernumber = 'P180818183459444' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410205'
                WHERE ordernumber = 'P190818183513929' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '75384'
                WHERE ordernumber = 'P420818183642340' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410206'
                WHERE ordernumber = 'P180818184019618' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '195239'
                WHERE ordernumber = 'P200818184107451' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405415'
                WHERE ordernumber = 'P420818184132540' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410208'
                WHERE ordernumber = 'P180818184440584' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410207'
                WHERE ordernumber = 'P190818184444501' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410211'
                WHERE ordernumber = 'P200818184814431' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '151935'
                WHERE ordernumber = 'P200818185036881' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364903'
                WHERE ordernumber = 'P200818185234652' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294668'
                WHERE ordernumber = 'P180818185407230' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302040'
                WHERE ordernumber = 'P190818185557672' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410224'
                WHERE ordernumber = 'P180818185855342' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410225'
                WHERE ordernumber = 'P200818190425834' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410227'
                WHERE ordernumber = 'P200818191125516' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410228'
                WHERE ordernumber = 'P200818191618472' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214639'
                WHERE ordernumber = 'P190818192211246' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410233'
                WHERE ordernumber = 'P190818192629622' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410212'
                WHERE ordernumber = 'P200818192819869' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300648'
                WHERE ordernumber = 'P190818192836581' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125170'
                WHERE ordernumber = 'P200818193019127' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410235'
                WHERE ordernumber = 'P200818193134852' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410236'
                WHERE ordernumber = 'P190818193456908' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410239'
                WHERE ordernumber = 'P200818193748456' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235441'
                WHERE ordernumber = 'P200818193845570' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379347'
                WHERE ordernumber = 'P190818193948169' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410241'
                WHERE ordernumber = 'P190818194357474' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '410243'
                WHERE ordernumber = 'P200818195024367' 
            
2024-08-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406679'
                WHERE ordernumber = 'P200818195738393'