2024-05-15 01:00:03 -- 將會員中心id寫入data-lake
2024-05-15 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-05-14%';
        
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389914'
                WHERE ordernumber = 'P630514103253959' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389916'
                WHERE ordernumber = 'P190514110723898' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389917'
                WHERE ordernumber = 'P200514110955970' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389918'
                WHERE ordernumber = 'P190514111203606' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343684'
                WHERE ordernumber = 'P200514111627594' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349708'
                WHERE ordernumber = 'P200514111813968' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336911'
                WHERE ordernumber = 'P190514112044733' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P180514112639233' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389923'
                WHERE ordernumber = 'P190514112808533' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372351'
                WHERE ordernumber = 'P180514113116330' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316264'
                WHERE ordernumber = 'P180514113348191' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P190514113451979' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277884'
                WHERE ordernumber = 'P630514113458334' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122618'
                WHERE ordernumber = 'P180514114803541' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383426'
                WHERE ordernumber = 'P190514114847461' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299129'
                WHERE ordernumber = 'P200514115048606' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389926'
                WHERE ordernumber = 'P200514115205669' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389927'
                WHERE ordernumber = 'P200514115551397' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101457'
                WHERE ordernumber = 'P200514120236228' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389928'
                WHERE ordernumber = 'P200514120243957' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232171'
                WHERE ordernumber = 'P180514120322157' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293351'
                WHERE ordernumber = 'P200514121048646' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389931'
                WHERE ordernumber = 'P180514121144970' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273234'
                WHERE ordernumber = 'P200514121305816' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305277'
                WHERE ordernumber = 'P200514121333179' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389932'
                WHERE ordernumber = 'P190514121410221' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293741'
                WHERE ordernumber = 'P180514122557454' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389933'
                WHERE ordernumber = 'P180514122928545' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389934'
                WHERE ordernumber = 'P420514123037186' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239181'
                WHERE ordernumber = 'P180514124104737' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389937'
                WHERE ordernumber = 'P180514124417789' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387788'
                WHERE ordernumber = 'P630514124620227' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281691'
                WHERE ordernumber = 'P200514124707756' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389938'
                WHERE ordernumber = 'P200514124938404' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P180514125038112' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388149'
                WHERE ordernumber = 'P180514125325154' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307359'
                WHERE ordernumber = 'P200514125448925' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P180514130138374' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98968'
                WHERE ordernumber = 'P420514130207774' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92634'
                WHERE ordernumber = 'P180514130306706' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '4'
                WHERE ordernumber = 'P180514130520263' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389621'
                WHERE ordernumber = 'P190514130834948' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389943'
                WHERE ordernumber = 'P420514130946705' 
            
2024-05-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P420514131211674' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264585'
                WHERE ordernumber = 'P200514131622533' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372199'
                WHERE ordernumber = 'P420514132213457' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378465'
                WHERE ordernumber = 'P200514132257761' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97016'
                WHERE ordernumber = 'P200514132429173' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163148'
                WHERE ordernumber = 'P190514132546905' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97016'
                WHERE ordernumber = 'P200514132747945' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389944'
                WHERE ordernumber = 'P180514132837891' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389945'
                WHERE ordernumber = 'P420514133310949' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389946'
                WHERE ordernumber = 'P180514133603569' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257642'
                WHERE ordernumber = 'P180514134029489' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245241'
                WHERE ordernumber = 'P180514134203639' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389949'
                WHERE ordernumber = 'P180514134319651' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247008'
                WHERE ordernumber = 'P180514134519804' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273567'
                WHERE ordernumber = 'P200514134824624' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103163'
                WHERE ordernumber = 'P180514135057173' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382540'
                WHERE ordernumber = 'P180514135353908' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389952'
                WHERE ordernumber = 'P200514135428788' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389954'
                WHERE ordernumber = 'P200514135640806' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340688'
                WHERE ordernumber = 'P420514135752357' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389951'
                WHERE ordernumber = 'P790514135950963' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380616'
                WHERE ordernumber = 'P180514140134748' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389955'
                WHERE ordernumber = 'P190514140304201' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286322'
                WHERE ordernumber = 'P180514140316645' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '173213'
                WHERE ordernumber = 'P180514140752217' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389957'
                WHERE ordernumber = 'P180514141255556' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389958'
                WHERE ordernumber = 'P420514142102427' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346309'
                WHERE ordernumber = 'P200514142119113' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389959'
                WHERE ordernumber = 'P180514142320275' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P200514142403987' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242184'
                WHERE ordernumber = 'P200514142427503' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P200514142645201' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389961'
                WHERE ordernumber = 'P180514142756791' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307121'
                WHERE ordernumber = 'P200514142837954' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386761'
                WHERE ordernumber = 'P420514143342319' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P420514143519468' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389959'
                WHERE ordernumber = 'P180514143900751' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315380'
                WHERE ordernumber = 'P420514144119738' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200514144441382' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389964'
                WHERE ordernumber = 'P180514145043815' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389965'
                WHERE ordernumber = 'P790514145357541' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380535'
                WHERE ordernumber = 'P420514151045762' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315588'
                WHERE ordernumber = 'P420514151302770' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389967'
                WHERE ordernumber = 'P420514151617174' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288989'
                WHERE ordernumber = 'P200514152243395' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P420514152942685' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389968'
                WHERE ordernumber = 'P790514153306199' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P200514154104217' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389970'
                WHERE ordernumber = 'P420514154753701' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389971'
                WHERE ordernumber = 'P180514155301325' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389974'
                WHERE ordernumber = 'P420514155812428' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389974'
                WHERE ordernumber = 'P420514155904282' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389975'
                WHERE ordernumber = 'P180514160021154' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122570'
                WHERE ordernumber = 'P200514160230802' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261162'
                WHERE ordernumber = 'P190514160404270' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389976'
                WHERE ordernumber = 'P180514160410745' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384260'
                WHERE ordernumber = 'P420514160546357' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240288'
                WHERE ordernumber = 'P200514161350198' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241210'
                WHERE ordernumber = 'P420514162321310' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389832'
                WHERE ordernumber = 'P630514162520972' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389981'
                WHERE ordernumber = 'P200514163124225' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389983'
                WHERE ordernumber = 'P790514163527763' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380226'
                WHERE ordernumber = 'P190514163624869' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389984'
                WHERE ordernumber = 'P420514163637704' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384434'
                WHERE ordernumber = 'P180514163943499' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104691'
                WHERE ordernumber = 'P200514164051362' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389985'
                WHERE ordernumber = 'P190514164251803' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389079'
                WHERE ordernumber = 'P790514165121476' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389987'
                WHERE ordernumber = 'P200514165314608' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389988'
                WHERE ordernumber = 'P180514165858566' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389989'
                WHERE ordernumber = 'P420514170008351' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389986'
                WHERE ordernumber = 'P790514170059219' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358732'
                WHERE ordernumber = 'P790514170245241' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389990'
                WHERE ordernumber = 'P200514170446220' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389991'
                WHERE ordernumber = 'P200514170917122' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389992'
                WHERE ordernumber = 'P180514171327871' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389628'
                WHERE ordernumber = 'P630514171751376' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258957'
                WHERE ordernumber = 'P180514172429247' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389993'
                WHERE ordernumber = 'P180514172650667' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389985'
                WHERE ordernumber = 'P190514172916136' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382227'
                WHERE ordernumber = 'P420514173001577' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374206'
                WHERE ordernumber = 'P420514173522819' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389997'
                WHERE ordernumber = 'P180514174036592' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389998'
                WHERE ordernumber = 'P180514174314190' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385765'
                WHERE ordernumber = 'P630514174604551' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390000'
                WHERE ordernumber = 'P180514175402614' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390001'
                WHERE ordernumber = 'P190514175559589' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390002'
                WHERE ordernumber = 'P200514180342836' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P420514180428680' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310329'
                WHERE ordernumber = 'P180514180612285' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262503'
                WHERE ordernumber = 'P180514180857291' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386511'
                WHERE ordernumber = 'P200514181710266' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346631'
                WHERE ordernumber = 'P200514181834399' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '34045'
                WHERE ordernumber = 'P200514182802541' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390004'
                WHERE ordernumber = 'P790514182808879' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343406'
                WHERE ordernumber = 'P180514182818815' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248048'
                WHERE ordernumber = 'P180514183221925' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390005'
                WHERE ordernumber = 'P200514184237951' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P180514184553920' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390006'
                WHERE ordernumber = 'P190514184931616' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390007'
                WHERE ordernumber = 'P190514185337254' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274723'
                WHERE ordernumber = 'P190514185449876' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390008'
                WHERE ordernumber = 'P190514185623234' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384063'
                WHERE ordernumber = 'P190514185802895' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P190514185843344' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385995'
                WHERE ordernumber = 'P420514190118118' 
            
2024-05-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390010'
                WHERE ordernumber = 'P790514191247573' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334506'
                WHERE ordernumber = 'P420514191752506' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390011'
                WHERE ordernumber = 'P790514191805597' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390015'
                WHERE ordernumber = 'P190514193606599' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240424'
                WHERE ordernumber = 'P200514193651578' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390016'
                WHERE ordernumber = 'P200514194728490' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '162397'
                WHERE ordernumber = 'P190514194948598' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341940'
                WHERE ordernumber = 'P190514195037554' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348316'
                WHERE ordernumber = 'P200514195239443' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24804'
                WHERE ordernumber = 'P630514200934308' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390018'
                WHERE ordernumber = 'P790514201931646' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390019'
                WHERE ordernumber = 'P790514202339541' 
            
2024-05-15 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390022'
                WHERE ordernumber = 'P790514211752556'