2024-10-20 01:00:01 -- 將會員中心id寫入data-lake
2024-10-20 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-10-19%';
        
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394270'
                WHERE ordernumber = 'P591019110339248' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409514'
                WHERE ordernumber = 'P181019110459667' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424416'
                WHERE ordernumber = 'P421019110534504' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426576'
                WHERE ordernumber = 'P191019110555514' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426577'
                WHERE ordernumber = 'P201019110703989' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426577'
                WHERE ordernumber = 'P201019110821407' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426575'
                WHERE ordernumber = 'P181019110833777' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426579'
                WHERE ordernumber = 'P421019110903207' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426581'
                WHERE ordernumber = 'P201019111448879' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426580'
                WHERE ordernumber = 'P191019111742128' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254450'
                WHERE ordernumber = 'P421019112240853' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426584'
                WHERE ordernumber = 'P731019113741596' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426583'
                WHERE ordernumber = 'P181019114252898' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426583'
                WHERE ordernumber = 'P181019114316364' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238751'
                WHERE ordernumber = 'P191019114346237' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394270'
                WHERE ordernumber = 'P201019114409314' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421093'
                WHERE ordernumber = 'P181019114631155' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381591'
                WHERE ordernumber = 'P421019115203633' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426589'
                WHERE ordernumber = 'P731019115632851' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426424'
                WHERE ordernumber = 'P421019120219978' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426593'
                WHERE ordernumber = 'P181019120714912' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414164'
                WHERE ordernumber = 'P181019120921540' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388438'
                WHERE ordernumber = 'P711019121101803' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P181019121152490' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P191019121241345' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426592'
                WHERE ordernumber = 'P191019121338984' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422474'
                WHERE ordernumber = 'P421019121434878' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426595'
                WHERE ordernumber = 'P181019121707286' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426594'
                WHERE ordernumber = 'P731019121823549' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426597'
                WHERE ordernumber = 'P201019122304219' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426599'
                WHERE ordernumber = 'P201019122420140' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426598'
                WHERE ordernumber = 'P421019122637211' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305672'
                WHERE ordernumber = 'P201019123120882' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426600'
                WHERE ordernumber = 'P771019123132787' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406733'
                WHERE ordernumber = 'P421019123136365' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139071'
                WHERE ordernumber = 'P201019123422579' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381802'
                WHERE ordernumber = 'P771019123425740' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406733'
                WHERE ordernumber = 'P421019123721601' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P201019124233715' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P201019124621532' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391612'
                WHERE ordernumber = 'P181019124628622' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350514'
                WHERE ordernumber = 'P631019124641619' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417227'
                WHERE ordernumber = 'P201019124709909' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426602'
                WHERE ordernumber = 'P181019124909869' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386243'
                WHERE ordernumber = 'P181019125244300' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426601'
                WHERE ordernumber = 'P421019125504881' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275766'
                WHERE ordernumber = 'P181019125836500' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426603'
                WHERE ordernumber = 'P201019125916580' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426605'
                WHERE ordernumber = 'P771019130318856' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426606'
                WHERE ordernumber = 'P771019130804740' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426607'
                WHERE ordernumber = 'P631019130823194' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342558'
                WHERE ordernumber = 'P181019130830651' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426609'
                WHERE ordernumber = 'P201019130938351' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426608'
                WHERE ordernumber = 'P181019131223300' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '195731'
                WHERE ordernumber = 'P201019131321897' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81093'
                WHERE ordernumber = 'P191019131716694' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426611'
                WHERE ordernumber = 'P181019131748635' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426612'
                WHERE ordernumber = 'P201019131901956' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111817'
                WHERE ordernumber = 'P181019132040246' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335214'
                WHERE ordernumber = 'P201019132240205' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329135'
                WHERE ordernumber = 'P181019132509277' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426614'
                WHERE ordernumber = 'P201019132611986' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423366'
                WHERE ordernumber = 'P731019132920154' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236183'
                WHERE ordernumber = 'P181019132947867' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426613'
                WHERE ordernumber = 'P771019133005271' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236183'
                WHERE ordernumber = 'P181019133034349' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426615'
                WHERE ordernumber = 'P771019133206134' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P181019133737784' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '356794'
                WHERE ordernumber = 'P201019134308211' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426618'
                WHERE ordernumber = 'P181019134319531' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426616'
                WHERE ordernumber = 'P181019134654402' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426604'
                WHERE ordernumber = 'P771019134828404' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426621'
                WHERE ordernumber = 'P181019135301997' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426624'
                WHERE ordernumber = 'P181019135621168' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426623'
                WHERE ordernumber = 'P731019135822550' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372886'
                WHERE ordernumber = 'P421019135919187' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425550'
                WHERE ordernumber = 'P731019140024498' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426625'
                WHERE ordernumber = 'P421019140146654' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345721'
                WHERE ordernumber = 'P201019140419458' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93632'
                WHERE ordernumber = 'P201019141106493' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426627'
                WHERE ordernumber = 'P191019141125856' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426622'
                WHERE ordernumber = 'P181019141128748' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394739'
                WHERE ordernumber = 'P421019141157440' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426628'
                WHERE ordernumber = 'P201019141357410' 
            
2024-10-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383745'
                WHERE ordernumber = 'P181019141506781' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426629'
                WHERE ordernumber = 'P731019141538247' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289356'
                WHERE ordernumber = 'P201019142209380' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131682'
                WHERE ordernumber = 'P181019142726573' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426632'
                WHERE ordernumber = 'P421019142821334' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381714'
                WHERE ordernumber = 'P181019142928473' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426634'
                WHERE ordernumber = 'P201019143031645' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395572'
                WHERE ordernumber = 'P421019143049820' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391880'
                WHERE ordernumber = 'P181019143114794' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426633'
                WHERE ordernumber = 'P421019143305558' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421260'
                WHERE ordernumber = 'P201019143443724' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426637'
                WHERE ordernumber = 'P181019143700163' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426636'
                WHERE ordernumber = 'P421019143800380' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426638'
                WHERE ordernumber = 'P181019143956792' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426635'
                WHERE ordernumber = 'P771019144004250' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426630'
                WHERE ordernumber = 'P421019144024475' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426639'
                WHERE ordernumber = 'P201019144130473' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424411'
                WHERE ordernumber = 'P181019144144572' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P421019144320270' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415741'
                WHERE ordernumber = 'P421019144508734' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426641'
                WHERE ordernumber = 'P191019144752320' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426642'
                WHERE ordernumber = 'P181019144910860' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426640'
                WHERE ordernumber = 'P771019145325495' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106876'
                WHERE ordernumber = 'P201019145358213' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426604'
                WHERE ordernumber = 'P771019145842781' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275876'
                WHERE ordernumber = 'P181019150104419' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426645'
                WHERE ordernumber = 'P771019150112214' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426646'
                WHERE ordernumber = 'P201019150204285' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426648'
                WHERE ordernumber = 'P201019150259129' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426644'
                WHERE ordernumber = 'P181019150510143' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426649'
                WHERE ordernumber = 'P421019150510322' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426647'
                WHERE ordernumber = 'P191019150526515' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241198'
                WHERE ordernumber = 'P201019150841467' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268450'
                WHERE ordernumber = 'P731019150932758' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426650'
                WHERE ordernumber = 'P181019151034743' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426651'
                WHERE ordernumber = 'P201019151200496' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P181019151304280' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426652'
                WHERE ordernumber = 'P201019151336542' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P181019151528965' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355598'
                WHERE ordernumber = 'P201019151545224' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426653'
                WHERE ordernumber = 'P181019151718464' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426654'
                WHERE ordernumber = 'P771019151927552' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306150'
                WHERE ordernumber = 'P181019152132910' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386126'
                WHERE ordernumber = 'P181019152241934' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425991'
                WHERE ordernumber = 'P201019152309282' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426658'
                WHERE ordernumber = 'P201019153108355' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426657'
                WHERE ordernumber = 'P771019153112384' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359981'
                WHERE ordernumber = 'P201019153429916' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426659'
                WHERE ordernumber = 'P631019154512951' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426660'
                WHERE ordernumber = 'P731019154655283' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426661'
                WHERE ordernumber = 'P181019154816431' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394746'
                WHERE ordernumber = 'P421019155055266' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426663'
                WHERE ordernumber = 'P181019155124293' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426662'
                WHERE ordernumber = 'P181019155318320' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276467'
                WHERE ordernumber = 'P201019155739121' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P181019160008251' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90174'
                WHERE ordernumber = 'P201019160310974' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426665'
                WHERE ordernumber = 'P421019160615399' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '50014'
                WHERE ordernumber = 'P181019160632282' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P201019160706391' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102694'
                WHERE ordernumber = 'P421019160834596' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426667'
                WHERE ordernumber = 'P771019161150831' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426666'
                WHERE ordernumber = 'P181019161317884' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P181019161616720' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426668'
                WHERE ordernumber = 'P201019161705412' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299061'
                WHERE ordernumber = 'P421019161712464' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340673'
                WHERE ordernumber = 'P201019161750720' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425947'
                WHERE ordernumber = 'P201019161825587' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426669'
                WHERE ordernumber = 'P421019162254618' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426669'
                WHERE ordernumber = 'P421019162342260' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P181019162529966' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426671'
                WHERE ordernumber = 'P731019162542282' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291896'
                WHERE ordernumber = 'P201019162920661' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426672'
                WHERE ordernumber = 'P421019163230800' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426673'
                WHERE ordernumber = 'P731019163307260' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256834'
                WHERE ordernumber = 'P181019163643480' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426677'
                WHERE ordernumber = 'P421019164237963' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426676'
                WHERE ordernumber = 'P771019164316278' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421167'
                WHERE ordernumber = 'P181019164355861' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291463'
                WHERE ordernumber = 'P201019164414517' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426674'
                WHERE ordernumber = 'P181019164540283' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426675'
                WHERE ordernumber = 'P181019164654666' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306058'
                WHERE ordernumber = 'P201019164706292' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238751'
                WHERE ordernumber = 'P181019164943259' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312474'
                WHERE ordernumber = 'P711019165334530' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426678'
                WHERE ordernumber = 'P201019165335636' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426679'
                WHERE ordernumber = 'P201019165427334' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426680'
                WHERE ordernumber = 'P421019165724585' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163460'
                WHERE ordernumber = 'P201019165855134' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136226'
                WHERE ordernumber = 'P201019170112708' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423448'
                WHERE ordernumber = 'P181019170526570' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255861'
                WHERE ordernumber = 'P731019170555340' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426684'
                WHERE ordernumber = 'P421019170604429' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140451'
                WHERE ordernumber = 'P191019170636905' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424021'
                WHERE ordernumber = 'P191019170800348' 
            
2024-10-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426683'
                WHERE ordernumber = 'P201019170823624' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405095'
                WHERE ordernumber = 'P421019170911692' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '272159'
                WHERE ordernumber = 'P201019170925756' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426687'
                WHERE ordernumber = 'P201019171037557' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102694'
                WHERE ordernumber = 'P421019171108417' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426685'
                WHERE ordernumber = 'P771019171114994' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426687'
                WHERE ordernumber = 'P201019171159340' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405234'
                WHERE ordernumber = 'P201019171418325' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426682'
                WHERE ordernumber = 'P201019171520111' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426690'
                WHERE ordernumber = 'P421019171536812' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426689'
                WHERE ordernumber = 'P771019171559211' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426691'
                WHERE ordernumber = 'P711019171752240' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426688'
                WHERE ordernumber = 'P181019171852928' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426692'
                WHERE ordernumber = 'P771019171904453' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426693'
                WHERE ordernumber = 'P421019171938959' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426698'
                WHERE ordernumber = 'P201019172247282' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426696'
                WHERE ordernumber = 'P771019172346703' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276894'
                WHERE ordernumber = 'P201019172513916' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426695'
                WHERE ordernumber = 'P771019172517582' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P181019172520738' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335640'
                WHERE ordernumber = 'P181019172634398' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426699'
                WHERE ordernumber = 'P421019172851549' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426686'
                WHERE ordernumber = 'P771019173025601' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426697'
                WHERE ordernumber = 'P181019173121690' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426694'
                WHERE ordernumber = 'P771019173136131' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426697'
                WHERE ordernumber = 'P181019173153902' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234295'
                WHERE ordernumber = 'P631019173343189' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278444'
                WHERE ordernumber = 'P181019173358126' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426700'
                WHERE ordernumber = 'P421019173523812' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283274'
                WHERE ordernumber = 'P181019174052997' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273681'
                WHERE ordernumber = 'P181019174154583' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426701'
                WHERE ordernumber = 'P191019174709957' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325908'
                WHERE ordernumber = 'P421019175012916' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425029'
                WHERE ordernumber = 'P631019175634902' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251667'
                WHERE ordernumber = 'P181019175705119' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227486'
                WHERE ordernumber = 'P181019175921122' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400259'
                WHERE ordernumber = 'P201019175951364' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313325'
                WHERE ordernumber = 'P181019180019339' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75442'
                WHERE ordernumber = 'P181019180341860' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413213'
                WHERE ordernumber = 'P771019180353220' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426705'
                WHERE ordernumber = 'P201019180849381' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426704'
                WHERE ordernumber = 'P421019181236849' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P201019181536972' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105321'
                WHERE ordernumber = 'P711019181815882' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '323016'
                WHERE ordernumber = 'P421019181917684' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400730'
                WHERE ordernumber = 'P181019181918173' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426706'
                WHERE ordernumber = 'P771019182317833' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426707'
                WHERE ordernumber = 'P181019182849590' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426709'
                WHERE ordernumber = 'P181019183430127' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360967'
                WHERE ordernumber = 'P771019183552635' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426710'
                WHERE ordernumber = 'P191019183841126' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425029'
                WHERE ordernumber = 'P421019183853846' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426711'
                WHERE ordernumber = 'P191019183949669' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426712'
                WHERE ordernumber = 'P181019184326647' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426714'
                WHERE ordernumber = 'P201019184531888' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426713'
                WHERE ordernumber = 'P181019184533779' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425937'
                WHERE ordernumber = 'P191019184541319' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142615'
                WHERE ordernumber = 'P201019185224525' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207012'
                WHERE ordernumber = 'P191019185242939' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426715'
                WHERE ordernumber = 'P191019185407154' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426716'
                WHERE ordernumber = 'P201019185436979' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341560'
                WHERE ordernumber = 'P191019185536326' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234754'
                WHERE ordernumber = 'P201019185809367' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426717'
                WHERE ordernumber = 'P191019185814334' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426718'
                WHERE ordernumber = 'P191019185927560' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426719'
                WHERE ordernumber = 'P631019190450389' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110492'
                WHERE ordernumber = 'P191019190737176' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426722'
                WHERE ordernumber = 'P201019191153976' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426723'
                WHERE ordernumber = 'P201019192118327' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426724'
                WHERE ordernumber = 'P201019192213300' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379760'
                WHERE ordernumber = 'P191019192716638' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289302'
                WHERE ordernumber = 'P201019192735821' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426725'
                WHERE ordernumber = 'P771019193254352' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426726'
                WHERE ordernumber = 'P771019193905734' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421836'
                WHERE ordernumber = 'P201019194821701' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P201019194918865' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365102'
                WHERE ordernumber = 'P201019195056391' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426728'
                WHERE ordernumber = 'P631019200332885' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426728'
                WHERE ordernumber = 'P631019200518739' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426731'
                WHERE ordernumber = 'P771019202632553' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426730'
                WHERE ordernumber = 'P731019202945894' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425822'
                WHERE ordernumber = 'P731019203408385' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426733'
                WHERE ordernumber = 'P771019203942581' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426734'
                WHERE ordernumber = 'P631019204306918' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P631019205108477' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '45157'
                WHERE ordernumber = 'P631019210712137' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426736'
                WHERE ordernumber = 'P731019210813861' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '204883'
                WHERE ordernumber = 'P711019210952543' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421572'
                WHERE ordernumber = 'P711019212038773' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426737'
                WHERE ordernumber = 'P771019213907827' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426738'
                WHERE ordernumber = 'P771019214334265' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426740'
                WHERE ordernumber = 'P771019215153331' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426741'
                WHERE ordernumber = 'P711019215711862' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288557'
                WHERE ordernumber = 'P731019220148813' 
            
2024-10-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426739'
                WHERE ordernumber = 'P711019220527817'