2024-09-09 01:00:01 -- 將會員中心id寫入data-lake
2024-09-09 01:00:01 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-09-08%';
        
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419912'
                WHERE ordernumber = 'P420908110359211' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271516'
                WHERE ordernumber = 'P200908110412702' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419913'
                WHERE ordernumber = 'P420908110512194' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231963'
                WHERE ordernumber = 'P190908110549290' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419902'
                WHERE ordernumber = 'P180908110602209' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378836'
                WHERE ordernumber = 'P420908110717557' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373337'
                WHERE ordernumber = 'P200908110820682' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419908'
                WHERE ordernumber = 'P630908110927269' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326142'
                WHERE ordernumber = 'P200908110931570' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417994'
                WHERE ordernumber = 'P420908111026216' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417994'
                WHERE ordernumber = 'P420908111157858' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306780'
                WHERE ordernumber = 'P180908111228251' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '335278'
                WHERE ordernumber = 'P420908111321241' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244494'
                WHERE ordernumber = 'P200908111503430' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419910'
                WHERE ordernumber = 'P420908111700811' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '17684'
                WHERE ordernumber = 'P200908111744406' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419750'
                WHERE ordernumber = 'P420908111909220' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '200945'
                WHERE ordernumber = 'P200908112028843' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419177'
                WHERE ordernumber = 'P190908112114637' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419177'
                WHERE ordernumber = 'P190908112150408' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419925'
                WHERE ordernumber = 'P420908112218790' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419918'
                WHERE ordernumber = 'P200908112333170' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279068'
                WHERE ordernumber = 'P200908112517955' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419917'
                WHERE ordernumber = 'P180908112712976' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417650'
                WHERE ordernumber = 'P200908112823284' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '69296'
                WHERE ordernumber = 'P420908112951692' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418948'
                WHERE ordernumber = 'P200908113151137' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310855'
                WHERE ordernumber = 'P180908113221993' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419853'
                WHERE ordernumber = 'P420908113249606' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372901'
                WHERE ordernumber = 'P420908113505875' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97996'
                WHERE ordernumber = 'P200908113505324' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418414'
                WHERE ordernumber = 'P200908113629319' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419926'
                WHERE ordernumber = 'P190908113655874' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419928'
                WHERE ordernumber = 'P180908113726940' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131151'
                WHERE ordernumber = 'P200908113729443' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419933'
                WHERE ordernumber = 'P420908113745228' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '414693'
                WHERE ordernumber = 'P420908113829171' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419927'
                WHERE ordernumber = 'P180908113846952' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419935'
                WHERE ordernumber = 'P420908114015223' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279068'
                WHERE ordernumber = 'P200908114130793' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419940'
                WHERE ordernumber = 'P420908114224294' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137260'
                WHERE ordernumber = 'P200908114430370' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415098'
                WHERE ordernumber = 'P420908114507732' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419919'
                WHERE ordernumber = 'P420908114645619' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419945'
                WHERE ordernumber = 'P420908114748923' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419930'
                WHERE ordernumber = 'P180908114934504' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288062'
                WHERE ordernumber = 'P420908115034214' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419939'
                WHERE ordernumber = 'P180908115054865' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379322'
                WHERE ordernumber = 'P420908115210493' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419932'
                WHERE ordernumber = 'P190908115211497' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264556'
                WHERE ordernumber = 'P200908115256589' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406363'
                WHERE ordernumber = 'P190908115339705' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419931'
                WHERE ordernumber = 'P180908115402996' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419947'
                WHERE ordernumber = 'P420908115411262' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107983'
                WHERE ordernumber = 'P190908115437719' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419929'
                WHERE ordernumber = 'P190908115532989' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419941'
                WHERE ordernumber = 'P180908115541504' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394941'
                WHERE ordernumber = 'P180908115651581' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419943'
                WHERE ordernumber = 'P180908115917573' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419949'
                WHERE ordernumber = 'P420908115921971' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419943'
                WHERE ordernumber = 'P180908120001777' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419951'
                WHERE ordernumber = 'P420908120231174' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419952'
                WHERE ordernumber = 'P200908120300421' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396050'
                WHERE ordernumber = 'P180908120333618' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342239'
                WHERE ordernumber = 'P180908120450319' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419953'
                WHERE ordernumber = 'P420908120506246' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418694'
                WHERE ordernumber = 'P200908120534528' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419954'
                WHERE ordernumber = 'P420908120913335' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419955'
                WHERE ordernumber = 'P420908121023365' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '91211'
                WHERE ordernumber = 'P200908121457455' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413657'
                WHERE ordernumber = 'P420908121727167' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419957'
                WHERE ordernumber = 'P420908121757242' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419958'
                WHERE ordernumber = 'P200908122104913' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378660'
                WHERE ordernumber = 'P200908122225919' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419664'
                WHERE ordernumber = 'P420908122239776' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230008'
                WHERE ordernumber = 'P190908122259996' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419154'
                WHERE ordernumber = 'P420908122354994' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419959'
                WHERE ordernumber = 'P420908122630905' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '111741'
                WHERE ordernumber = 'P180908122709161' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219046'
                WHERE ordernumber = 'P420908122733584' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217299'
                WHERE ordernumber = 'P200908122813615' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217299'
                WHERE ordernumber = 'P200908122832403' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372726'
                WHERE ordernumber = 'P200908122945576' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224223'
                WHERE ordernumber = 'P180908123034629' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419902'
                WHERE ordernumber = 'P180908123200493' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302307'
                WHERE ordernumber = 'P200908123252265' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419934'
                WHERE ordernumber = 'P180908123429713' 
            
2024-09-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P200908123444363' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162872'
                WHERE ordernumber = 'P200908123803483' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419961'
                WHERE ordernumber = 'P420908123855475' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419963'
                WHERE ordernumber = 'P180908124221481' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418856'
                WHERE ordernumber = 'P200908124356348' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419964'
                WHERE ordernumber = 'P420908124907539' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419965'
                WHERE ordernumber = 'P420908125003747' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419966'
                WHERE ordernumber = 'P420908125140675' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302680'
                WHERE ordernumber = 'P180908125303234' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419967'
                WHERE ordernumber = 'P420908125317337' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268622'
                WHERE ordernumber = 'P420908125437915' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405141'
                WHERE ordernumber = 'P200908125521632' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419968'
                WHERE ordernumber = 'P420908125609631' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369295'
                WHERE ordernumber = 'P200908125614290' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419970'
                WHERE ordernumber = 'P420908125728664' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409578'
                WHERE ordernumber = 'P420908125805452' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238603'
                WHERE ordernumber = 'P200908125826555' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419971'
                WHERE ordernumber = 'P420908125924238' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393998'
                WHERE ordernumber = 'P200908130129593' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361959'
                WHERE ordernumber = 'P180908130347282' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371745'
                WHERE ordernumber = 'P420908130354510' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408047'
                WHERE ordernumber = 'P200908130635677' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418846'
                WHERE ordernumber = 'P190908130717145' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408047'
                WHERE ordernumber = 'P200908130733299' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337401'
                WHERE ordernumber = 'P420908130740793' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419973'
                WHERE ordernumber = 'P420908131047956' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419974'
                WHERE ordernumber = 'P420908131156767' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111329'
                WHERE ordernumber = 'P420908131231389' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418554'
                WHERE ordernumber = 'P420908131324117' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419975'
                WHERE ordernumber = 'P420908131420732' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419976'
                WHERE ordernumber = 'P420908131527356' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415582'
                WHERE ordernumber = 'P200908132223357' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288950'
                WHERE ordernumber = 'P200908132611782' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418520'
                WHERE ordernumber = 'P200908132757794' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419977'
                WHERE ordernumber = 'P420908132822692' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419980'
                WHERE ordernumber = 'P420908132945371' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419981'
                WHERE ordernumber = 'P420908133429524' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404976'
                WHERE ordernumber = 'P420908133530125' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419901'
                WHERE ordernumber = 'P420908133941557' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418737'
                WHERE ordernumber = 'P200908134249307' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419983'
                WHERE ordernumber = 'P200908134450242' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419901'
                WHERE ordernumber = 'P420908134515459' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419901'
                WHERE ordernumber = 'P420908134609510' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419985'
                WHERE ordernumber = 'P420908134823895' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419987'
                WHERE ordernumber = 'P420908135012966' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419901'
                WHERE ordernumber = 'P420908135140996' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419988'
                WHERE ordernumber = 'P200908135344272' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137626'
                WHERE ordernumber = 'P190908135356406' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419989'
                WHERE ordernumber = 'P420908135451140' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420908135605634' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137626'
                WHERE ordernumber = 'P190908135624542' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419990'
                WHERE ordernumber = 'P420908135718512' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419991'
                WHERE ordernumber = 'P420908140040401' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390816'
                WHERE ordernumber = 'P630908140059483' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419992'
                WHERE ordernumber = 'P420908140156738' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419994'
                WHERE ordernumber = 'P420908140453769' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419995'
                WHERE ordernumber = 'P420908140557809' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250283'
                WHERE ordernumber = 'P180908140558723' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166311'
                WHERE ordernumber = 'P200908140602265' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419994'
                WHERE ordernumber = 'P420908140626997' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180908140717909' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419996'
                WHERE ordernumber = 'P420908140751932' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253323'
                WHERE ordernumber = 'P420908140931914' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419997'
                WHERE ordernumber = 'P420908141124633' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312644'
                WHERE ordernumber = 'P200908141200738' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417449'
                WHERE ordernumber = 'P420908141218288' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200908141243656' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413149'
                WHERE ordernumber = 'P200908141459426' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419998'
                WHERE ordernumber = 'P420908141525476' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90592'
                WHERE ordernumber = 'P420908141712539' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90592'
                WHERE ordernumber = 'P420908141939819' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419999'
                WHERE ordernumber = 'P200908142649392' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '129091'
                WHERE ordernumber = 'P190908142803196' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407965'
                WHERE ordernumber = 'P180908142814760' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420002'
                WHERE ordernumber = 'P420908143008406' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420003'
                WHERE ordernumber = 'P200908143049372' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420004'
                WHERE ordernumber = 'P420908143151442' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304155'
                WHERE ordernumber = 'P630908143642641' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420007'
                WHERE ordernumber = 'P420908143812917' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420009'
                WHERE ordernumber = 'P420908144454159' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420010'
                WHERE ordernumber = 'P420908144556483' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416707'
                WHERE ordernumber = 'P180908145034270' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419914'
                WHERE ordernumber = 'P180908145251758' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420012'
                WHERE ordernumber = 'P420908145326214' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420013'
                WHERE ordernumber = 'P420908145611326' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '411487'
                WHERE ordernumber = 'P180908145645257' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415401'
                WHERE ordernumber = 'P420908145740193' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420014'
                WHERE ordernumber = 'P420908145932111' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420015'
                WHERE ordernumber = 'P420908150024529' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420016'
                WHERE ordernumber = 'P420908150224401' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420019'
                WHERE ordernumber = 'P420908150445608' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420020'
                WHERE ordernumber = 'P420908151013458' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287194'
                WHERE ordernumber = 'P180908151343526' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414522'
                WHERE ordernumber = 'P420908151530372' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415967'
                WHERE ordernumber = 'P200908151743674' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420021'
                WHERE ordernumber = 'P420908151836717' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420023'
                WHERE ordernumber = 'P420908151948593' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419970'
                WHERE ordernumber = 'P200908152001944' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420024'
                WHERE ordernumber = 'P200908152149116' 
            
2024-09-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418569'
                WHERE ordernumber = 'P420908152216262' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420027'
                WHERE ordernumber = 'P420908152500130' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245637'
                WHERE ordernumber = 'P180908153001202' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392656'
                WHERE ordernumber = 'P200908153110449' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110093'
                WHERE ordernumber = 'P200908153534575' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420028'
                WHERE ordernumber = 'P200908153809297' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420030'
                WHERE ordernumber = 'P420908154027752' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414113'
                WHERE ordernumber = 'P190908154039798' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419986'
                WHERE ordernumber = 'P200908154058995' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '415119'
                WHERE ordernumber = 'P420908154117568' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413149'
                WHERE ordernumber = 'P200908154228446' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128818'
                WHERE ordernumber = 'P180908154429810' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '44865'
                WHERE ordernumber = 'P420908154453552' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420031'
                WHERE ordernumber = 'P200908154511846' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401189'
                WHERE ordernumber = 'P200908154635747' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420032'
                WHERE ordernumber = 'P420908154814611' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420033'
                WHERE ordernumber = 'P420908155250866' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420034'
                WHERE ordernumber = 'P420908155418222' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404252'
                WHERE ordernumber = 'P200908155726446' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420035'
                WHERE ordernumber = 'P420908160231677' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404145'
                WHERE ordernumber = 'P420908161451455' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286826'
                WHERE ordernumber = 'P200908161509465' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333498'
                WHERE ordernumber = 'P420908161615587' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420038'
                WHERE ordernumber = 'P420908161756304' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92425'
                WHERE ordernumber = 'P200908162100294' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '92425'
                WHERE ordernumber = 'P200908162359334' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411200'
                WHERE ordernumber = 'P420908162846149' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411200'
                WHERE ordernumber = 'P420908163008959' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '112924'
                WHERE ordernumber = 'P180908163702662' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419897'
                WHERE ordernumber = 'P180908165613720' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366602'
                WHERE ordernumber = 'P180908170027355' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420048'
                WHERE ordernumber = 'P420908172527571' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '311075'
                WHERE ordernumber = 'P200908172529178' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407275'
                WHERE ordernumber = 'P420908172912129' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420050'
                WHERE ordernumber = 'P420908173521697' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420052'
                WHERE ordernumber = 'P420908175133839' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420059'
                WHERE ordernumber = 'P420908181226461' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420060'
                WHERE ordernumber = 'P420908182451746' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420061'
                WHERE ordernumber = 'P420908182642959' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420061'
                WHERE ordernumber = 'P420908182853785' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420063'
                WHERE ordernumber = 'P420908183055698' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367480'
                WHERE ordernumber = 'P200908183345768' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420065'
                WHERE ordernumber = 'P420908185017472' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420066'
                WHERE ordernumber = 'P200908185333648' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114142'
                WHERE ordernumber = 'P180908185412586' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418639'
                WHERE ordernumber = 'P420908191137538' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248644'
                WHERE ordernumber = 'P190908192254752' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '420073'
                WHERE ordernumber = 'P200908194837881' 
            
2024-09-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '408247'
                WHERE ordernumber = 'P180908195336119'