2024-01-04 01:00:02 -- 將會員中心id寫入data-lake
2024-01-04 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-01-03%';
        
2024-01-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348868'
                WHERE ordernumber = 'P180103110129532' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354173'
                WHERE ordernumber = 'P180103110605168' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354173'
                WHERE ordernumber = 'P180103110644513' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316812'
                WHERE ordernumber = 'P420103110646458' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354173'
                WHERE ordernumber = 'P180103110744520' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200103110814737' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358247'
                WHERE ordernumber = 'P420103111530782' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358249'
                WHERE ordernumber = 'P420103111827934' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353885'
                WHERE ordernumber = 'P420103112015643' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358250'
                WHERE ordernumber = 'P180103112206715' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162592'
                WHERE ordernumber = 'P180103113232126' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358254'
                WHERE ordernumber = 'P190103113309291' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257909'
                WHERE ordernumber = 'P200103114014226' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358258'
                WHERE ordernumber = 'P200103114603811' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319348'
                WHERE ordernumber = 'P180103114940954' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127573'
                WHERE ordernumber = 'P180103115135571' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P190103115307447' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358262'
                WHERE ordernumber = 'P420103115519764' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P180103115701797' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358227'
                WHERE ordernumber = 'P200103120214244' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358264'
                WHERE ordernumber = 'P180103121016415' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358264'
                WHERE ordernumber = 'P180103121043914' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351999'
                WHERE ordernumber = 'P180103121207836' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270092'
                WHERE ordernumber = 'P420103121212227' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358267'
                WHERE ordernumber = 'P200103121318326' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358269'
                WHERE ordernumber = 'P200103122016603' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358270'
                WHERE ordernumber = 'P180103122018687' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287380'
                WHERE ordernumber = 'P200103122337928' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358273'
                WHERE ordernumber = 'P420103122359302' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358274'
                WHERE ordernumber = 'P200103122508293' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358270'
                WHERE ordernumber = 'P180103122511403' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219117'
                WHERE ordernumber = 'P180103122837248' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104445'
                WHERE ordernumber = 'P180103123439981' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358279'
                WHERE ordernumber = 'P180103123827417' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358278'
                WHERE ordernumber = 'P420103123914780' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219462'
                WHERE ordernumber = 'P200103124612945' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290492'
                WHERE ordernumber = 'P180103124627943' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277359'
                WHERE ordernumber = 'P180103125058147' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289534'
                WHERE ordernumber = 'P180103125201125' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82659'
                WHERE ordernumber = 'P200103125457678' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358285'
                WHERE ordernumber = 'P180103125540314' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358288'
                WHERE ordernumber = 'P180103130046631' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358289'
                WHERE ordernumber = 'P200103130129521' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216054'
                WHERE ordernumber = 'P180103130318697' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358291'
                WHERE ordernumber = 'P200103130839313' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358295'
                WHERE ordernumber = 'P190103131038557' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126699'
                WHERE ordernumber = 'P190103131159553' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88929'
                WHERE ordernumber = 'P190103131931255' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79147'
                WHERE ordernumber = 'P180103132024715' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358299'
                WHERE ordernumber = 'P200103132204968' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216890'
                WHERE ordernumber = 'P180103132508524' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358301'
                WHERE ordernumber = 'P180103132828420' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358302'
                WHERE ordernumber = 'P180103133029350' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358305'
                WHERE ordernumber = 'P420103133204487' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P180103133306929' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358306'
                WHERE ordernumber = 'P180103133559597' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237146'
                WHERE ordernumber = 'P200103133853484' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358309'
                WHERE ordernumber = 'P180103134000724' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322364'
                WHERE ordernumber = 'P180103134228690' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219133'
                WHERE ordernumber = 'P200103134307286' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306865'
                WHERE ordernumber = 'P200103134433639' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358312'
                WHERE ordernumber = 'P180103134806975' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245271'
                WHERE ordernumber = 'P200103135059687' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109758'
                WHERE ordernumber = 'P200103135231738' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358317'
                WHERE ordernumber = 'P200103135606578' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358320'
                WHERE ordernumber = 'P200103135822271' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358324'
                WHERE ordernumber = 'P180103140249380' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358325'
                WHERE ordernumber = 'P200103140317661' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289688'
                WHERE ordernumber = 'P200103140336894' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107098'
                WHERE ordernumber = 'P190103140339497' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358327'
                WHERE ordernumber = 'P190103140539662' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103808'
                WHERE ordernumber = 'P200103140554785' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100450'
                WHERE ordernumber = 'P190103140633444' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358329'
                WHERE ordernumber = 'P190103141010469' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116605'
                WHERE ordernumber = 'P180103141040741' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306488'
                WHERE ordernumber = 'P200103141041853' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303745'
                WHERE ordernumber = 'P200103141323981' 
            
2024-01-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93572'
                WHERE ordernumber = 'P190103141416356' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358329'
                WHERE ordernumber = 'P190103141506920' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337552'
                WHERE ordernumber = 'P180103142104990' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358336'
                WHERE ordernumber = 'P180103142829713' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358337'
                WHERE ordernumber = 'P180103143022968' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125995'
                WHERE ordernumber = 'P180103143137419' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247665'
                WHERE ordernumber = 'P180103143710954' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358341'
                WHERE ordernumber = 'P200103143845160' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358343'
                WHERE ordernumber = 'P200103144609644' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358345'
                WHERE ordernumber = 'P200103145037645' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355683'
                WHERE ordernumber = 'P420103145437499' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209597'
                WHERE ordernumber = 'P190103145501416' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358347'
                WHERE ordernumber = 'P180103145510756' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358348'
                WHERE ordernumber = 'P200103145729757' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358349'
                WHERE ordernumber = 'P200103145809290' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358351'
                WHERE ordernumber = 'P180103150155465' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353608'
                WHERE ordernumber = 'P180103151038574' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353608'
                WHERE ordernumber = 'P180103151101817' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324224'
                WHERE ordernumber = 'P180103151319444' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358359'
                WHERE ordernumber = 'P180103151440644' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358360'
                WHERE ordernumber = 'P200103151641470' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358361'
                WHERE ordernumber = 'P180103152151355' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358364'
                WHERE ordernumber = 'P420103152227400' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282667'
                WHERE ordernumber = 'P180103152929697' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358367'
                WHERE ordernumber = 'P200103153042368' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353080'
                WHERE ordernumber = 'P420103153100962' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271555'
                WHERE ordernumber = 'P180103153116359' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358371'
                WHERE ordernumber = 'P420103153239312' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223821'
                WHERE ordernumber = 'P200103153357625' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358374'
                WHERE ordernumber = 'P420103153503279' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237010'
                WHERE ordernumber = 'P200103153734694' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358376'
                WHERE ordernumber = 'P180103154529500' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358379'
                WHERE ordernumber = 'P200103154834925' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358384'
                WHERE ordernumber = 'P180103155319291' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358381'
                WHERE ordernumber = 'P200103155431623' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347647'
                WHERE ordernumber = 'P420103155507373' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358385'
                WHERE ordernumber = 'P180103155559586' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350989'
                WHERE ordernumber = 'P180103155809416' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358387'
                WHERE ordernumber = 'P420103160557681' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358389'
                WHERE ordernumber = 'P200103161231440' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358390'
                WHERE ordernumber = 'P420103161652688' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358395'
                WHERE ordernumber = 'P180103162216172' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139087'
                WHERE ordernumber = 'P200103162226159' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358397'
                WHERE ordernumber = 'P200103162349596' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358396'
                WHERE ordernumber = 'P180103162353929' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139087'
                WHERE ordernumber = 'P200103162654352' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124396'
                WHERE ordernumber = 'P180103163220132' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267130'
                WHERE ordernumber = 'P200103163400248' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358404'
                WHERE ordernumber = 'P190103163543435' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358408'
                WHERE ordernumber = 'P190103164001635' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358405'
                WHERE ordernumber = 'P180103164002417' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358411'
                WHERE ordernumber = 'P200103164154655' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358412'
                WHERE ordernumber = 'P420103164205445' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358416'
                WHERE ordernumber = 'P200103164408968' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358419'
                WHERE ordernumber = 'P180103164726340' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358415'
                WHERE ordernumber = 'P200103164812827' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358420'
                WHERE ordernumber = 'P180103164839541' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358415'
                WHERE ordernumber = 'P200103164902635' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358411'
                WHERE ordernumber = 'P200103164940823' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358422'
                WHERE ordernumber = 'P420103165108860' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180103165116821' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '62247'
                WHERE ordernumber = 'P180103165405542' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358425'
                WHERE ordernumber = 'P420103165508447' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358429'
                WHERE ordernumber = 'P180103170136310' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358431'
                WHERE ordernumber = 'P180103170239804' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93984'
                WHERE ordernumber = 'P180103170429867' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358434'
                WHERE ordernumber = 'P180103170540570' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319051'
                WHERE ordernumber = 'P180103170616989' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180103170914569' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358438'
                WHERE ordernumber = 'P200103171033971' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108952'
                WHERE ordernumber = 'P200103171157761' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240176'
                WHERE ordernumber = 'P180103171211251' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358441'
                WHERE ordernumber = 'P200103171348166' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254184'
                WHERE ordernumber = 'P200103171551509' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358445'
                WHERE ordernumber = 'P420103171634605' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358450'
                WHERE ordernumber = 'P180103171907502' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358443'
                WHERE ordernumber = 'P200103172000530' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353795'
                WHERE ordernumber = 'P180103172437479' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358454'
                WHERE ordernumber = 'P180103172900385' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358455'
                WHERE ordernumber = 'P420103173127307' 
            
2024-01-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337254'
                WHERE ordernumber = 'P420103173425222' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358457'
                WHERE ordernumber = 'P200103173445813' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '44686'
                WHERE ordernumber = 'P180103173907170' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358459'
                WHERE ordernumber = 'P200103174356743' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358461'
                WHERE ordernumber = 'P200103174557671' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358462'
                WHERE ordernumber = 'P200103174741113' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309779'
                WHERE ordernumber = 'P180103174849520' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358464'
                WHERE ordernumber = 'P200103174932244' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358468'
                WHERE ordernumber = 'P180103175220757' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200103175414148' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128493'
                WHERE ordernumber = 'P420103175438677' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358470'
                WHERE ordernumber = 'P200103175528404' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289937'
                WHERE ordernumber = 'P180103180933691' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229742'
                WHERE ordernumber = 'P200103181752631' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P190103182233703' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358477'
                WHERE ordernumber = 'P180103182605941' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358479'
                WHERE ordernumber = 'P420103183042302' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358478'
                WHERE ordernumber = 'P180103183052662' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221452'
                WHERE ordernumber = 'P200103183233887' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358480'
                WHERE ordernumber = 'P200103183323956' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358482'
                WHERE ordernumber = 'P180103183357910' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P200103183830940' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '46166'
                WHERE ordernumber = 'P420103184016762' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358483'
                WHERE ordernumber = 'P420103184247203' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '125819'
                WHERE ordernumber = 'P200103184505876' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275430'
                WHERE ordernumber = 'P180103184552921' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358448'
                WHERE ordernumber = 'P420103184707127' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358448'
                WHERE ordernumber = 'P420103184734881' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214333'
                WHERE ordernumber = 'P180103184746303' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358485'
                WHERE ordernumber = 'P200103184823905' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '71667'
                WHERE ordernumber = 'P180103184847918' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120686'
                WHERE ordernumber = 'P180103184944363' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336467'
                WHERE ordernumber = 'P200103184953712' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358487'
                WHERE ordernumber = 'P420103185001825' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358488'
                WHERE ordernumber = 'P200103185331540' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358489'
                WHERE ordernumber = 'P180103185334955' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P190103185609568' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358490'
                WHERE ordernumber = 'P190103185758132' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358491'
                WHERE ordernumber = 'P200103185929857' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357437'
                WHERE ordernumber = 'P190103190152689' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200103190335341' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342750'
                WHERE ordernumber = 'P420103190434512' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101825'
                WHERE ordernumber = 'P200103191119969' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358503'
                WHERE ordernumber = 'P420103191233400' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '111574'
                WHERE ordernumber = 'P190103191317203' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165422'
                WHERE ordernumber = 'P200103191428437' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358506'
                WHERE ordernumber = 'P200103191713803' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358507'
                WHERE ordernumber = 'P200103191915521' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341935'
                WHERE ordernumber = 'P190103191943517' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358507'
                WHERE ordernumber = 'P200103192045745' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358510'
                WHERE ordernumber = 'P190103192517660' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352297'
                WHERE ordernumber = 'P200103192524452' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358511'
                WHERE ordernumber = 'P200103192729406' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358513'
                WHERE ordernumber = 'P200103193049186' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358516'
                WHERE ordernumber = 'P200103193316130' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '44865'
                WHERE ordernumber = 'P420103194044970' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358483'
                WHERE ordernumber = 'P420103194249980' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358520'
                WHERE ordernumber = 'P190103194753413' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358521'
                WHERE ordernumber = 'P190103194901713' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343970'
                WHERE ordernumber = 'P190103195312602' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358524'
                WHERE ordernumber = 'P200103195922305' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358526'
                WHERE ordernumber = 'P420103200113817' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285826'
                WHERE ordernumber = 'P190103200154385' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141300'
                WHERE ordernumber = 'P200103201015313' 
            
2024-01-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141300'
                WHERE ordernumber = 'P200103201232766'