2024-07-12 01:00:03 -- 將會員中心id寫入data-lake
2024-07-12 01:00:03 -- 
            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-07-11%';
        
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400324'
                WHERE ordernumber = 'P630711100911249' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400712'
                WHERE ordernumber = 'P630711110018519' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400713'
                WHERE ordernumber = 'P420711110117874' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230059'
                WHERE ordernumber = 'P200711110337845' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98774'
                WHERE ordernumber = 'P200711110537376' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400714'
                WHERE ordernumber = 'P190711110717260' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153429'
                WHERE ordernumber = 'P200711110726758' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400715'
                WHERE ordernumber = 'P180711110822337' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400716'
                WHERE ordernumber = 'P200711111011122' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210705'
                WHERE ordernumber = 'P180711111109534' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400717'
                WHERE ordernumber = 'P200711111124372' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137870'
                WHERE ordernumber = 'P200711111434469' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400718'
                WHERE ordernumber = 'P180711112000214' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400118'
                WHERE ordernumber = 'P180711112310941' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400719'
                WHERE ordernumber = 'P200711112343891' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395782'
                WHERE ordernumber = 'P200711112515738' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137870'
                WHERE ordernumber = 'P200711112752539' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P420711113422262' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142748'
                WHERE ordernumber = 'P200711113621905' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336569'
                WHERE ordernumber = 'P420711113707365' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400721'
                WHERE ordernumber = 'P420711114013425' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384732'
                WHERE ordernumber = 'P420711114141629' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393125'
                WHERE ordernumber = 'P200711114353302' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400722'
                WHERE ordernumber = 'P190711114458863' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231324'
                WHERE ordernumber = 'P190711114731535' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279838'
                WHERE ordernumber = 'P190711114910720' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400723'
                WHERE ordernumber = 'P200711115024195' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400725'
                WHERE ordernumber = 'P180711115134369' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400726'
                WHERE ordernumber = 'P200711115212177' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400727'
                WHERE ordernumber = 'P420711115301236' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400728'
                WHERE ordernumber = 'P180711115329626' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400729'
                WHERE ordernumber = 'P200711115402265' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400730'
                WHERE ordernumber = 'P180711115527994' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400731'
                WHERE ordernumber = 'P180711115731308' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159648'
                WHERE ordernumber = 'P200711120139899' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141776'
                WHERE ordernumber = 'P180711121550432' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400734'
                WHERE ordernumber = 'P180711121820562' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180711122000514' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400736'
                WHERE ordernumber = 'P420711122059716' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400737'
                WHERE ordernumber = 'P200711123057157' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304820'
                WHERE ordernumber = 'P180711123347711' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303758'
                WHERE ordernumber = 'P190711123936465' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P190711124056934' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393616'
                WHERE ordernumber = 'P200711124409864' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275963'
                WHERE ordernumber = 'P420711124612634' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400740'
                WHERE ordernumber = 'P420711125122882' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357689'
                WHERE ordernumber = 'P200711125414456' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251321'
                WHERE ordernumber = 'P180711125615220' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255480'
                WHERE ordernumber = 'P180711125943774' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259988'
                WHERE ordernumber = 'P180711130445250' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244099'
                WHERE ordernumber = 'P190711130548241' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P200711130751472' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399590'
                WHERE ordernumber = 'P200711131629284' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400742'
                WHERE ordernumber = 'P180711132102824' 
            
2024-07-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236502'
                WHERE ordernumber = 'P200711132119673' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243365'
                WHERE ordernumber = 'P200711132945227' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P180711133207855' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349241'
                WHERE ordernumber = 'P420711133636285' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381767'
                WHERE ordernumber = 'P180711133812212' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268194'
                WHERE ordernumber = 'P200711134149698' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400744'
                WHERE ordernumber = 'P180711134257868' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400741'
                WHERE ordernumber = 'P180711134922778' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272814'
                WHERE ordernumber = 'P200711135133683' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P200711135819531' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262406'
                WHERE ordernumber = 'P180711140211734' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398189'
                WHERE ordernumber = 'P180711140815414' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94161'
                WHERE ordernumber = 'P180711140930986' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118274'
                WHERE ordernumber = 'P180711141204770' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400129'
                WHERE ordernumber = 'P180711141449317' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400746'
                WHERE ordernumber = 'P200711141917119' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400746'
                WHERE ordernumber = 'P200711142019939' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400129'
                WHERE ordernumber = 'P180711141449317' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400747'
                WHERE ordernumber = 'P180711142655877' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395665'
                WHERE ordernumber = 'P420711142720467' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388819'
                WHERE ordernumber = 'P190711142827437' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400750'
                WHERE ordernumber = 'P200711145229122' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180711145235502' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211379'
                WHERE ordernumber = 'P180711150214457' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400753'
                WHERE ordernumber = 'P200711150533724' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400756'
                WHERE ordernumber = 'P420711151311398' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399327'
                WHERE ordernumber = 'P180711151411461' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108200'
                WHERE ordernumber = 'P180711151447715' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P180711151654203' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283648'
                WHERE ordernumber = 'P180711151858433' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378375'
                WHERE ordernumber = 'P630711152758662' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398646'
                WHERE ordernumber = 'P420711153632773' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315957'
                WHERE ordernumber = 'P200711153837850' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400757'
                WHERE ordernumber = 'P200711153928593' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397634'
                WHERE ordernumber = 'P630711154400975' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248591'
                WHERE ordernumber = 'P200711154723955' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398677'
                WHERE ordernumber = 'P200711154958788' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400758'
                WHERE ordernumber = 'P180711155232264' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400761'
                WHERE ordernumber = 'P180711160035845' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247064'
                WHERE ordernumber = 'P200711160047709' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390116'
                WHERE ordernumber = 'P200711160327111' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225612'
                WHERE ordernumber = 'P200711160603337' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400763'
                WHERE ordernumber = 'P420711160732725' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400764'
                WHERE ordernumber = 'P420711161526224' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400769'
                WHERE ordernumber = 'P420711162939583' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400770'
                WHERE ordernumber = 'P200711163038949' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400771'
                WHERE ordernumber = 'P190711163209189' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400772'
                WHERE ordernumber = 'P420711163702719' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344749'
                WHERE ordernumber = 'P420711163909332' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400772'
                WHERE ordernumber = 'P420711164000378' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400774'
                WHERE ordernumber = 'P180711164059808' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96442'
                WHERE ordernumber = 'P180711164141475' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93488'
                WHERE ordernumber = 'P180711164228271' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343537'
                WHERE ordernumber = 'P180711164554517' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400775'
                WHERE ordernumber = 'P180711164931673' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389185'
                WHERE ordernumber = 'P180711165009521' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363042'
                WHERE ordernumber = 'P420711165234861' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240218'
                WHERE ordernumber = 'P180711165302293' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389185'
                WHERE ordernumber = 'P180711165334933' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400776'
                WHERE ordernumber = 'P180711170229332' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400777'
                WHERE ordernumber = 'P180711170902280' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287147'
                WHERE ordernumber = 'P180711171036126' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245134'
                WHERE ordernumber = 'P200711171041181' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400395'
                WHERE ordernumber = 'P420711171614631' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208501'
                WHERE ordernumber = 'P180711172026456' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400780'
                WHERE ordernumber = 'P420711172152936' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249872'
                WHERE ordernumber = 'P180711172353663' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400781'
                WHERE ordernumber = 'P190711172510750' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387817'
                WHERE ordernumber = 'P200711172648891' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400782'
                WHERE ordernumber = 'P420711172745139' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P630711172814518' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282218'
                WHERE ordernumber = 'P200711172938511' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400783'
                WHERE ordernumber = 'P420711173207377' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34187'
                WHERE ordernumber = 'P420711173318463' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380301'
                WHERE ordernumber = 'P420711173504457' 
            
2024-07-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P200711173719556' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304024'
                WHERE ordernumber = 'P420711173734640' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338947'
                WHERE ordernumber = 'P420711174157901' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400786'
                WHERE ordernumber = 'P200711174429857' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324778'
                WHERE ordernumber = 'P420711174558347' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400694'
                WHERE ordernumber = 'P180711174754740' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400694'
                WHERE ordernumber = 'P180711174831957' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298392'
                WHERE ordernumber = 'P200711174922539' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400788'
                WHERE ordernumber = 'P190711175127369' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400789'
                WHERE ordernumber = 'P190711175520848' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '91022'
                WHERE ordernumber = 'P180711180038338' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400790'
                WHERE ordernumber = 'P200711180104850' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400791'
                WHERE ordernumber = 'P190711180220592' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '238250'
                WHERE ordernumber = 'P420711180423849' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400792'
                WHERE ordernumber = 'P420711180905281' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '290726'
                WHERE ordernumber = 'P180711181141644' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400793'
                WHERE ordernumber = 'P200711181620298' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105423'
                WHERE ordernumber = 'P180711181646269' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215170'
                WHERE ordernumber = 'P180711181756554' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400794'
                WHERE ordernumber = 'P200711182327449' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165497'
                WHERE ordernumber = 'P190711182528855' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400795'
                WHERE ordernumber = 'P190711182656303' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400509'
                WHERE ordernumber = 'P420711182928210' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396733'
                WHERE ordernumber = 'P200711182933290' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400796'
                WHERE ordernumber = 'P180711183546577' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400797'
                WHERE ordernumber = 'P200711183957754' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '389171'
                WHERE ordernumber = 'P200711184230579' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312880'
                WHERE ordernumber = 'P200711184332128' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '62902'
                WHERE ordernumber = 'P190711184855922' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '225185'
                WHERE ordernumber = 'P190711184919560' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400798'
                WHERE ordernumber = 'P200711185156594' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190711190249457' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '259735'
                WHERE ordernumber = 'P190711190340355' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400527'
                WHERE ordernumber = 'P200711190432116' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400799'
                WHERE ordernumber = 'P190711190436788' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '208609'
                WHERE ordernumber = 'P190711190502567' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400800'
                WHERE ordernumber = 'P190711190631855' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '177312'
                WHERE ordernumber = 'P190711191254425' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308644'
                WHERE ordernumber = 'P190711191756774' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '29379'
                WHERE ordernumber = 'P200711191853595' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396045'
                WHERE ordernumber = 'P200711193003557' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '295508'
                WHERE ordernumber = 'P200711194530838' 
            
2024-07-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299188'
                WHERE ordernumber = 'P200711195715858'