2024-03-30 01:00:03 -- 將會員中心id寫入data-lake
2024-03-30 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-03-29%';
        
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326775'
                WHERE ordernumber = 'P420329110114868' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376254'
                WHERE ordernumber = 'P190329110242329' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356322'
                WHERE ordernumber = 'P190329110456479' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383569'
                WHERE ordernumber = 'P190329110756507' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172874'
                WHERE ordernumber = 'P190329111016929' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372285'
                WHERE ordernumber = 'P190329111239690' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285919'
                WHERE ordernumber = 'P190329111452894' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P190329111625853' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383571'
                WHERE ordernumber = 'P190329111917761' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383571'
                WHERE ordernumber = 'P190329112438954' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255796'
                WHERE ordernumber = 'P180329112542340' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258271'
                WHERE ordernumber = 'P190329113032763' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223100'
                WHERE ordernumber = 'P190329113320725' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312702'
                WHERE ordernumber = 'P190329113531426' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383576'
                WHERE ordernumber = 'P190329113915567' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383578'
                WHERE ordernumber = 'P190329114405462' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115196'
                WHERE ordernumber = 'P190329114851442' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271209'
                WHERE ordernumber = 'P420329114945223' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287066'
                WHERE ordernumber = 'P190329115048500' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277801'
                WHERE ordernumber = 'P200329115053794' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383580'
                WHERE ordernumber = 'P420329115213833' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342581'
                WHERE ordernumber = 'P590329115656170' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364963'
                WHERE ordernumber = 'P190329120351153' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101187'
                WHERE ordernumber = 'P180329120459615' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364963'
                WHERE ordernumber = 'P190329120531553' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319604'
                WHERE ordernumber = 'P180329120641395' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275810'
                WHERE ordernumber = 'P200329121517417' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383439'
                WHERE ordernumber = 'P200329121653984' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383583'
                WHERE ordernumber = 'P190329121758557' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337850'
                WHERE ordernumber = 'P420329121809449' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214522'
                WHERE ordernumber = 'P420329122109356' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301918'
                WHERE ordernumber = 'P420329122707209' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P190329122723585' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383584'
                WHERE ordernumber = 'P200329122850697' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288950'
                WHERE ordernumber = 'P420329123206880' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383586'
                WHERE ordernumber = 'P200329123350610' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383587'
                WHERE ordernumber = 'P190329123812396' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297147'
                WHERE ordernumber = 'P420329123916701' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383588'
                WHERE ordernumber = 'P200329124028141' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246112'
                WHERE ordernumber = 'P190329124137785' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383590'
                WHERE ordernumber = 'P420329124257622' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383587'
                WHERE ordernumber = 'P190329124400230' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383592'
                WHERE ordernumber = 'P200329124817301' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383593'
                WHERE ordernumber = 'P190329125217233' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383594'
                WHERE ordernumber = 'P190329125621210' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95060'
                WHERE ordernumber = 'P200329125744978' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P420329125818407' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250618'
                WHERE ordernumber = 'P200329130009230' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '25647'
                WHERE ordernumber = 'P190329130554150' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260013'
                WHERE ordernumber = 'P200329131202273' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297418'
                WHERE ordernumber = 'P420329131413991' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383597'
                WHERE ordernumber = 'P190329131626608' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383597'
                WHERE ordernumber = 'P190329131707145' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142399'
                WHERE ordernumber = 'P420329132204472' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381646'
                WHERE ordernumber = 'P190329132408608' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383598'
                WHERE ordernumber = 'P200329132636287' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351211'
                WHERE ordernumber = 'P190329132742785' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213823'
                WHERE ordernumber = 'P200329132908598' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420329132942271' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272813'
                WHERE ordernumber = 'P200329133038830' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337565'
                WHERE ordernumber = 'P190329133146314' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327485'
                WHERE ordernumber = 'P200329133250118' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350876'
                WHERE ordernumber = 'P200329133404475' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342855'
                WHERE ordernumber = 'P200329133532871' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383599'
                WHERE ordernumber = 'P190329133628552' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379521'
                WHERE ordernumber = 'P200329133701481' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114984'
                WHERE ordernumber = 'P190329134029948' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383601'
                WHERE ordernumber = 'P190329134159806' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383602'
                WHERE ordernumber = 'P180329134305728' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383604'
                WHERE ordernumber = 'P180329134710202' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383546'
                WHERE ordernumber = 'P200329135108735' 
            
2024-03-30 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316477'
                WHERE ordernumber = 'P180329135216826' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383546'
                WHERE ordernumber = 'P200329135241121' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349687'
                WHERE ordernumber = 'P190329135252154' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200329135622533' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383605'
                WHERE ordernumber = 'P190329135846895' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200329135944625' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148666'
                WHERE ordernumber = 'P190329140053792' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360735'
                WHERE ordernumber = 'P190329140321629' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '3830'
                WHERE ordernumber = 'P190329140554306' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383607'
                WHERE ordernumber = 'P200329140654697' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377420'
                WHERE ordernumber = 'P190329140656118' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312771'
                WHERE ordernumber = 'P190329140900715' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285580'
                WHERE ordernumber = 'P180329140919203' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382277'
                WHERE ordernumber = 'P180329141122735' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287840'
                WHERE ordernumber = 'P200329141227421' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383608'
                WHERE ordernumber = 'P180329141548636' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383598'
                WHERE ordernumber = 'P200329141710724' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '275812'
                WHERE ordernumber = 'P180329141911979' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383609'
                WHERE ordernumber = 'P180329142102548' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125989'
                WHERE ordernumber = 'P180329142320682' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383610'
                WHERE ordernumber = 'P590329142603638' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383612'
                WHERE ordernumber = 'P190329143836382' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383614'
                WHERE ordernumber = 'P190329143951903' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93821'
                WHERE ordernumber = 'P190329144122624' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383615'
                WHERE ordernumber = 'P180329144146222' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374630'
                WHERE ordernumber = 'P200329144157185' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350645'
                WHERE ordernumber = 'P190329144549636' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382483'
                WHERE ordernumber = 'P190329145328397' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383619'
                WHERE ordernumber = 'P420329145501160' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380491'
                WHERE ordernumber = 'P420329145745117' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P180329150030408' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '308916'
                WHERE ordernumber = 'P180329150115290' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382272'
                WHERE ordernumber = 'P180329150413144' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251367'
                WHERE ordernumber = 'P420329150606722' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383620'
                WHERE ordernumber = 'P200329150614274' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383622'
                WHERE ordernumber = 'P180329150651245' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250051'
                WHERE ordernumber = 'P190329150703858' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383623'
                WHERE ordernumber = 'P200329150822400' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383625'
                WHERE ordernumber = 'P180329151549245' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200329152411472' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378684'
                WHERE ordernumber = 'P180329152504425' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378443'
                WHERE ordernumber = 'P190329152552752' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97453'
                WHERE ordernumber = 'P200329152642467' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383628'
                WHERE ordernumber = 'P180329152848768' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378443'
                WHERE ordernumber = 'P190329152900982' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383629'
                WHERE ordernumber = 'P180329153205365' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383630'
                WHERE ordernumber = 'P190329153247978' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383631'
                WHERE ordernumber = 'P180329153341464' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383632'
                WHERE ordernumber = 'P190329153407973' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238862'
                WHERE ordernumber = 'P180329153432361' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383633'
                WHERE ordernumber = 'P200329154003115' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378873'
                WHERE ordernumber = 'P200329154133441' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383634'
                WHERE ordernumber = 'P420329154209231' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310414'
                WHERE ordernumber = 'P180329154350871' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319079'
                WHERE ordernumber = 'P180329154917325' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383636'
                WHERE ordernumber = 'P180329155019456' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383637'
                WHERE ordernumber = 'P180329155703664' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382469'
                WHERE ordernumber = 'P190329155806132' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383638'
                WHERE ordernumber = 'P190329155942305' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383638'
                WHERE ordernumber = 'P190329160048267' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383639'
                WHERE ordernumber = 'P420329160334474' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378894'
                WHERE ordernumber = 'P420329160412154' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383640'
                WHERE ordernumber = 'P420329160642430' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380575'
                WHERE ordernumber = 'P200329160756334' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208671'
                WHERE ordernumber = 'P420329160838449' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383641'
                WHERE ordernumber = 'P420329161223343' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276741'
                WHERE ordernumber = 'P180329161539571' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297096'
                WHERE ordernumber = 'P420329161612322' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P200329161830243' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '365314'
                WHERE ordernumber = 'P190329162430746' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110539'
                WHERE ordernumber = 'P190329162518669' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182308'
                WHERE ordernumber = 'P180329162612511' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113187'
                WHERE ordernumber = 'P420329162612881' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94987'
                WHERE ordernumber = 'P190329163309600' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298622'
                WHERE ordernumber = 'P200329163329661' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252751'
                WHERE ordernumber = 'P180329163349878' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316745'
                WHERE ordernumber = 'P180329163823400' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P180329164503743' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371881'
                WHERE ordernumber = 'P180329164718847' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383643'
                WHERE ordernumber = 'P200329164729783' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383644'
                WHERE ordernumber = 'P180329165032615' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95542'
                WHERE ordernumber = 'P180329165204839' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364749'
                WHERE ordernumber = 'P190329165357236' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383412'
                WHERE ordernumber = 'P180329165449168' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383645'
                WHERE ordernumber = 'P190329165608205' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348237'
                WHERE ordernumber = 'P190329165721316' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101828'
                WHERE ordernumber = 'P200329165733651' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '375978'
                WHERE ordernumber = 'P180329165751142' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383646'
                WHERE ordernumber = 'P180329165952589' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383648'
                WHERE ordernumber = 'P200329170519269' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273469'
                WHERE ordernumber = 'P180329171005460' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237657'
                WHERE ordernumber = 'P180329171239475' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382488'
                WHERE ordernumber = 'P420329171303747' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294610'
                WHERE ordernumber = 'P200329171336174' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383649'
                WHERE ordernumber = 'P180329171438523' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383650'
                WHERE ordernumber = 'P180329171712937' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269333'
                WHERE ordernumber = 'P200329171859769' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383651'
                WHERE ordernumber = 'P180329171913784' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383652'
                WHERE ordernumber = 'P180329172136958' 
            
2024-03-30 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383653'
                WHERE ordernumber = 'P180329172242698' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383654'
                WHERE ordernumber = 'P180329172341919' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288090'
                WHERE ordernumber = 'P180329172445161' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383655'
                WHERE ordernumber = 'P180329172549691' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360180'
                WHERE ordernumber = 'P200329172747301' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282335'
                WHERE ordernumber = 'P200329173059991' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382918'
                WHERE ordernumber = 'P180329173523259' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382918'
                WHERE ordernumber = 'P180329173541887' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353809'
                WHERE ordernumber = 'P590329174102523' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383658'
                WHERE ordernumber = 'P420329174212365' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383656'
                WHERE ordernumber = 'P200329174258905' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281082'
                WHERE ordernumber = 'P200329174611441' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381756'
                WHERE ordernumber = 'P420329174616960' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281369'
                WHERE ordernumber = 'P200329174858700' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287777'
                WHERE ordernumber = 'P180329174902852' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383659'
                WHERE ordernumber = 'P180329175211710' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '273295'
                WHERE ordernumber = 'P200329175254499' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383661'
                WHERE ordernumber = 'P180329175608960' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383660'
                WHERE ordernumber = 'P200329175753627' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383662'
                WHERE ordernumber = 'P200329175948990' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368193'
                WHERE ordernumber = 'P200329180103238' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237225'
                WHERE ordernumber = 'P190329180653684' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '369485'
                WHERE ordernumber = 'P200329180851693' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '291522'
                WHERE ordernumber = 'P420329180920547' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383663'
                WHERE ordernumber = 'P420329181123448' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379193'
                WHERE ordernumber = 'P190329181214713' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95502'
                WHERE ordernumber = 'P190329181329859' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '102724'
                WHERE ordernumber = 'P180329181344488' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383618'
                WHERE ordernumber = 'P200329181724835' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297429'
                WHERE ordernumber = 'P420329181734768' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383664'
                WHERE ordernumber = 'P180329181759407' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383618'
                WHERE ordernumber = 'P200329181803452' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237363'
                WHERE ordernumber = 'P180329182226377' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255791'
                WHERE ordernumber = 'P420329182337428' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '230318'
                WHERE ordernumber = 'P180329182410959' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383666'
                WHERE ordernumber = 'P180329182645803' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180329182801808' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383667'
                WHERE ordernumber = 'P180329182859929' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '108462'
                WHERE ordernumber = 'P180329183034754' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '334388'
                WHERE ordernumber = 'P180329183455346' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '378327'
                WHERE ordernumber = 'P180329183620135' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383668'
                WHERE ordernumber = 'P180329183757190' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '297145'
                WHERE ordernumber = 'P420329183929828' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293625'
                WHERE ordernumber = 'P200329184013985' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '315127'
                WHERE ordernumber = 'P200329184351563' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227696'
                WHERE ordernumber = 'P180329184405482' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '255520'
                WHERE ordernumber = 'P180329184505675' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P180329184610979' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383670'
                WHERE ordernumber = 'P180329184741846' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383669'
                WHERE ordernumber = 'P200329184959836' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227696'
                WHERE ordernumber = 'P180329185030123' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383671'
                WHERE ordernumber = 'P190329185347367' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99654'
                WHERE ordernumber = 'P200329185357270' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383672'
                WHERE ordernumber = 'P190329185713672' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346556'
                WHERE ordernumber = 'P200329185934267' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383673'
                WHERE ordernumber = 'P420329190142639' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '163915'
                WHERE ordernumber = 'P190329190356518' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '254082'
                WHERE ordernumber = 'P190329190441552' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292330'
                WHERE ordernumber = 'P590329190446367' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383674'
                WHERE ordernumber = 'P190329190741681' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '63909'
                WHERE ordernumber = 'P200329191310460' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '380270'
                WHERE ordernumber = 'P420329191418851' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383676'
                WHERE ordernumber = 'P420329191603242' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '379609'
                WHERE ordernumber = 'P190329191851675' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383677'
                WHERE ordernumber = 'P420329192028697' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '92431'
                WHERE ordernumber = 'P200329192043611' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383678'
                WHERE ordernumber = 'P420329192139676' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '231953'
                WHERE ordernumber = 'P200329192156265' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383679'
                WHERE ordernumber = 'P190329192212858' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383680'
                WHERE ordernumber = 'P200329192911126' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383682'
                WHERE ordernumber = 'P420329193054314' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383683'
                WHERE ordernumber = 'P420329193204789' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383684'
                WHERE ordernumber = 'P420329193546552' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235646'
                WHERE ordernumber = 'P200329193627916' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80988'
                WHERE ordernumber = 'P190329193916738' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141215'
                WHERE ordernumber = 'P200329193931797' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256175'
                WHERE ordernumber = 'P190329193956667' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383685'
                WHERE ordernumber = 'P420329194015240' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383686'
                WHERE ordernumber = 'P420329194338253' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382885'
                WHERE ordernumber = 'P190329194345607' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298962'
                WHERE ordernumber = 'P200329194359524' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383533'
                WHERE ordernumber = 'P190329194540268' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '171274'
                WHERE ordernumber = 'P190329194607855' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383687'
                WHERE ordernumber = 'P420329194831654' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130240'
                WHERE ordernumber = 'P200329195409772' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236244'
                WHERE ordernumber = 'P200329195608250' 
            
2024-03-30 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383689'
                WHERE ordernumber = 'P590329202818668'