2024-09-20 01:00:02 -- 將會員中心id寫入data-lake
2024-09-20 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-09-19%';
        
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385355'
                WHERE ordernumber = 'P200919110242449' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167176'
                WHERE ordernumber = 'P200919110849526' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421735'
                WHERE ordernumber = 'P200919111213540' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126335'
                WHERE ordernumber = 'P190919111242529' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406831'
                WHERE ordernumber = 'P190919112252315' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190919112710607' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139359'
                WHERE ordernumber = 'P420919112921285' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328300'
                WHERE ordernumber = 'P420919113155252' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97327'
                WHERE ordernumber = 'P190919113630875' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421738'
                WHERE ordernumber = 'P200919113745473' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285181'
                WHERE ordernumber = 'P190919114311926' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101990'
                WHERE ordernumber = 'P200919114353887' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421740'
                WHERE ordernumber = 'P420919114404545' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421741'
                WHERE ordernumber = 'P420919114519693' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421742'
                WHERE ordernumber = 'P200919114653342' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P420919115013577' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281590'
                WHERE ordernumber = 'P200919115205565' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297197'
                WHERE ordernumber = 'P420919120339275' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384978'
                WHERE ordernumber = 'P420919120711653' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421744'
                WHERE ordernumber = 'P710919121028137' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P180919121422601' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180919121548646' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331180'
                WHERE ordernumber = 'P420919121619123' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421745'
                WHERE ordernumber = 'P420919121840844' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421746'
                WHERE ordernumber = 'P420919122200876' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421747'
                WHERE ordernumber = 'P420919122438627' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339230'
                WHERE ordernumber = 'P630919123200191' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247625'
                WHERE ordernumber = 'P200919123410740' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P420919123451720' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421748'
                WHERE ordernumber = 'P420919124027320' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '168331'
                WHERE ordernumber = 'P180919124657256' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421749'
                WHERE ordernumber = 'P730919124744505' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421750'
                WHERE ordernumber = 'P200919125104815' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421751'
                WHERE ordernumber = 'P420919125717351' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421752'
                WHERE ordernumber = 'P200919130419931' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421754'
                WHERE ordernumber = 'P200919130658321' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421753'
                WHERE ordernumber = 'P710919130755601' 
            
2024-09-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419227'
                WHERE ordernumber = 'P200919131039687' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419227'
                WHERE ordernumber = 'P200919131041120' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419227'
                WHERE ordernumber = 'P200919131044535' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421755'
                WHERE ordernumber = 'P710919131128928' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421756'
                WHERE ordernumber = 'P710919131412126' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421758'
                WHERE ordernumber = 'P420919131722626' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417042'
                WHERE ordernumber = 'P630919131753318' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421757'
                WHERE ordernumber = 'P710919131813876' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346564'
                WHERE ordernumber = 'P420919132206267' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271522'
                WHERE ordernumber = 'P200919132854397' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267409'
                WHERE ordernumber = 'P200919133111699' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421759'
                WHERE ordernumber = 'P710919133207701' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421760'
                WHERE ordernumber = 'P200919133825586' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421762'
                WHERE ordernumber = 'P710919134133851' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348803'
                WHERE ordernumber = 'P420919134418650' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421763'
                WHERE ordernumber = 'P200919134631804' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421764'
                WHERE ordernumber = 'P180919134718819' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136357'
                WHERE ordernumber = 'P200919135045231' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136357'
                WHERE ordernumber = 'P200919135202862' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136357'
                WHERE ordernumber = 'P200919135245734' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421761'
                WHERE ordernumber = 'P730919135252796' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136357'
                WHERE ordernumber = 'P200919135337864' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136357'
                WHERE ordernumber = 'P200919135429446' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421765'
                WHERE ordernumber = 'P420919135833801' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320267'
                WHERE ordernumber = 'P180919140226709' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311387'
                WHERE ordernumber = 'P200919140808487' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137599'
                WHERE ordernumber = 'P180919140819760' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421766'
                WHERE ordernumber = 'P180919140934896' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421767'
                WHERE ordernumber = 'P180919141124780' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421768'
                WHERE ordernumber = 'P730919141300886' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345218'
                WHERE ordernumber = 'P420919141701859' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200919141839131' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421770'
                WHERE ordernumber = 'P730919141852247' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419798'
                WHERE ordernumber = 'P180919142234143' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421772'
                WHERE ordernumber = 'P420919142323975' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421771'
                WHERE ordernumber = 'P710919142629596' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420700'
                WHERE ordernumber = 'P200919143239323' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420700'
                WHERE ordernumber = 'P200919143342491' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420700'
                WHERE ordernumber = 'P200919143423848' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420700'
                WHERE ordernumber = 'P200919143551760' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421774'
                WHERE ordernumber = 'P420919143703276' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421775'
                WHERE ordernumber = 'P180919143719369' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404300'
                WHERE ordernumber = 'P420919143854292' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213710'
                WHERE ordernumber = 'P730919144138888' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397039'
                WHERE ordernumber = 'P180919144145478' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421776'
                WHERE ordernumber = 'P710919144226116' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389112'
                WHERE ordernumber = 'P200919145031991' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417222'
                WHERE ordernumber = 'P420919145044392' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293797'
                WHERE ordernumber = 'P180919145144604' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P180919145641300' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96406'
                WHERE ordernumber = 'P180919145824994' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395818'
                WHERE ordernumber = 'P180919145932227' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421780'
                WHERE ordernumber = 'P730919150748207' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421781'
                WHERE ordernumber = 'P420919150940910' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172438'
                WHERE ordernumber = 'P710919151056815' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180919151143390' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230010'
                WHERE ordernumber = 'P710919151220372' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143832'
                WHERE ordernumber = 'P420919151236199' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421782'
                WHERE ordernumber = 'P710919151311802' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421783'
                WHERE ordernumber = 'P710919151501527' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421784'
                WHERE ordernumber = 'P200919151506597' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403578'
                WHERE ordernumber = 'P420919152319999' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421785'
                WHERE ordernumber = 'P180919152324992' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230555'
                WHERE ordernumber = 'P200919152433285' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421786'
                WHERE ordernumber = 'P730919152505548' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421787'
                WHERE ordernumber = 'P710919152634770' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206631'
                WHERE ordernumber = 'P180919152844257' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421789'
                WHERE ordernumber = 'P180919153352984' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421791'
                WHERE ordernumber = 'P180919154355234' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421793'
                WHERE ordernumber = 'P180919154825919' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381447'
                WHERE ordernumber = 'P710919154838230' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327773'
                WHERE ordernumber = 'P420919155203891' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421794'
                WHERE ordernumber = 'P180919155212281' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P180919155519946' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421795'
                WHERE ordernumber = 'P180919160214694' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390366'
                WHERE ordernumber = 'P180919160524781' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421796'
                WHERE ordernumber = 'P200919160604595' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421797'
                WHERE ordernumber = 'P200919160931294' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421531'
                WHERE ordernumber = 'P180919161106803' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379256'
                WHERE ordernumber = 'P180919161224304' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380226'
                WHERE ordernumber = 'P180919161702965' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421798'
                WHERE ordernumber = 'P710919162100541' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421799'
                WHERE ordernumber = 'P180919162258984' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318939'
                WHERE ordernumber = 'P420919163019774' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282921'
                WHERE ordernumber = 'P180919163055524' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387138'
                WHERE ordernumber = 'P180919163141724' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P200919163640971' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419024'
                WHERE ordernumber = 'P200919163915383' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421801'
                WHERE ordernumber = 'P730919164123758' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421802'
                WHERE ordernumber = 'P180919164422936' 
            
2024-09-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211882'
                WHERE ordernumber = 'P180919165113215' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421803'
                WHERE ordernumber = 'P710919165401673' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421804'
                WHERE ordernumber = 'P180919165421823' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135240'
                WHERE ordernumber = 'P730919165437606' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397442'
                WHERE ordernumber = 'P180919165651677' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128554'
                WHERE ordernumber = 'P200919165926197' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290554'
                WHERE ordernumber = 'P630919165935533' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398841'
                WHERE ordernumber = 'P180919165955971' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421806'
                WHERE ordernumber = 'P710919170102631' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421807'
                WHERE ordernumber = 'P710919170454444' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421808'
                WHERE ordernumber = 'P200919170744284' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421808'
                WHERE ordernumber = 'P200919170832684' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '354846'
                WHERE ordernumber = 'P630919171302326' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236036'
                WHERE ordernumber = 'P200919171707922' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421809'
                WHERE ordernumber = 'P710919171732796' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421709'
                WHERE ordernumber = 'P200919171802749' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421810'
                WHERE ordernumber = 'P730919171928458' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421810'
                WHERE ordernumber = 'P730919172048671' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421812'
                WHERE ordernumber = 'P200919172905379' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421811'
                WHERE ordernumber = 'P710919173117208' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248370'
                WHERE ordernumber = 'P180919173230331' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421813'
                WHERE ordernumber = 'P180919173503567' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324778'
                WHERE ordernumber = 'P420919174023242' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421673'
                WHERE ordernumber = 'P180919175610449' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221989'
                WHERE ordernumber = 'P200919175722487' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351916'
                WHERE ordernumber = 'P180919175802487' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '247445'
                WHERE ordernumber = 'P200919175920627' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421816'
                WHERE ordernumber = 'P420919180652820' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421819'
                WHERE ordernumber = 'P180919181148534' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421814'
                WHERE ordernumber = 'P200919181216495' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421820'
                WHERE ordernumber = 'P420919181424249' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97201'
                WHERE ordernumber = 'P420919181624306' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421822'
                WHERE ordernumber = 'P730919181944296' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421823'
                WHERE ordernumber = 'P420919182023451' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421821'
                WHERE ordernumber = 'P710919182100977' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389088'
                WHERE ordernumber = 'P630919182324823' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415982'
                WHERE ordernumber = 'P420919183014843' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97074'
                WHERE ordernumber = 'P200919183123159' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421825'
                WHERE ordernumber = 'P180919183400988' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421826'
                WHERE ordernumber = 'P200919183514644' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356544'
                WHERE ordernumber = 'P200919183649128' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421688'
                WHERE ordernumber = 'P180919184501714' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421828'
                WHERE ordernumber = 'P420919185137218' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421829'
                WHERE ordernumber = 'P730919185604261' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419861'
                WHERE ordernumber = 'P200919185918594' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419676'
                WHERE ordernumber = 'P420919190110611' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '89155'
                WHERE ordernumber = 'P730919190326307' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421347'
                WHERE ordernumber = 'P200919190721379' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '68606'
                WHERE ordernumber = 'P190919191810713' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251367'
                WHERE ordernumber = 'P630919192019471' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385716'
                WHERE ordernumber = 'P630919192730934' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386469'
                WHERE ordernumber = 'P200919192739559' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421833'
                WHERE ordernumber = 'P200919193054135' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239648'
                WHERE ordernumber = 'P190919193125376' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421835'
                WHERE ordernumber = 'P200919193646684' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421836'
                WHERE ordernumber = 'P200919194356371' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366846'
                WHERE ordernumber = 'P730919194754497' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421837'
                WHERE ordernumber = 'P730919200251324' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421840'
                WHERE ordernumber = 'P730919203854212' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416650'
                WHERE ordernumber = 'P710919211546944' 
            
2024-09-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421841'
                WHERE ordernumber = 'P710919213517665'