2023-12-12 01:00:03 -- 將會員中心id寫入data-lake
2023-12-12 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2023-12-11%';
        
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351806'
                WHERE ordernumber = 'P201211110113648' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113555'
                WHERE ordernumber = 'P191211110625660' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312010'
                WHERE ordernumber = 'P191211110745309' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351808'
                WHERE ordernumber = 'P191211110939593' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351809'
                WHERE ordernumber = 'P191211111151343' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351812'
                WHERE ordernumber = 'P201211111827629' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P201211112012206' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351813'
                WHERE ordernumber = 'P191211112101762' 
            
2023-12-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '188976'
                WHERE ordernumber = 'P191211112320510' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308636'
                WHERE ordernumber = 'P201211112321763' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104695'
                WHERE ordernumber = 'P191211112356548' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347999'
                WHERE ordernumber = 'P181211112857945' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '145853'
                WHERE ordernumber = 'P421211113340737' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351816'
                WHERE ordernumber = 'P181211113616426' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343932'
                WHERE ordernumber = 'P181211113659524' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351818'
                WHERE ordernumber = 'P201211113904810' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351819'
                WHERE ordernumber = 'P201211114057295' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207992'
                WHERE ordernumber = 'P191211120309774' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191211120507139' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268071'
                WHERE ordernumber = 'P181211120627943' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318424'
                WHERE ordernumber = 'P181211120735786' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P201211121845847' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351827'
                WHERE ordernumber = 'P181211122250280' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114398'
                WHERE ordernumber = 'P181211122610289' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30702'
                WHERE ordernumber = 'P201211122638159' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289545'
                WHERE ordernumber = 'P201211122805705' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P421211123431357' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314923'
                WHERE ordernumber = 'P181211123625912' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351829'
                WHERE ordernumber = 'P181211123903457' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351830'
                WHERE ordernumber = 'P181211124103926' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277918'
                WHERE ordernumber = 'P191211124410541' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351830'
                WHERE ordernumber = 'P181211124502539' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351831'
                WHERE ordernumber = 'P191211124528691' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351832'
                WHERE ordernumber = 'P201211124635226' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267870'
                WHERE ordernumber = 'P201211124900253' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351833'
                WHERE ordernumber = 'P181211125650826' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247610'
                WHERE ordernumber = 'P201211130120267' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305291'
                WHERE ordernumber = 'P181211130206796' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346316'
                WHERE ordernumber = 'P181211130509689' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351790'
                WHERE ordernumber = 'P421211130624614' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351835'
                WHERE ordernumber = 'P181211131039609' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339750'
                WHERE ordernumber = 'P181211131430393' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268816'
                WHERE ordernumber = 'P201211132123255' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324736'
                WHERE ordernumber = 'P181211132201371' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351837'
                WHERE ordernumber = 'P181211132242582' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '2690'
                WHERE ordernumber = 'P201211132504506' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299725'
                WHERE ordernumber = 'P201211132605834' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P421211132638461' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93916'
                WHERE ordernumber = 'P201211132837450' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351520'
                WHERE ordernumber = 'P181211132941971' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347027'
                WHERE ordernumber = 'P181211132959258' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351520'
                WHERE ordernumber = 'P181211133018459' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351839'
                WHERE ordernumber = 'P181211133918863' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351840'
                WHERE ordernumber = 'P181211134101590' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215784'
                WHERE ordernumber = 'P191211134102742' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351539'
                WHERE ordernumber = 'P181211134201265' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P201211134604240' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351841'
                WHERE ordernumber = 'P181211134652654' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91679'
                WHERE ordernumber = 'P201211134718181' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351842'
                WHERE ordernumber = 'P181211134832182' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241124'
                WHERE ordernumber = 'P191211134844181' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351843'
                WHERE ordernumber = 'P421211134935930' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351844'
                WHERE ordernumber = 'P191211135005656' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303385'
                WHERE ordernumber = 'P191211135100665' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302812'
                WHERE ordernumber = 'P201211135943781' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100813'
                WHERE ordernumber = 'P201211140314685' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351847'
                WHERE ordernumber = 'P181211141058560' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351849'
                WHERE ordernumber = 'P421211141239139' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351848'
                WHERE ordernumber = 'P181211141304259' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351850'
                WHERE ordernumber = 'P191211141436359' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351851'
                WHERE ordernumber = 'P191211141611645' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351853'
                WHERE ordernumber = 'P191211141717525' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248591'
                WHERE ordernumber = 'P201211142049533' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258017'
                WHERE ordernumber = 'P181211142501429' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351857'
                WHERE ordernumber = 'P181211143550333' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351857'
                WHERE ordernumber = 'P181211143635499' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351857'
                WHERE ordernumber = 'P181211143735169' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351859'
                WHERE ordernumber = 'P191211144341790' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351858'
                WHERE ordernumber = 'P191211144526706' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259262'
                WHERE ordernumber = 'P201211144629273' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351860'
                WHERE ordernumber = 'P191211144850309' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351861'
                WHERE ordernumber = 'P191211145015478' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351862'
                WHERE ordernumber = 'P181211145829398' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351864'
                WHERE ordernumber = 'P181211145958669' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351865'
                WHERE ordernumber = 'P181211150148873' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227610'
                WHERE ordernumber = 'P181211150634818' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351869'
                WHERE ordernumber = 'P201211152002266' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347187'
                WHERE ordernumber = 'P201211152340389' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351871'
                WHERE ordernumber = 'P201211152518812' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351873'
                WHERE ordernumber = 'P201211152601197' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351872'
                WHERE ordernumber = 'P181211152603457' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167899'
                WHERE ordernumber = 'P201211152639801' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351874'
                WHERE ordernumber = 'P181211152835783' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299746'
                WHERE ordernumber = 'P181211153607563' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351880'
                WHERE ordernumber = 'P201211154514951' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P181211154750933' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351881'
                WHERE ordernumber = 'P181211155122695' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96100'
                WHERE ordernumber = 'P181211155157497' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351882'
                WHERE ordernumber = 'P181211155301662' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220499'
                WHERE ordernumber = 'P181211155334683' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351884'
                WHERE ordernumber = 'P201211155354959' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351886'
                WHERE ordernumber = 'P201211160211400' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351887'
                WHERE ordernumber = 'P201211160418113' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P181211160438150' 
            
2023-12-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351888'
                WHERE ordernumber = 'P201211160606755' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81402'
                WHERE ordernumber = 'P181211160606248' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351885'
                WHERE ordernumber = 'P181211160745588' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351885'
                WHERE ordernumber = 'P181211160821825' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141799'
                WHERE ordernumber = 'P201211160916851' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351891'
                WHERE ordernumber = 'P181211161659885' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351892'
                WHERE ordernumber = 'P181211161853478' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351894'
                WHERE ordernumber = 'P181211162005231' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343221'
                WHERE ordernumber = 'P421211162008477' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237023'
                WHERE ordernumber = 'P201211162020426' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '53157'
                WHERE ordernumber = 'P181211162139626' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351896'
                WHERE ordernumber = 'P181211162528790' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351897'
                WHERE ordernumber = 'P181211162744489' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '88072'
                WHERE ordernumber = 'P181211162908869' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351898'
                WHERE ordernumber = 'P201211162918432' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349405'
                WHERE ordernumber = 'P421211163035943' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351899'
                WHERE ordernumber = 'P181211163036620' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349405'
                WHERE ordernumber = 'P421211163136891' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105553'
                WHERE ordernumber = 'P181211163206479' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350335'
                WHERE ordernumber = 'P201211163207659' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P181211163554847' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302260'
                WHERE ordernumber = 'P181211164645544' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85226'
                WHERE ordernumber = 'P201211171535521' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261978'
                WHERE ordernumber = 'P201211171857563' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351905'
                WHERE ordernumber = 'P201211172220721' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351906'
                WHERE ordernumber = 'P201211172539865' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351907'
                WHERE ordernumber = 'P201211172704973' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351908'
                WHERE ordernumber = 'P201211173042628' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95813'
                WHERE ordernumber = 'P201211173427325' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351910'
                WHERE ordernumber = 'P421211175155946' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221993'
                WHERE ordernumber = 'P191211175901925' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351913'
                WHERE ordernumber = 'P201211180007859' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351914'
                WHERE ordernumber = 'P181211180037889' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351915'
                WHERE ordernumber = 'P181211180628157' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273711'
                WHERE ordernumber = 'P201211180802833' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336454'
                WHERE ordernumber = 'P201211180912189' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351916'
                WHERE ordernumber = 'P191211180949710' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351917'
                WHERE ordernumber = 'P201211181303380' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351915'
                WHERE ordernumber = 'P181211181335731' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P191211181354404' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303547'
                WHERE ordernumber = 'P191211181648575' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351918'
                WHERE ordernumber = 'P421211181708858' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254413'
                WHERE ordernumber = 'P181211181726681' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351918'
                WHERE ordernumber = 'P421211181755640' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321300'
                WHERE ordernumber = 'P201211181817250' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '221027'
                WHERE ordernumber = 'P421211181846839' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351919'
                WHERE ordernumber = 'P191211181928372' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351920'
                WHERE ordernumber = 'P181211182722974' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '265717'
                WHERE ordernumber = 'P181211182819636' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351922'
                WHERE ordernumber = 'P421211183616113' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324301'
                WHERE ordernumber = 'P201211183655556' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '317431'
                WHERE ordernumber = 'P181211183724803' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351924'
                WHERE ordernumber = 'P201211184747181' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336480'
                WHERE ordernumber = 'P421211184844132' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315104'
                WHERE ordernumber = 'P191211185108632' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '160748'
                WHERE ordernumber = 'P201211185200282' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351926'
                WHERE ordernumber = 'P191211185456340' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351927'
                WHERE ordernumber = 'P191211185912735' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343224'
                WHERE ordernumber = 'P201211185921129' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351928'
                WHERE ordernumber = 'P421211185936606' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351929'
                WHERE ordernumber = 'P191211190040524' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '104586'
                WHERE ordernumber = 'P201211190945996' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343224'
                WHERE ordernumber = 'P201211191249479' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341866'
                WHERE ordernumber = 'P201211191450979' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351930'
                WHERE ordernumber = 'P201211191721384' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351932'
                WHERE ordernumber = 'P201211192115797' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351933'
                WHERE ordernumber = 'P201211192254539' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324342'
                WHERE ordernumber = 'P191211193001332' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294187'
                WHERE ordernumber = 'P421211193039189' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351935'
                WHERE ordernumber = 'P421211193927578' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312181'
                WHERE ordernumber = 'P201211194020925' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101791'
                WHERE ordernumber = 'P201211194132475' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302604'
                WHERE ordernumber = 'P191211194237814' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336063'
                WHERE ordernumber = 'P191211194344937' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236030'
                WHERE ordernumber = 'P201211194524740' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351879'
                WHERE ordernumber = 'P201211194609446' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350098'
                WHERE ordernumber = 'P201211195241922' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351937'
                WHERE ordernumber = 'P201211195323533' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '262063'
                WHERE ordernumber = 'P201211195429608' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348965'
                WHERE ordernumber = 'P191211195638875' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348965'
                WHERE ordernumber = 'P191211195714714' 
            
2023-12-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351939'
                WHERE ordernumber = 'P191211200011773'