2024-07-11 01:00:03 -- 將會員中心id寫入data-lake
2024-07-11 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-10%';
        
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297128'
                WHERE ordernumber = 'P200710110241592' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102081'
                WHERE ordernumber = 'P180710110327837' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288562'
                WHERE ordernumber = 'P200710110359516' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216330'
                WHERE ordernumber = 'P180710110551296' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400595'
                WHERE ordernumber = 'P200710110554414' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400571'
                WHERE ordernumber = 'P190710110714932' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400571'
                WHERE ordernumber = 'P190710110734711' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400596'
                WHERE ordernumber = 'P200710110753519' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278989'
                WHERE ordernumber = 'P180710111107284' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180710111155804' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94068'
                WHERE ordernumber = 'P180710111519413' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103462'
                WHERE ordernumber = 'P200710111844449' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137782'
                WHERE ordernumber = 'P180710111929613' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285340'
                WHERE ordernumber = 'P180710112018895' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P190710112234448' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165748'
                WHERE ordernumber = 'P180710112239629' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400597'
                WHERE ordernumber = 'P420710113504721' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400599'
                WHERE ordernumber = 'P180710113840814' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400600'
                WHERE ordernumber = 'P200710113900397' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400601'
                WHERE ordernumber = 'P190710114015614' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240728'
                WHERE ordernumber = 'P200710114054539' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400601'
                WHERE ordernumber = 'P190710114103873' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400601'
                WHERE ordernumber = 'P190710114120636' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358258'
                WHERE ordernumber = 'P200710114742468' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400603'
                WHERE ordernumber = 'P200710114906471' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375793'
                WHERE ordernumber = 'P180710115247954' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400605'
                WHERE ordernumber = 'P420710115247163' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400606'
                WHERE ordernumber = 'P190710115451133' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400607'
                WHERE ordernumber = 'P420710115524435' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93882'
                WHERE ordernumber = 'P420710115639714' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400608'
                WHERE ordernumber = 'P180710115825594' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291851'
                WHERE ordernumber = 'P190710115829813' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287470'
                WHERE ordernumber = 'P190710120059703' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45780'
                WHERE ordernumber = 'P200710120138247' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235621'
                WHERE ordernumber = 'P180710120152285' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246514'
                WHERE ordernumber = 'P590710120256288' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400611'
                WHERE ordernumber = 'P420710121234492' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '22232'
                WHERE ordernumber = 'P200710121317299' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300785'
                WHERE ordernumber = 'P180710122215134' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391664'
                WHERE ordernumber = 'P420710122555765' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400612'
                WHERE ordernumber = 'P180710122635237' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400613'
                WHERE ordernumber = 'P200710122654535' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400614'
                WHERE ordernumber = 'P180710122746465' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400615'
                WHERE ordernumber = 'P180710123007476' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420710123923999' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296939'
                WHERE ordernumber = 'P420710124019569' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400617'
                WHERE ordernumber = 'P200710124522743' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86643'
                WHERE ordernumber = 'P180710124657652' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160775'
                WHERE ordernumber = 'P420710124842948' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399196'
                WHERE ordernumber = 'P180710125436516' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400619'
                WHERE ordernumber = 'P190710125530143' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353974'
                WHERE ordernumber = 'P200710130817636' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163308'
                WHERE ordernumber = 'P180710131338120' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313636'
                WHERE ordernumber = 'P180710132652662' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400622'
                WHERE ordernumber = 'P420710132907374' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399842'
                WHERE ordernumber = 'P420710133040538' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381329'
                WHERE ordernumber = 'P420710133252576' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385217'
                WHERE ordernumber = 'P200710133526802' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325136'
                WHERE ordernumber = 'P420710133651319' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400591'
                WHERE ordernumber = 'P180710135203185' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400625'
                WHERE ordernumber = 'P180710135724232' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141288'
                WHERE ordernumber = 'P200710135948890' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400626'
                WHERE ordernumber = 'P180710140314600' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400627'
                WHERE ordernumber = 'P630710141336424' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P420710141356938' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400628'
                WHERE ordernumber = 'P200710141504279' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44110'
                WHERE ordernumber = 'P180710142502734' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400630'
                WHERE ordernumber = 'P180710143618930' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400631'
                WHERE ordernumber = 'P180710143954758' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400632'
                WHERE ordernumber = 'P180710144215409' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265506'
                WHERE ordernumber = 'P180710144911263' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394386'
                WHERE ordernumber = 'P200710145922626' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254216'
                WHERE ordernumber = 'P180710150300140' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367187'
                WHERE ordernumber = 'P180710150338287' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163720'
                WHERE ordernumber = 'P590710150730834' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400634'
                WHERE ordernumber = 'P180710151648581' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400636'
                WHERE ordernumber = 'P180710152149171' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384238'
                WHERE ordernumber = 'P180710153531207' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P180710153628643' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P190710153951358' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311320'
                WHERE ordernumber = 'P200710154240972' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393066'
                WHERE ordernumber = 'P200710154401634' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162781'
                WHERE ordernumber = 'P420710155046434' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400639'
                WHERE ordernumber = 'P180710155129672' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214789'
                WHERE ordernumber = 'P180710155342438' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308957'
                WHERE ordernumber = 'P420710155547129' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400641'
                WHERE ordernumber = 'P200710160601783' 
            
2024-07-11 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400641'
                WHERE ordernumber = 'P200710160630507' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400643'
                WHERE ordernumber = 'P180710161304390' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400644'
                WHERE ordernumber = 'P190710161430470' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400645'
                WHERE ordernumber = 'P180710161839705' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400647'
                WHERE ordernumber = 'P180710163001588' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400648'
                WHERE ordernumber = 'P420710163021312' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391016'
                WHERE ordernumber = 'P420710163453960' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400592'
                WHERE ordernumber = 'P180710163731243' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237174'
                WHERE ordernumber = 'P200710164003371' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400650'
                WHERE ordernumber = 'P180710164216508' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '269134'
                WHERE ordernumber = 'P420710164750628' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313057'
                WHERE ordernumber = 'P420710170331909' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P200710170504576' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P200710170647915' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289932'
                WHERE ordernumber = 'P420710170733789' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '326943'
                WHERE ordernumber = 'P180710170736532' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390292'
                WHERE ordernumber = 'P420710170901255' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348751'
                WHERE ordernumber = 'P200710171251114' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '387983'
                WHERE ordernumber = 'P420710171631465' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400658'
                WHERE ordernumber = 'P200710171707172' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400659'
                WHERE ordernumber = 'P420710173228571' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P180710173239875' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '348437'
                WHERE ordernumber = 'P180710173523213' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110388'
                WHERE ordernumber = 'P200710174037285' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360260'
                WHERE ordernumber = 'P200710174225929' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380103'
                WHERE ordernumber = 'P180710174335297' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298460'
                WHERE ordernumber = 'P420710174420601' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400313'
                WHERE ordernumber = 'P200710175446298' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294985'
                WHERE ordernumber = 'P180710180309657' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214831'
                WHERE ordernumber = 'P180710180532491' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400661'
                WHERE ordernumber = 'P420710180858834' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400662'
                WHERE ordernumber = 'P200710180902830' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400663'
                WHERE ordernumber = 'P200710182139864' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399782'
                WHERE ordernumber = 'P180710182226212' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399782'
                WHERE ordernumber = 'P180710182253325' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '310242'
                WHERE ordernumber = 'P200710182412396' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400664'
                WHERE ordernumber = 'P190710182512276' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400665'
                WHERE ordernumber = 'P420710182644379' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '324640'
                WHERE ordernumber = 'P190710182742978' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394824'
                WHERE ordernumber = 'P420710183301896' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100976'
                WHERE ordernumber = 'P180710183633496' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '173303'
                WHERE ordernumber = 'P180710183833432' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400666'
                WHERE ordernumber = 'P180710184149254' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400667'
                WHERE ordernumber = 'P200710184245196' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242381'
                WHERE ordernumber = 'P420710184404696' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400668'
                WHERE ordernumber = 'P200710184704381' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400669'
                WHERE ordernumber = 'P200710184952178' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400670'
                WHERE ordernumber = 'P590710185101343' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161640'
                WHERE ordernumber = 'P200710185205704' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399316'
                WHERE ordernumber = 'P200710185336601' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365768'
                WHERE ordernumber = 'P420710185832864' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400671'
                WHERE ordernumber = 'P200710190341449' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163149'
                WHERE ordernumber = 'P190710190518320' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276776'
                WHERE ordernumber = 'P190710190700381' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313332'
                WHERE ordernumber = 'P200710190712440' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400672'
                WHERE ordernumber = 'P190710190731527' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287203'
                WHERE ordernumber = 'P200710190806422' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382216'
                WHERE ordernumber = 'P190710190806883' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400673'
                WHERE ordernumber = 'P200710191023857' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400674'
                WHERE ordernumber = 'P190710191230921' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169009'
                WHERE ordernumber = 'P200710191438167' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396733'
                WHERE ordernumber = 'P200710191625780' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400675'
                WHERE ordernumber = 'P190710191916777' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400676'
                WHERE ordernumber = 'P190710192016659' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400678'
                WHERE ordernumber = 'P190710192124621' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400679'
                WHERE ordernumber = 'P190710192215711' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400680'
                WHERE ordernumber = 'P190710192417467' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '377659'
                WHERE ordernumber = 'P190710192537471' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400682'
                WHERE ordernumber = 'P190710192802827' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400683'
                WHERE ordernumber = 'P200710193019495' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400304'
                WHERE ordernumber = 'P200710193057527' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400684'
                WHERE ordernumber = 'P630710193418536' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '158000'
                WHERE ordernumber = 'P200710193850177' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95172'
                WHERE ordernumber = 'P190710194206649' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400687'
                WHERE ordernumber = 'P200710194300781' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400686'
                WHERE ordernumber = 'P630710194303808' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282511'
                WHERE ordernumber = 'P190710194350750' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '364923'
                WHERE ordernumber = 'P190710194521921' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400688'
                WHERE ordernumber = 'P200710194833314' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '396657'
                WHERE ordernumber = 'P200710195145270' 
            
2024-07-11 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400690'
                WHERE ordernumber = 'P200710195733510'