2024-07-29 01:00:03 -- 將會員中心id寫入data-lake
2024-07-29 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-07-28%';
        
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403535'
                WHERE ordernumber = 'P630728104559266' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403536'
                WHERE ordernumber = 'P630728104854482' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403536'
                WHERE ordernumber = 'P630728105436665' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403538'
                WHERE ordernumber = 'P180728110316397' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403538'
                WHERE ordernumber = 'P180728110356874' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340272'
                WHERE ordernumber = 'P420728110434363' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403541'
                WHERE ordernumber = 'P200728110638432' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230854'
                WHERE ordernumber = 'P190728110931799' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403543'
                WHERE ordernumber = 'P200728111108872' 
            
2024-07-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252156'
                WHERE ordernumber = 'P180728111134705' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P190728111158898' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403545'
                WHERE ordernumber = 'P420728111757707' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308920'
                WHERE ordernumber = 'P180728111804774' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403546'
                WHERE ordernumber = 'P420728111953426' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P190728112015937' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360897'
                WHERE ordernumber = 'P200728112607827' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403547'
                WHERE ordernumber = 'P180728112654752' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403548'
                WHERE ordernumber = 'P420728112729169' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390078'
                WHERE ordernumber = 'P200728112743940' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403552'
                WHERE ordernumber = 'P200728113424405' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403553'
                WHERE ordernumber = 'P180728113453225' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350922'
                WHERE ordernumber = 'P180728114123145' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403556'
                WHERE ordernumber = 'P180728114340160' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403557'
                WHERE ordernumber = 'P190728114348890' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403558'
                WHERE ordernumber = 'P200728114450689' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '57181'
                WHERE ordernumber = 'P180728114709980' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234207'
                WHERE ordernumber = 'P200728120027636' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403559'
                WHERE ordernumber = 'P190728120502480' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196514'
                WHERE ordernumber = 'P200728120754511' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403560'
                WHERE ordernumber = 'P420728121119711' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401384'
                WHERE ordernumber = 'P200728121300999' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403562'
                WHERE ordernumber = 'P180728121412705' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '201949'
                WHERE ordernumber = 'P420728121429935' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403565'
                WHERE ordernumber = 'P180728121554667' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81500'
                WHERE ordernumber = 'P420728121659833' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397128'
                WHERE ordernumber = 'P200728121834409' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '28813'
                WHERE ordernumber = 'P180728121841776' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403566'
                WHERE ordernumber = 'P190728122016743' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125535'
                WHERE ordernumber = 'P180728122106411' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403568'
                WHERE ordernumber = 'P420728122243995' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397034'
                WHERE ordernumber = 'P630728123022591' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299653'
                WHERE ordernumber = 'P420728123115501' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225389'
                WHERE ordernumber = 'P200728123209171' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317774'
                WHERE ordernumber = 'P180728123429828' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '218050'
                WHERE ordernumber = 'P180728123937994' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347375'
                WHERE ordernumber = 'P180728124604667' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403572'
                WHERE ordernumber = 'P190728124655938' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230389'
                WHERE ordernumber = 'P180728125704360' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306120'
                WHERE ordernumber = 'P200728130230475' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302943'
                WHERE ordernumber = 'P180728130346940' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403573'
                WHERE ordernumber = 'P420728130540266' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377353'
                WHERE ordernumber = 'P420728131613480' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103282'
                WHERE ordernumber = 'P180728132538590' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403574'
                WHERE ordernumber = 'P420728132950789' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403575'
                WHERE ordernumber = 'P420728133503625' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396930'
                WHERE ordernumber = 'P180728134624511' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403578'
                WHERE ordernumber = 'P420728134835364' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403580'
                WHERE ordernumber = 'P180728135445609' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403581'
                WHERE ordernumber = 'P420728135557805' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403583'
                WHERE ordernumber = 'P180728135830517' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403584'
                WHERE ordernumber = 'P200728140130921' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403585'
                WHERE ordernumber = 'P420728140224338' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397409'
                WHERE ordernumber = 'P180728140413726' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403586'
                WHERE ordernumber = 'P420728140505765' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403587'
                WHERE ordernumber = 'P190728141018890' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403588'
                WHERE ordernumber = 'P420728141243315' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326954'
                WHERE ordernumber = 'P200728141259478' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233907'
                WHERE ordernumber = 'P200728141348638' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403589'
                WHERE ordernumber = 'P420728141425572' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238452'
                WHERE ordernumber = 'P180728141430134' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284152'
                WHERE ordernumber = 'P200728141459511' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403590'
                WHERE ordernumber = 'P190728141559220' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253084'
                WHERE ordernumber = 'P590728141835214' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '327600'
                WHERE ordernumber = 'P420728142111941' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81675'
                WHERE ordernumber = 'P190728142557557' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228446'
                WHERE ordernumber = 'P190728143038783' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317853'
                WHERE ordernumber = 'P420728143113325' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '69979'
                WHERE ordernumber = 'P420728143212924' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396741'
                WHERE ordernumber = 'P420728143309123' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228446'
                WHERE ordernumber = 'P190728143442265' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271242'
                WHERE ordernumber = 'P200728143542851' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403594'
                WHERE ordernumber = 'P420728144229258' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403593'
                WHERE ordernumber = 'P190728144237443' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403595'
                WHERE ordernumber = 'P420728144647510' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '398107'
                WHERE ordernumber = 'P630728145021306' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403598'
                WHERE ordernumber = 'P420728145322801' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403600'
                WHERE ordernumber = 'P190728150022599' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397674'
                WHERE ordernumber = 'P630728150454418' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403604'
                WHERE ordernumber = 'P190728150716755' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403605'
                WHERE ordernumber = 'P420728150855876' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162476'
                WHERE ordernumber = 'P190728150929747' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403606'
                WHERE ordernumber = 'P420728151016690' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403609'
                WHERE ordernumber = 'P190728151531294' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403610'
                WHERE ordernumber = 'P420728151549470' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395158'
                WHERE ordernumber = 'P420728152058534' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351423'
                WHERE ordernumber = 'P190728152103903' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403612'
                WHERE ordernumber = 'P200728152325281' 
            
2024-07-29 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403613'
                WHERE ordernumber = 'P420728153039858' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403611'
                WHERE ordernumber = 'P180728153216895' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403614'
                WHERE ordernumber = 'P190728153257966' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403616'
                WHERE ordernumber = 'P200728153843808' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403617'
                WHERE ordernumber = 'P420728154130832' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '275698'
                WHERE ordernumber = 'P200728154214778' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283028'
                WHERE ordernumber = 'P420728154222973' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403619'
                WHERE ordernumber = 'P180728155220456' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357019'
                WHERE ordernumber = 'P420728155239508' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357019'
                WHERE ordernumber = 'P420728155351128' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403621'
                WHERE ordernumber = 'P420728155842420' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403623'
                WHERE ordernumber = 'P180728160509378' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393678'
                WHERE ordernumber = 'P180728160637813' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402602'
                WHERE ordernumber = 'P200728160710776' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218945'
                WHERE ordernumber = 'P200728160816362' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268585'
                WHERE ordernumber = 'P200728161051831' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273507'
                WHERE ordernumber = 'P180728161226362' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403626'
                WHERE ordernumber = 'P180728161745525' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403625'
                WHERE ordernumber = 'P180728161927147' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93869'
                WHERE ordernumber = 'P180728162109468' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403627'
                WHERE ordernumber = 'P190728162630214' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222245'
                WHERE ordernumber = 'P190728162934822' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357006'
                WHERE ordernumber = 'P200728163704669' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379347'
                WHERE ordernumber = 'P180728164137764' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388538'
                WHERE ordernumber = 'P420728164252956' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '398689'
                WHERE ordernumber = 'P180728164346918' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403629'
                WHERE ordernumber = 'P420728164423910' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403630'
                WHERE ordernumber = 'P420728164616618' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337854'
                WHERE ordernumber = 'P200728164952521' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403631'
                WHERE ordernumber = 'P190728165018941' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '166187'
                WHERE ordernumber = 'P190728165124864' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403632'
                WHERE ordernumber = 'P420728165228529' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360069'
                WHERE ordernumber = 'P190728165233943' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403633'
                WHERE ordernumber = 'P200728165607525' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403634'
                WHERE ordernumber = 'P420728165849120' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P180728170123297' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403635'
                WHERE ordernumber = 'P420728170225583' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403636'
                WHERE ordernumber = 'P200728170321924' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109870'
                WHERE ordernumber = 'P420728170342352' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403638'
                WHERE ordernumber = 'P200728170747277' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '312847'
                WHERE ordernumber = 'P190728170811838' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403639'
                WHERE ordernumber = 'P180728170817150' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307592'
                WHERE ordernumber = 'P180728171407934' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '157521'
                WHERE ordernumber = 'P420728171755639' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97047'
                WHERE ordernumber = 'P420728172426971' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301176'
                WHERE ordernumber = 'P420728172552669' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P180728172739749' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403640'
                WHERE ordernumber = 'P420728172917187' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403641'
                WHERE ordernumber = 'P420728173427248' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307277'
                WHERE ordernumber = 'P200728173721921' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399132'
                WHERE ordernumber = 'P190728174200146' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403642'
                WHERE ordernumber = 'P180728174231451' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403644'
                WHERE ordernumber = 'P420728174626538' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403602'
                WHERE ordernumber = 'P200728174814794' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403602'
                WHERE ordernumber = 'P200728174816181' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403647'
                WHERE ordernumber = 'P420728175055943' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403643'
                WHERE ordernumber = 'P180728175217475' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340795'
                WHERE ordernumber = 'P180728175403529' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '264223'
                WHERE ordernumber = 'P420728175810887' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '327193'
                WHERE ordernumber = 'P200728180003248' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403648'
                WHERE ordernumber = 'P200728180124970' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403649'
                WHERE ordernumber = 'P180728180217437' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403650'
                WHERE ordernumber = 'P200728180234866' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403651'
                WHERE ordernumber = 'P420728180316378' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403651'
                WHERE ordernumber = 'P420728180610442' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '303362'
                WHERE ordernumber = 'P420728181005157' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222989'
                WHERE ordernumber = 'P200728181210736' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403653'
                WHERE ordernumber = 'P420728181416474' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403654'
                WHERE ordernumber = 'P180728181434711' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403655'
                WHERE ordernumber = 'P200728181600318' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114279'
                WHERE ordernumber = 'P200728181650730' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403657'
                WHERE ordernumber = 'P420728181707202' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403658'
                WHERE ordernumber = 'P420728181935747' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233813'
                WHERE ordernumber = 'P200728181938667' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403659'
                WHERE ordernumber = 'P420728182050539' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353117'
                WHERE ordernumber = 'P180728182100675' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24507'
                WHERE ordernumber = 'P180728182234957' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403660'
                WHERE ordernumber = 'P420728182455800' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403661'
                WHERE ordernumber = 'P180728182459333' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403665'
                WHERE ordernumber = 'P420728183210280' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '120318'
                WHERE ordernumber = 'P180728183323787' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403666'
                WHERE ordernumber = 'P180728183702833' 
            
2024-07-29 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403646'
                WHERE ordernumber = 'P420728185101941' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403669'
                WHERE ordernumber = 'P190728185342236' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403671'
                WHERE ordernumber = 'P190728185510280' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403672'
                WHERE ordernumber = 'P190728185639183' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403673'
                WHERE ordernumber = 'P190728185848523' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403674'
                WHERE ordernumber = 'P190728190032198' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '371660'
                WHERE ordernumber = 'P190728190528939' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403377'
                WHERE ordernumber = 'P200728190706955' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403628'
                WHERE ordernumber = 'P190728191248700' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403628'
                WHERE ordernumber = 'P190728191310180' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269154'
                WHERE ordernumber = 'P190728191440566' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '278238'
                WHERE ordernumber = 'P200728192057867' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402818'
                WHERE ordernumber = 'P200728192325884' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '399661'
                WHERE ordernumber = 'P190728192437623' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '323657'
                WHERE ordernumber = 'P190728192615147' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403679'
                WHERE ordernumber = 'P200728192722564' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403680'
                WHERE ordernumber = 'P200728193228198' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '303420'
                WHERE ordernumber = 'P190728193512332' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403682'
                WHERE ordernumber = 'P200728193617877' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '897'
                WHERE ordernumber = 'P190728194415252' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403687'
                WHERE ordernumber = 'P200728194939790' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403689'
                WHERE ordernumber = 'P200728200003544' 
            
2024-07-29 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '249653'
                WHERE ordernumber = 'P590728203748922'