2024-04-01 01:00:02 -- 將會員中心id寫入data-lake
2024-04-01 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-03-31%';
        
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352817'
                WHERE ordernumber = 'P420331102212713' 
            
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383839'
                WHERE ordernumber = 'P420331102740826' 
            
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332912'
                WHERE ordernumber = 'P200331110607310' 
            
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383844'
                WHERE ordernumber = 'P420331110832305' 
            
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383845'
                WHERE ordernumber = 'P180331110908413' 
            
2024-04-01 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168434'
                WHERE ordernumber = 'P200331110926596' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362264'
                WHERE ordernumber = 'P180331111443481' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383847'
                WHERE ordernumber = 'P420331111502753' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245558'
                WHERE ordernumber = 'P420331111530880' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383848'
                WHERE ordernumber = 'P180331112253120' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95033'
                WHERE ordernumber = 'P200331112321944' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383849'
                WHERE ordernumber = 'P180331112647301' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P420331113208973' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383853'
                WHERE ordernumber = 'P420331113333143' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383717'
                WHERE ordernumber = 'P190331113348145' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290301'
                WHERE ordernumber = 'P200331113402808' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270511'
                WHERE ordernumber = 'P420331113516391' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383855'
                WHERE ordernumber = 'P180331113711356' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P200331113913331' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383856'
                WHERE ordernumber = 'P180331113938426' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383857'
                WHERE ordernumber = 'P180331114042781' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383857'
                WHERE ordernumber = 'P180331114129130' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352098'
                WHERE ordernumber = 'P180331114617463' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383858'
                WHERE ordernumber = 'P180331114812789' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244638'
                WHERE ordernumber = 'P190331115209731' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383859'
                WHERE ordernumber = 'P180331115300896' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127024'
                WHERE ordernumber = 'P190331115702308' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383860'
                WHERE ordernumber = 'P200331115707583' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106026'
                WHERE ordernumber = 'P180331115806585' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320964'
                WHERE ordernumber = 'P190331115809746' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106026'
                WHERE ordernumber = 'P180331115855589' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383861'
                WHERE ordernumber = 'P200331120035323' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112587'
                WHERE ordernumber = 'P180331120144957' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P180331120508532' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220513'
                WHERE ordernumber = 'P180331120630286' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235265'
                WHERE ordernumber = 'P200331120806660' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287796'
                WHERE ordernumber = 'P200331121026446' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211993'
                WHERE ordernumber = 'P590331121131626' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383862'
                WHERE ordernumber = 'P180331121244350' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220513'
                WHERE ordernumber = 'P180331121823939' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343518'
                WHERE ordernumber = 'P420331121849824' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265962'
                WHERE ordernumber = 'P190331121927439' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383863'
                WHERE ordernumber = 'P200331122653258' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382685'
                WHERE ordernumber = 'P420331122925551' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129070'
                WHERE ordernumber = 'P180331123026240' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383653'
                WHERE ordernumber = 'P180331123134254' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383864'
                WHERE ordernumber = 'P200331123338606' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276745'
                WHERE ordernumber = 'P180331123907709' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383866'
                WHERE ordernumber = 'P420331124207117' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383867'
                WHERE ordernumber = 'P180331125829145' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383869'
                WHERE ordernumber = 'P200331130243797' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182128'
                WHERE ordernumber = 'P190331130410360' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383870'
                WHERE ordernumber = 'P420331130703353' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383872'
                WHERE ordernumber = 'P420331131322815' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383873'
                WHERE ordernumber = 'P200331131501179' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239761'
                WHERE ordernumber = 'P180331131532701' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284933'
                WHERE ordernumber = 'P180331131855373' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383875'
                WHERE ordernumber = 'P180331132141329' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137601'
                WHERE ordernumber = 'P200331132144158' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137601'
                WHERE ordernumber = 'P200331132150205' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383876'
                WHERE ordernumber = 'P180331132326606' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377832'
                WHERE ordernumber = 'P180331132543278' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383878'
                WHERE ordernumber = 'P190331132855959' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383879'
                WHERE ordernumber = 'P180331132915653' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277000'
                WHERE ordernumber = 'P180331133006117' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383274'
                WHERE ordernumber = 'P180331133605977' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282048'
                WHERE ordernumber = 'P200331133923697' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383880'
                WHERE ordernumber = 'P180331134402351' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383881'
                WHERE ordernumber = 'P200331134508913' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380928'
                WHERE ordernumber = 'P180331134552287' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383882'
                WHERE ordernumber = 'P180331134746907' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383883'
                WHERE ordernumber = 'P180331134845794' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383885'
                WHERE ordernumber = 'P180331134951213' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383886'
                WHERE ordernumber = 'P420331135203235' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382409'
                WHERE ordernumber = 'P420331135303297' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383887'
                WHERE ordernumber = 'P420331135519198' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383888'
                WHERE ordernumber = 'P180331135605476' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383889'
                WHERE ordernumber = 'P180331135844647' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355468'
                WHERE ordernumber = 'P180331135945775' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249384'
                WHERE ordernumber = 'P180331140107614' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380759'
                WHERE ordernumber = 'P200331140130323' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383786'
                WHERE ordernumber = 'P200331140238925' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383891'
                WHERE ordernumber = 'P180331140347720' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383892'
                WHERE ordernumber = 'P180331140656571' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269454'
                WHERE ordernumber = 'P200331141240223' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292465'
                WHERE ordernumber = 'P200331141341711' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325980'
                WHERE ordernumber = 'P180331141356155' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139189'
                WHERE ordernumber = 'P180331141447884' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383895'
                WHERE ordernumber = 'P200331141505135' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125468'
                WHERE ordernumber = 'P200331141654418' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383897'
                WHERE ordernumber = 'P190331142010256' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383898'
                WHERE ordernumber = 'P190331142152357' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241226'
                WHERE ordernumber = 'P180331142511373' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310940'
                WHERE ordernumber = 'P200331142539646' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200331142700804' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383900'
                WHERE ordernumber = 'P180331143307327' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383901'
                WHERE ordernumber = 'P190331143420335' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383902'
                WHERE ordernumber = 'P200331143805156' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222864'
                WHERE ordernumber = 'P180331143929445' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377694'
                WHERE ordernumber = 'P420331144000664' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '199012'
                WHERE ordernumber = 'P420331144119350' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383903'
                WHERE ordernumber = 'P180331144202943' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222864'
                WHERE ordernumber = 'P180331144237164' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383904'
                WHERE ordernumber = 'P190331144327984' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383905'
                WHERE ordernumber = 'P180331144410797' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383906'
                WHERE ordernumber = 'P180331144909704' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344955'
                WHERE ordernumber = 'P180331145018461' 
            
2024-04-01 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166170'
                WHERE ordernumber = 'P190331145125790' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285455'
                WHERE ordernumber = 'P200331145240196' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383907'
                WHERE ordernumber = 'P180331145250695' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383908'
                WHERE ordernumber = 'P420331145318192' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383906'
                WHERE ordernumber = 'P190331145353837' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383909'
                WHERE ordernumber = 'P200331145431646' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383911'
                WHERE ordernumber = 'P190331145822282' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283457'
                WHERE ordernumber = 'P190331145908753' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383912'
                WHERE ordernumber = 'P420331150029191' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285854'
                WHERE ordernumber = 'P200331150159908' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341038'
                WHERE ordernumber = 'P190331150837357' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383914'
                WHERE ordernumber = 'P420331151149978' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383915'
                WHERE ordernumber = 'P190331151449930' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P190331151606764' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383917'
                WHERE ordernumber = 'P590331151916700' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383920'
                WHERE ordernumber = 'P190331152234346' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279055'
                WHERE ordernumber = 'P190331152419748' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348119'
                WHERE ordernumber = 'P420331152818706' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383921'
                WHERE ordernumber = 'P190331152853431' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383922'
                WHERE ordernumber = 'P420331153138459' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383923'
                WHERE ordernumber = 'P200331153417289' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340163'
                WHERE ordernumber = 'P200331154343321' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383924'
                WHERE ordernumber = 'P180331154435362' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254447'
                WHERE ordernumber = 'P200331154856342' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383925'
                WHERE ordernumber = 'P180331155720783' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383927'
                WHERE ordernumber = 'P180331155914825' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383928'
                WHERE ordernumber = 'P420331155936720' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '43180'
                WHERE ordernumber = 'P200331155946358' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77886'
                WHERE ordernumber = 'P200331160013202' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383929'
                WHERE ordernumber = 'P190331160510958' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217941'
                WHERE ordernumber = 'P180331160625988' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383817'
                WHERE ordernumber = 'P200331161013274' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94486'
                WHERE ordernumber = 'P200331161117523' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383931'
                WHERE ordernumber = 'P180331161533152' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226416'
                WHERE ordernumber = 'P180331161622498' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267645'
                WHERE ordernumber = 'P420331161720150' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383932'
                WHERE ordernumber = 'P180331162131650' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383934'
                WHERE ordernumber = 'P180331162505590' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383933'
                WHERE ordernumber = 'P200331162509969' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143775'
                WHERE ordernumber = 'P420331162615903' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383935'
                WHERE ordernumber = 'P200331162836652' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383936'
                WHERE ordernumber = 'P180331162942324' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382627'
                WHERE ordernumber = 'P420331163235814' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230225'
                WHERE ordernumber = 'P180331164316981' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287227'
                WHERE ordernumber = 'P180331164401321' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383940'
                WHERE ordernumber = 'P420331165048212' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249472'
                WHERE ordernumber = 'P180331165434545' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383941'
                WHERE ordernumber = 'P420331165803609' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330898'
                WHERE ordernumber = 'P180331170008804' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383884'
                WHERE ordernumber = 'P420331170032610' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382400'
                WHERE ordernumber = 'P420331170430364' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164657'
                WHERE ordernumber = 'P180331170601381' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383943'
                WHERE ordernumber = 'P180331171057797' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180331171454597' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383945'
                WHERE ordernumber = 'P190331171556198' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375318'
                WHERE ordernumber = 'P180331171656645' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123569'
                WHERE ordernumber = 'P200331172523790' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371909'
                WHERE ordernumber = 'P180331172857751' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383948'
                WHERE ordernumber = 'P200331173335867' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382709'
                WHERE ordernumber = 'P200331173447483' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383950'
                WHERE ordernumber = 'P180331173537888' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383893'
                WHERE ordernumber = 'P180331173656589' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242508'
                WHERE ordernumber = 'P200331173738552' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283644'
                WHERE ordernumber = 'P180331174715793' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383953'
                WHERE ordernumber = 'P180331175025489' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110982'
                WHERE ordernumber = 'P180331175350177' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321974'
                WHERE ordernumber = 'P180331175539631' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93698'
                WHERE ordernumber = 'P200331175836441' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383955'
                WHERE ordernumber = 'P180331175930461' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382923'
                WHERE ordernumber = 'P180331180042996' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383956'
                WHERE ordernumber = 'P190331180114865' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383957'
                WHERE ordernumber = 'P190331180426414' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383959'
                WHERE ordernumber = 'P190331181229526' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383960'
                WHERE ordernumber = 'P190331181553954' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139005'
                WHERE ordernumber = 'P200331181835334' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355931'
                WHERE ordernumber = 'P190331182408204' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98009'
                WHERE ordernumber = 'P190331183134288' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200331183343685' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383961'
                WHERE ordernumber = 'P200331183705800' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374652'
                WHERE ordernumber = 'P190331185047135' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227393'
                WHERE ordernumber = 'P190331185700668' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383963'
                WHERE ordernumber = 'P420331190325464' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285899'
                WHERE ordernumber = 'P420331190537520' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118601'
                WHERE ordernumber = 'P190331190545646' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132149'
                WHERE ordernumber = 'P190331191121695' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233981'
                WHERE ordernumber = 'P200331192237264' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382973'
                WHERE ordernumber = 'P420331193800952' 
            
2024-04-01 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138374'
                WHERE ordernumber = 'P200331195136732'