2024-12-19 01:00:01 -- 將會員中心id寫入data-lake
2024-12-19 01:00:01 -- 
            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-12-18%';
        
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P2412180000173' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354018'
                WHERE ordernumber = 'P2412180000299' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436776'
                WHERE ordernumber = 'P2412180000778' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436777'
                WHERE ordernumber = 'P2412180000924' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '52467'
                WHERE ordernumber = 'P2412180001012' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436778'
                WHERE ordernumber = 'P2412180001111' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436534'
                WHERE ordernumber = 'P2412180001262' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155223'
                WHERE ordernumber = 'P2412180001474' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207000'
                WHERE ordernumber = 'P2412180001681' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279863'
                WHERE ordernumber = 'P2412180001764' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326368'
                WHERE ordernumber = 'P2412180001935' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435325'
                WHERE ordernumber = 'P2412180002058' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386561'
                WHERE ordernumber = 'P2412180002190' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '265257'
                WHERE ordernumber = 'P2412180002247' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435325'
                WHERE ordernumber = 'P2412180002449' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436785'
                WHERE ordernumber = 'P2412180002580' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401001'
                WHERE ordernumber = 'P2412180002648' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326368'
                WHERE ordernumber = 'P2412180002783' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142556'
                WHERE ordernumber = 'P2412180002966' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436786'
                WHERE ordernumber = 'P2412180003155' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142556'
                WHERE ordernumber = 'P2412180003227' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338504'
                WHERE ordernumber = 'P2412180003418' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246892'
                WHERE ordernumber = 'P2412180003525' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '292417'
                WHERE ordernumber = 'P2412180003768' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430049'
                WHERE ordernumber = 'P2412180003870' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264596'
                WHERE ordernumber = 'P2412180004055' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436791'
                WHERE ordernumber = 'P2412180004552' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392812'
                WHERE ordernumber = 'P2412180004662' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436793'
                WHERE ordernumber = 'P2412180004738' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2412180004818' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222507'
                WHERE ordernumber = 'P2412180004942' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170787'
                WHERE ordernumber = 'P2412180005019' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418787'
                WHERE ordernumber = 'P2412180005234' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436797'
                WHERE ordernumber = 'P2412180005373' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380672'
                WHERE ordernumber = 'P2412180005422' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436749'
                WHERE ordernumber = 'P2412180005857' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363084'
                WHERE ordernumber = 'P2412180005928' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436749'
                WHERE ordernumber = 'P2412180006041' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347639'
                WHERE ordernumber = 'P2412180006144' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436513'
                WHERE ordernumber = 'P2412180006244' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211737'
                WHERE ordernumber = 'P2412180006391' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436801'
                WHERE ordernumber = 'P2412180006424' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436803'
                WHERE ordernumber = 'P2412180006571' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436804'
                WHERE ordernumber = 'P2412180006698' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293506'
                WHERE ordernumber = 'P2412180006832' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436802'
                WHERE ordernumber = 'P2412180007083' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425023'
                WHERE ordernumber = 'P2412180007124' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304835'
                WHERE ordernumber = 'P2412180007280' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355172'
                WHERE ordernumber = 'P2412180007351' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293506'
                WHERE ordernumber = 'P2412180007473' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436805'
                WHERE ordernumber = 'P2412180007581' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '70452'
                WHERE ordernumber = 'P2412180007610' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268585'
                WHERE ordernumber = 'P2412180007779' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436806'
                WHERE ordernumber = 'P2412180007899' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432977'
                WHERE ordernumber = 'P2412180008096' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287854'
                WHERE ordernumber = 'P2412180008230' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P2412180008345' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435573'
                WHERE ordernumber = 'P2412180008439' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '48124'
                WHERE ordernumber = 'P2412180008923' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436813'
                WHERE ordernumber = 'P2412180009073' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P2412180009233' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436814'
                WHERE ordernumber = 'P2412180009346' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281238'
                WHERE ordernumber = 'P2412180009469' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436816'
                WHERE ordernumber = 'P2412180009685' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433460'
                WHERE ordernumber = 'P2412180009849' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436818'
                WHERE ordernumber = 'P2412180009980' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244101'
                WHERE ordernumber = 'P2412180010013' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436819'
                WHERE ordernumber = 'P2412180010155' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436817'
                WHERE ordernumber = 'P2412180010280' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412180010319' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436820'
                WHERE ordernumber = 'P2412180010431' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107286'
                WHERE ordernumber = 'P2412180010834' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436821'
                WHERE ordernumber = 'P2412180010963' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266171'
                WHERE ordernumber = 'P2412180011159' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397234'
                WHERE ordernumber = 'P2412180011260' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436823'
                WHERE ordernumber = 'P2412180011337' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436826'
                WHERE ordernumber = 'P2412180011417' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436827'
                WHERE ordernumber = 'P2412180011547' 
            
2024-12-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436827'
                WHERE ordernumber = 'P2412180011639' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436827'
                WHERE ordernumber = 'P2412180011737' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380341'
                WHERE ordernumber = 'P2412180011833' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436832'
                WHERE ordernumber = 'P2412180012286' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436831'
                WHERE ordernumber = 'P2412180012333' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113510'
                WHERE ordernumber = 'P2412180012491' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436833'
                WHERE ordernumber = 'P2412180012755' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108747'
                WHERE ordernumber = 'P2412180013030' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367291'
                WHERE ordernumber = 'P2412180013232' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436835'
                WHERE ordernumber = 'P2412180013326' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180013498' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436841'
                WHERE ordernumber = 'P2412180013582' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421450'
                WHERE ordernumber = 'P2412180013741' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433369'
                WHERE ordernumber = 'P2412180013929' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436847'
                WHERE ordernumber = 'P2412180014080' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271216'
                WHERE ordernumber = 'P2412180014170' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436849'
                WHERE ordernumber = 'P2412180014216' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98582'
                WHERE ordernumber = 'P2412180014317' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436849'
                WHERE ordernumber = 'P2412180014428' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433369'
                WHERE ordernumber = 'P2412180014556' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436849'
                WHERE ordernumber = 'P2412180014644' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436852'
                WHERE ordernumber = 'P2412180014836' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275401'
                WHERE ordernumber = 'P2412180015044' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015134' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015263' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015372' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015451' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015538' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015614' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180015772' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436856'
                WHERE ordernumber = 'P2412180015871' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436731'
                WHERE ordernumber = 'P2412180015943' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180016039' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436839'
                WHERE ordernumber = 'P2412180016144' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436849'
                WHERE ordernumber = 'P2412180016213' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436849'
                WHERE ordernumber = 'P2412180016330' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96010'
                WHERE ordernumber = 'P2412180016985' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436863'
                WHERE ordernumber = 'P2412180017171' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436864'
                WHERE ordernumber = 'P2412180017347' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382122'
                WHERE ordernumber = 'P2412180017445' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383608'
                WHERE ordernumber = 'P2412180017879' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224573'
                WHERE ordernumber = 'P2412180018029' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286476'
                WHERE ordernumber = 'P2412180018290' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427232'
                WHERE ordernumber = 'P2412180018548' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284565'
                WHERE ordernumber = 'P2412180018654' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129674'
                WHERE ordernumber = 'P2412180018769' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427230'
                WHERE ordernumber = 'P2412180018884' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427230'
                WHERE ordernumber = 'P2412180018981' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429605'
                WHERE ordernumber = 'P2412180019059' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436873'
                WHERE ordernumber = 'P2412180019254' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436874'
                WHERE ordernumber = 'P2412180019341' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436876'
                WHERE ordernumber = 'P2412180019536' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424230'
                WHERE ordernumber = 'P2412180019644' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436880'
                WHERE ordernumber = 'P2412180019824' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423093'
                WHERE ordernumber = 'P2412180019964' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284841'
                WHERE ordernumber = 'P2412180020024' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354790'
                WHERE ordernumber = 'P2412180020226' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235839'
                WHERE ordernumber = 'P2412180020559' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380648'
                WHERE ordernumber = 'P2412180020669' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380648'
                WHERE ordernumber = 'P2412180020719' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436889'
                WHERE ordernumber = 'P2412180020927' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426496'
                WHERE ordernumber = 'P2412180021028' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436883'
                WHERE ordernumber = 'P2412180021292' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436891'
                WHERE ordernumber = 'P2412180021537' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436895'
                WHERE ordernumber = 'P2412180021850' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436897'
                WHERE ordernumber = 'P2412180021991' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383852'
                WHERE ordernumber = 'P2412180022026' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P2412180022183' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436890'
                WHERE ordernumber = 'P2412180022253' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436900'
                WHERE ordernumber = 'P2412180022325' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133915'
                WHERE ordernumber = 'P2412180022526' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436902'
                WHERE ordernumber = 'P2412180022745' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319863'
                WHERE ordernumber = 'P2412180023113' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436901'
                WHERE ordernumber = 'P2412180023281' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326963'
                WHERE ordernumber = 'P2412180023334' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425881'
                WHERE ordernumber = 'P2412180023542' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436903'
                WHERE ordernumber = 'P2412180023638' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436906'
                WHERE ordernumber = 'P2412180023861' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425881'
                WHERE ordernumber = 'P2412180024192' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245670'
                WHERE ordernumber = 'P2412180024412' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164997'
                WHERE ordernumber = 'P2412180024582' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436907'
                WHERE ordernumber = 'P2412180025023' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436911'
                WHERE ordernumber = 'P2412180025478' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279433'
                WHERE ordernumber = 'P2412180025794' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436914'
                WHERE ordernumber = 'P2412180025848' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436915'
                WHERE ordernumber = 'P2412180026544' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436915'
                WHERE ordernumber = 'P2412180026875' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436470'
                WHERE ordernumber = 'P2412180027714' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67948'
                WHERE ordernumber = 'P2412180028010' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435563'
                WHERE ordernumber = 'P2412180028517' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351359'
                WHERE ordernumber = 'P2412180028695' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436927'
                WHERE ordernumber = 'P2412180028736' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436928'
                WHERE ordernumber = 'P2412180029347' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436928'
                WHERE ordernumber = 'P2412180029488' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304451'
                WHERE ordernumber = 'P2412180029999' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436937'
                WHERE ordernumber = 'P2412180031311' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436936'
                WHERE ordernumber = 'P2412180031224' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436937'
                WHERE ordernumber = 'P2412180031485' 
            
2024-12-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436940'
                WHERE ordernumber = 'P2412180031774'