2024-06-25 01:00:02 -- 將會員中心id寫入data-lake
2024-06-25 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-06-24%';
        
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396532'
                WHERE ordernumber = 'P630624104015433' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397771'
                WHERE ordernumber = 'P420624110130409' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397774'
                WHERE ordernumber = 'P180624110516290' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '361235'
                WHERE ordernumber = 'P200624110538481' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397772'
                WHERE ordernumber = 'P630624110545407' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397774'
                WHERE ordernumber = 'P180624110606532' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397773'
                WHERE ordernumber = 'P190624110618378' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397775'
                WHERE ordernumber = 'P200624110619937' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255078'
                WHERE ordernumber = 'P200624110715945' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391122'
                WHERE ordernumber = 'P190624110744454' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '255078'
                WHERE ordernumber = 'P200624110748319' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397776'
                WHERE ordernumber = 'P180624110759310' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397777'
                WHERE ordernumber = 'P200624110902532' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378722'
                WHERE ordernumber = 'P180624110929233' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '42157'
                WHERE ordernumber = 'P190624111039977' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397778'
                WHERE ordernumber = 'P200624111128329' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397779'
                WHERE ordernumber = 'P180624111201836' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397780'
                WHERE ordernumber = 'P420624111845543' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395557'
                WHERE ordernumber = 'P190624111920510' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393875'
                WHERE ordernumber = 'P200624111959531' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397782'
                WHERE ordernumber = 'P190624112213189' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397781'
                WHERE ordernumber = 'P630624112220405' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397782'
                WHERE ordernumber = 'P190624112315195' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279525'
                WHERE ordernumber = 'P190624112426897' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359176'
                WHERE ordernumber = 'P630624112509241' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241465'
                WHERE ordernumber = 'P190624112702725' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397785'
                WHERE ordernumber = 'P200624112958689' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221617'
                WHERE ordernumber = 'P200624113059675' 
            
2024-06-25 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397788'
                WHERE ordernumber = 'P630624113415389' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273591'
                WHERE ordernumber = 'P200624113623763' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P180624113724675' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397784'
                WHERE ordernumber = 'P200624113911520' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247567'
                WHERE ordernumber = 'P190624113927463' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304189'
                WHERE ordernumber = 'P590624113955231' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397791'
                WHERE ordernumber = 'P200624114031309' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396588'
                WHERE ordernumber = 'P180624114101376' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '58269'
                WHERE ordernumber = 'P180624114218237' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397726'
                WHERE ordernumber = 'P200624114428985' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397792'
                WHERE ordernumber = 'P630624114743233' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369813'
                WHERE ordernumber = 'P200624114906112' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397793'
                WHERE ordernumber = 'P420624115254567' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '191978'
                WHERE ordernumber = 'P180624115304572' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351832'
                WHERE ordernumber = 'P200624115346230' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345014'
                WHERE ordernumber = 'P190624115556557' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397794'
                WHERE ordernumber = 'P630624115654966' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200624115828724' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81879'
                WHERE ordernumber = 'P180624115951122' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393231'
                WHERE ordernumber = 'P420624115952177' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200624120015223' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64181'
                WHERE ordernumber = 'P200624120409900' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397795'
                WHERE ordernumber = 'P180624120514307' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376065'
                WHERE ordernumber = 'P420624120832115' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397796'
                WHERE ordernumber = 'P180624121107971' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420624121128810' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397797'
                WHERE ordernumber = 'P180624121404510' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P420624121545136' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397798'
                WHERE ordernumber = 'P190624121630234' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397799'
                WHERE ordernumber = 'P630624121634807' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397800'
                WHERE ordernumber = 'P180624121719144' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323499'
                WHERE ordernumber = 'P190624122244327' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397802'
                WHERE ordernumber = 'P180624122620524' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397803'
                WHERE ordernumber = 'P190624122709319' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '69209'
                WHERE ordernumber = 'P780624122711903' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397804'
                WHERE ordernumber = 'P780624123009370' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397805'
                WHERE ordernumber = 'P420624123013656' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303674'
                WHERE ordernumber = 'P180624123023721' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397806'
                WHERE ordernumber = 'P190624123054798' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397807'
                WHERE ordernumber = 'P180624123403287' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340762'
                WHERE ordernumber = 'P180624123705782' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363255'
                WHERE ordernumber = 'P630624123706894' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397808'
                WHERE ordernumber = 'P420624123714577' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397809'
                WHERE ordernumber = 'P780624123935214' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379370'
                WHERE ordernumber = 'P180624124029846' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301491'
                WHERE ordernumber = 'P630624124123880' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397812'
                WHERE ordernumber = 'P420624124221378' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397813'
                WHERE ordernumber = 'P630624124314978' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365960'
                WHERE ordernumber = 'P180624125115355' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397814'
                WHERE ordernumber = 'P630624125157558' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397815'
                WHERE ordernumber = 'P630624125523721' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397816'
                WHERE ordernumber = 'P630624125835147' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397818'
                WHERE ordernumber = 'P180624130113521' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382088'
                WHERE ordernumber = 'P180624130209926' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397818'
                WHERE ordernumber = 'P180624130313873' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397819'
                WHERE ordernumber = 'P630624130615959' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397820'
                WHERE ordernumber = 'P180624131022277' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340830'
                WHERE ordernumber = 'P190624131329997' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272613'
                WHERE ordernumber = 'P420624131937669' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397820'
                WHERE ordernumber = 'P180624132227584' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391074'
                WHERE ordernumber = 'P200624132620319' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '146448'
                WHERE ordernumber = 'P190624132722730' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397821'
                WHERE ordernumber = 'P180624132832476' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397822'
                WHERE ordernumber = 'P630624133513737' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224752'
                WHERE ordernumber = 'P180624133548265' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397823'
                WHERE ordernumber = 'P630624134137981' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81029'
                WHERE ordernumber = 'P200624134223309' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306524'
                WHERE ordernumber = 'P180624134634865' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397825'
                WHERE ordernumber = 'P200624134722246' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397768'
                WHERE ordernumber = 'P630624134914953' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397827'
                WHERE ordernumber = 'P200624135549539' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397828'
                WHERE ordernumber = 'P630624135918807' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397829'
                WHERE ordernumber = 'P630624140030275' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113772'
                WHERE ordernumber = 'P190624140113940' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '16888'
                WHERE ordernumber = 'P630624140254406' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397830'
                WHERE ordernumber = 'P190624140554738' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98161'
                WHERE ordernumber = 'P630624140648889' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282596'
                WHERE ordernumber = 'P190624141146679' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397832'
                WHERE ordernumber = 'P630624141557286' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341867'
                WHERE ordernumber = 'P190624141928204' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397833'
                WHERE ordernumber = 'P420624142148978' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397834'
                WHERE ordernumber = 'P180624142204447' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286596'
                WHERE ordernumber = 'P190624142316836' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397836'
                WHERE ordernumber = 'P180624142336696' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397837'
                WHERE ordernumber = 'P420624142400198' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397835'
                WHERE ordernumber = 'P630624142441738' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397838'
                WHERE ordernumber = 'P190624142540317' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390360'
                WHERE ordernumber = 'P420624142914685' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228431'
                WHERE ordernumber = 'P190624143352986' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303580'
                WHERE ordernumber = 'P190624143614205' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393233'
                WHERE ordernumber = 'P200624143849117' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381402'
                WHERE ordernumber = 'P190624144031723' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397839'
                WHERE ordernumber = 'P190624144211135' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397841'
                WHERE ordernumber = 'P180624145353939' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381285'
                WHERE ordernumber = 'P180624150338153' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397842'
                WHERE ordernumber = 'P180624150533538' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218493'
                WHERE ordernumber = 'P630624150832663' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215829'
                WHERE ordernumber = 'P180624151211281' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308916'
                WHERE ordernumber = 'P180624151433125' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358723'
                WHERE ordernumber = 'P630624151741172' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208833'
                WHERE ordernumber = 'P180624152143822' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247746'
                WHERE ordernumber = 'P630624153039219' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397844'
                WHERE ordernumber = 'P180624153243159' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397846'
                WHERE ordernumber = 'P180624153830905' 
            
2024-06-25 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386719'
                WHERE ordernumber = 'P200624154514913' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397850'
                WHERE ordernumber = 'P630624154817558' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357022'
                WHERE ordernumber = 'P180624155003494' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397852'
                WHERE ordernumber = 'P180624155207817' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397855'
                WHERE ordernumber = 'P200624160654251' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300327'
                WHERE ordernumber = 'P180624160713278' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353168'
                WHERE ordernumber = 'P180624160849276' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397857'
                WHERE ordernumber = 'P630624161304908' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396216'
                WHERE ordernumber = 'P200624161708794' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278615'
                WHERE ordernumber = 'P180624161949657' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397860'
                WHERE ordernumber = 'P780624162847380' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397861'
                WHERE ordernumber = 'P180624162850436' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343682'
                WHERE ordernumber = 'P180624163123995' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397860'
                WHERE ordernumber = 'P780624163312867' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397862'
                WHERE ordernumber = 'P180624163335405' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397863'
                WHERE ordernumber = 'P630624163437576' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397864'
                WHERE ordernumber = 'P630624163604487' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300607'
                WHERE ordernumber = 'P420624164325881' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220439'
                WHERE ordernumber = 'P180624164614628' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397866'
                WHERE ordernumber = 'P200624165338434' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397865'
                WHERE ordernumber = 'P630624165358151' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397867'
                WHERE ordernumber = 'P420624165405790' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397868'
                WHERE ordernumber = 'P630624170012179' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397869'
                WHERE ordernumber = 'P420624170215215' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276242'
                WHERE ordernumber = 'P200624170506495' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397871'
                WHERE ordernumber = 'P420624170627877' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397872'
                WHERE ordernumber = 'P420624170736938' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397873'
                WHERE ordernumber = 'P200624170812234' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397874'
                WHERE ordernumber = 'P630624170932786' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '201727'
                WHERE ordernumber = 'P630624171212721' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252044'
                WHERE ordernumber = 'P200624171237198' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343835'
                WHERE ordernumber = 'P420624171246688' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281899'
                WHERE ordernumber = 'P420624171425909' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397875'
                WHERE ordernumber = 'P420624171852594' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245514'
                WHERE ordernumber = 'P200624171944463' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397876'
                WHERE ordernumber = 'P630624172308311' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282051'
                WHERE ordernumber = 'P200624172349388' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392379'
                WHERE ordernumber = 'P420624172528214' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297030'
                WHERE ordernumber = 'P420624173029559' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397877'
                WHERE ordernumber = 'P180624173111157' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397878'
                WHERE ordernumber = 'P180624173130681' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397880'
                WHERE ordernumber = 'P630624173430391' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397881'
                WHERE ordernumber = 'P180624174016655' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237283'
                WHERE ordernumber = 'P180624174240929' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397882'
                WHERE ordernumber = 'P200624174521291' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397883'
                WHERE ordernumber = 'P420624174626124' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397884'
                WHERE ordernumber = 'P630624174646754' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P180624175045632' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396510'
                WHERE ordernumber = 'P590624175123134' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P180624175216622' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373857'
                WHERE ordernumber = 'P200624175314510' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '76849'
                WHERE ordernumber = 'P420624175422576' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397886'
                WHERE ordernumber = 'P630624175812633' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307833'
                WHERE ordernumber = 'P180624175829983' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397887'
                WHERE ordernumber = 'P200624180051388' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392676'
                WHERE ordernumber = 'P420624180150625' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262782'
                WHERE ordernumber = 'P200624180246802' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291977'
                WHERE ordernumber = 'P200624180431890' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393642'
                WHERE ordernumber = 'P420624180444204' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397888'
                WHERE ordernumber = 'P630624180643113' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380678'
                WHERE ordernumber = 'P200624180656349' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397889'
                WHERE ordernumber = 'P630624180829437' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397890'
                WHERE ordernumber = 'P180624181105139' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227618'
                WHERE ordernumber = 'P200624181208679' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397616'
                WHERE ordernumber = 'P190624181210226' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361248'
                WHERE ordernumber = 'P630624182027210' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397891'
                WHERE ordernumber = 'P630624182409957' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397892'
                WHERE ordernumber = 'P630624182544241' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397893'
                WHERE ordernumber = 'P200624182638124' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358687'
                WHERE ordernumber = 'P420624182836329' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351726'
                WHERE ordernumber = 'P200624182916169' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131163'
                WHERE ordernumber = 'P180624183150508' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '110816'
                WHERE ordernumber = 'P180624183323319' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397894'
                WHERE ordernumber = 'P420624183614192' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397895'
                WHERE ordernumber = 'P180624183903963' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237250'
                WHERE ordernumber = 'P200624183922297' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211568'
                WHERE ordernumber = 'P190624183931760' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278727'
                WHERE ordernumber = 'P180624184005960' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302604'
                WHERE ordernumber = 'P180624184117244' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391240'
                WHERE ordernumber = 'P180624184220189' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397896'
                WHERE ordernumber = 'P630624184325954' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300038'
                WHERE ordernumber = 'P630624184404577' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397487'
                WHERE ordernumber = 'P200624184614162' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397898'
                WHERE ordernumber = 'P180624184803448' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231467'
                WHERE ordernumber = 'P200624184855593' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397898'
                WHERE ordernumber = 'P180624184936217' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293456'
                WHERE ordernumber = 'P200624184958157' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P590624185615767' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397900'
                WHERE ordernumber = 'P200624185810412' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316671'
                WHERE ordernumber = 'P190624185812312' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315096'
                WHERE ordernumber = 'P200624190017860' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397902'
                WHERE ordernumber = 'P200624190331623' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397901'
                WHERE ordernumber = 'P630624190338934' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376380'
                WHERE ordernumber = 'P190624190608689' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397905'
                WHERE ordernumber = 'P190624191033289' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397904'
                WHERE ordernumber = 'P590624191052350' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396357'
                WHERE ordernumber = 'P190624191352689' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '335266'
                WHERE ordernumber = 'P190624191440343' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396332'
                WHERE ordernumber = 'P200624191523476' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397906'
                WHERE ordernumber = 'P630624191714674' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344300'
                WHERE ordernumber = 'P190624191829336' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397908'
                WHERE ordernumber = 'P200624192158587' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394239'
                WHERE ordernumber = 'P200624192431818' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240866'
                WHERE ordernumber = 'P200624192536665' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397909'
                WHERE ordernumber = 'P190624192552175' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397910'
                WHERE ordernumber = 'P190624192912359' 
            
2024-06-25 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396864'
                WHERE ordernumber = 'P200624192951564' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397911'
                WHERE ordernumber = 'P190624193033292' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96384'
                WHERE ordernumber = 'P200624193047762' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81074'
                WHERE ordernumber = 'P200624193636955' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P200624193859832' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397912'
                WHERE ordernumber = 'P630624194156926' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212722'
                WHERE ordernumber = 'P190624194250366' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212722'
                WHERE ordernumber = 'P190624194319890' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '330635'
                WHERE ordernumber = 'P190624195009501' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397914'
                WHERE ordernumber = 'P630624195040949' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '113192'
                WHERE ordernumber = 'P190624195113549' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397915'
                WHERE ordernumber = 'P630624195500998' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '117937'
                WHERE ordernumber = 'P200624195539634' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '293737'
                WHERE ordernumber = 'P630624201118849' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397916'
                WHERE ordernumber = 'P590624201227908' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397918'
                WHERE ordernumber = 'P630624201322166' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304369'
                WHERE ordernumber = 'P630624201514292' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306413'
                WHERE ordernumber = 'P630624201609828' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397922'
                WHERE ordernumber = 'P630624204900999' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397923'
                WHERE ordernumber = 'P630624205146532' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397926'
                WHERE ordernumber = 'P590624210244406' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397927'
                WHERE ordernumber = 'P630624210630965' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397927'
                WHERE ordernumber = 'P630624211556260' 
            
2024-06-25 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '397928'
                WHERE ordernumber = 'P630624212559208'