2024-01-09 01:00:02 -- 將會員中心id寫入data-lake
2024-01-09 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-01-08%';
        
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215554'
                WHERE ordernumber = 'P200108110257896' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262484'
                WHERE ordernumber = 'P190108110520174' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270148'
                WHERE ordernumber = 'P200108110523751' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353079'
                WHERE ordernumber = 'P190108110651898' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362009'
                WHERE ordernumber = 'P190108110922126' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356885'
                WHERE ordernumber = 'P420108111401214' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356885'
                WHERE ordernumber = 'P420108111432731' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268675'
                WHERE ordernumber = 'P190108111745959' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251728'
                WHERE ordernumber = 'P200108112032271' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352773'
                WHERE ordernumber = 'P420108112226462' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101144'
                WHERE ordernumber = 'P200108112238933' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362019'
                WHERE ordernumber = 'P190108112342895' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141741'
                WHERE ordernumber = 'P200108112802925' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362024'
                WHERE ordernumber = 'P190108112901684' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141777'
                WHERE ordernumber = 'P200108113230888' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '124614'
                WHERE ordernumber = 'P190108113301965' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362030'
                WHERE ordernumber = 'P180108113341701' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362033'
                WHERE ordernumber = 'P190108113714188' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P190108113901822' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362038'
                WHERE ordernumber = 'P200108114055562' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362039'
                WHERE ordernumber = 'P200108114208381' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222004'
                WHERE ordernumber = 'P200108114243248' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362042'
                WHERE ordernumber = 'P200108114332637' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350303'
                WHERE ordernumber = 'P200108114705480' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303115'
                WHERE ordernumber = 'P200108114817815' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344425'
                WHERE ordernumber = 'P190108114848999' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357845'
                WHERE ordernumber = 'P180108114908404' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350153'
                WHERE ordernumber = 'P200108114934306' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362047'
                WHERE ordernumber = 'P200108115010655' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362049'
                WHERE ordernumber = 'P420108115107954' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354685'
                WHERE ordernumber = 'P180108115226602' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307010'
                WHERE ordernumber = 'P190108115454546' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362056'
                WHERE ordernumber = 'P180108115616309' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357399'
                WHERE ordernumber = 'P200108115752469' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362058'
                WHERE ordernumber = 'P420108115753322' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355285'
                WHERE ordernumber = 'P190108115758887' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361148'
                WHERE ordernumber = 'P200108120044437' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362061'
                WHERE ordernumber = 'P180108120058550' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362063'
                WHERE ordernumber = 'P190108120307789' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357700'
                WHERE ordernumber = 'P200108120415384' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358469'
                WHERE ordernumber = 'P200108120555822' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362076'
                WHERE ordernumber = 'P420108121306596' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248446'
                WHERE ordernumber = 'P190108121603474' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98874'
                WHERE ordernumber = 'P180108122051418' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162592'
                WHERE ordernumber = 'P190108122203484' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362083'
                WHERE ordernumber = 'P190108122448846' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362092'
                WHERE ordernumber = 'P190108123220397' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362093'
                WHERE ordernumber = 'P180108123230636' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362096'
                WHERE ordernumber = 'P420108123314625' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362098'
                WHERE ordernumber = 'P420108123407243' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359112'
                WHERE ordernumber = 'P420108123509888' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140799'
                WHERE ordernumber = 'P200108123627461' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340181'
                WHERE ordernumber = 'P200108123804700' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297814'
                WHERE ordernumber = 'P420108124351999' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301962'
                WHERE ordernumber = 'P420108124448394' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358640'
                WHERE ordernumber = 'P190108124542957' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358640'
                WHERE ordernumber = 'P190108124617857' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94814'
                WHERE ordernumber = 'P180108124904253' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351381'
                WHERE ordernumber = 'P200108124909473' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94815'
                WHERE ordernumber = 'P200108124914914' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362114'
                WHERE ordernumber = 'P420108125033471' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362117'
                WHERE ordernumber = 'P190108125213235' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106769'
                WHERE ordernumber = 'P420108125252779' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362118'
                WHERE ordernumber = 'P200108125316855' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346775'
                WHERE ordernumber = 'P180108125508803' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94815'
                WHERE ordernumber = 'P200108125512936' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362128'
                WHERE ordernumber = 'P200108130109751' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362130'
                WHERE ordernumber = 'P420108130127537' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362129'
                WHERE ordernumber = 'P180108130306718' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362135'
                WHERE ordernumber = 'P180108130518566' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303916'
                WHERE ordernumber = 'P200108130551644' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362136'
                WHERE ordernumber = 'P420108131003481' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '317723'
                WHERE ordernumber = 'P200108131034578' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362142'
                WHERE ordernumber = 'P200108131421714' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218520'
                WHERE ordernumber = 'P190108131425279' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223893'
                WHERE ordernumber = 'P180108131503533' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302353'
                WHERE ordernumber = 'P190108131624127' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362153'
                WHERE ordernumber = 'P180108132151471' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362155'
                WHERE ordernumber = 'P180108132403632' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345752'
                WHERE ordernumber = 'P190108132506370' 
            
2024-01-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362160'
                WHERE ordernumber = 'P200108132715119' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362160'
                WHERE ordernumber = 'P200108132939771' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362165'
                WHERE ordernumber = 'P200108133311709' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '182156'
                WHERE ordernumber = 'P200108133545640' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '1592'
                WHERE ordernumber = 'P180108133616690' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358254'
                WHERE ordernumber = 'P190108133710402' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362169'
                WHERE ordernumber = 'P180108133832987' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362174'
                WHERE ordernumber = 'P420108134312143' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276679'
                WHERE ordernumber = 'P200108135130409' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362185'
                WHERE ordernumber = 'P180108135507428' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362186'
                WHERE ordernumber = 'P200108135530647' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273038'
                WHERE ordernumber = 'P200108135751529' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362189'
                WHERE ordernumber = 'P420108135753705' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122923'
                WHERE ordernumber = 'P180108140013828' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362196'
                WHERE ordernumber = 'P200108140403562' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362199'
                WHERE ordernumber = 'P200108140626644' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362201'
                WHERE ordernumber = 'P180108140807845' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362203'
                WHERE ordernumber = 'P200108140857125' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302805'
                WHERE ordernumber = 'P420108141140696' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362208'
                WHERE ordernumber = 'P200108141510454' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239204'
                WHERE ordernumber = 'P180108141558785' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362211'
                WHERE ordernumber = 'P180108141703438' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362213'
                WHERE ordernumber = 'P420108141836732' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263879'
                WHERE ordernumber = 'P180108142045472' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362216'
                WHERE ordernumber = 'P420108142138543' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362212'
                WHERE ordernumber = 'P200108142304727' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362212'
                WHERE ordernumber = 'P200108142307257' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362218'
                WHERE ordernumber = 'P420108142359446' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362220'
                WHERE ordernumber = 'P420108142606435' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362223'
                WHERE ordernumber = 'P190108142709359' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300170'
                WHERE ordernumber = 'P190108142935572' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '40686'
                WHERE ordernumber = 'P200108143023735' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258315'
                WHERE ordernumber = 'P190108143413153' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227730'
                WHERE ordernumber = 'P200108143416920' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362228'
                WHERE ordernumber = 'P180108143509708' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362230'
                WHERE ordernumber = 'P180108143653820' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362231'
                WHERE ordernumber = 'P420108143746529' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362233'
                WHERE ordernumber = 'P420108144005822' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362237'
                WHERE ordernumber = 'P180108144057945' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97768'
                WHERE ordernumber = 'P190108144155111' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271204'
                WHERE ordernumber = 'P180108144405932' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94416'
                WHERE ordernumber = 'P190108144608506' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362241'
                WHERE ordernumber = 'P190108144825694' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232506'
                WHERE ordernumber = 'P200108144905746' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260400'
                WHERE ordernumber = 'P190108145104861' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114124'
                WHERE ordernumber = 'P200108145912801' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114124'
                WHERE ordernumber = 'P200108150001478' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '114124'
                WHERE ordernumber = 'P200108150141166' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357967'
                WHERE ordernumber = 'P200108150242270' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334413'
                WHERE ordernumber = 'P180108150352958' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360922'
                WHERE ordernumber = 'P420108150715286' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362268'
                WHERE ordernumber = 'P190108150955720' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228507'
                WHERE ordernumber = 'P190108151213987' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P420108151734245' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296563'
                WHERE ordernumber = 'P190108151951911' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94997'
                WHERE ordernumber = 'P200108152103927' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362292'
                WHERE ordernumber = 'P420108152755520' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337105'
                WHERE ordernumber = 'P420108152828841' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268675'
                WHERE ordernumber = 'P190108153010485' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211186'
                WHERE ordernumber = 'P190108153211737' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304762'
                WHERE ordernumber = 'P200108153442657' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263029'
                WHERE ordernumber = 'P180108153443921' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269403'
                WHERE ordernumber = 'P180108153636391' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362301'
                WHERE ordernumber = 'P420108153712692' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362305'
                WHERE ordernumber = 'P180108153755762' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270167'
                WHERE ordernumber = 'P190108153758199' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362306'
                WHERE ordernumber = 'P180108154013881' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337269'
                WHERE ordernumber = 'P420108154058487' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353795'
                WHERE ordernumber = 'P180108154216138' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362312'
                WHERE ordernumber = 'P180108154403318' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362311'
                WHERE ordernumber = 'P420108154456728' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362316'
                WHERE ordernumber = 'P190108154515530' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P180108154550130' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362319'
                WHERE ordernumber = 'P420108154608226' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362318'
                WHERE ordernumber = 'P180108154622429' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353956'
                WHERE ordernumber = 'P200108154758991' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362323'
                WHERE ordernumber = 'P190108154830309' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362324'
                WHERE ordernumber = 'P200108154857607' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362321'
                WHERE ordernumber = 'P180108155250609' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362328'
                WHERE ordernumber = 'P420108155258865' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '87271'
                WHERE ordernumber = 'P200108155304404' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306300'
                WHERE ordernumber = 'P200108155334639' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362333'
                WHERE ordernumber = 'P190108155541866' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362336'
                WHERE ordernumber = 'P420108155629571' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362335'
                WHERE ordernumber = 'P180108155634243' 
            
2024-01-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '362339'
                WHERE ordernumber = 'P200108155759853' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362335'
                WHERE ordernumber = 'P180108155903825' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343888'
                WHERE ordernumber = 'P180108155957180' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362346'
                WHERE ordernumber = 'P180108160726565' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362347'
                WHERE ordernumber = 'P420108160735247' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362348'
                WHERE ordernumber = 'P190108160827691' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '241413'
                WHERE ordernumber = 'P420108161012998' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362350'
                WHERE ordernumber = 'P180108161044856' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282693'
                WHERE ordernumber = 'P190108161354892' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P180108161405651' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282693'
                WHERE ordernumber = 'P190108161509462' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362335'
                WHERE ordernumber = 'P190108161546917' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362352'
                WHERE ordernumber = 'P420108161548847' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124325'
                WHERE ordernumber = 'P180108161722222' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362354'
                WHERE ordernumber = 'P180108161832264' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85491'
                WHERE ordernumber = 'P190108161836681' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362355'
                WHERE ordernumber = 'P420108162046230' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '188867'
                WHERE ordernumber = 'P200108162117239' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362356'
                WHERE ordernumber = 'P180108162157307' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362357'
                WHERE ordernumber = 'P200108162226611' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355023'
                WHERE ordernumber = 'P420108162339869' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '188867'
                WHERE ordernumber = 'P200108162500268' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362362'
                WHERE ordernumber = 'P200108162715918' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362317'
                WHERE ordernumber = 'P420108162838752' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355023'
                WHERE ordernumber = 'P420108162946484' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362367'
                WHERE ordernumber = 'P420108163237407' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '106253'
                WHERE ordernumber = 'P180108163326634' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '133146'
                WHERE ordernumber = 'P200108163603481' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358840'
                WHERE ordernumber = 'P200108163710434' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362370'
                WHERE ordernumber = 'P190108163954195' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362370'
                WHERE ordernumber = 'P190108164033586' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '227161'
                WHERE ordernumber = 'P200108164502848' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '85491'
                WHERE ordernumber = 'P190108164540808' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '214922'
                WHERE ordernumber = 'P180108164923551' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362389'
                WHERE ordernumber = 'P180108165615363' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362393'
                WHERE ordernumber = 'P420108170022180' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362398'
                WHERE ordernumber = 'P180108170211828' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362399'
                WHERE ordernumber = 'P200108170301744' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362404'
                WHERE ordernumber = 'P200108170434281' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '284200'
                WHERE ordernumber = 'P200108171020644' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '289937'
                WHERE ordernumber = 'P180108171031624' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '263337'
                WHERE ordernumber = 'P200108171138880' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351335'
                WHERE ordernumber = 'P420108171158798' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349042'
                WHERE ordernumber = 'P420108171341816' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '237850'
                WHERE ordernumber = 'P190108171408553' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274934'
                WHERE ordernumber = 'P200108171445126' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '288511'
                WHERE ordernumber = 'P420108171514906' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '141404'
                WHERE ordernumber = 'P190108171712700' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362414'
                WHERE ordernumber = 'P180108172058248' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362416'
                WHERE ordernumber = 'P180108173224159' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362416'
                WHERE ordernumber = 'P180108173259525' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337605'
                WHERE ordernumber = 'P420108173605508' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362039'
                WHERE ordernumber = 'P200108173715720' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362423'
                WHERE ordernumber = 'P180108173823679' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362428'
                WHERE ordernumber = 'P180108174030371' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362428'
                WHERE ordernumber = 'P180108174321236' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '313314'
                WHERE ordernumber = 'P420108174655226' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362432'
                WHERE ordernumber = 'P190108174700220' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '351205'
                WHERE ordernumber = 'P200108175236973' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362432'
                WHERE ordernumber = 'P190108175310812' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362441'
                WHERE ordernumber = 'P200108175700526' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '98220'
                WHERE ordernumber = 'P200108181005752' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286425'
                WHERE ordernumber = 'P200108182257158' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283784'
                WHERE ordernumber = 'P200108182802713' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '301997'
                WHERE ordernumber = 'P200108183459866' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '281383'
                WHERE ordernumber = 'P200108183724185' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '81113'
                WHERE ordernumber = 'P200108184017916' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '209586'
                WHERE ordernumber = 'P180108184055964' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353079'
                WHERE ordernumber = 'P190108184058741' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362468'
                WHERE ordernumber = 'P180108184446964' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359038'
                WHERE ordernumber = 'P200108184614973' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358745'
                WHERE ordernumber = 'P190108185157731' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362477'
                WHERE ordernumber = 'P420108185819258' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362479'
                WHERE ordernumber = 'P190108185917838' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '358072'
                WHERE ordernumber = 'P200108190325169' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357946'
                WHERE ordernumber = 'P200108190414817' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '357944'
                WHERE ordernumber = 'P200108190457869' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '274026'
                WHERE ordernumber = 'P190108190607867' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362487'
                WHERE ordernumber = 'P200108190843146' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '305825'
                WHERE ordernumber = 'P190108191059449' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236635'
                WHERE ordernumber = 'P420108191214446' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '154567'
                WHERE ordernumber = 'P420108191324826' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362503'
                WHERE ordernumber = 'P190108192537865' 
            
2024-01-09 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '362504'
                WHERE ordernumber = 'P200108192612617' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362507'
                WHERE ordernumber = 'P190108192827398' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362509'
                WHERE ordernumber = 'P200108192901912' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '300157'
                WHERE ordernumber = 'P190108193154218' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '137887'
                WHERE ordernumber = 'P190108193508734' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '128477'
                WHERE ordernumber = 'P200108193704979' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280842'
                WHERE ordernumber = 'P190108193830878' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '280842'
                WHERE ordernumber = 'P190108194015674' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '229208'
                WHERE ordernumber = 'P190108194401953' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P190108194650517' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '345233'
                WHERE ordernumber = 'P420108194743806' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '103010'
                WHERE ordernumber = 'P420108195605182' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '362549'
                WHERE ordernumber = 'P200108195636716' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P190108195812156' 
            
2024-01-09 01:00:06 -- 
                UPDATE `omo_order_list` SET userId = '112335'
                WHERE ordernumber = 'P190108195856794'