2024-08-12 01:00:02 -- 將會員中心id寫入data-lake
2024-08-12 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-08-11%';
        
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98145'
                WHERE ordernumber = 'P200811110236412' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407165'
                WHERE ordernumber = 'P180811110343952' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407166'
                WHERE ordernumber = 'P420811110556577' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407167'
                WHERE ordernumber = 'P180811110650825' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133133'
                WHERE ordernumber = 'P190811110751970' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390790'
                WHERE ordernumber = 'P190811110857459' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407168'
                WHERE ordernumber = 'P420811110928214' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407169'
                WHERE ordernumber = 'P180811111019705' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386405'
                WHERE ordernumber = 'P190811111026125' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404157'
                WHERE ordernumber = 'P190811111157620' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407170'
                WHERE ordernumber = 'P420811111243729' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99444'
                WHERE ordernumber = 'P200811111318957' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '109223'
                WHERE ordernumber = 'P190811111430637' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407172'
                WHERE ordernumber = 'P420811111956931' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357748'
                WHERE ordernumber = 'P180811112203611' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403658'
                WHERE ordernumber = 'P420811112215350' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357105'
                WHERE ordernumber = 'P630811112433597' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357748'
                WHERE ordernumber = 'P180811112711622' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96759'
                WHERE ordernumber = 'P200811112735249' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407175'
                WHERE ordernumber = 'P180811113056624' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407176'
                WHERE ordernumber = 'P190811113205627' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399042'
                WHERE ordernumber = 'P180811113230843' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407178'
                WHERE ordernumber = 'P420811113353934' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289972'
                WHERE ordernumber = 'P180811113402768' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407181'
                WHERE ordernumber = 'P180811113839433' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407182'
                WHERE ordernumber = 'P200811114026605' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407179'
                WHERE ordernumber = 'P420811114201127' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287895'
                WHERE ordernumber = 'P200811114210997' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407179'
                WHERE ordernumber = 'P420811114339793' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212334'
                WHERE ordernumber = 'P180811114413208' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339434'
                WHERE ordernumber = 'P180811114531155' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217676'
                WHERE ordernumber = 'P200811114548562' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P200811114639855' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407184'
                WHERE ordernumber = 'P180811114740532' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407186'
                WHERE ordernumber = 'P180811115038597' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324234'
                WHERE ordernumber = 'P190811115104933' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407187'
                WHERE ordernumber = 'P180811115224985' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407188'
                WHERE ordernumber = 'P180811115412763' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298298'
                WHERE ordernumber = 'P180811115455414' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225379'
                WHERE ordernumber = 'P200811115525596' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402197'
                WHERE ordernumber = 'P180811115546245' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407190'
                WHERE ordernumber = 'P180811115813699' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407191'
                WHERE ordernumber = 'P190811115816994' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130468'
                WHERE ordernumber = 'P200811115840210' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230486'
                WHERE ordernumber = 'P180811120048415' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407192'
                WHERE ordernumber = 'P420811120106241' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406050'
                WHERE ordernumber = 'P180811120159805' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407194'
                WHERE ordernumber = 'P420811120330880' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346997'
                WHERE ordernumber = 'P190811120918157' 
            
2024-08-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407198'
                WHERE ordernumber = 'P180811121345718' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314326'
                WHERE ordernumber = 'P200811121451194' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407199'
                WHERE ordernumber = 'P190811121821266' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407200'
                WHERE ordernumber = 'P180811122144489' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407202'
                WHERE ordernumber = 'P420811122508138' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407203'
                WHERE ordernumber = 'P180811122731735' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407205'
                WHERE ordernumber = 'P180811123135871' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288219'
                WHERE ordernumber = 'P190811123824280' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347486'
                WHERE ordernumber = 'P180811124001880' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407206'
                WHERE ordernumber = 'P420811124214288' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321239'
                WHERE ordernumber = 'P420811124547229' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407209'
                WHERE ordernumber = 'P420811124755946' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420811125301160' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407212'
                WHERE ordernumber = 'P180811125558876' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407213'
                WHERE ordernumber = 'P190811125716846' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420811125907112' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407214'
                WHERE ordernumber = 'P180811125916444' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300127'
                WHERE ordernumber = 'P200811130041551' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407215'
                WHERE ordernumber = 'P420811130510809' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407216'
                WHERE ordernumber = 'P200811130657112' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382266'
                WHERE ordernumber = 'P420811125301160' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407218'
                WHERE ordernumber = 'P420811131547823' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407219'
                WHERE ordernumber = 'P180811131709541' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407220'
                WHERE ordernumber = 'P180811131853615' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314211'
                WHERE ordernumber = 'P180811132212357' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407223'
                WHERE ordernumber = 'P420811133222747' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351891'
                WHERE ordernumber = 'P180811133532674' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380759'
                WHERE ordernumber = 'P200811133608115' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234274'
                WHERE ordernumber = 'P200811133722778' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '402778'
                WHERE ordernumber = 'P420811134033919' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343760'
                WHERE ordernumber = 'P420811134129998' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407226'
                WHERE ordernumber = 'P180811134141507' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346054'
                WHERE ordernumber = 'P180811134328491' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407228'
                WHERE ordernumber = 'P180811134702456' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407230'
                WHERE ordernumber = 'P180811134927430' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386595'
                WHERE ordernumber = 'P200811135044805' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407231'
                WHERE ordernumber = 'P420811135207355' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406820'
                WHERE ordernumber = 'P180811135347641' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207373'
                WHERE ordernumber = 'P200811135402113' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405173'
                WHERE ordernumber = 'P180811135640794' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407234'
                WHERE ordernumber = 'P190811135847516' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407235'
                WHERE ordernumber = 'P420811135921221' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407238'
                WHERE ordernumber = 'P190811140423800' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407237'
                WHERE ordernumber = 'P420811140433253' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407238'
                WHERE ordernumber = 'P190811140507501' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407239'
                WHERE ordernumber = 'P420811140544400' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319423'
                WHERE ordernumber = 'P200811140658146' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407241'
                WHERE ordernumber = 'P180811140738179' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407242'
                WHERE ordernumber = 'P420811140814987' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407243'
                WHERE ordernumber = 'P420811141003997' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237921'
                WHERE ordernumber = 'P200811141052437' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407244'
                WHERE ordernumber = 'P180811141059394' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279039'
                WHERE ordernumber = 'P200811141323760' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407245'
                WHERE ordernumber = 'P190811141646789' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407246'
                WHERE ordernumber = 'P180811141722752' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407247'
                WHERE ordernumber = 'P180811141838397' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407248'
                WHERE ordernumber = 'P190811141953186' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407249'
                WHERE ordernumber = 'P420811142008384' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407251'
                WHERE ordernumber = 'P180811142118476' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407252'
                WHERE ordernumber = 'P180811142251164' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407253'
                WHERE ordernumber = 'P190811142737263' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407254'
                WHERE ordernumber = 'P420811142800726' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '32381'
                WHERE ordernumber = 'P190811143242328' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341634'
                WHERE ordernumber = 'P190811143319537' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407165'
                WHERE ordernumber = 'P180811143557984' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407165'
                WHERE ordernumber = 'P180811143650198' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399567'
                WHERE ordernumber = 'P190811143749382' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407260'
                WHERE ordernumber = 'P200811144204439' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407262'
                WHERE ordernumber = 'P180811144504190' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407261'
                WHERE ordernumber = 'P190811144507334' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223688'
                WHERE ordernumber = 'P180811144712690' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314597'
                WHERE ordernumber = 'P190811145039544' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407265'
                WHERE ordernumber = 'P190811145242423' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386846'
                WHERE ordernumber = 'P630811145409799' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385907'
                WHERE ordernumber = 'P420811145604896' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407266'
                WHERE ordernumber = 'P420811145749416' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407268'
                WHERE ordernumber = 'P180811150129826' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267163'
                WHERE ordernumber = 'P200811150537580' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407270'
                WHERE ordernumber = 'P420811150855330' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '203898'
                WHERE ordernumber = 'P200811150908421' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407271'
                WHERE ordernumber = 'P200811151102630' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396484'
                WHERE ordernumber = 'P630811151518889' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407272'
                WHERE ordernumber = 'P180811151548271' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407273'
                WHERE ordernumber = 'P420811151659999' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396484'
                WHERE ordernumber = 'P630811151741170' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390666'
                WHERE ordernumber = 'P200811151917546' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407274'
                WHERE ordernumber = 'P180811151916375' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377608'
                WHERE ordernumber = 'P180811152141988' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407277'
                WHERE ordernumber = 'P190811152524722' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407278'
                WHERE ordernumber = 'P420811152613272' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166831'
                WHERE ordernumber = 'P200811152942180' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407281'
                WHERE ordernumber = 'P180811152955777' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101497'
                WHERE ordernumber = 'P200811153115211' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407284'
                WHERE ordernumber = 'P180811153120370' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407283'
                WHERE ordernumber = 'P420811153137590' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407285'
                WHERE ordernumber = 'P420811153228768' 
            
2024-08-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190811153236123' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405848'
                WHERE ordernumber = 'P180811153312666' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '77908'
                WHERE ordernumber = 'P180811153809976' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406831'
                WHERE ordernumber = 'P190811153914793' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407286'
                WHERE ordernumber = 'P180811153935656' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '363295'
                WHERE ordernumber = 'P180811154030236' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406831'
                WHERE ordernumber = 'P190811154102874' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407287'
                WHERE ordernumber = 'P420811154217114' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343064'
                WHERE ordernumber = 'P190811154253628' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407288'
                WHERE ordernumber = 'P180811154524676' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406153'
                WHERE ordernumber = 'P180811154744815' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407290'
                WHERE ordernumber = 'P180811155119923' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407289'
                WHERE ordernumber = 'P420811155157172' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407293'
                WHERE ordernumber = 'P200811155428665' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405027'
                WHERE ordernumber = 'P420811155658265' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316297'
                WHERE ordernumber = 'P180811155826952' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407295'
                WHERE ordernumber = 'P200811155835702' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407296'
                WHERE ordernumber = 'P200811160121435' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380750'
                WHERE ordernumber = 'P630811160502806' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180811160808363' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218542'
                WHERE ordernumber = 'P180811160941369' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407299'
                WHERE ordernumber = 'P190811161143336' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407301'
                WHERE ordernumber = 'P200811161224755' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407303'
                WHERE ordernumber = 'P180811161259512' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407298'
                WHERE ordernumber = 'P200811161422999' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407300'
                WHERE ordernumber = 'P200811161458999' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407300'
                WHERE ordernumber = 'P200811161631965' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407302'
                WHERE ordernumber = 'P200811161732672' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399863'
                WHERE ordernumber = 'P590811161739610' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407306'
                WHERE ordernumber = 'P180811161857660' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345359'
                WHERE ordernumber = 'P200811161919944' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25221'
                WHERE ordernumber = 'P200811162047650' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407307'
                WHERE ordernumber = 'P420811162142922' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257648'
                WHERE ordernumber = 'P200811162148303' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '217295'
                WHERE ordernumber = 'P190811162152377' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301862'
                WHERE ordernumber = 'P200811162357775' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407308'
                WHERE ordernumber = 'P180811162621641' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118795'
                WHERE ordernumber = 'P420811162644865' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384957'
                WHERE ordernumber = 'P190811162707795' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400798'
                WHERE ordernumber = 'P200811162821342' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290218'
                WHERE ordernumber = 'P200811162905961' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407309'
                WHERE ordernumber = 'P200811162955247' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232073'
                WHERE ordernumber = 'P180811163106218' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230870'
                WHERE ordernumber = 'P180811163255767' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400338'
                WHERE ordernumber = 'P190811163358559' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385207'
                WHERE ordernumber = 'P180811163413492' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '303338'
                WHERE ordernumber = 'P180811163540870' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407313'
                WHERE ordernumber = 'P200811163636989' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407314'
                WHERE ordernumber = 'P200811163753707' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322114'
                WHERE ordernumber = 'P200811164246275' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215725'
                WHERE ordernumber = 'P180811164304817' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407315'
                WHERE ordernumber = 'P180811164419558' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245789'
                WHERE ordernumber = 'P190811164643308' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397200'
                WHERE ordernumber = 'P180811164750828' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '91736'
                WHERE ordernumber = 'P200811165103860' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407317'
                WHERE ordernumber = 'P180811165130443' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281256'
                WHERE ordernumber = 'P180811165239832' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407318'
                WHERE ordernumber = 'P200811165321351' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407319'
                WHERE ordernumber = 'P180811165534466' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99149'
                WHERE ordernumber = 'P190811165812412' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262249'
                WHERE ordernumber = 'P180811165824200' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344260'
                WHERE ordernumber = 'P420811170025249' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397200'
                WHERE ordernumber = 'P180811170222411' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407323'
                WHERE ordernumber = 'P180811170641517' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407322'
                WHERE ordernumber = 'P420811170646402' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407324'
                WHERE ordernumber = 'P180811171048922' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334829'
                WHERE ordernumber = 'P180811171200807' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407326'
                WHERE ordernumber = 'P200811171316594' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370965'
                WHERE ordernumber = 'P420811171351373' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '23083'
                WHERE ordernumber = 'P200811171428123' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370965'
                WHERE ordernumber = 'P420811172005204' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407327'
                WHERE ordernumber = 'P180811172354838' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407328'
                WHERE ordernumber = 'P180811172638457' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407329'
                WHERE ordernumber = 'P420811172645610' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407330'
                WHERE ordernumber = 'P200811172820114' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407331'
                WHERE ordernumber = 'P420811172927447' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310433'
                WHERE ordernumber = 'P180811173409669' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405883'
                WHERE ordernumber = 'P180811173613656' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357110'
                WHERE ordernumber = 'P200811174440329' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407336'
                WHERE ordernumber = 'P420811174522491' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407338'
                WHERE ordernumber = 'P180811174621612' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312462'
                WHERE ordernumber = 'P420811174642812' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407339'
                WHERE ordernumber = 'P180811174914677' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324718'
                WHERE ordernumber = 'P180811175054397' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407139'
                WHERE ordernumber = 'P630811175257153' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381139'
                WHERE ordernumber = 'P200811175306959' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1220'
                WHERE ordernumber = 'P420811180255131' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133748'
                WHERE ordernumber = 'P420811181114943' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402996'
                WHERE ordernumber = 'P180811181251198' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407345'
                WHERE ordernumber = 'P200811181509681' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '257620'
                WHERE ordernumber = 'P200811182234619' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404378'
                WHERE ordernumber = 'P420811182424357' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280479'
                WHERE ordernumber = 'P200811182455551' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407348'
                WHERE ordernumber = 'P180811182526256' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235736'
                WHERE ordernumber = 'P200811182739693' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P200811183421411' 
            
2024-08-12 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160444'
                WHERE ordernumber = 'P180811183641903' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407351'
                WHERE ordernumber = 'P180811183914120' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407352'
                WHERE ordernumber = 'P180811184304933' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407353'
                WHERE ordernumber = 'P180811184408564' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63815'
                WHERE ordernumber = 'P180811184543571' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304297'
                WHERE ordernumber = 'P200811185308524' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407355'
                WHERE ordernumber = 'P190811185339407' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275946'
                WHERE ordernumber = 'P420811185655543' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P190811185815131' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407357'
                WHERE ordernumber = 'P200811190026526' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407358'
                WHERE ordernumber = 'P190811190920175' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350016'
                WHERE ordernumber = 'P190811191324801' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '139334'
                WHERE ordernumber = 'P190811191532459' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405445'
                WHERE ordernumber = 'P190811191815857' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260162'
                WHERE ordernumber = 'P190811191952846' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405650'
                WHERE ordernumber = 'P190811192131208' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407361'
                WHERE ordernumber = 'P190811192947721' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214805'
                WHERE ordernumber = 'P190811193021265' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '407362'
                WHERE ordernumber = 'P200811193314461' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '375069'
                WHERE ordernumber = 'P200811195359811' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '165876'
                WHERE ordernumber = 'P200811195608126' 
            
2024-08-12 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '405009'
                WHERE ordernumber = 'P630811205428691'