2024-04-26 01:00:02 -- 將會員中心id寫入data-lake
2024-04-26 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-04-25%';
        
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249250'
                WHERE ordernumber = 'P630425102154614' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386941'
                WHERE ordernumber = 'P630425104205924' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386943'
                WHERE ordernumber = 'P180425110417496' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386945'
                WHERE ordernumber = 'P180425110728416' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386946'
                WHERE ordernumber = 'P180425110830788' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386947'
                WHERE ordernumber = 'P180425111031464' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386948'
                WHERE ordernumber = 'P200425111521595' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338262'
                WHERE ordernumber = 'P200425111744196' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375751'
                WHERE ordernumber = 'P180425112315754' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344557'
                WHERE ordernumber = 'P420425112829513' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386949'
                WHERE ordernumber = 'P200425113629456' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386950'
                WHERE ordernumber = 'P180425113704289' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275156'
                WHERE ordernumber = 'P180425113934193' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266373'
                WHERE ordernumber = 'P200425114100207' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386953'
                WHERE ordernumber = 'P420425114634301' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180425115153293' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273956'
                WHERE ordernumber = 'P420425115422122' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180425115612560' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284096'
                WHERE ordernumber = 'P180425115924789' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P200425120446379' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386938'
                WHERE ordernumber = 'P200425120759637' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242425'
                WHERE ordernumber = 'P180425121052953' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386956'
                WHERE ordernumber = 'P180425121348856' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320328'
                WHERE ordernumber = 'P180425122554861' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386958'
                WHERE ordernumber = 'P200425122826149' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '116366'
                WHERE ordernumber = 'P200425122915968' 
            
2024-04-26 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386959'
                WHERE ordernumber = 'P180425122957518' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P200425123312812' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386960'
                WHERE ordernumber = 'P180425123831180' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386894'
                WHERE ordernumber = 'P180425123906984' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386962'
                WHERE ordernumber = 'P420425124411166' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386961'
                WHERE ordernumber = 'P200425124438339' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386964'
                WHERE ordernumber = 'P200425124623302' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245786'
                WHERE ordernumber = 'P180425124752801' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386965'
                WHERE ordernumber = 'P590425124841364' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386966'
                WHERE ordernumber = 'P180425125154996' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386967'
                WHERE ordernumber = 'P420425130252120' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215063'
                WHERE ordernumber = 'P180425130407116' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385206'
                WHERE ordernumber = 'P200425131327506' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386968'
                WHERE ordernumber = 'P200425131642732' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386970'
                WHERE ordernumber = 'P200425132022301' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386972'
                WHERE ordernumber = 'P190425132053659' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386971'
                WHERE ordernumber = 'P420425132112640' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386973'
                WHERE ordernumber = 'P200425132235710' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386969'
                WHERE ordernumber = 'P180425132630460' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386974'
                WHERE ordernumber = 'P200425132838433' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386978'
                WHERE ordernumber = 'P200425133058436' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166541'
                WHERE ordernumber = 'P180425133229990' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386979'
                WHERE ordernumber = 'P180425133540412' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279954'
                WHERE ordernumber = 'P630425133903422' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '174924'
                WHERE ordernumber = 'P180425134245443' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386981'
                WHERE ordernumber = 'P200425134709653' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386982'
                WHERE ordernumber = 'P420425134748938' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386984'
                WHERE ordernumber = 'P180425135148235' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160744'
                WHERE ordernumber = 'P200425135344729' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374815'
                WHERE ordernumber = 'P180425135750531' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386732'
                WHERE ordernumber = 'P180425135851841' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386833'
                WHERE ordernumber = 'P200425140233126' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310745'
                WHERE ordernumber = 'P420425140552490' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386986'
                WHERE ordernumber = 'P180425140659488' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P180425141734647' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386988'
                WHERE ordernumber = 'P420425142345743' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382548'
                WHERE ordernumber = 'P590425142822975' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237574'
                WHERE ordernumber = 'P180425143124922' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P180425143243768' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386991'
                WHERE ordernumber = 'P420425143716286' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386992'
                WHERE ordernumber = 'P180425143908914' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180425144329600' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288521'
                WHERE ordernumber = 'P420425144610158' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386993'
                WHERE ordernumber = 'P590425145021556' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386994'
                WHERE ordernumber = 'P180425145647982' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386523'
                WHERE ordernumber = 'P180425145959594' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386523'
                WHERE ordernumber = 'P180425150120603' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386996'
                WHERE ordernumber = 'P190425150552883' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180425150931613' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318040'
                WHERE ordernumber = 'P180425151120638' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386998'
                WHERE ordernumber = 'P420425151125389' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386999'
                WHERE ordernumber = 'P180425151232146' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387000'
                WHERE ordernumber = 'P200425151248909' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387001'
                WHERE ordernumber = 'P180425151327964' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288329'
                WHERE ordernumber = 'P200425151658964' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387002'
                WHERE ordernumber = 'P180425151815163' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387003'
                WHERE ordernumber = 'P200425152204971' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386995'
                WHERE ordernumber = 'P180425152553542' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387006'
                WHERE ordernumber = 'P200425152929322' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387007'
                WHERE ordernumber = 'P180425153412295' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387008'
                WHERE ordernumber = 'P180425154113583' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387009'
                WHERE ordernumber = 'P180425154332614' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96938'
                WHERE ordernumber = 'P630425154412700' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387010'
                WHERE ordernumber = 'P420425154629275' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387012'
                WHERE ordernumber = 'P180425155905415' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387013'
                WHERE ordernumber = 'P180425160146201' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302561'
                WHERE ordernumber = 'P630425160215164' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387014'
                WHERE ordernumber = 'P190425160359669' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317383'
                WHERE ordernumber = 'P180425160525438' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387015'
                WHERE ordernumber = 'P630425160635838' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387016'
                WHERE ordernumber = 'P420425161047321' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224820'
                WHERE ordernumber = 'P200425161251947' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387017'
                WHERE ordernumber = 'P200425161516824' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387018'
                WHERE ordernumber = 'P420425161517366' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P180425161534647' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387019'
                WHERE ordernumber = 'P420425161937367' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351276'
                WHERE ordernumber = 'P630425162714306' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '158650'
                WHERE ordernumber = 'P200425162752291' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300778'
                WHERE ordernumber = 'P420425163048573' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277039'
                WHERE ordernumber = 'P630425163719541' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387021'
                WHERE ordernumber = 'P190425164255987' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379300'
                WHERE ordernumber = 'P420425164513735' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387008'
                WHERE ordernumber = 'P180425164555541' 
            
2024-04-26 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121245'
                WHERE ordernumber = 'P190425165023171' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387023'
                WHERE ordernumber = 'P200425165306711' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381113'
                WHERE ordernumber = 'P190425165923508' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234770'
                WHERE ordernumber = 'P200425170347194' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387024'
                WHERE ordernumber = 'P180425170628616' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349243'
                WHERE ordernumber = 'P420425170942859' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341846'
                WHERE ordernumber = 'P180425171031741' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385915'
                WHERE ordernumber = 'P200425171257127' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387025'
                WHERE ordernumber = 'P180425171450809' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387026'
                WHERE ordernumber = 'P180425171602534' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387027'
                WHERE ordernumber = 'P200425171607870' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387028'
                WHERE ordernumber = 'P200425172325443' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387029'
                WHERE ordernumber = 'P200425172529785' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386991'
                WHERE ordernumber = 'P420425172644365' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281899'
                WHERE ordernumber = 'P420425173239117' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264845'
                WHERE ordernumber = 'P190425174240233' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P630425174344775' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387030'
                WHERE ordernumber = 'P190425174413370' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387032'
                WHERE ordernumber = 'P180425174839589' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387032'
                WHERE ordernumber = 'P180425175339345' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81299'
                WHERE ordernumber = 'P180425175710283' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324575'
                WHERE ordernumber = 'P420425180031873' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221817'
                WHERE ordernumber = 'P200425180116834' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387034'
                WHERE ordernumber = 'P630425180327142' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387036'
                WHERE ordernumber = 'P200425180443439' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387035'
                WHERE ordernumber = 'P180425180516863' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270787'
                WHERE ordernumber = 'P200425180542438' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387037'
                WHERE ordernumber = 'P420425181300896' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160145'
                WHERE ordernumber = 'P420425182909573' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387022'
                WHERE ordernumber = 'P200425183041292' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113510'
                WHERE ordernumber = 'P180425183528514' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387038'
                WHERE ordernumber = 'P180425184608665' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '21240'
                WHERE ordernumber = 'P630425184720874' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387039'
                WHERE ordernumber = 'P200425185927215' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229560'
                WHERE ordernumber = 'P190425190909159' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387041'
                WHERE ordernumber = 'P190425191446656' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272421'
                WHERE ordernumber = 'P200425191556769' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387042'
                WHERE ordernumber = 'P630425191619632' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387043'
                WHERE ordernumber = 'P630425192204596' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387044'
                WHERE ordernumber = 'P420425192304931' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387045'
                WHERE ordernumber = 'P190425192401272' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387046'
                WHERE ordernumber = 'P190425192746510' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246226'
                WHERE ordernumber = 'P200425193442779' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328235'
                WHERE ordernumber = 'P420425193640252' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387047'
                WHERE ordernumber = 'P200425193713927' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387045'
                WHERE ordernumber = 'P190425193809704' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387045'
                WHERE ordernumber = 'P190425193906488' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P190425195101561' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387048'
                WHERE ordernumber = 'P190425195209525' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387050'
                WHERE ordernumber = 'P420425195428158' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132999'
                WHERE ordernumber = 'P630425203126227' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387051'
                WHERE ordernumber = 'P630425203322500' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387052'
                WHERE ordernumber = 'P630425204638517' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158602'
                WHERE ordernumber = 'P630425204910455' 
            
2024-04-26 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387054'
                WHERE ordernumber = 'P630425210655381'