2024-01-03 01:00:03 -- 將會員中心id寫入data-lake
2024-01-03 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-01-02%';
        
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250348'
                WHERE ordernumber = 'P190102110403715' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73445'
                WHERE ordernumber = 'P200102110551303' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322291'
                WHERE ordernumber = 'P200102110655650' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250348'
                WHERE ordernumber = 'P190102110713982' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357838'
                WHERE ordernumber = 'P190102110800901' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357840'
                WHERE ordernumber = 'P420102110946862' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357838'
                WHERE ordernumber = 'P180102110959362' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357842'
                WHERE ordernumber = 'P200102111059158' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355605'
                WHERE ordernumber = 'P420102111225869' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357837'
                WHERE ordernumber = 'P180102111441571' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46442'
                WHERE ordernumber = 'P200102111516490' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357843'
                WHERE ordernumber = 'P420102111709774' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357837'
                WHERE ordernumber = 'P180102111747544' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356522'
                WHERE ordernumber = 'P200102111750516' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357845'
                WHERE ordernumber = 'P180102111927253' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P200102112208336' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357847'
                WHERE ordernumber = 'P180102112809614' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352408'
                WHERE ordernumber = 'P200102112836911' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268146'
                WHERE ordernumber = 'P180102113346531' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238458'
                WHERE ordernumber = 'P200102113649249' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112416'
                WHERE ordernumber = 'P180102114010814' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98539'
                WHERE ordernumber = 'P180102114154228' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356641'
                WHERE ordernumber = 'P420102114301481' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249733'
                WHERE ordernumber = 'P200102115040987' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357856'
                WHERE ordernumber = 'P190102115322461' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334257'
                WHERE ordernumber = 'P420102115946181' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213971'
                WHERE ordernumber = 'P190102121142991' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357864'
                WHERE ordernumber = 'P420102121438390' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357865'
                WHERE ordernumber = 'P180102121756574' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227980'
                WHERE ordernumber = 'P200102121839515' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357868'
                WHERE ordernumber = 'P180102121840654' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357869'
                WHERE ordernumber = 'P420102122005329' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224684'
                WHERE ordernumber = 'P180102122104922' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357870'
                WHERE ordernumber = 'P420102122541702' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354991'
                WHERE ordernumber = 'P200102122813477' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354128'
                WHERE ordernumber = 'P180102122839745' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277989'
                WHERE ordernumber = 'P190102124207875' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357061'
                WHERE ordernumber = 'P200102124359760' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357877'
                WHERE ordernumber = 'P420102124539966' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79530'
                WHERE ordernumber = 'P190102124829792' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357880'
                WHERE ordernumber = 'P190102125008775' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357881'
                WHERE ordernumber = 'P420102125115420' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357882'
                WHERE ordernumber = 'P190102125117419' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357883'
                WHERE ordernumber = 'P190102125219619' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237026'
                WHERE ordernumber = 'P200102125412184' 
            
2024-01-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357884'
                WHERE ordernumber = 'P420102125414847' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357887'
                WHERE ordernumber = 'P190102130357794' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357888'
                WHERE ordernumber = 'P420102130541722' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '790'
                WHERE ordernumber = 'P420102130930760' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136692'
                WHERE ordernumber = 'P190102131041346' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158709'
                WHERE ordernumber = 'P200102131138174' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94952'
                WHERE ordernumber = 'P200102131339534' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250618'
                WHERE ordernumber = 'P200102131510939' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357895'
                WHERE ordernumber = 'P190102131537859' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357896'
                WHERE ordernumber = 'P200102131800507' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420102132642554' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285941'
                WHERE ordernumber = 'P190102132825918' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316113'
                WHERE ordernumber = 'P200102133214677' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357904'
                WHERE ordernumber = 'P420102133611640' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297385'
                WHERE ordernumber = 'P190102133752919' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357905'
                WHERE ordernumber = 'P420102133914298' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357906'
                WHERE ordernumber = 'P190102134008374' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357907'
                WHERE ordernumber = 'P190102134114529' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310026'
                WHERE ordernumber = 'P180102134206819' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105984'
                WHERE ordernumber = 'P190102134242603' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357909'
                WHERE ordernumber = 'P420102134449827' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180102134514908' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238800'
                WHERE ordernumber = 'P180102134615497' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357912'
                WHERE ordernumber = 'P190102134651996' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357914'
                WHERE ordernumber = 'P200102135127161' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288685'
                WHERE ordernumber = 'P190102135212242' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357915'
                WHERE ordernumber = 'P190102135339351' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307848'
                WHERE ordernumber = 'P190102135650181' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357917'
                WHERE ordernumber = 'P420102135958853' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357919'
                WHERE ordernumber = 'P420102140140443' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105116'
                WHERE ordernumber = 'P200102140844329' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P200102141051444' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96512'
                WHERE ordernumber = 'P200102141259771' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228035'
                WHERE ordernumber = 'P190102141516743' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207694'
                WHERE ordernumber = 'P200102141604862' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318790'
                WHERE ordernumber = 'P200102141641659' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357924'
                WHERE ordernumber = 'P200102141811676' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357925'
                WHERE ordernumber = 'P200102142105809' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '31300'
                WHERE ordernumber = 'P200102142451284' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336156'
                WHERE ordernumber = 'P420102142519890' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357727'
                WHERE ordernumber = 'P190102142614865' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325658'
                WHERE ordernumber = 'P180102142742362' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161876'
                WHERE ordernumber = 'P200102143009964' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P190102143109483' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320225'
                WHERE ordernumber = 'P190102143409416' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357930'
                WHERE ordernumber = 'P190102143426694' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356802'
                WHERE ordernumber = 'P200102143740524' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222490'
                WHERE ordernumber = 'P190102144107846' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357933'
                WHERE ordernumber = 'P200102144141886' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357937'
                WHERE ordernumber = 'P190102144651334' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319376'
                WHERE ordernumber = 'P420102144802917' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357940'
                WHERE ordernumber = 'P190102145238350' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94728'
                WHERE ordernumber = 'P200102145339813' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357941'
                WHERE ordernumber = 'P190102145348454' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P190102145537663' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357943'
                WHERE ordernumber = 'P190102145636759' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357944'
                WHERE ordernumber = 'P200102145710670' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357945'
                WHERE ordernumber = 'P200102145810218' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357946'
                WHERE ordernumber = 'P200102145944628' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357947'
                WHERE ordernumber = 'P190102150006815' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167632'
                WHERE ordernumber = 'P200102150401732' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357954'
                WHERE ordernumber = 'P190102151307522' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271271'
                WHERE ordernumber = 'P200102151311700' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357955'
                WHERE ordernumber = 'P200102151431264' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313765'
                WHERE ordernumber = 'P190102151646336' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357956'
                WHERE ordernumber = 'P420102151844178' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357957'
                WHERE ordernumber = 'P190102152023900' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357958'
                WHERE ordernumber = 'P190102152202886' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357959'
                WHERE ordernumber = 'P190102152352663' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339857'
                WHERE ordernumber = 'P420102152430496' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357961'
                WHERE ordernumber = 'P190102152624876' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342303'
                WHERE ordernumber = 'P190102152756351' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357964'
                WHERE ordernumber = 'P190102152930886' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357967'
                WHERE ordernumber = 'P200102153618401' 
            
2024-01-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139381'
                WHERE ordernumber = 'P200102153736187' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357968'
                WHERE ordernumber = 'P420102154104561' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357970'
                WHERE ordernumber = 'P200102154152596' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96397'
                WHERE ordernumber = 'P180102154256126' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357971'
                WHERE ordernumber = 'P420102154331461' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96397'
                WHERE ordernumber = 'P180102154336476' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357977'
                WHERE ordernumber = 'P420102154623853' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357978'
                WHERE ordernumber = 'P420102154744766' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357980'
                WHERE ordernumber = 'P190102154912353' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357981'
                WHERE ordernumber = 'P420102154921899' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357982'
                WHERE ordernumber = 'P190102155127573' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357984'
                WHERE ordernumber = 'P200102155312571' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357986'
                WHERE ordernumber = 'P420102155641426' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294984'
                WHERE ordernumber = 'P190102155643887' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357988'
                WHERE ordernumber = 'P190102155926488' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228082'
                WHERE ordernumber = 'P190102160058197' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P190102160136177' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357991'
                WHERE ordernumber = 'P190102160338600' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357993'
                WHERE ordernumber = 'P420102160448841' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357994'
                WHERE ordernumber = 'P420102160551823' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357996'
                WHERE ordernumber = 'P420102161103955' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256850'
                WHERE ordernumber = 'P200102161139874' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357999'
                WHERE ordernumber = 'P200102161534871' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358001'
                WHERE ordernumber = 'P190102161626646' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254191'
                WHERE ordernumber = 'P200102161704559' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349225'
                WHERE ordernumber = 'P190102161928984' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298394'
                WHERE ordernumber = 'P200102162109988' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349225'
                WHERE ordernumber = 'P190102162451953' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344375'
                WHERE ordernumber = 'P200102162510651' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358005'
                WHERE ordernumber = 'P420102162625350' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298854'
                WHERE ordernumber = 'P420102162723146' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343932'
                WHERE ordernumber = 'P190102163038144' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355166'
                WHERE ordernumber = 'P420102163322549' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358011'
                WHERE ordernumber = 'P190102163537216' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297385'
                WHERE ordernumber = 'P190102163627751' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358012'
                WHERE ordernumber = 'P200102163705437' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357309'
                WHERE ordernumber = 'P420102163850247' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358014'
                WHERE ordernumber = 'P200102163919597' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246643'
                WHERE ordernumber = 'P190102164022210' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358016'
                WHERE ordernumber = 'P190102164344208' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358017'
                WHERE ordernumber = 'P420102164356280' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358019'
                WHERE ordernumber = 'P190102164526597' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358020'
                WHERE ordernumber = 'P200102164844579' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358021'
                WHERE ordernumber = 'P420102165248771' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353106'
                WHERE ordernumber = 'P200102165506292' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358023'
                WHERE ordernumber = 'P190102165512558' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358024'
                WHERE ordernumber = 'P200102165645686' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P420102165734178' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358026'
                WHERE ordernumber = 'P190102165756227' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P190102165844321' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358027'
                WHERE ordernumber = 'P200102170115273' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113453'
                WHERE ordernumber = 'P200102170545904' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358027'
                WHERE ordernumber = 'P200102170748689' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358029'
                WHERE ordernumber = 'P200102171120357' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288090'
                WHERE ordernumber = 'P190102172032211' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '90101'
                WHERE ordernumber = 'P200102172059503' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '131885'
                WHERE ordernumber = 'P190102172420476' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358035'
                WHERE ordernumber = 'P190102173103980' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P190102174027787' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '257872'
                WHERE ordernumber = 'P200102174738444' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358040'
                WHERE ordernumber = 'P190102174912870' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358042'
                WHERE ordernumber = 'P200102175034674' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273894'
                WHERE ordernumber = 'P190102175202191' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281686'
                WHERE ordernumber = 'P200102175322360' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358045'
                WHERE ordernumber = 'P190102180001327' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358046'
                WHERE ordernumber = 'P190102180106750' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340529'
                WHERE ordernumber = 'P200102180238402' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97095'
                WHERE ordernumber = 'P200102180404455' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300894'
                WHERE ordernumber = 'P200102180559928' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358045'
                WHERE ordernumber = 'P190102180902121' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '192108'
                WHERE ordernumber = 'P200102182025467' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358049'
                WHERE ordernumber = 'P420102182040694' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109157'
                WHERE ordernumber = 'P200102183547925' 
            
2024-01-03 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '168484'
                WHERE ordernumber = 'P200102183738996' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '330261'
                WHERE ordernumber = 'P190102183817528' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358059'
                WHERE ordernumber = 'P200102183948643' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358060'
                WHERE ordernumber = 'P190102184012461' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '113879'
                WHERE ordernumber = 'P190102184129669' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '293285'
                WHERE ordernumber = 'P190102184513290' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358061'
                WHERE ordernumber = 'P420102184614333' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319475'
                WHERE ordernumber = 'P420102184704221' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358062'
                WHERE ordernumber = 'P190102184727589' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '357019'
                WHERE ordernumber = 'P420102184741444' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '341725'
                WHERE ordernumber = 'P420102184858485' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '256518'
                WHERE ordernumber = 'P420102185020686' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358064'
                WHERE ordernumber = 'P200102185149711' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '302614'
                WHERE ordernumber = 'P200102185241466' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358067'
                WHERE ordernumber = 'P420102185556651' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358068'
                WHERE ordernumber = 'P200102185701237' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200102190159725' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358073'
                WHERE ordernumber = 'P190102190221296' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351717'
                WHERE ordernumber = 'P420102190421837' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358074'
                WHERE ordernumber = 'P190102190448496' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358075'
                WHERE ordernumber = 'P190102190555596' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358075'
                WHERE ordernumber = 'P190102190633212' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358080'
                WHERE ordernumber = 'P190102190856595' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358082'
                WHERE ordernumber = 'P420102191258230' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '237609'
                WHERE ordernumber = 'P200102191449669' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '356963'
                WHERE ordernumber = 'P200102191734264' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358086'
                WHERE ordernumber = 'P200102191851651' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358087'
                WHERE ordernumber = 'P200102192342401' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351717'
                WHERE ordernumber = 'P200102192523241' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315952'
                WHERE ordernumber = 'P190102192857558' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358092'
                WHERE ordernumber = 'P420102193558316' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235055'
                WHERE ordernumber = 'P200102193729792' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358094'
                WHERE ordernumber = 'P420102194046701' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358098'
                WHERE ordernumber = 'P420102194656119' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P420102194841614' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '358101'
                WHERE ordernumber = 'P420102195802447' 
            
2024-01-03 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319601'
                WHERE ordernumber = 'P190102195934630'