2023-12-18 01:00:03 -- 將會員中心id寫入data-lake
2023-12-18 01:00:03 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2023-12-17%';
        
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309039'
                WHERE ordernumber = 'P421217102022988' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P421217102710478' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319393'
                WHERE ordernumber = 'P421217102913843' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353014'
                WHERE ordernumber = 'P421217104305616' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314433'
                WHERE ordernumber = 'P181217110206482' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353017'
                WHERE ordernumber = 'P191217110431874' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '110061'
                WHERE ordernumber = 'P201217110552985' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338563'
                WHERE ordernumber = 'P191217110631363' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353019'
                WHERE ordernumber = 'P181217110728427' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353020'
                WHERE ordernumber = 'P191217110801475' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167252'
                WHERE ordernumber = 'P191217111057885' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273047'
                WHERE ordernumber = 'P181217111117789' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345943'
                WHERE ordernumber = 'P431217111127389' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352004'
                WHERE ordernumber = 'P201217111327251' 
            
2023-12-18 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351729'
                WHERE ordernumber = 'P181217111331306' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219616'
                WHERE ordernumber = 'P201217111445995' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '203004'
                WHERE ordernumber = 'P181217111513915' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353021'
                WHERE ordernumber = 'P181217111835760' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98128'
                WHERE ordernumber = 'P201217111922510' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326272'
                WHERE ordernumber = 'P181217112132184' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249105'
                WHERE ordernumber = 'P201217112451555' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315907'
                WHERE ordernumber = 'P191217112646504' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353022'
                WHERE ordernumber = 'P201217112706856' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97743'
                WHERE ordernumber = 'P181217112730995' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346597'
                WHERE ordernumber = 'P191217112814708' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352341'
                WHERE ordernumber = 'P201217112937280' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101158'
                WHERE ordernumber = 'P181217113510364' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353024'
                WHERE ordernumber = 'P181217113807851' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353025'
                WHERE ordernumber = 'P191217113910393' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353026'
                WHERE ordernumber = 'P181217114244225' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347544'
                WHERE ordernumber = 'P181217114338950' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '58721'
                WHERE ordernumber = 'P201217114411278' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P201217114450846' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140992'
                WHERE ordernumber = 'P421217114556870' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284722'
                WHERE ordernumber = 'P421217114738864' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P201217115455551' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142452'
                WHERE ordernumber = 'P201217115636740' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353027'
                WHERE ordernumber = 'P181217115946424' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285053'
                WHERE ordernumber = 'P421217120203776' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353028'
                WHERE ordernumber = 'P181217120205912' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353030'
                WHERE ordernumber = 'P181217120259603' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130600'
                WHERE ordernumber = 'P181217120447785' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353030'
                WHERE ordernumber = 'P181217120545807' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353031'
                WHERE ordernumber = 'P201217120554834' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353032'
                WHERE ordernumber = 'P421217120626578' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310730'
                WHERE ordernumber = 'P201217120758838' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '53269'
                WHERE ordernumber = 'P181217120923557' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353033'
                WHERE ordernumber = 'P181217121220801' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353035'
                WHERE ordernumber = 'P181217121414716' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243888'
                WHERE ordernumber = 'P201217121438733' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353037'
                WHERE ordernumber = 'P421217121854432' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353036'
                WHERE ordernumber = 'P181217122243519' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353039'
                WHERE ordernumber = 'P181217122658994' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353040'
                WHERE ordernumber = 'P181217122804360' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353041'
                WHERE ordernumber = 'P181217122852802' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353038'
                WHERE ordernumber = 'P181217123349411' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353038'
                WHERE ordernumber = 'P181217123416754' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353042'
                WHERE ordernumber = 'P201217123543987' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353043'
                WHERE ordernumber = 'P201217123705295' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353044'
                WHERE ordernumber = 'P181217123953230' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353045'
                WHERE ordernumber = 'P201217124121557' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353046'
                WHERE ordernumber = 'P181217124228592' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207272'
                WHERE ordernumber = 'P181217124336899' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207272'
                WHERE ordernumber = 'P181217124401384' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353047'
                WHERE ordernumber = 'P421217124807954' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304707'
                WHERE ordernumber = 'P201217125104578' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353048'
                WHERE ordernumber = 'P201217125358613' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353050'
                WHERE ordernumber = 'P201217130228486' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353053'
                WHERE ordernumber = 'P181217130727970' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353051'
                WHERE ordernumber = 'P201217130728192' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353055'
                WHERE ordernumber = 'P181217130926883' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139102'
                WHERE ordernumber = 'P181217130954292' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353058'
                WHERE ordernumber = 'P181217131812994' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353059'
                WHERE ordernumber = 'P421217132121916' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353060'
                WHERE ordernumber = 'P181217132313208' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290206'
                WHERE ordernumber = 'P201217132342617' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111308'
                WHERE ordernumber = 'P181217132401361' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331248'
                WHERE ordernumber = 'P181217132509592' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288455'
                WHERE ordernumber = 'P201217133456682' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244433'
                WHERE ordernumber = 'P421217134044121' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353063'
                WHERE ordernumber = 'P181217134640570' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353064'
                WHERE ordernumber = 'P181217134741364' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291152'
                WHERE ordernumber = 'P201217134901966' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353065'
                WHERE ordernumber = 'P201217135050309' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353066'
                WHERE ordernumber = 'P191217135054599' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103849'
                WHERE ordernumber = 'P201217135505290' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292257'
                WHERE ordernumber = 'P201217135553199' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156401'
                WHERE ordernumber = 'P181217135742324' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353068'
                WHERE ordernumber = 'P191217135854698' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348880'
                WHERE ordernumber = 'P181217135952706' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353069'
                WHERE ordernumber = 'P191217140033151' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212075'
                WHERE ordernumber = 'P181217140054739' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215027'
                WHERE ordernumber = 'P181217140221590' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353070'
                WHERE ordernumber = 'P421217141210259' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353071'
                WHERE ordernumber = 'P421217141325219' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265951'
                WHERE ordernumber = 'P201217141503187' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353075'
                WHERE ordernumber = 'P191217142029126' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353076'
                WHERE ordernumber = 'P191217142419522' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P181217142727383' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353077'
                WHERE ordernumber = 'P201217142729698' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353079'
                WHERE ordernumber = 'P191217142941243' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353080'
                WHERE ordernumber = 'P421217143344489' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P201217143346271' 
            
2023-12-18 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353081'
                WHERE ordernumber = 'P191217143509490' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353083'
                WHERE ordernumber = 'P181217143527964' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353082'
                WHERE ordernumber = 'P421217143539389' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353084'
                WHERE ordernumber = 'P191217143601906' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353086'
                WHERE ordernumber = 'P191217143643169' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353087'
                WHERE ordernumber = 'P421217143806967' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353088'
                WHERE ordernumber = 'P201217144330296' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353089'
                WHERE ordernumber = 'P201217144506217' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298196'
                WHERE ordernumber = 'P421217144520722' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353090'
                WHERE ordernumber = 'P201217144751780' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349510'
                WHERE ordernumber = 'P201217144934880' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353091'
                WHERE ordernumber = 'P181217144959360' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286609'
                WHERE ordernumber = 'P201217145217174' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232538'
                WHERE ordernumber = 'P191217145300811' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353092'
                WHERE ordernumber = 'P201217145405800' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353093'
                WHERE ordernumber = 'P191217145439256' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353094'
                WHERE ordernumber = 'P421217145612610' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353095'
                WHERE ordernumber = 'P191217145622948' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217881'
                WHERE ordernumber = 'P191217145756602' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P201217145844222' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353096'
                WHERE ordernumber = 'P191217145921550' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242754'
                WHERE ordernumber = 'P191217150055385' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353097'
                WHERE ordernumber = 'P421217150102473' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353098'
                WHERE ordernumber = 'P191217150157973' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353100'
                WHERE ordernumber = 'P181217150651217' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343878'
                WHERE ordernumber = 'P181217150822952' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256454'
                WHERE ordernumber = 'P191217150952756' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353101'
                WHERE ordernumber = 'P421217151108388' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352170'
                WHERE ordernumber = 'P191217151308675' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353102'
                WHERE ordernumber = 'P181217151323479' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351140'
                WHERE ordernumber = 'P181217151439629' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350155'
                WHERE ordernumber = 'P421217151552251' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353104'
                WHERE ordernumber = 'P181217151732656' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353105'
                WHERE ordernumber = 'P201217151900209' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353106'
                WHERE ordernumber = 'P421217152117243' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353107'
                WHERE ordernumber = 'P201217152323495' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353109'
                WHERE ordernumber = 'P181217152659936' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353110'
                WHERE ordernumber = 'P181217152745226' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353108'
                WHERE ordernumber = 'P191217152804925' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353111'
                WHERE ordernumber = 'P181217152846429' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '128950'
                WHERE ordernumber = 'P181217152946117' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353112'
                WHERE ordernumber = 'P421217153141701' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271615'
                WHERE ordernumber = 'P421217153510804' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '277273'
                WHERE ordernumber = 'P201217153559493' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353114'
                WHERE ordernumber = 'P181217153735819' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349622'
                WHERE ordernumber = 'P191217153828939' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353115'
                WHERE ordernumber = 'P181217153944186' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '311562'
                WHERE ordernumber = 'P421217154659883' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353116'
                WHERE ordernumber = 'P181217154756859' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161316'
                WHERE ordernumber = 'P421217154925532' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353117'
                WHERE ordernumber = 'P181217155336866' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263746'
                WHERE ordernumber = 'P421217155523639' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353120'
                WHERE ordernumber = 'P181217155612476' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '116605'
                WHERE ordernumber = 'P181217155837645' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263101'
                WHERE ordernumber = 'P201217155956382' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '296753'
                WHERE ordernumber = 'P421217160156830' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353121'
                WHERE ordernumber = 'P181217160415769' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223171'
                WHERE ordernumber = 'P191217160443718' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353123'
                WHERE ordernumber = 'P421217160521885' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353122'
                WHERE ordernumber = 'P201217160531868' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353124'
                WHERE ordernumber = 'P421217160654398' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P191217160757831' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '307328'
                WHERE ordernumber = 'P201217160935663' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353126'
                WHERE ordernumber = 'P191217161329281' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353127'
                WHERE ordernumber = 'P181217161333849' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P181217161430829' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '164605'
                WHERE ordernumber = 'P191217161519215' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '302346'
                WHERE ordernumber = 'P181217161539201' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351732'
                WHERE ordernumber = 'P191217161818231' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353128'
                WHERE ordernumber = 'P201217161854775' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353129'
                WHERE ordernumber = 'P181217162516552' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24'
                WHERE ordernumber = 'P201217162908297' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114993'
                WHERE ordernumber = 'P421217163228423' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353131'
                WHERE ordernumber = 'P181217163233916' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353132'
                WHERE ordernumber = 'P181217163426857' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353133'
                WHERE ordernumber = 'P181217163700445' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100823'
                WHERE ordernumber = 'P201217163700673' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353134'
                WHERE ordernumber = 'P191217163712707' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256574'
                WHERE ordernumber = 'P201217163836743' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353135'
                WHERE ordernumber = 'P181217163934778' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353136'
                WHERE ordernumber = 'P181217164255897' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288680'
                WHERE ordernumber = 'P181217164728764' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117320'
                WHERE ordernumber = 'P181217164941935' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353137'
                WHERE ordernumber = 'P201217165312139' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353139'
                WHERE ordernumber = 'P181217165435682' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353138'
                WHERE ordernumber = 'P201217165443285' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353140'
                WHERE ordernumber = 'P181217165823367' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '152068'
                WHERE ordernumber = 'P191217170714391' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353141'
                WHERE ordernumber = 'P191217170810342' 
            
2023-12-18 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103201'
                WHERE ordernumber = 'P191217170859900' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353142'
                WHERE ordernumber = 'P191217171146840' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '314372'
                WHERE ordernumber = 'P191217171342926' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353145'
                WHERE ordernumber = 'P191217171442441' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '314372'
                WHERE ordernumber = 'P191217171559163' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '238800'
                WHERE ordernumber = 'P191217171658586' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353147'
                WHERE ordernumber = 'P191217172121596' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '128982'
                WHERE ordernumber = 'P191217172216447' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353148'
                WHERE ordernumber = 'P181217172229611' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353149'
                WHERE ordernumber = 'P191217172342551' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353150'
                WHERE ordernumber = 'P181217172607575' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351693'
                WHERE ordernumber = 'P191217172927326' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353151'
                WHERE ordernumber = 'P181217173014927' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '243391'
                WHERE ordernumber = 'P181217173206829' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227822'
                WHERE ordernumber = 'P181217173516819' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '315885'
                WHERE ordernumber = 'P181217173603962' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334015'
                WHERE ordernumber = 'P201217174101772' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '334015'
                WHERE ordernumber = 'P201217174157193' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '227822'
                WHERE ordernumber = 'P181217174159991' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353157'
                WHERE ordernumber = 'P191217174217879' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P201217174832179' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353154'
                WHERE ordernumber = 'P421217174922245' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '268906'
                WHERE ordernumber = 'P201217175312385' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '290609'
                WHERE ordernumber = 'P201217175553656' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280290'
                WHERE ordernumber = 'P191217175626397' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P201217175728920' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P191217175819858' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353160'
                WHERE ordernumber = 'P191217180009322' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353161'
                WHERE ordernumber = 'P191217180605627' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '351437'
                WHERE ordernumber = 'P191217180802747' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353162'
                WHERE ordernumber = 'P191217181033245' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353163'
                WHERE ordernumber = 'P201217181123893' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '301547'
                WHERE ordernumber = 'P201217181203469' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353166'
                WHERE ordernumber = 'P191217181408286' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353165'
                WHERE ordernumber = 'P201217181723564' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353168'
                WHERE ordernumber = 'P191217181728613' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353169'
                WHERE ordernumber = 'P201217181835257' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P201217182025344' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '89714'
                WHERE ordernumber = 'P191217182514400' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353171'
                WHERE ordernumber = 'P191217182746922' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353172'
                WHERE ordernumber = 'P191217182932928' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '202335'
                WHERE ordernumber = 'P201217183127817' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353173'
                WHERE ordernumber = 'P191217183316207' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235075'
                WHERE ordernumber = 'P191217183443781' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '235075'
                WHERE ordernumber = 'P191217183523585' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353174'
                WHERE ordernumber = 'P191217183700447' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '120134'
                WHERE ordernumber = 'P191217184332906' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '298235'
                WHERE ordernumber = 'P201217184355475' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353176'
                WHERE ordernumber = 'P191217184615641' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353175'
                WHERE ordernumber = 'P201217184724200' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353177'
                WHERE ordernumber = 'P191217184855372' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '349339'
                WHERE ordernumber = 'P201217185155359' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353180'
                WHERE ordernumber = 'P421217190119613' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353181'
                WHERE ordernumber = 'P191217190120710' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '319184'
                WHERE ordernumber = 'P191217190240573' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353182'
                WHERE ordernumber = 'P201217190257133' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353183'
                WHERE ordernumber = 'P191217190401784' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353185'
                WHERE ordernumber = 'P191217190619976' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345622'
                WHERE ordernumber = 'P201217190850825' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '353186'
                WHERE ordernumber = 'P421217191105679' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '348969'
                WHERE ordernumber = 'P201217192219713' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '206592'
                WHERE ordernumber = 'P191217192626326' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P191217193152633' 
            
2023-12-18 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '259652'
                WHERE ordernumber = 'P191217194953114'