2024-04-07 01:00:02 -- 將會員中心id寫入data-lake
2024-04-07 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-04-06%';
        
2024-04-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384577'
                WHERE ordernumber = 'P420406104446180' 
            
2024-04-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200406110156756' 
            
2024-04-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384578'
                WHERE ordernumber = 'P190406110413771' 
            
2024-04-07 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348114'
                WHERE ordernumber = 'P200406110517266' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384579'
                WHERE ordernumber = 'P180406110537461' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348114'
                WHERE ordernumber = 'P200406110544817' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P200406110944445' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245281'
                WHERE ordernumber = 'P200406111127622' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41058'
                WHERE ordernumber = 'P630406112105551' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384580'
                WHERE ordernumber = 'P630406112247932' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176927'
                WHERE ordernumber = 'P200406112504612' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176927'
                WHERE ordernumber = 'P200406112609693' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384583'
                WHERE ordernumber = 'P420406112803239' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257238'
                WHERE ordernumber = 'P420406112826470' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140759'
                WHERE ordernumber = 'P590406113244522' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213853'
                WHERE ordernumber = 'P180406113405675' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384584'
                WHERE ordernumber = 'P420406113628610' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384585'
                WHERE ordernumber = 'P180406113724115' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213853'
                WHERE ordernumber = 'P180406113906334' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384585'
                WHERE ordernumber = 'P180406114006607' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384586'
                WHERE ordernumber = 'P420406114137734' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384587'
                WHERE ordernumber = 'P180406114310794' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140510'
                WHERE ordernumber = 'P190406114610577' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384588'
                WHERE ordernumber = 'P420406114718603' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384589'
                WHERE ordernumber = 'P420406115048797' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212334'
                WHERE ordernumber = 'P190406115124565' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267420'
                WHERE ordernumber = 'P200406115157976' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384590'
                WHERE ordernumber = 'P420406115254617' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377604'
                WHERE ordernumber = 'P420406115404492' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288211'
                WHERE ordernumber = 'P180406115535677' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382837'
                WHERE ordernumber = 'P200406115715585' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384591'
                WHERE ordernumber = 'P200406120210155' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384592'
                WHERE ordernumber = 'P420406120502657' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375062'
                WHERE ordernumber = 'P200406120540309' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384593'
                WHERE ordernumber = 'P420406120622465' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384594'
                WHERE ordernumber = 'P180406120917393' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243032'
                WHERE ordernumber = 'P180406121225147' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384595'
                WHERE ordernumber = 'P630406121242770' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384596'
                WHERE ordernumber = 'P420406121305837' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384597'
                WHERE ordernumber = 'P200406121842602' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277801'
                WHERE ordernumber = 'P200406122023455' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384599'
                WHERE ordernumber = 'P180406122522522' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384600'
                WHERE ordernumber = 'P180406123124244' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384601'
                WHERE ordernumber = 'P200406123843742' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384602'
                WHERE ordernumber = 'P180406124111978' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384603'
                WHERE ordernumber = 'P420406124457565' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384604'
                WHERE ordernumber = 'P200406124852458' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381169'
                WHERE ordernumber = 'P180406124916190' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384605'
                WHERE ordernumber = 'P190406125055176' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339056'
                WHERE ordernumber = 'P420406125426320' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384606'
                WHERE ordernumber = 'P180406130102804' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384168'
                WHERE ordernumber = 'P180406130220502' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P180406130357468' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39674'
                WHERE ordernumber = 'P630406130744231' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384607'
                WHERE ordernumber = 'P630406131629507' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242246'
                WHERE ordernumber = 'P200406132908923' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236626'
                WHERE ordernumber = 'P630406132915805' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384608'
                WHERE ordernumber = 'P180406133113667' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384609'
                WHERE ordernumber = 'P420406133358121' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384610'
                WHERE ordernumber = 'P180406133426946' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262581'
                WHERE ordernumber = 'P180406133805495' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384611'
                WHERE ordernumber = 'P630406133849135' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384612'
                WHERE ordernumber = 'P420406134211808' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228365'
                WHERE ordernumber = 'P180406134412923' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367712'
                WHERE ordernumber = 'P420406135051342' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '62458'
                WHERE ordernumber = 'P200406135446378' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125999'
                WHERE ordernumber = 'P420406135733348' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384615'
                WHERE ordernumber = 'P630406135818925' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384616'
                WHERE ordernumber = 'P420406140050276' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384617'
                WHERE ordernumber = 'P420406140326633' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P200406140732518' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384615'
                WHERE ordernumber = 'P630406140803820' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348675'
                WHERE ordernumber = 'P420406140807900' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240810'
                WHERE ordernumber = 'P180406141003196' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341729'
                WHERE ordernumber = 'P420406141036271' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384619'
                WHERE ordernumber = 'P190406141256260' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308784'
                WHERE ordernumber = 'P200406141446530' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341550'
                WHERE ordernumber = 'P200406141733326' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384622'
                WHERE ordernumber = 'P180406141804131' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384621'
                WHERE ordernumber = 'P420406141814530' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351529'
                WHERE ordernumber = 'P190406142027207' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285894'
                WHERE ordernumber = 'P420406142501555' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384623'
                WHERE ordernumber = 'P420406142644280' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384624'
                WHERE ordernumber = 'P420406142848559' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307593'
                WHERE ordernumber = 'P180406142940572' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104252'
                WHERE ordernumber = 'P420406143024981' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320456'
                WHERE ordernumber = 'P200406143137583' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380203'
                WHERE ordernumber = 'P200406143331379' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200406143432349' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384625'
                WHERE ordernumber = 'P420406143509377' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282547'
                WHERE ordernumber = 'P180406143558499' 
            
2024-04-07 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384626'
                WHERE ordernumber = 'P180406144051792' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '329610'
                WHERE ordernumber = 'P420406144203111' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384627'
                WHERE ordernumber = 'P180406144446548' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384628'
                WHERE ordernumber = 'P180406144620431' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288121'
                WHERE ordernumber = 'P200406144756817' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282099'
                WHERE ordernumber = 'P180406150337442' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384630'
                WHERE ordernumber = 'P190406150402360' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384631'
                WHERE ordernumber = 'P180406150449625' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384631'
                WHERE ordernumber = 'P180406150603140' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384632'
                WHERE ordernumber = 'P200406150730398' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236901'
                WHERE ordernumber = 'P420406150931699' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384633'
                WHERE ordernumber = 'P420406151047332' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167600'
                WHERE ordernumber = 'P200406151130819' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359847'
                WHERE ordernumber = 'P200406151409942' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384634'
                WHERE ordernumber = 'P420406151635185' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337424'
                WHERE ordernumber = 'P180406151706431' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384635'
                WHERE ordernumber = 'P630406152408747' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378704'
                WHERE ordernumber = 'P420406152457357' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328914'
                WHERE ordernumber = 'P420406152546723' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384636'
                WHERE ordernumber = 'P180406152846864' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384637'
                WHERE ordernumber = 'P180406153026519' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128867'
                WHERE ordernumber = 'P200406153127931' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310543'
                WHERE ordernumber = 'P200406153259981' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384639'
                WHERE ordernumber = 'P630406153619727' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135637'
                WHERE ordernumber = 'P200406153749182' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273421'
                WHERE ordernumber = 'P200406153954849' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376254'
                WHERE ordernumber = 'P180406154052399' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384640'
                WHERE ordernumber = 'P200406154053377' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384641'
                WHERE ordernumber = 'P420406154125855' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384644'
                WHERE ordernumber = 'P180406154314542' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384645'
                WHERE ordernumber = 'P420406154324571' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384646'
                WHERE ordernumber = 'P200406154517895' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384647'
                WHERE ordernumber = 'P180406154605226' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230279'
                WHERE ordernumber = 'P190406154805198' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289840'
                WHERE ordernumber = 'P630406154858779' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '238439'
                WHERE ordernumber = 'P200406154929145' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384648'
                WHERE ordernumber = 'P630406155100448' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384649'
                WHERE ordernumber = 'P180406155350213' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357970'
                WHERE ordernumber = 'P200406155843505' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384650'
                WHERE ordernumber = 'P180406155959230' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81659'
                WHERE ordernumber = 'P190406160238282' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '253661'
                WHERE ordernumber = 'P180406160242906' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384651'
                WHERE ordernumber = 'P420406160636183' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98116'
                WHERE ordernumber = 'P180406160730423' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307031'
                WHERE ordernumber = 'P180406160922283' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384652'
                WHERE ordernumber = 'P180406161102889' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384653'
                WHERE ordernumber = 'P190406161126864' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357187'
                WHERE ordernumber = 'P190406161321826' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '65390'
                WHERE ordernumber = 'P180406161401308' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '55374'
                WHERE ordernumber = 'P200406161549119' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357591'
                WHERE ordernumber = 'P190406161722224' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260324'
                WHERE ordernumber = 'P200406162001282' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384654'
                WHERE ordernumber = 'P190406162008207' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '256216'
                WHERE ordernumber = 'P420406162116434' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380907'
                WHERE ordernumber = 'P200406162553674' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384656'
                WHERE ordernumber = 'P180406162940715' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384657'
                WHERE ordernumber = 'P420406163038746' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384655'
                WHERE ordernumber = 'P180406163129973' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384655'
                WHERE ordernumber = 'P180406163157677' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278377'
                WHERE ordernumber = 'P200406163200948' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384658'
                WHERE ordernumber = 'P420406163239924' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384659'
                WHERE ordernumber = 'P180406163310456' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384660'
                WHERE ordernumber = 'P200406163428457' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384661'
                WHERE ordernumber = 'P180406163711484' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384662'
                WHERE ordernumber = 'P180406163820730' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384663'
                WHERE ordernumber = 'P180406163909197' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381980'
                WHERE ordernumber = 'P200406164147491' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384665'
                WHERE ordernumber = 'P200406165011694' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384666'
                WHERE ordernumber = 'P200406165115636' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384667'
                WHERE ordernumber = 'P420406165216370' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '4562'
                WHERE ordernumber = 'P630406165758351' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349236'
                WHERE ordernumber = 'P200406170056667' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384670'
                WHERE ordernumber = 'P200406170910929' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384669'
                WHERE ordernumber = 'P590406171150796' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382139'
                WHERE ordernumber = 'P630406171308304' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384671'
                WHERE ordernumber = 'P200406171321388' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384672'
                WHERE ordernumber = 'P200406171458525' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383379'
                WHERE ordernumber = 'P180406171942189' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125995'
                WHERE ordernumber = 'P180406172152568' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378873'
                WHERE ordernumber = 'P200406172636900' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271182'
                WHERE ordernumber = 'P190406172758823' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306208'
                WHERE ordernumber = 'P200406173234424' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384673'
                WHERE ordernumber = 'P200406173623445' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380765'
                WHERE ordernumber = 'P420406173857539' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274429'
                WHERE ordernumber = 'P420406174058645' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384674'
                WHERE ordernumber = 'P180406174130989' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373851'
                WHERE ordernumber = 'P420406174320133' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384675'
                WHERE ordernumber = 'P180406174555468' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223674'
                WHERE ordernumber = 'P180406175537146' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325115'
                WHERE ordernumber = 'P180406180128376' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384677'
                WHERE ordernumber = 'P420406180200669' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384678'
                WHERE ordernumber = 'P200406181050957' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312274'
                WHERE ordernumber = 'P200406181142670' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384679'
                WHERE ordernumber = 'P180406182602892' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384680'
                WHERE ordernumber = 'P180406182757751' 
            
2024-04-07 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384681'
                WHERE ordernumber = 'P190406184259549' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384676'
                WHERE ordernumber = 'P190406184452268' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384682'
                WHERE ordernumber = 'P590406185844617' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279810'
                WHERE ordernumber = 'P190406190129322' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384684'
                WHERE ordernumber = 'P420406190509566' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304571'
                WHERE ordernumber = 'P190406191221674' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384685'
                WHERE ordernumber = 'P420406191306724' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384686'
                WHERE ordernumber = 'P190406191320157' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384688'
                WHERE ordernumber = 'P190406191459515' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384689'
                WHERE ordernumber = 'P190406192002489' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384690'
                WHERE ordernumber = 'P190406192134631' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384691'
                WHERE ordernumber = 'P190406192240111' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353091'
                WHERE ordernumber = 'P190406192358888' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384688'
                WHERE ordernumber = 'P190406192543833' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '228154'
                WHERE ordernumber = 'P200406193514874' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '376569'
                WHERE ordernumber = 'P190406194349454' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '381869'
                WHERE ordernumber = 'P190406195340970' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384693'
                WHERE ordernumber = 'P200406195700371' 
            
2024-04-07 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '384695'
                WHERE ordernumber = 'P630406204018638'