2024-10-31 01:00:02 -- 將會員中心id寫入data-lake
2024-10-31 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-10-30%';
        
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245829'
                WHERE ordernumber = 'P181030110242947' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428238'
                WHERE ordernumber = 'P201030110621575' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428240'
                WHERE ordernumber = 'P181030111147228' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385277'
                WHERE ordernumber = 'P181030111937733' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428241'
                WHERE ordernumber = 'P421030112123562' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P181030112559546' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428244'
                WHERE ordernumber = 'P731030112634269' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428243'
                WHERE ordernumber = 'P711030113303619' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '405206'
                WHERE ordernumber = 'P201030113728775' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378224'
                WHERE ordernumber = 'P201030113949350' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P181030114135282' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428245'
                WHERE ordernumber = 'P731030114541325' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428246'
                WHERE ordernumber = 'P181030114907220' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306397'
                WHERE ordernumber = 'P181030115410439' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428248'
                WHERE ordernumber = 'P731030115610990' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375259'
                WHERE ordernumber = 'P181030115640650' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '94228'
                WHERE ordernumber = 'P181030120542321' 
            
2024-10-31 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428250'
                WHERE ordernumber = 'P421030120708552' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428247'
                WHERE ordernumber = 'P181030120950562' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428251'
                WHERE ordernumber = 'P771030121139994' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '157035'
                WHERE ordernumber = 'P201030121233332' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428252'
                WHERE ordernumber = 'P181030121239337' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94025'
                WHERE ordernumber = 'P201030121345158' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428253'
                WHERE ordernumber = 'P181030121525945' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299619'
                WHERE ordernumber = 'P421030121839659' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428255'
                WHERE ordernumber = 'P771030122056779' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426958'
                WHERE ordernumber = 'P181030122058329' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181030122232886' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428256'
                WHERE ordernumber = 'P181030122812699' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375587'
                WHERE ordernumber = 'P711030122829482' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288428'
                WHERE ordernumber = 'P201030122954406' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277364'
                WHERE ordernumber = 'P201030123118279' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428257'
                WHERE ordernumber = 'P421030123347215' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428008'
                WHERE ordernumber = 'P771030123441460' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428258'
                WHERE ordernumber = 'P201030123457664' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '202370'
                WHERE ordernumber = 'P771030123851374' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427355'
                WHERE ordernumber = 'P201030123916138' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428259'
                WHERE ordernumber = 'P181030123924838' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239548'
                WHERE ordernumber = 'P181030124929850' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172599'
                WHERE ordernumber = 'P181030125147641' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318257'
                WHERE ordernumber = 'P201030125635923' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428260'
                WHERE ordernumber = 'P181030125654301' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428261'
                WHERE ordernumber = 'P631030125927409' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428263'
                WHERE ordernumber = 'P201030130249609' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137446'
                WHERE ordernumber = 'P421030130310701' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428264'
                WHERE ordernumber = 'P421030130549230' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349068'
                WHERE ordernumber = 'P421030130615365' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428015'
                WHERE ordernumber = 'P181030130801873' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428266'
                WHERE ordernumber = 'P711030131459592' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428267'
                WHERE ordernumber = 'P421030131841858' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428270'
                WHERE ordernumber = 'P201030131950392' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428268'
                WHERE ordernumber = 'P181030132035519' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428271'
                WHERE ordernumber = 'P711030132131509' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427219'
                WHERE ordernumber = 'P771030132133283' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214749'
                WHERE ordernumber = 'P181030132306785' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428272'
                WHERE ordernumber = 'P201030132316796' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428273'
                WHERE ordernumber = 'P711030132521753' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420128'
                WHERE ordernumber = 'P421030133055314' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76607'
                WHERE ordernumber = 'P181030133200322' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428275'
                WHERE ordernumber = 'P731030133749868' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428276'
                WHERE ordernumber = 'P181030134113130' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165757'
                WHERE ordernumber = 'P771030134711307' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428278'
                WHERE ordernumber = 'P181030135838427' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428280'
                WHERE ordernumber = 'P201030141654910' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428282'
                WHERE ordernumber = 'P731030142610622' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290603'
                WHERE ordernumber = 'P421030142721483' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426344'
                WHERE ordernumber = 'P181030142811334' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428285'
                WHERE ordernumber = 'P731030143212790' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325030'
                WHERE ordernumber = 'P181030143230131' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402061'
                WHERE ordernumber = 'P201030143312940' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365304'
                WHERE ordernumber = 'P711030143546807' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160722'
                WHERE ordernumber = 'P771030144102160' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428288'
                WHERE ordernumber = 'P711030144132405' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424262'
                WHERE ordernumber = 'P201030144300226' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428279'
                WHERE ordernumber = 'P711030144304406' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424262'
                WHERE ordernumber = 'P201030144557515' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428292'
                WHERE ordernumber = 'P421030145355612' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428293'
                WHERE ordernumber = 'P711030145937150' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428294'
                WHERE ordernumber = 'P201030150624296' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393021'
                WHERE ordernumber = 'P631030150722250' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428293'
                WHERE ordernumber = 'P711030151252114' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428295'
                WHERE ordernumber = 'P201030151526222' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369311'
                WHERE ordernumber = 'P201030151808301' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428297'
                WHERE ordernumber = 'P711030152059434' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428296'
                WHERE ordernumber = 'P191030152449416' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421763'
                WHERE ordernumber = 'P201030152911536' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428298'
                WHERE ordernumber = 'P771030152944818' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428301'
                WHERE ordernumber = 'P201030153201214' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428299'
                WHERE ordernumber = 'P191030153423365' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428303'
                WHERE ordernumber = 'P711030154233948' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428302'
                WHERE ordernumber = 'P771030154250285' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428305'
                WHERE ordernumber = 'P711030154454203' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428304'
                WHERE ordernumber = 'P191030154457906' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181030154725896' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428308'
                WHERE ordernumber = 'P421030155102350' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428306'
                WHERE ordernumber = 'P421030155105713' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191030155121947' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273488'
                WHERE ordernumber = 'P191030155223130' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426998'
                WHERE ordernumber = 'P181030155555907' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P191030155724400' 
            
2024-10-31 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428310'
                WHERE ordernumber = 'P731030155732740' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711030155806532' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425793'
                WHERE ordernumber = 'P731030160022163' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105625'
                WHERE ordernumber = 'P591030160632372' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '226896'
                WHERE ordernumber = 'P201030162214512' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219940'
                WHERE ordernumber = 'P191030162622790' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390832'
                WHERE ordernumber = 'P421030162827148' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428313'
                WHERE ordernumber = 'P191030162850524' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45112'
                WHERE ordernumber = 'P191030163524435' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428314'
                WHERE ordernumber = 'P191030164236356' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428316'
                WHERE ordernumber = 'P731030164354351' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428317'
                WHERE ordernumber = 'P421030164503423' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428315'
                WHERE ordernumber = 'P191030164816232' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428318'
                WHERE ordernumber = 'P421030165243399' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378446'
                WHERE ordernumber = 'P191030165523111' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428319'
                WHERE ordernumber = 'P731030170336430' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280709'
                WHERE ordernumber = 'P181030171704327' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428320'
                WHERE ordernumber = 'P771030171835658' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219782'
                WHERE ordernumber = 'P181030171924147' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421808'
                WHERE ordernumber = 'P201030171959354' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428321'
                WHERE ordernumber = 'P711030172322706' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '50069'
                WHERE ordernumber = 'P771030172448762' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372637'
                WHERE ordernumber = 'P421030172948281' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428322'
                WHERE ordernumber = 'P181030173041474' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276192'
                WHERE ordernumber = 'P201030173532185' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428324'
                WHERE ordernumber = 'P771030173542957' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428324'
                WHERE ordernumber = 'P771030173656398' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325502'
                WHERE ordernumber = 'P181030173904231' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428326'
                WHERE ordernumber = 'P711030174043533' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428325'
                WHERE ordernumber = 'P181030174054969' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249124'
                WHERE ordernumber = 'P771030174107291' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428327'
                WHERE ordernumber = 'P201030174331342' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428328'
                WHERE ordernumber = 'P771030174414361' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163339'
                WHERE ordernumber = 'P201030174552497' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P181030174825383' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428330'
                WHERE ordernumber = 'P181030175242781' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428331'
                WHERE ordernumber = 'P421030175251415' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P181030175438419' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331239'
                WHERE ordernumber = 'P711030175522216' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428329'
                WHERE ordernumber = 'P181030175650400' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428332'
                WHERE ordernumber = 'P771030175743819' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428079'
                WHERE ordernumber = 'P711030175840692' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281701'
                WHERE ordernumber = 'P181030175907972' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426961'
                WHERE ordernumber = 'P181030180135537' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428334'
                WHERE ordernumber = 'P201030180429312' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132651'
                WHERE ordernumber = 'P631030180635855' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266591'
                WHERE ordernumber = 'P181030181618727' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133909'
                WHERE ordernumber = 'P181030181816825' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427863'
                WHERE ordernumber = 'P711030181913120' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426531'
                WHERE ordernumber = 'P771030182618347' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428338'
                WHERE ordernumber = 'P181030182618207' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203398'
                WHERE ordernumber = 'P771030182633764' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428337'
                WHERE ordernumber = 'P421030182708625' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428340'
                WHERE ordernumber = 'P191030183352233' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280344'
                WHERE ordernumber = 'P181030183423274' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428341'
                WHERE ordernumber = 'P181030183737117' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428342'
                WHERE ordernumber = 'P181030184007699' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358265'
                WHERE ordernumber = 'P771030184219414' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427812'
                WHERE ordernumber = 'P201030184350684' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299916'
                WHERE ordernumber = 'P771030184629259' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344719'
                WHERE ordernumber = 'P181030185201493' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428345'
                WHERE ordernumber = 'P181030185644389' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428346'
                WHERE ordernumber = 'P191030185717709' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234457'
                WHERE ordernumber = 'P201030185918420' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428347'
                WHERE ordernumber = 'P201030190137713' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407439'
                WHERE ordernumber = 'P771030190257908' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286871'
                WHERE ordernumber = 'P191030190940820' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428349'
                WHERE ordernumber = 'P201030191221544' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381869'
                WHERE ordernumber = 'P191030192739808' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428350'
                WHERE ordernumber = 'P201030192818795' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298961'
                WHERE ordernumber = 'P191030193738378' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298961'
                WHERE ordernumber = 'P191030193825799' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428351'
                WHERE ordernumber = 'P771030194407198' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387664'
                WHERE ordernumber = 'P771030200021697' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387664'
                WHERE ordernumber = 'P771030200025404' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428355'
                WHERE ordernumber = 'P771030201030663' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428356'
                WHERE ordernumber = 'P771030202958432' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428357'
                WHERE ordernumber = 'P771030203644315' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428358'
                WHERE ordernumber = 'P771030203940496' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365586'
                WHERE ordernumber = 'P771030204255416' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428359'
                WHERE ordernumber = 'P731030204852488' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428361'
                WHERE ordernumber = 'P731030205539998' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365586'
                WHERE ordernumber = 'P771030205936596' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '56999'
                WHERE ordernumber = 'P731030212943117' 
            
2024-10-31 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365586'
                WHERE ordernumber = 'P771030214103118' 
            
2024-10-31 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '428366'
                WHERE ordernumber = 'P731030214144152'