2024-07-27 01:00:03 -- 將會員中心id寫入data-lake
2024-07-27 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 '2024-07-26%';
        
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '149849'
                WHERE ordernumber = 'P200726110201426' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '33696'
                WHERE ordernumber = 'P200726110613536' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403080'
                WHERE ordernumber = 'P420726110735283' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89637'
                WHERE ordernumber = 'P190726110800475' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112386'
                WHERE ordernumber = 'P190726110956546' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379476'
                WHERE ordernumber = 'P200726111055171' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403081'
                WHERE ordernumber = 'P190726111228587' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403083'
                WHERE ordernumber = 'P420726111439926' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88195'
                WHERE ordernumber = 'P180726111443169' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380159'
                WHERE ordernumber = 'P190726111535954' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369193'
                WHERE ordernumber = 'P200726112134843' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403055'
                WHERE ordernumber = 'P630726112138139' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403087'
                WHERE ordernumber = 'P190726112525802' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283028'
                WHERE ordernumber = 'P420726112651582' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403088'
                WHERE ordernumber = 'P190726112707822' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403089'
                WHERE ordernumber = 'P420726112830407' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403090'
                WHERE ordernumber = 'P420726113022223' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403086'
                WHERE ordernumber = 'P200726113156884' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105393'
                WHERE ordernumber = 'P180726113336301' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '398350'
                WHERE ordernumber = 'P420726113403654' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372278'
                WHERE ordernumber = 'P200726113420214' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403096'
                WHERE ordernumber = 'P420726113903601' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403097'
                WHERE ordernumber = 'P420726114206933' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234144'
                WHERE ordernumber = 'P190726114219819' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403098'
                WHERE ordernumber = 'P200726114524114' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315891'
                WHERE ordernumber = 'P420726114558740' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296939'
                WHERE ordernumber = 'P420726114744602' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403100'
                WHERE ordernumber = 'P420726114931911' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403061'
                WHERE ordernumber = 'P190726114951378' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401724'
                WHERE ordernumber = 'P630726115057674' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403061'
                WHERE ordernumber = 'P190726115145677' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403101'
                WHERE ordernumber = 'P180726115304756' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '92619'
                WHERE ordernumber = 'P180726120146407' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403102'
                WHERE ordernumber = 'P200726120149128' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180726120313690' 
            
2024-07-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356749'
                WHERE ordernumber = 'P190726120328618' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400715'
                WHERE ordernumber = 'P180726120731812' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395925'
                WHERE ordernumber = 'P190726120803560' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304827'
                WHERE ordernumber = 'P180726121345185' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397230'
                WHERE ordernumber = 'P180726121506224' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304827'
                WHERE ordernumber = 'P180726121530926' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '251223'
                WHERE ordernumber = 'P180726121917543' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392841'
                WHERE ordernumber = 'P590726122028843' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222004'
                WHERE ordernumber = 'P200726122123708' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403105'
                WHERE ordernumber = 'P180726122125415' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306336'
                WHERE ordernumber = 'P180726122357659' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98432'
                WHERE ordernumber = 'P200726123040284' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297774'
                WHERE ordernumber = 'P420726123135424' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P200726123159204' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52118'
                WHERE ordernumber = 'P420726123525228' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377369'
                WHERE ordernumber = 'P200726123617834' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403108'
                WHERE ordernumber = 'P180726123958587' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403110'
                WHERE ordernumber = 'P180726124358857' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287175'
                WHERE ordernumber = 'P420726124437649' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180726124441633' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289788'
                WHERE ordernumber = 'P200726124513163' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '330341'
                WHERE ordernumber = 'P180726124649671' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '196319'
                WHERE ordernumber = 'P200726124809115' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403112'
                WHERE ordernumber = 'P180726124939871' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403113'
                WHERE ordernumber = 'P180726125411646' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403116'
                WHERE ordernumber = 'P180726125635897' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403115'
                WHERE ordernumber = 'P200726125637182' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396863'
                WHERE ordernumber = 'P180726130050141' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403118'
                WHERE ordernumber = 'P180726131028892' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403120'
                WHERE ordernumber = 'P420726132057699' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336070'
                WHERE ordernumber = 'P190726133102372' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403121'
                WHERE ordernumber = 'P200726133121500' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384245'
                WHERE ordernumber = 'P200726133223466' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402489'
                WHERE ordernumber = 'P200726133406216' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P590726133947415' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396085'
                WHERE ordernumber = 'P200726133953838' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403122'
                WHERE ordernumber = 'P200726134317506' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403123'
                WHERE ordernumber = 'P420726134736655' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403124'
                WHERE ordernumber = 'P180726134859365' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403125'
                WHERE ordernumber = 'P180726135055790' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385749'
                WHERE ordernumber = 'P180726135236840' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245558'
                WHERE ordernumber = 'P200726135857798' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403127'
                WHERE ordernumber = 'P180726140142196' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361146'
                WHERE ordernumber = 'P200726140316835' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278583'
                WHERE ordernumber = 'P180726140910536' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403129'
                WHERE ordernumber = 'P180726141048856' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346343'
                WHERE ordernumber = 'P420726141248973' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403131'
                WHERE ordernumber = 'P180726141314137' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402948'
                WHERE ordernumber = 'P200726141359288' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399871'
                WHERE ordernumber = 'P200726141733893' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292259'
                WHERE ordernumber = 'P200726142101685' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342855'
                WHERE ordernumber = 'P200726142103599' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P200726142233319' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334332'
                WHERE ordernumber = 'P420726142521302' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '186085'
                WHERE ordernumber = 'P630726142906336' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385062'
                WHERE ordernumber = 'P200726143044247' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403136'
                WHERE ordernumber = 'P420726143110742' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403137'
                WHERE ordernumber = 'P420726143230114' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403139'
                WHERE ordernumber = 'P420726143336596' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277237'
                WHERE ordernumber = 'P200726143515634' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403140'
                WHERE ordernumber = 'P420726143518648' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403142'
                WHERE ordernumber = 'P180726144213144' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297095'
                WHERE ordernumber = 'P420726144355209' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297096'
                WHERE ordernumber = 'P420726144452605' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403145'
                WHERE ordernumber = 'P180726144631845' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403147'
                WHERE ordernumber = 'P180726144825742' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403146'
                WHERE ordernumber = 'P200726144910951' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403148'
                WHERE ordernumber = 'P200726145024731' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403149'
                WHERE ordernumber = 'P420726145356963' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305444'
                WHERE ordernumber = 'P420726145458755' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402510'
                WHERE ordernumber = 'P180726145503635' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310745'
                WHERE ordernumber = 'P420726145643772' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98539'
                WHERE ordernumber = 'P180726145808770' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367839'
                WHERE ordernumber = 'P420726145905276' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403150'
                WHERE ordernumber = 'P180726150106675' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137181'
                WHERE ordernumber = 'P180726150221963' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40686'
                WHERE ordernumber = 'P200726150345924' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403151'
                WHERE ordernumber = 'P420726150416789' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294456'
                WHERE ordernumber = 'P180726150543336' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '294456'
                WHERE ordernumber = 'P180726150558249' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403152'
                WHERE ordernumber = 'P200726150909364' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220439'
                WHERE ordernumber = 'P180726151002988' 
            
2024-07-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162115'
                WHERE ordernumber = 'P180726151213297' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235004'
                WHERE ordernumber = 'P420726151220698' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403065'
                WHERE ordernumber = 'P420726151518749' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403065'
                WHERE ordernumber = 'P420726151546833' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403154'
                WHERE ordernumber = 'P180726151722227' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304893'
                WHERE ordernumber = 'P200726151722640' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '388725'
                WHERE ordernumber = 'P180726151940788' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403156'
                WHERE ordernumber = 'P180726152322875' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382139'
                WHERE ordernumber = 'P200726152444660' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '300581'
                WHERE ordernumber = 'P200726152652523' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403158'
                WHERE ordernumber = 'P420726152725572' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400004'
                WHERE ordernumber = 'P630726153107296' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374169'
                WHERE ordernumber = 'P200726153232583' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '402787'
                WHERE ordernumber = 'P180726153313642' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390443'
                WHERE ordernumber = 'P190726153411142' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400004'
                WHERE ordernumber = 'P630726154410891' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403159'
                WHERE ordernumber = 'P180726154523808' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403160'
                WHERE ordernumber = 'P200726154759886' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '382039'
                WHERE ordernumber = 'P200726155036607' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287203'
                WHERE ordernumber = 'P200726155146726' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '350897'
                WHERE ordernumber = 'P630726155200964' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392501'
                WHERE ordernumber = 'P200726155514488' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403162'
                WHERE ordernumber = 'P180726155533353' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403163'
                WHERE ordernumber = 'P180726155722532' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403166'
                WHERE ordernumber = 'P190726160516723' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390496'
                WHERE ordernumber = 'P200726160642627' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337418'
                WHERE ordernumber = 'P420726160735527' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '213314'
                WHERE ordernumber = 'P190726161101807' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403168'
                WHERE ordernumber = 'P200726161238562' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403169'
                WHERE ordernumber = 'P180726161303904' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403170'
                WHERE ordernumber = 'P200726161500973' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250272'
                WHERE ordernumber = 'P590726161634462' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403134'
                WHERE ordernumber = 'P180726161707814' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399264'
                WHERE ordernumber = 'P420726161828762' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403171'
                WHERE ordernumber = 'P180726161844576' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368002'
                WHERE ordernumber = 'P180726162029508' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383660'
                WHERE ordernumber = 'P200726162039668' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403172'
                WHERE ordernumber = 'P420726162104555' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P420726162210966' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403173'
                WHERE ordernumber = 'P190726162748288' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366205'
                WHERE ordernumber = 'P200726163240542' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403174'
                WHERE ordernumber = 'P200726163557202' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '294814'
                WHERE ordernumber = 'P200726163848984' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403176'
                WHERE ordernumber = 'P200726164109954' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '80513'
                WHERE ordernumber = 'P200726164338157' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '393533'
                WHERE ordernumber = 'P420726164515856' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401700'
                WHERE ordernumber = 'P180726164811637' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403178'
                WHERE ordernumber = 'P190726164848950' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '257085'
                WHERE ordernumber = 'P180726164935354' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403179'
                WHERE ordernumber = 'P190726165417222' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394120'
                WHERE ordernumber = 'P420726165741874' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403180'
                WHERE ordernumber = 'P200726170124457' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '100505'
                WHERE ordernumber = 'P200726170700503' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403182'
                WHERE ordernumber = 'P180726170844423' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403183'
                WHERE ordernumber = 'P200726171051927' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '84019'
                WHERE ordernumber = 'P180726171216225' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392031'
                WHERE ordernumber = 'P180726171322422' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215207'
                WHERE ordernumber = 'P420726171446898' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403184'
                WHERE ordernumber = 'P190726171951566' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403185'
                WHERE ordernumber = 'P420726172123984' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '340270'
                WHERE ordernumber = 'P180726173710623' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271278'
                WHERE ordernumber = 'P200726173727756' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403186'
                WHERE ordernumber = 'P420726173854590' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '400934'
                WHERE ordernumber = 'P590726174224965' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '308242'
                WHERE ordernumber = 'P180726174322260' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '319517'
                WHERE ordernumber = 'P420726174349113' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403189'
                WHERE ordernumber = 'P420726174536543' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P180726175110725' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217049'
                WHERE ordernumber = 'P180726175229724' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403190'
                WHERE ordernumber = 'P420726175338173' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403191'
                WHERE ordernumber = 'P180726175341238' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '260818'
                WHERE ordernumber = 'P200726175408534' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403192'
                WHERE ordernumber = 'P180726180008497' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403193'
                WHERE ordernumber = 'P180726180259193' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403194'
                WHERE ordernumber = 'P180726180455883' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403195'
                WHERE ordernumber = 'P180726180558250' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '403196'
                WHERE ordernumber = 'P420726180624770' 
            
2024-07-27 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '2068'
                WHERE ordernumber = 'P200726180658921' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '170570'
                WHERE ordernumber = 'P630726180909963' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403197'
                WHERE ordernumber = 'P420726181054225' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '118257'
                WHERE ordernumber = 'P200726181738653' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '281242'
                WHERE ordernumber = 'P180726181834993' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403199'
                WHERE ordernumber = 'P190726181938573' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403201'
                WHERE ordernumber = 'P420726182427672' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403200'
                WHERE ordernumber = 'P420726182543661' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403204'
                WHERE ordernumber = 'P200726182700622' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403205'
                WHERE ordernumber = 'P180726182739172' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '300492'
                WHERE ordernumber = 'P420726182747953' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403206'
                WHERE ordernumber = 'P180726182830457' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403207'
                WHERE ordernumber = 'P190726182904227' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394941'
                WHERE ordernumber = 'P180726183144472' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '394941'
                WHERE ordernumber = 'P180726183222481' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '302037'
                WHERE ordernumber = 'P200726183308584' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403208'
                WHERE ordernumber = 'P200726183429900' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402758'
                WHERE ordernumber = 'P180726184001888' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '391392'
                WHERE ordernumber = 'P420726184021619' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '384959'
                WHERE ordernumber = 'P200726184159811' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403210'
                WHERE ordernumber = 'P200726184419573' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403209'
                WHERE ordernumber = 'P420726184422459' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403212'
                WHERE ordernumber = 'P420726184804571' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403213'
                WHERE ordernumber = 'P420726184939276' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403214'
                WHERE ordernumber = 'P200726184955562' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402912'
                WHERE ordernumber = 'P200726185113202' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98465'
                WHERE ordernumber = 'P200726185506461' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '98465'
                WHERE ordernumber = 'P200726185643956' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402997'
                WHERE ordernumber = 'P190726185826783' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403216'
                WHERE ordernumber = 'P200726185927852' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '330341'
                WHERE ordernumber = 'P190726190008394' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403217'
                WHERE ordernumber = 'P190726190620527' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403219'
                WHERE ordernumber = 'P190726190754266' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '247066'
                WHERE ordernumber = 'P200726190817959' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401068'
                WHERE ordernumber = 'P190726190848233' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403220'
                WHERE ordernumber = 'P200726190947772' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '312211'
                WHERE ordernumber = 'P190726191037130' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403223'
                WHERE ordernumber = 'P190726191947628' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403224'
                WHERE ordernumber = 'P200726192105313' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '244176'
                WHERE ordernumber = 'P200726192131745' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '401952'
                WHERE ordernumber = 'P200726192218706' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '273423'
                WHERE ordernumber = 'P190726192227758' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '246143'
                WHERE ordernumber = 'P200726193303770' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403226'
                WHERE ordernumber = 'P190726193940673' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '230106'
                WHERE ordernumber = 'P200726194305199' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '233813'
                WHERE ordernumber = 'P200726194515136' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403227'
                WHERE ordernumber = 'P200726194631664' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403229'
                WHERE ordernumber = 'P190726194850416' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403230'
                WHERE ordernumber = 'P190726195448573' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403231'
                WHERE ordernumber = 'P190726195550520' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403232'
                WHERE ordernumber = 'P190726195701221' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '403233'
                WHERE ordernumber = 'P200726200012775' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375826'
                WHERE ordernumber = 'P190726200345629' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '375826'
                WHERE ordernumber = 'P190726200446677' 
            
2024-07-27 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '402883'
                WHERE ordernumber = 'P630726211957545'