2024-04-23 01:00:02 -- 將會員中心id寫入data-lake
2024-04-23 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-04-22%';
        
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339493'
                WHERE ordernumber = 'P630422100927429' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339493'
                WHERE ordernumber = 'P630422103411607' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386543'
                WHERE ordernumber = 'P630422105939152' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386545'
                WHERE ordernumber = 'P180422110404344' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376562'
                WHERE ordernumber = 'P180422110829944' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386547'
                WHERE ordernumber = 'P180422110958769' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P180422111041711' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340442'
                WHERE ordernumber = 'P180422111951633' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362393'
                WHERE ordernumber = 'P420422112019525' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362393'
                WHERE ordernumber = 'P420422112320815' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386548'
                WHERE ordernumber = 'P180422112723639' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96307'
                WHERE ordernumber = 'P180422112802620' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269555'
                WHERE ordernumber = 'P200422113053254' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386549'
                WHERE ordernumber = 'P180422113151632' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279764'
                WHERE ordernumber = 'P200422113226349' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378451'
                WHERE ordernumber = 'P180422113240504' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282132'
                WHERE ordernumber = 'P630422113402148' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322971'
                WHERE ordernumber = 'P180422113818796' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386550'
                WHERE ordernumber = 'P590422114140412' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386551'
                WHERE ordernumber = 'P180422114333267' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386551'
                WHERE ordernumber = 'P180422114409840' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386552'
                WHERE ordernumber = 'P190422115127778' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386553'
                WHERE ordernumber = 'P420422115427165' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386555'
                WHERE ordernumber = 'P180422120420151' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371641'
                WHERE ordernumber = 'P200422120836916' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386556'
                WHERE ordernumber = 'P180422121214265' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386256'
                WHERE ordernumber = 'P420422121654834' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386557'
                WHERE ordernumber = 'P200422121817222' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386559'
                WHERE ordernumber = 'P180422121852636' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386558'
                WHERE ordernumber = 'P420422122256482' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386521'
                WHERE ordernumber = 'P200422122423320' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386561'
                WHERE ordernumber = 'P420422122605545' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386563'
                WHERE ordernumber = 'P180422123244360' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386564'
                WHERE ordernumber = 'P180422123457632' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420422123559191' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P180422123631421' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386565'
                WHERE ordernumber = 'P200422123757266' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386567'
                WHERE ordernumber = 'P420422123957646' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107391'
                WHERE ordernumber = 'P180422124400248' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96621'
                WHERE ordernumber = 'P180422124711499' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100186'
                WHERE ordernumber = 'P180422125008998' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386567'
                WHERE ordernumber = 'P420422125324194' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266126'
                WHERE ordernumber = 'P180422125417906' 
            
2024-04-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386567'
                WHERE ordernumber = 'P420422125451581' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68503'
                WHERE ordernumber = 'P180422125748498' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '68503'
                WHERE ordernumber = 'P180422125837478' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136526'
                WHERE ordernumber = 'P200422130010989' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420422130552855' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347214'
                WHERE ordernumber = 'P180422130856678' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380098'
                WHERE ordernumber = 'P200422131233582' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166417'
                WHERE ordernumber = 'P190422132029514' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348811'
                WHERE ordernumber = 'P180422132310664' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200422132459918' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386569'
                WHERE ordernumber = 'P180422132720421' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336162'
                WHERE ordernumber = 'P420422132808251' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386568'
                WHERE ordernumber = 'P180422133004394' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386568'
                WHERE ordernumber = 'P180422133110383' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386570'
                WHERE ordernumber = 'P200422134247454' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '20905'
                WHERE ordernumber = 'P180422134307193' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386571'
                WHERE ordernumber = 'P420422134547970' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385076'
                WHERE ordernumber = 'P200422134604655' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386573'
                WHERE ordernumber = 'P180422134619334' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386574'
                WHERE ordernumber = 'P200422135256756' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385841'
                WHERE ordernumber = 'P200422135340808' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242791'
                WHERE ordernumber = 'P190422135854180' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386575'
                WHERE ordernumber = 'P190422140717545' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162224'
                WHERE ordernumber = 'P200422140813350' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386576'
                WHERE ordernumber = 'P420422141010136' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386577'
                WHERE ordernumber = 'P630422141115746' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386578'
                WHERE ordernumber = 'P190422141437740' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115120'
                WHERE ordernumber = 'P200422142130892' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141536'
                WHERE ordernumber = 'P180422143120162' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200422143201753' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386580'
                WHERE ordernumber = 'P180422143347993' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305740'
                WHERE ordernumber = 'P200422144519937' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279534'
                WHERE ordernumber = 'P200422144723286' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386581'
                WHERE ordernumber = 'P420422144741283' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212334'
                WHERE ordernumber = 'P180422144910969' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386583'
                WHERE ordernumber = 'P420422145323335' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420422145615431' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97561'
                WHERE ordernumber = 'P200422150711708' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P180422151214888' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165627'
                WHERE ordernumber = 'P200422151349802' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233558'
                WHERE ordernumber = 'P180422151629841' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P190422151719291' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282309'
                WHERE ordernumber = 'P180422152241537' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335347'
                WHERE ordernumber = 'P200422152550778' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '11177'
                WHERE ordernumber = 'P180422153048238' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386587'
                WHERE ordernumber = 'P180422153235383' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386589'
                WHERE ordernumber = 'P180422153414817' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386588'
                WHERE ordernumber = 'P190422153548811' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386590'
                WHERE ordernumber = 'P180422153807288' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386591'
                WHERE ordernumber = 'P420422153957344' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386593'
                WHERE ordernumber = 'P420422154257308' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386594'
                WHERE ordernumber = 'P200422154320191' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P200422154347905' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P180422155149799' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162043'
                WHERE ordernumber = 'P180422155426788' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234548'
                WHERE ordernumber = 'P420422155615278' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386595'
                WHERE ordernumber = 'P200422155700496' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304095'
                WHERE ordernumber = 'P180422160107715' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386597'
                WHERE ordernumber = 'P200422160749513' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386598'
                WHERE ordernumber = 'P180422161440341' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295145'
                WHERE ordernumber = 'P180422161547554' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233407'
                WHERE ordernumber = 'P200422161719161' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244053'
                WHERE ordernumber = 'P180422161900360' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386599'
                WHERE ordernumber = 'P590422162003584' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266299'
                WHERE ordernumber = 'P180422162405691' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386602'
                WHERE ordernumber = 'P630422163455788' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244201'
                WHERE ordernumber = 'P200422163823694' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386603'
                WHERE ordernumber = 'P200422164147746' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P590422164934971' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244090'
                WHERE ordernumber = 'P180422165028938' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386606'
                WHERE ordernumber = 'P180422165742162' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382763'
                WHERE ordernumber = 'P180422170809541' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386608'
                WHERE ordernumber = 'P630422171923969' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384251'
                WHERE ordernumber = 'P180422171929125' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348578'
                WHERE ordernumber = 'P180422172119249' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386607'
                WHERE ordernumber = 'P590422172539777' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386600'
                WHERE ordernumber = 'P180422173325408' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386611'
                WHERE ordernumber = 'P180422173748301' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349243'
                WHERE ordernumber = 'P420422174130286' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386609'
                WHERE ordernumber = 'P180422174157633' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349243'
                WHERE ordernumber = 'P420422174256136' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P180422174514564' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386612'
                WHERE ordernumber = 'P200422174948909' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386613'
                WHERE ordernumber = 'P200422175125809' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364693'
                WHERE ordernumber = 'P200422175218440' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385780'
                WHERE ordernumber = 'P180422175314292' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73891'
                WHERE ordernumber = 'P180422175427327' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146915'
                WHERE ordernumber = 'P180422175520242' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386615'
                WHERE ordernumber = 'P590422180240512' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386616'
                WHERE ordernumber = 'P180422180250760' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386617'
                WHERE ordernumber = 'P180422180349113' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386618'
                WHERE ordernumber = 'P180422180445675' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386620'
                WHERE ordernumber = 'P180422181258236' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P200422181524923' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386621'
                WHERE ordernumber = 'P180422181705998' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386619'
                WHERE ordernumber = 'P200422182059901' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100279'
                WHERE ordernumber = 'P180422182248810' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353559'
                WHERE ordernumber = 'P180422182805827' 
            
2024-04-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81134'
                WHERE ordernumber = 'P180422182855119' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386623'
                WHERE ordernumber = 'P180422183115114' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386624'
                WHERE ordernumber = 'P180422183605450' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386625'
                WHERE ordernumber = 'P180422184154189' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237565'
                WHERE ordernumber = 'P630422184841915' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P190422185351822' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386630'
                WHERE ordernumber = 'P420422185526471' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386629'
                WHERE ordernumber = 'P200422185552158' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386632'
                WHERE ordernumber = 'P200422190147652' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386633'
                WHERE ordernumber = 'P420422190259327' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '224298'
                WHERE ordernumber = 'P420422190448391' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386634'
                WHERE ordernumber = 'P190422190529251' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386586'
                WHERE ordernumber = 'P190422190729842' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241196'
                WHERE ordernumber = 'P190422190858138' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P200422191451118' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287382'
                WHERE ordernumber = 'P200422191528712' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386637'
                WHERE ordernumber = 'P190422191602595' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386638'
                WHERE ordernumber = 'P190422191752728' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384981'
                WHERE ordernumber = 'P200422191840637' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386639'
                WHERE ordernumber = 'P190422192020843' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '177894'
                WHERE ordernumber = 'P420422192310780' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275423'
                WHERE ordernumber = 'P190422193952825' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386640'
                WHERE ordernumber = 'P200422194308451' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386641'
                WHERE ordernumber = 'P200422194629167' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386643'
                WHERE ordernumber = 'P420422194709706' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386642'
                WHERE ordernumber = 'P200422194748401' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386644'
                WHERE ordernumber = 'P590422195539239' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386647'
                WHERE ordernumber = 'P420422200048931' 
            
2024-04-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386431'
                WHERE ordernumber = 'P590422201533308'