2023-12-06 01:00:03 -- 將會員中心id寫入data-lake
2023-12-06 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 '2023-12-05%';
        
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83927'
                WHERE ordernumber = 'P181205110422428' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342052'
                WHERE ordernumber = 'P181205110616738' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319951'
                WHERE ordernumber = 'P201205110847147' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109486'
                WHERE ordernumber = 'P201205111254270' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160734'
                WHERE ordernumber = 'P201205111341791' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P201205111451466' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94592'
                WHERE ordernumber = 'P181205111751793' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350828'
                WHERE ordernumber = 'P201205112132499' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P201205112613614' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297061'
                WHERE ordernumber = 'P201205112655535' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421205112813205' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209599'
                WHERE ordernumber = 'P191205112819402' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350829'
                WHERE ordernumber = 'P181205112959230' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350831'
                WHERE ordernumber = 'P181205113710682' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350832'
                WHERE ordernumber = 'P181205113827578' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350833'
                WHERE ordernumber = 'P181205113926695' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350835'
                WHERE ordernumber = 'P181205114124999' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350834'
                WHERE ordernumber = 'P201205114214784' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P181205114244382' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350836'
                WHERE ordernumber = 'P181205114443493' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350837'
                WHERE ordernumber = 'P201205115045148' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P181205115252745' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350838'
                WHERE ordernumber = 'P181205115525397' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96664'
                WHERE ordernumber = 'P201205115823392' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247610'
                WHERE ordernumber = 'P201205120315866' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350840'
                WHERE ordernumber = 'P201205120549127' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350841'
                WHERE ordernumber = 'P201205120725327' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345396'
                WHERE ordernumber = 'P191205121027518' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350632'
                WHERE ordernumber = 'P201205121253473' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350842'
                WHERE ordernumber = 'P191205121342282' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256613'
                WHERE ordernumber = 'P181205122444764' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350844'
                WHERE ordernumber = 'P201205123643768' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349585'
                WHERE ordernumber = 'P181205123851581' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350846'
                WHERE ordernumber = 'P201205124239463' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302321'
                WHERE ordernumber = 'P421205124306613' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312777'
                WHERE ordernumber = 'P181205124911818' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348065'
                WHERE ordernumber = 'P421205125158794' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99956'
                WHERE ordernumber = 'P201205125701147' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350848'
                WHERE ordernumber = 'P201205130247376' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119732'
                WHERE ordernumber = 'P181205130519474' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350849'
                WHERE ordernumber = 'P421205130958596' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136997'
                WHERE ordernumber = 'P191205131054177' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346316'
                WHERE ordernumber = 'P181205131146754' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350850'
                WHERE ordernumber = 'P421205131242923' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214179'
                WHERE ordernumber = 'P191205132122783' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272140'
                WHERE ordernumber = 'P181205132505721' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350853'
                WHERE ordernumber = 'P181205133115345' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350854'
                WHERE ordernumber = 'P181205134055134' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350857'
                WHERE ordernumber = 'P181205135507279' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350858'
                WHERE ordernumber = 'P201205140244676' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343684'
                WHERE ordernumber = 'P201205140328329' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P191205141611323' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350862'
                WHERE ordernumber = 'P201205141617382' 
            
2023-12-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350863'
                WHERE ordernumber = 'P421205141647957' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128717'
                WHERE ordernumber = 'P191205141733991' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163844'
                WHERE ordernumber = 'P201205141947486' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350811'
                WHERE ordernumber = 'P191205141951391' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132946'
                WHERE ordernumber = 'P191205142222574' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350864'
                WHERE ordernumber = 'P181205142348988' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283209'
                WHERE ordernumber = 'P181205143012685' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350866'
                WHERE ordernumber = 'P191205143304988' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350868'
                WHERE ordernumber = 'P181205143537226' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350868'
                WHERE ordernumber = 'P181205143719298' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P191205143749399' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P181205143807801' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P191205143830170' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251706'
                WHERE ordernumber = 'P421205144037692' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350870'
                WHERE ordernumber = 'P201205144135217' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '39039'
                WHERE ordernumber = 'P201205145136752' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238736'
                WHERE ordernumber = 'P181205145248980' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320785'
                WHERE ordernumber = 'P421205145258726' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P201205145304179' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240632'
                WHERE ordernumber = 'P201205145549517' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350873'
                WHERE ordernumber = 'P201205145719449' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350874'
                WHERE ordernumber = 'P201205150210672' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350876'
                WHERE ordernumber = 'P201205150422407' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350877'
                WHERE ordernumber = 'P181205150533189' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350875'
                WHERE ordernumber = 'P181205150911318' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350877'
                WHERE ordernumber = 'P181205151027927' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350878'
                WHERE ordernumber = 'P421205151059698' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350879'
                WHERE ordernumber = 'P201205151113670' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350881'
                WHERE ordernumber = 'P201205151220947' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350882'
                WHERE ordernumber = 'P201205151311327' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206353'
                WHERE ordernumber = 'P181205151400414' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281172'
                WHERE ordernumber = 'P201205151404768' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347855'
                WHERE ordernumber = 'P181205151611646' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350126'
                WHERE ordernumber = 'P191205151743528' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96407'
                WHERE ordernumber = 'P201205151841364' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96407'
                WHERE ordernumber = 'P201205152123922' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350883'
                WHERE ordernumber = 'P181205152337605' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P191205153714731' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350886'
                WHERE ordernumber = 'P421205155308390' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350887'
                WHERE ordernumber = 'P181205155316652' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290465'
                WHERE ordernumber = 'P201205155354268' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350889'
                WHERE ordernumber = 'P181205155654613' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343004'
                WHERE ordernumber = 'P201205160036270' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350890'
                WHERE ordernumber = 'P201205160230994' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '67684'
                WHERE ordernumber = 'P201205160518718' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298022'
                WHERE ordernumber = 'P201205161054561' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343004'
                WHERE ordernumber = 'P201205161556134' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181205161813911' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250265'
                WHERE ordernumber = 'P201205161854491' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343976'
                WHERE ordernumber = 'P201205162045288' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P201205162615166' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349777'
                WHERE ordernumber = 'P191205162700231' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350892'
                WHERE ordernumber = 'P191205162838421' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350894'
                WHERE ordernumber = 'P191205162959602' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104141'
                WHERE ordernumber = 'P191205163526990' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346955'
                WHERE ordernumber = 'P201205164231267' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350895'
                WHERE ordernumber = 'P201205164330993' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P201205164426150' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277769'
                WHERE ordernumber = 'P201205164601860' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350897'
                WHERE ordernumber = 'P201205165230545' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350899'
                WHERE ordernumber = 'P201205170040842' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P201205170500706' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350901'
                WHERE ordernumber = 'P191205170742785' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221489'
                WHERE ordernumber = 'P201205170753752' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350902'
                WHERE ordernumber = 'P191205171430689' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '180261'
                WHERE ordernumber = 'P181205171732183' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350903'
                WHERE ordernumber = 'P201205172424305' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350904'
                WHERE ordernumber = 'P201205172713641' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350905'
                WHERE ordernumber = 'P191205173402810' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348088'
                WHERE ordernumber = 'P201205173517313' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338804'
                WHERE ordernumber = 'P191205173615264' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30912'
                WHERE ordernumber = 'P421205173644710' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338804'
                WHERE ordernumber = 'P181205173757746' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350906'
                WHERE ordernumber = 'P201205173900141' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350907'
                WHERE ordernumber = 'P191205174103415' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281180'
                WHERE ordernumber = 'P201205174158794' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350907'
                WHERE ordernumber = 'P191205174355230' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350909'
                WHERE ordernumber = 'P201205174612475' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350911'
                WHERE ordernumber = 'P201205175102867' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350912'
                WHERE ordernumber = 'P191205175117946' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223482'
                WHERE ordernumber = 'P191205175419637' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349876'
                WHERE ordernumber = 'P201205175719463' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272680'
                WHERE ordernumber = 'P181205180131888' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350913'
                WHERE ordernumber = 'P421205180208978' 
            
2023-12-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350914'
                WHERE ordernumber = 'P201205180311853' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350438'
                WHERE ordernumber = 'P201205180701281' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232237'
                WHERE ordernumber = 'P191205180853615' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299549'
                WHERE ordernumber = 'P181205181121783' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245393'
                WHERE ordernumber = 'P201205181200629' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350920'
                WHERE ordernumber = 'P181205181257614' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350921'
                WHERE ordernumber = 'P191205181641489' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P181205181654139' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350923'
                WHERE ordernumber = 'P201205181719253' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350924'
                WHERE ordernumber = 'P181205181741397' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350925'
                WHERE ordernumber = 'P421205181837456' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350923'
                WHERE ordernumber = 'P201205182022459' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350926'
                WHERE ordernumber = 'P201205182518468' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350928'
                WHERE ordernumber = 'P191205182826531' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350929'
                WHERE ordernumber = 'P191205183007204' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350929'
                WHERE ordernumber = 'P191205183110922' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350930'
                WHERE ordernumber = 'P201205183301980' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296980'
                WHERE ordernumber = 'P421205183349378' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '122493'
                WHERE ordernumber = 'P191205183537600' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350931'
                WHERE ordernumber = 'P191205184000450' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350933'
                WHERE ordernumber = 'P191205184151508' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350934'
                WHERE ordernumber = 'P191205184413473' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348898'
                WHERE ordernumber = 'P421205185311207' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121876'
                WHERE ordernumber = 'P191205185439623' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350936'
                WHERE ordernumber = 'P191205185644469' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100925'
                WHERE ordernumber = 'P201205190022855' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350937'
                WHERE ordernumber = 'P191205190047863' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350938'
                WHERE ordernumber = 'P201205191147308' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343608'
                WHERE ordernumber = 'P201205191641349' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P201205192234930' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343817'
                WHERE ordernumber = 'P191205192630482' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350943'
                WHERE ordernumber = 'P191205193056538' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98423'
                WHERE ordernumber = 'P201205193137827' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P191205193637407' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350944'
                WHERE ordernumber = 'P201205193715477' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350945'
                WHERE ordernumber = 'P201205194013196' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350948'
                WHERE ordernumber = 'P421205195336519' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214830'
                WHERE ordernumber = 'P191205195450494' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342504'
                WHERE ordernumber = 'P201205195558628' 
            
2023-12-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350950'
                WHERE ordernumber = 'P421205200058898'