2023-12-10 01:00:03 -- 將會員中心id寫入data-lake
2023-12-10 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 '2023-12-09%';
        
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336660'
                WHERE ordernumber = 'P421209100304145' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '299697'
                WHERE ordernumber = 'P421209104016213' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267331'
                WHERE ordernumber = 'P421209104546876' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289795'
                WHERE ordernumber = 'P201209110116822' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344253'
                WHERE ordernumber = 'P191209110127460' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324528'
                WHERE ordernumber = 'P191209110307179' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130759'
                WHERE ordernumber = 'P191209110452212' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349725'
                WHERE ordernumber = 'P191209110534452' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270818'
                WHERE ordernumber = 'P191209110947602' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200867'
                WHERE ordernumber = 'P181209111032936' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114534'
                WHERE ordernumber = 'P191209111058597' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351413'
                WHERE ordernumber = 'P191209111217205' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351414'
                WHERE ordernumber = 'P191209111340989' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247386'
                WHERE ordernumber = 'P421209111349477' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351415'
                WHERE ordernumber = 'P191209111730509' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351416'
                WHERE ordernumber = 'P181209111739781' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351417'
                WHERE ordernumber = 'P201209112058777' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351418'
                WHERE ordernumber = 'P191209112444372' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351419'
                WHERE ordernumber = 'P181209112552732' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P421209112602682' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351421'
                WHERE ordernumber = 'P201209112618115' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351420'
                WHERE ordernumber = 'P201209112715470' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176302'
                WHERE ordernumber = 'P421209112726453' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341608'
                WHERE ordernumber = 'P201209112755745' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348002'
                WHERE ordernumber = 'P421209112912538' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351422'
                WHERE ordernumber = 'P201209113015955' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107228'
                WHERE ordernumber = 'P191209113242784' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325043'
                WHERE ordernumber = 'P191209113512894' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176087'
                WHERE ordernumber = 'P191209113803582' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309537'
                WHERE ordernumber = 'P181209114029854' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351423'
                WHERE ordernumber = 'P191209114048207' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103779'
                WHERE ordernumber = 'P181209114214996' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '184739'
                WHERE ordernumber = 'P421209114525116' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351424'
                WHERE ordernumber = 'P421209114816780' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143853'
                WHERE ordernumber = 'P191209114829664' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143853'
                WHERE ordernumber = 'P191209114908352' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351425'
                WHERE ordernumber = 'P181209115125344' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241001'
                WHERE ordernumber = 'P181209115440690' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351426'
                WHERE ordernumber = 'P201209115916846' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351428'
                WHERE ordernumber = 'P421209120550460' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351429'
                WHERE ordernumber = 'P181209120617130' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324842'
                WHERE ordernumber = 'P421209120644165' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262372'
                WHERE ordernumber = 'P181209120703699' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324842'
                WHERE ordernumber = 'P421209120817542' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96919'
                WHERE ordernumber = 'P181209120830333' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351431'
                WHERE ordernumber = 'P201209120834429' 
            
2023-12-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95983'
                WHERE ordernumber = 'P201209120918169' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325774'
                WHERE ordernumber = 'P181209120947202' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338804'
                WHERE ordernumber = 'P181209121033471' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351432'
                WHERE ordernumber = 'P201209121047628' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351433'
                WHERE ordernumber = 'P201209121159858' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351434'
                WHERE ordernumber = 'P201209121237821' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333976'
                WHERE ordernumber = 'P191209121323728' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351435'
                WHERE ordernumber = 'P181209121354634' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351436'
                WHERE ordernumber = 'P201209121406362' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '183168'
                WHERE ordernumber = 'P191209121441916' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216329'
                WHERE ordernumber = 'P191209121620650' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154268'
                WHERE ordernumber = 'P201209121729732' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351437'
                WHERE ordernumber = 'P191209121842982' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98211'
                WHERE ordernumber = 'P191209122045112' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111574'
                WHERE ordernumber = 'P191209122304152' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275669'
                WHERE ordernumber = 'P191209122731522' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351439'
                WHERE ordernumber = 'P191209122922205' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246901'
                WHERE ordernumber = 'P191209123137233' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351441'
                WHERE ordernumber = 'P191209123607161' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291571'
                WHERE ordernumber = 'P421209123736563' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351442'
                WHERE ordernumber = 'P191209123831273' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191209123922298' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241279'
                WHERE ordernumber = 'P201209123948316' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299907'
                WHERE ordernumber = 'P421209124229778' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351444'
                WHERE ordernumber = 'P191209124446250' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246643'
                WHERE ordernumber = 'P191209124750976' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351440'
                WHERE ordernumber = 'P191209125002869' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351440'
                WHERE ordernumber = 'P191209125032728' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351445'
                WHERE ordernumber = 'P191209125204290' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351446'
                WHERE ordernumber = 'P421209125233151' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351447'
                WHERE ordernumber = 'P191209125329297' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225755'
                WHERE ordernumber = 'P181209125641113' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351449'
                WHERE ordernumber = 'P201209125825840' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348863'
                WHERE ordernumber = 'P201209130039780' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '133274'
                WHERE ordernumber = 'P191209130106469' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340385'
                WHERE ordernumber = 'P201209131516351' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121545'
                WHERE ordernumber = 'P191209131520265' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81434'
                WHERE ordernumber = 'P201209131648783' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267294'
                WHERE ordernumber = 'P181209131848453' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255520'
                WHERE ordernumber = 'P191209132804202' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158216'
                WHERE ordernumber = 'P201209133132622' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351457'
                WHERE ordernumber = 'P191209133247588' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '69626'
                WHERE ordernumber = 'P191209133727677' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287649'
                WHERE ordernumber = 'P181209134349677' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351290'
                WHERE ordernumber = 'P201209134405964' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351460'
                WHERE ordernumber = 'P191209134423462' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351462'
                WHERE ordernumber = 'P191209134900552' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298937'
                WHERE ordernumber = 'P421209134903797' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330275'
                WHERE ordernumber = 'P181209134936369' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162040'
                WHERE ordernumber = 'P421209135155617' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351463'
                WHERE ordernumber = 'P191209135305703' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337528'
                WHERE ordernumber = 'P421209135805429' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282048'
                WHERE ordernumber = 'P201209135925976' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '75134'
                WHERE ordernumber = 'P191209135927566' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345002'
                WHERE ordernumber = 'P421209140024995' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351464'
                WHERE ordernumber = 'P181209140051235' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282048'
                WHERE ordernumber = 'P201209140100561' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351465'
                WHERE ordernumber = 'P191209140139797' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351466'
                WHERE ordernumber = 'P181209140203616' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351465'
                WHERE ordernumber = 'P191209140312661' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351469'
                WHERE ordernumber = 'P191209141032269' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351469'
                WHERE ordernumber = 'P191209141155467' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351470'
                WHERE ordernumber = 'P421209141255518' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349966'
                WHERE ordernumber = 'P201209141257775' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351471'
                WHERE ordernumber = 'P191209141452892' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351472'
                WHERE ordernumber = 'P421209141556355' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230762'
                WHERE ordernumber = 'P191209141629857' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292136'
                WHERE ordernumber = 'P201209141708471' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351472'
                WHERE ordernumber = 'P421209141932436' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351474'
                WHERE ordernumber = 'P201209141941594' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351475'
                WHERE ordernumber = 'P191209142156943' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293002'
                WHERE ordernumber = 'P201209142429632' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343783'
                WHERE ordernumber = 'P191209143004817' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281358'
                WHERE ordernumber = 'P191209143218384' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '254478'
                WHERE ordernumber = 'P191209143334319' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351479'
                WHERE ordernumber = 'P421209143700214' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351481'
                WHERE ordernumber = 'P191209143852214' 
            
2023-12-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351482'
                WHERE ordernumber = 'P191209144017968' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351483'
                WHERE ordernumber = 'P191209144253618' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '285975'
                WHERE ordernumber = 'P191209144437374' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350982'
                WHERE ordernumber = 'P201209144451881' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351486'
                WHERE ordernumber = 'P421209144957216' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351487'
                WHERE ordernumber = 'P421209145332540' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351488'
                WHERE ordernumber = 'P191209145415766' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351489'
                WHERE ordernumber = 'P191209145551638' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351491'
                WHERE ordernumber = 'P421209145808436' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298283'
                WHERE ordernumber = 'P421209145956447' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351493'
                WHERE ordernumber = 'P191209150020513' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351493'
                WHERE ordernumber = 'P191209150057984' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212856'
                WHERE ordernumber = 'P191209150248210' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351494'
                WHERE ordernumber = 'P421209150311788' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351495'
                WHERE ordernumber = 'P201209150944597' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351496'
                WHERE ordernumber = 'P421209151103895' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351497'
                WHERE ordernumber = 'P421209151349348' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351498'
                WHERE ordernumber = 'P421209151825214' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '314211'
                WHERE ordernumber = 'P191209152208290' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351500'
                WHERE ordernumber = 'P191209152312957' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351503'
                WHERE ordernumber = 'P191209152526673' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351502'
                WHERE ordernumber = 'P181209152534995' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351504'
                WHERE ordernumber = 'P181209152636875' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100049'
                WHERE ordernumber = 'P201209153530387' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351506'
                WHERE ordernumber = 'P201209153854993' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351507'
                WHERE ordernumber = 'P191209153919733' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351508'
                WHERE ordernumber = 'P181209154032316' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351120'
                WHERE ordernumber = 'P191209154141338' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351510'
                WHERE ordernumber = 'P191209154354885' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102280'
                WHERE ordernumber = 'P181209154402938' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284827'
                WHERE ordernumber = 'P191209154503884' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141620'
                WHERE ordernumber = 'P181209154541698' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167805'
                WHERE ordernumber = 'P421209154551504' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351511'
                WHERE ordernumber = 'P181209154937585' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102862'
                WHERE ordernumber = 'P181209155701537' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351513'
                WHERE ordernumber = 'P191209155831939' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351517'
                WHERE ordernumber = 'P201209155956915' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351516'
                WHERE ordernumber = 'P421209160008287' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351518'
                WHERE ordernumber = 'P421209160132320' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351519'
                WHERE ordernumber = 'P201209160456410' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '41785'
                WHERE ordernumber = 'P201209160610796' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351521'
                WHERE ordernumber = 'P181209160634855' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235488'
                WHERE ordernumber = 'P181209160727901' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116470'
                WHERE ordernumber = 'P181209160825301' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245289'
                WHERE ordernumber = 'P181209160942227' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351522'
                WHERE ordernumber = 'P181209161112486' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209057'
                WHERE ordernumber = 'P201209161116768' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P201209161340459' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116470'
                WHERE ordernumber = 'P181209161515549' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311650'
                WHERE ordernumber = 'P201209161544776' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351524'
                WHERE ordernumber = 'P181209161651708' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350276'
                WHERE ordernumber = 'P181209161842837' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351525'
                WHERE ordernumber = 'P191209161849404' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '342524'
                WHERE ordernumber = 'P181209161946795' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P191209162032900' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '121120'
                WHERE ordernumber = 'P201209162340974' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283388'
                WHERE ordernumber = 'P201209162558821' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319847'
                WHERE ordernumber = 'P191209162639640' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299527'
                WHERE ordernumber = 'P201209163206688' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351526'
                WHERE ordernumber = 'P191209163247362' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98211'
                WHERE ordernumber = 'P191209163554339' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351528'
                WHERE ordernumber = 'P181209163652591' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351529'
                WHERE ordernumber = 'P191209163728854' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351530'
                WHERE ordernumber = 'P201209163745754' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351532'
                WHERE ordernumber = 'P201209164223410' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351533'
                WHERE ordernumber = 'P181209164433478' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351527'
                WHERE ordernumber = 'P201209164512270' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351527'
                WHERE ordernumber = 'P201209164540582' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351534'
                WHERE ordernumber = 'P201209165225193' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340122'
                WHERE ordernumber = 'P421209165340396' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351535'
                WHERE ordernumber = 'P181209165423289' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '341732'
                WHERE ordernumber = 'P181209165710484' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161195'
                WHERE ordernumber = 'P421209165729151' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351536'
                WHERE ordernumber = 'P421209170105856' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351537'
                WHERE ordernumber = 'P181209170251766' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272784'
                WHERE ordernumber = 'P201209170447844' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302658'
                WHERE ordernumber = 'P201209170602401' 
            
2023-12-10 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351538'
                WHERE ordernumber = 'P181209170805425' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '325850'
                WHERE ordernumber = 'P421209170842283' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '294135'
                WHERE ordernumber = 'P421209170930284' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349940'
                WHERE ordernumber = 'P181209171312600' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345673'
                WHERE ordernumber = 'P201209171357328' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301384'
                WHERE ordernumber = 'P191209171440446' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351539'
                WHERE ordernumber = 'P191209171626723' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '102664'
                WHERE ordernumber = 'P191209172125963' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351540'
                WHERE ordernumber = 'P421209172141921' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '112108'
                WHERE ordernumber = 'P191209172401624' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351541'
                WHERE ordernumber = 'P181209172432207' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351542'
                WHERE ordernumber = 'P181209172706275' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '225299'
                WHERE ordernumber = 'P201209172745999' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351543'
                WHERE ordernumber = 'P191209172822387' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351545'
                WHERE ordernumber = 'P181209173029215' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351546'
                WHERE ordernumber = 'P201209173237430' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351548'
                WHERE ordernumber = 'P421209173315914' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351549'
                WHERE ordernumber = 'P201209173337211' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351550'
                WHERE ordernumber = 'P181209173448656' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351552'
                WHERE ordernumber = 'P201209173805158' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351551'
                WHERE ordernumber = 'P181209173810984' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351553'
                WHERE ordernumber = 'P201209174403863' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '269692'
                WHERE ordernumber = 'P201209174712280' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '317043'
                WHERE ordernumber = 'P201209174858677' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351555'
                WHERE ordernumber = 'P201209175338248' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351557'
                WHERE ordernumber = 'P421209175746927' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351554'
                WHERE ordernumber = 'P191209175800736' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345522'
                WHERE ordernumber = 'P201209175934552' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351558'
                WHERE ordernumber = 'P191209180027620' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351560'
                WHERE ordernumber = 'P191209180344951' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351562'
                WHERE ordernumber = 'P191209180910111' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351563'
                WHERE ordernumber = 'P201209181358628' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351565'
                WHERE ordernumber = 'P191209181618328' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '102102'
                WHERE ordernumber = 'P191209182438209' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351566'
                WHERE ordernumber = 'P201209182555301' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351567'
                WHERE ordernumber = 'P191209182640344' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345634'
                WHERE ordernumber = 'P191209182747823' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351568'
                WHERE ordernumber = 'P201209182846545' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351569'
                WHERE ordernumber = 'P421209182949371' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351570'
                WHERE ordernumber = 'P421209184001735' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351572'
                WHERE ordernumber = 'P421209184338900' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351573'
                WHERE ordernumber = 'P421209184553518' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P191209185442638' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351574'
                WHERE ordernumber = 'P191209185621176' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '109486'
                WHERE ordernumber = 'P201209185659882' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351575'
                WHERE ordernumber = 'P191209185739664' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '350207'
                WHERE ordernumber = 'P191209185847567' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '40749'
                WHERE ordernumber = 'P191209190429418' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351577'
                WHERE ordernumber = 'P191209190814501' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '102179'
                WHERE ordernumber = 'P201209191001859' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351578'
                WHERE ordernumber = 'P191209191105635' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351579'
                WHERE ordernumber = 'P421209191152112' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '81675'
                WHERE ordernumber = 'P191209191709890' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301678'
                WHERE ordernumber = 'P201209191809896' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351580'
                WHERE ordernumber = 'P191209191839452' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351581'
                WHERE ordernumber = 'P201209192020682' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351582'
                WHERE ordernumber = 'P191209192219285' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351583'
                WHERE ordernumber = 'P201209192351386' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351584'
                WHERE ordernumber = 'P191209192419441' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '346356'
                WHERE ordernumber = 'P191209192909583' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351587'
                WHERE ordernumber = 'P421209193106403' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '97019'
                WHERE ordernumber = 'P191209193148941' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351588'
                WHERE ordernumber = 'P191209193418808' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351590'
                WHERE ordernumber = 'P191209193530617' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '304306'
                WHERE ordernumber = 'P191209193657790' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351591'
                WHERE ordernumber = 'P201209193800931' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351240'
                WHERE ordernumber = 'P201209194417802' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '216155'
                WHERE ordernumber = 'P421209194728776' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '286847'
                WHERE ordernumber = 'P201209195426815' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351595'
                WHERE ordernumber = 'P191209195756229' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '291912'
                WHERE ordernumber = 'P201209195848238' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351596'
                WHERE ordernumber = 'P421209200237483' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351597'
                WHERE ordernumber = 'P421209200421626' 
            
2023-12-10 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '336345'
                WHERE ordernumber = 'P201209200507950'