2024-07-02 01:00:02 -- 將會員中心id寫入data-lake
2024-07-02 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-01%';
        
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163961'
                WHERE ordernumber = 'P200701110142825' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200701110315788' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278840'
                WHERE ordernumber = 'P180701110427122' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124407'
                WHERE ordernumber = 'P190701110540944' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399227'
                WHERE ordernumber = 'P420701110651322' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399227'
                WHERE ordernumber = 'P420701110954914' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389004'
                WHERE ordernumber = 'P180701111134189' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346212'
                WHERE ordernumber = 'P180701111420690' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P200701111505430' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318412'
                WHERE ordernumber = 'P420701112034999' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399230'
                WHERE ordernumber = 'P200701112127252' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389282'
                WHERE ordernumber = 'P200701112259837' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399231'
                WHERE ordernumber = 'P200701112355676' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342465'
                WHERE ordernumber = 'P180701112434304' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399232'
                WHERE ordernumber = 'P180701113129577' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383459'
                WHERE ordernumber = 'P180701113350751' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399234'
                WHERE ordernumber = 'P180701113541724' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399236'
                WHERE ordernumber = 'P190701113827519' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399237'
                WHERE ordernumber = 'P180701113847912' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112548'
                WHERE ordernumber = 'P180701114026437' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399109'
                WHERE ordernumber = 'P180701114119364' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265537'
                WHERE ordernumber = 'P200701114249986' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399238'
                WHERE ordernumber = 'P180701114337593' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399225'
                WHERE ordernumber = 'P180701114625787' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399239'
                WHERE ordernumber = 'P190701114710979' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343725'
                WHERE ordernumber = 'P200701115025831' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279917'
                WHERE ordernumber = 'P180701115118548' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399241'
                WHERE ordernumber = 'P180701115715913' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296836'
                WHERE ordernumber = 'P180701120216348' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305078'
                WHERE ordernumber = 'P190701120841376' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399244'
                WHERE ordernumber = 'P200701120923581' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337238'
                WHERE ordernumber = 'P420701121103634' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399245'
                WHERE ordernumber = 'P190701121149366' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399246'
                WHERE ordernumber = 'P420701121252535' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216569'
                WHERE ordernumber = 'P200701121625396' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362245'
                WHERE ordernumber = 'P180701121629331' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314822'
                WHERE ordernumber = 'P200701121732169' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104030'
                WHERE ordernumber = 'P200701122305435' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314759'
                WHERE ordernumber = 'P200701122814145' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132768'
                WHERE ordernumber = 'P200701123321376' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399218'
                WHERE ordernumber = 'P190701125037492' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338398'
                WHERE ordernumber = 'P180701125113406' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342877'
                WHERE ordernumber = 'P180701125904488' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96382'
                WHERE ordernumber = 'P180701130328834' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399250'
                WHERE ordernumber = 'P180701131348914' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286144'
                WHERE ordernumber = 'P180701131441500' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345000'
                WHERE ordernumber = 'P200701131602931' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180701131614804' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399251'
                WHERE ordernumber = 'P200701132112748' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399252'
                WHERE ordernumber = 'P200701132157771' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399253'
                WHERE ordernumber = 'P200701132504424' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219462'
                WHERE ordernumber = 'P200701132703144' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399254'
                WHERE ordernumber = 'P420701132851607' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302925'
                WHERE ordernumber = 'P180701132934175' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399257'
                WHERE ordernumber = 'P200701133613927' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200701133804735' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46390'
                WHERE ordernumber = 'P180701133838626' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399258'
                WHERE ordernumber = 'P180701134241185' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399259'
                WHERE ordernumber = 'P200701134756258' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399261'
                WHERE ordernumber = 'P200701135122409' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98293'
                WHERE ordernumber = 'P200701135454620' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420701140116678' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113555'
                WHERE ordernumber = 'P180701140235535' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420701140308377' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399262'
                WHERE ordernumber = 'P420701140825914' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180701141919462' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396403'
                WHERE ordernumber = 'P180701142234452' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247164'
                WHERE ordernumber = 'P200701142920361' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399265'
                WHERE ordernumber = 'P180701142924891' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '153152'
                WHERE ordernumber = 'P180701143604400' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208620'
                WHERE ordernumber = 'P180701143717446' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399267'
                WHERE ordernumber = 'P420701143854879' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399269'
                WHERE ordernumber = 'P180701144717358' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395239'
                WHERE ordernumber = 'P180701145706330' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399271'
                WHERE ordernumber = 'P180701150730168' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312010'
                WHERE ordernumber = 'P180701151302951' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315226'
                WHERE ordernumber = 'P420701151855513' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399274'
                WHERE ordernumber = 'P180701152241783' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397844'
                WHERE ordernumber = 'P190701152347955' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390356'
                WHERE ordernumber = 'P200701152510646' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118752'
                WHERE ordernumber = 'P190701152647120' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236923'
                WHERE ordernumber = 'P180701152713908' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399248'
                WHERE ordernumber = 'P190701153115385' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398475'
                WHERE ordernumber = 'P420701153644733' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399275'
                WHERE ordernumber = 'P420701153921921' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380107'
                WHERE ordernumber = 'P180701154103497' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399276'
                WHERE ordernumber = 'P180701154239382' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275457'
                WHERE ordernumber = 'P180701154611209' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137091'
                WHERE ordernumber = 'P180701154904517' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399278'
                WHERE ordernumber = 'P180701155831135' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317700'
                WHERE ordernumber = 'P190701155843479' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399279'
                WHERE ordernumber = 'P420701155932792' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399280'
                WHERE ordernumber = 'P420701160335446' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389556'
                WHERE ordernumber = 'P200701160816222' 
            
2024-07-02 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399282'
                WHERE ordernumber = 'P200701161501434' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '7087'
                WHERE ordernumber = 'P190701161544161' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380001'
                WHERE ordernumber = 'P200701162002559' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396508'
                WHERE ordernumber = 'P180701162629204' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310147'
                WHERE ordernumber = 'P180701162950282' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399283'
                WHERE ordernumber = 'P200701163258834' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399284'
                WHERE ordernumber = 'P180701163554328' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399285'
                WHERE ordernumber = 'P420701163813467' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399286'
                WHERE ordernumber = 'P180701163818248' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399287'
                WHERE ordernumber = 'P180701164051477' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399010'
                WHERE ordernumber = 'P200701164508536' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399288'
                WHERE ordernumber = 'P200701164554504' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399289'
                WHERE ordernumber = 'P180701164628420' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398833'
                WHERE ordernumber = 'P180701165807685' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398833'
                WHERE ordernumber = 'P180701165918786' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137430'
                WHERE ordernumber = 'P200701170016549' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399290'
                WHERE ordernumber = 'P190701170248350' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P180701170430347' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322456'
                WHERE ordernumber = 'P200701171554359' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389701'
                WHERE ordernumber = 'P200701171641965' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399293'
                WHERE ordernumber = 'P180701172139469' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399294'
                WHERE ordernumber = 'P200701172532749' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399295'
                WHERE ordernumber = 'P420701172810442' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399297'
                WHERE ordernumber = 'P420701172953353' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399298'
                WHERE ordernumber = 'P420701173156132' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399299'
                WHERE ordernumber = 'P420701173342301' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75710'
                WHERE ordernumber = 'P200701173408344' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313776'
                WHERE ordernumber = 'P180701174512177' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389710'
                WHERE ordernumber = 'P420701174522621' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217015'
                WHERE ordernumber = 'P180701174759812' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397239'
                WHERE ordernumber = 'P180701174957588' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390980'
                WHERE ordernumber = 'P420701175357564' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399301'
                WHERE ordernumber = 'P420701180002714' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399302'
                WHERE ordernumber = 'P200701180152791' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226971'
                WHERE ordernumber = 'P180701180348239' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399303'
                WHERE ordernumber = 'P180701180751660' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399304'
                WHERE ordernumber = 'P180701181412709' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399305'
                WHERE ordernumber = 'P190701181608342' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109723'
                WHERE ordernumber = 'P200701182145580' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399229'
                WHERE ordernumber = 'P420701182202896' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398641'
                WHERE ordernumber = 'P630701182251417' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399229'
                WHERE ordernumber = 'P420701182714879' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P200701183204423' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P190701183227570' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P420701183820600' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399309'
                WHERE ordernumber = 'P180701184000409' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85675'
                WHERE ordernumber = 'P200701184220840' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316248'
                WHERE ordernumber = 'P190701185044417' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398521'
                WHERE ordernumber = 'P190701185327144' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399311'
                WHERE ordernumber = 'P190701190530550' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399312'
                WHERE ordernumber = 'P190701190852706' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P200701191646886' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P590701191751348' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399313'
                WHERE ordernumber = 'P190701191819956' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399314'
                WHERE ordernumber = 'P200701192503670' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399316'
                WHERE ordernumber = 'P200701192945249' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399317'
                WHERE ordernumber = 'P190701193005586' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P190701193524443' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393804'
                WHERE ordernumber = 'P200701194500542' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399318'
                WHERE ordernumber = 'P190701194840763' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399319'
                WHERE ordernumber = 'P190701195414745' 
            
2024-07-02 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235865'
                WHERE ordernumber = 'P630701215737870'