2024-11-04 01:00:02 -- 將會員中心id寫入data-lake
2024-11-04 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-11-03%';
        
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P421103110244497' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112837'
                WHERE ordernumber = 'P181103110448864' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385233'
                WHERE ordernumber = 'P421103110704303' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428739'
                WHERE ordernumber = 'P421103110805746' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428740'
                WHERE ordernumber = 'P181103111354247' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427360'
                WHERE ordernumber = 'P181103111545328' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '949'
                WHERE ordernumber = 'P181103111656874' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419738'
                WHERE ordernumber = 'P181103111840181' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101114'
                WHERE ordernumber = 'P201103111901408' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428744'
                WHERE ordernumber = 'P421103112203960' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428743'
                WHERE ordernumber = 'P421103112249966' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231091'
                WHERE ordernumber = 'P191103113022204' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428747'
                WHERE ordernumber = 'P191103113404488' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428745'
                WHERE ordernumber = 'P181103113632689' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428746'
                WHERE ordernumber = 'P191103113926423' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428749'
                WHERE ordernumber = 'P421103114202620' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384128'
                WHERE ordernumber = 'P201103114604562' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428750'
                WHERE ordernumber = 'P201103114832866' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428752'
                WHERE ordernumber = 'P201103120342879' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395552'
                WHERE ordernumber = 'P181103120514201' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390768'
                WHERE ordernumber = 'P191103120527720' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428753'
                WHERE ordernumber = 'P201103121010354' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428754'
                WHERE ordernumber = 'P201103122008510' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428755'
                WHERE ordernumber = 'P421103122156177' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428756'
                WHERE ordernumber = 'P201103122407832' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300072'
                WHERE ordernumber = 'P201103122505672' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428757'
                WHERE ordernumber = 'P421103123651550' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301109'
                WHERE ordernumber = 'P201103123807804' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428758'
                WHERE ordernumber = 'P421103123912993' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419981'
                WHERE ordernumber = 'P421103124035955' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428759'
                WHERE ordernumber = 'P201103124106715' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339611'
                WHERE ordernumber = 'P421103124613639' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428760'
                WHERE ordernumber = 'P421103124803361' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263960'
                WHERE ordernumber = 'P201103124942944' 
            
2024-11-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428763'
                WHERE ordernumber = 'P201103125432934' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425294'
                WHERE ordernumber = 'P201103125654433' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115120'
                WHERE ordernumber = 'P201103125821792' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391996'
                WHERE ordernumber = 'P201103130541342' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348809'
                WHERE ordernumber = 'P181103131130694' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428765'
                WHERE ordernumber = 'P181103131238545' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316185'
                WHERE ordernumber = 'P421103131454689' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276251'
                WHERE ordernumber = 'P201103131516316' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124404'
                WHERE ordernumber = 'P181103131548400' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363765'
                WHERE ordernumber = 'P181103131916901' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '30556'
                WHERE ordernumber = 'P191103132249644' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428766'
                WHERE ordernumber = 'P181103132526595' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428768'
                WHERE ordernumber = 'P421103132813349' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428767'
                WHERE ordernumber = 'P191103132855722' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428769'
                WHERE ordernumber = 'P201103132938377' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376937'
                WHERE ordernumber = 'P421103133026494' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296861'
                WHERE ordernumber = 'P201103133424874' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336831'
                WHERE ordernumber = 'P191103133424182' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428771'
                WHERE ordernumber = 'P771103133619686' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311517'
                WHERE ordernumber = 'P191103134223537' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319498'
                WHERE ordernumber = 'P201103134245289' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400474'
                WHERE ordernumber = 'P191103134558638' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427867'
                WHERE ordernumber = 'P201103134637337' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286306'
                WHERE ordernumber = 'P421103134654233' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330060'
                WHERE ordernumber = 'P201103134832758' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420802'
                WHERE ordernumber = 'P191103134854752' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428774'
                WHERE ordernumber = 'P421103134940219' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428713'
                WHERE ordernumber = 'P191103135324453' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428777'
                WHERE ordernumber = 'P421103135400165' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427947'
                WHERE ordernumber = 'P421103135559874' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428779'
                WHERE ordernumber = 'P201103135654254' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428778'
                WHERE ordernumber = 'P421103135842337' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246613'
                WHERE ordernumber = 'P201103140141769' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424256'
                WHERE ordernumber = 'P591103140158799' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275038'
                WHERE ordernumber = 'P421103140325437' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428773'
                WHERE ordernumber = 'P191103140341890' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295359'
                WHERE ordernumber = 'P201103140410463' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '854'
                WHERE ordernumber = 'P631103140556607' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218422'
                WHERE ordernumber = 'P421103140555887' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428783'
                WHERE ordernumber = 'P771103140714884' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384776'
                WHERE ordernumber = 'P421103140857381' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '40622'
                WHERE ordernumber = 'P191103141052565' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399140'
                WHERE ordernumber = 'P191103141138300' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380031'
                WHERE ordernumber = 'P201103141332846' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383688'
                WHERE ordernumber = 'P191103141411665' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428786'
                WHERE ordernumber = 'P421103141433902' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428785'
                WHERE ordernumber = 'P191103141855330' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428788'
                WHERE ordernumber = 'P421103142217414' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428790'
                WHERE ordernumber = 'P201103142239932' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428789'
                WHERE ordernumber = 'P421103142325868' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81972'
                WHERE ordernumber = 'P201103142409445' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428791'
                WHERE ordernumber = 'P421103142419405' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428792'
                WHERE ordernumber = 'P771103142455617' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428785'
                WHERE ordernumber = 'P191103142617243' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379879'
                WHERE ordernumber = 'P191103142841717' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428793'
                WHERE ordernumber = 'P421103142903550' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428794'
                WHERE ordernumber = 'P421103142945915' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339483'
                WHERE ordernumber = 'P421103143021931' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98457'
                WHERE ordernumber = 'P191103143128728' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398229'
                WHERE ordernumber = 'P181103143159278' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428797'
                WHERE ordernumber = 'P201103143729565' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226461'
                WHERE ordernumber = 'P181103143731647' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428796'
                WHERE ordernumber = 'P421103143737127' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '415720'
                WHERE ordernumber = 'P421103143807624' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226461'
                WHERE ordernumber = 'P181103144022767' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428799'
                WHERE ordernumber = 'P421103144029273' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428798'
                WHERE ordernumber = 'P181103144330884' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428800'
                WHERE ordernumber = 'P771103144636938' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428802'
                WHERE ordernumber = 'P421103145418596' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428803'
                WHERE ordernumber = 'P201103145604410' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428748'
                WHERE ordernumber = 'P181103145713420' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423063'
                WHERE ordernumber = 'P181103145926609' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428805'
                WHERE ordernumber = 'P771103150036302' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428804'
                WHERE ordernumber = 'P421103150041751' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428806'
                WHERE ordernumber = 'P771103150156746' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428807'
                WHERE ordernumber = 'P201103150330303' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428808'
                WHERE ordernumber = 'P421103150455766' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428809'
                WHERE ordernumber = 'P771103150915681' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291569'
                WHERE ordernumber = 'P421103151104381' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230896'
                WHERE ordernumber = 'P421103151156448' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428810'
                WHERE ordernumber = 'P771103151218506' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421502'
                WHERE ordernumber = 'P591103151708612' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428812'
                WHERE ordernumber = 'P771103151718774' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428813'
                WHERE ordernumber = 'P201103151751326' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428814'
                WHERE ordernumber = 'P771103152021283' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428813'
                WHERE ordernumber = 'P201103152614250' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421502'
                WHERE ordernumber = 'P591103152818344' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394018'
                WHERE ordernumber = 'P201103153030673' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428817'
                WHERE ordernumber = 'P181103153450547' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428818'
                WHERE ordernumber = 'P201103153811726' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '2588'
                WHERE ordernumber = 'P421103153839458' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428816'
                WHERE ordernumber = 'P181103154043535' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428819'
                WHERE ordernumber = 'P201103154118250' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102431'
                WHERE ordernumber = 'P181103154214833' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238232'
                WHERE ordernumber = 'P421103154239650' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428820'
                WHERE ordernumber = 'P181103154528606' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380921'
                WHERE ordernumber = 'P181103154651935' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281536'
                WHERE ordernumber = 'P181103154832658' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348294'
                WHERE ordernumber = 'P191103154908162' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417277'
                WHERE ordernumber = 'P201103155105920' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428821'
                WHERE ordernumber = 'P421103155607636' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428822'
                WHERE ordernumber = 'P201103155643749' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329527'
                WHERE ordernumber = 'P201103155952166' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428823'
                WHERE ordernumber = 'P201103160120579' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428751'
                WHERE ordernumber = 'P201103160336198' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428737'
                WHERE ordernumber = 'P181103160820961' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428825'
                WHERE ordernumber = 'P421103160945857' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428824'
                WHERE ordernumber = 'P631103161400319' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399042'
                WHERE ordernumber = 'P181103161419320' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99445'
                WHERE ordernumber = 'P201103161454745' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428826'
                WHERE ordernumber = 'P631103162441406' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428827'
                WHERE ordernumber = 'P201103162924183' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240484'
                WHERE ordernumber = 'P181103162958808' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425698'
                WHERE ordernumber = 'P181103163154810' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428828'
                WHERE ordernumber = 'P771103163210118' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407066'
                WHERE ordernumber = 'P201103163245826' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428831'
                WHERE ordernumber = 'P201103163600412' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428829'
                WHERE ordernumber = 'P421103163705901' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65608'
                WHERE ordernumber = 'P181103163723522' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284725'
                WHERE ordernumber = 'P421103163920640' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419924'
                WHERE ordernumber = 'P191103163924134' 
            
2024-11-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428832'
                WHERE ordernumber = 'P181103163948720' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428833'
                WHERE ordernumber = 'P201103164120576' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115981'
                WHERE ordernumber = 'P181103164458457' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '324545'
                WHERE ordernumber = 'P421103164704753' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425517'
                WHERE ordernumber = 'P181103164948270' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P191103165532504' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402812'
                WHERE ordernumber = 'P771103165810934' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428836'
                WHERE ordernumber = 'P201103170030112' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428835'
                WHERE ordernumber = 'P191103170538675' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409303'
                WHERE ordernumber = 'P421103170713833' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428837'
                WHERE ordernumber = 'P421103170718817' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383694'
                WHERE ordernumber = 'P191103170807337' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P421103170843765' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219550'
                WHERE ordernumber = 'P201103171346161' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428839'
                WHERE ordernumber = 'P201103171616408' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428839'
                WHERE ordernumber = 'P201103171731587' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428840'
                WHERE ordernumber = 'P771103172451471' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428841'
                WHERE ordernumber = 'P421103172539893' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97810'
                WHERE ordernumber = 'P191103172703350' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428842'
                WHERE ordernumber = 'P421103172837613' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285118'
                WHERE ordernumber = 'P191103172934483' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228096'
                WHERE ordernumber = 'P201103173027688' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428843'
                WHERE ordernumber = 'P771103173027131' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266697'
                WHERE ordernumber = 'P191103173141734' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428844'
                WHERE ordernumber = 'P181103173436600' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288606'
                WHERE ordernumber = 'P201103173645270' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107573'
                WHERE ordernumber = 'P181103173731479' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428846'
                WHERE ordernumber = 'P421103173828985' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428845'
                WHERE ordernumber = 'P421103173831504' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428847'
                WHERE ordernumber = 'P421103173833584' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404081'
                WHERE ordernumber = 'P421103174008474' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390946'
                WHERE ordernumber = 'P201103174156285' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428848'
                WHERE ordernumber = 'P181103174612439' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428849'
                WHERE ordernumber = 'P181103174758193' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389952'
                WHERE ordernumber = 'P201103175002264' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290965'
                WHERE ordernumber = 'P201103175300945' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428851'
                WHERE ordernumber = 'P201103175505718' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428853'
                WHERE ordernumber = 'P201103175737889' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428145'
                WHERE ordernumber = 'P421103175755767' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428854'
                WHERE ordernumber = 'P771103175854777' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213969'
                WHERE ordernumber = 'P771103180153135' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428855'
                WHERE ordernumber = 'P421103180308432' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428856'
                WHERE ordernumber = 'P421103180514243' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428857'
                WHERE ordernumber = 'P421103180814477' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291099'
                WHERE ordernumber = 'P201103181010602' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428858'
                WHERE ordernumber = 'P201103181116322' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376311'
                WHERE ordernumber = 'P421103181808752' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '207380'
                WHERE ordernumber = 'P181103181939932' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428859'
                WHERE ordernumber = 'P421103182204331' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428860'
                WHERE ordernumber = 'P421103182412229' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396308'
                WHERE ordernumber = 'P181103182802739' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263834'
                WHERE ordernumber = 'P181103182834274' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240018'
                WHERE ordernumber = 'P201103182851414' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428861'
                WHERE ordernumber = 'P421103182911456' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108266'
                WHERE ordernumber = 'P181103183049750' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428862'
                WHERE ordernumber = 'P771103183343476' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245587'
                WHERE ordernumber = 'P181103183605982' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372870'
                WHERE ordernumber = 'P181103183808833' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404111'
                WHERE ordernumber = 'P181103183851971' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377534'
                WHERE ordernumber = 'P181103183952838' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428865'
                WHERE ordernumber = 'P421103184635302' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239484'
                WHERE ordernumber = 'P201103185955270' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428867'
                WHERE ordernumber = 'P201103190223271' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428866'
                WHERE ordernumber = 'P771103190456865' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141604'
                WHERE ordernumber = 'P631103190634206' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428868'
                WHERE ordernumber = 'P201103190950697' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309750'
                WHERE ordernumber = 'P191103191522154' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '206507'
                WHERE ordernumber = 'P771103192658953' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360048'
                WHERE ordernumber = 'P191103192810478' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132136'
                WHERE ordernumber = 'P191103194447152' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '242508'
                WHERE ordernumber = 'P201103195632581' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428871'
                WHERE ordernumber = 'P771103203553819' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426482'
                WHERE ordernumber = 'P631103204123991' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298999'
                WHERE ordernumber = 'P771103210737621' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428875'
                WHERE ordernumber = 'P771103212057274' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428873'
                WHERE ordernumber = 'P771103212553146' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428878'
                WHERE ordernumber = 'P771103212745737' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428877'
                WHERE ordernumber = 'P771103213106375' 
            
2024-11-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '428875'
                WHERE ordernumber = 'P771103213327893'