2024-06-27 01:00:02 -- 將會員中心id寫入data-lake 2024-06-27 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-26%'; 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398126' WHERE ordernumber = 'P630626101958885' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398127' WHERE ordernumber = 'P630626102544869' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '379639' WHERE ordernumber = 'P630626102742686' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '98198' WHERE ordernumber = 'P200626104931257' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398130' WHERE ordernumber = 'P630626105557768' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '359064' WHERE ordernumber = 'P200626110316151' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '351167' WHERE ordernumber = 'P420626110329209' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '297128' WHERE ordernumber = 'P200626110502304' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '177753' WHERE ordernumber = 'P200626110610358' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '354502' WHERE ordernumber = 'P180626110918454' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398134' WHERE ordernumber = 'P180626111250860' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398133' WHERE ordernumber = 'P200626111251565' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398135' WHERE ordernumber = 'P420626111327757' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '354502' WHERE ordernumber = 'P180626111411775' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398136' WHERE ordernumber = 'P180626111945831' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '397745' WHERE ordernumber = 'P200626112005974' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398137' WHERE ordernumber = 'P630626112317460' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '266261' WHERE ordernumber = 'P200626112530658' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398139' WHERE ordernumber = 'P630626112843868' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398140' WHERE ordernumber = 'P630626113018502' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '134240' WHERE ordernumber = 'P180626113035752' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398141' WHERE ordernumber = 'P630626113358417' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '396983' WHERE ordernumber = 'P200626113508438' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398142' WHERE ordernumber = 'P180626113828583' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398144' WHERE ordernumber = 'P180626114122495' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '385154' WHERE ordernumber = 'P420626114303606' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '344543' WHERE ordernumber = 'P200626114329802' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '112587' WHERE ordernumber = 'P190626115612479' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '299059' WHERE ordernumber = 'P190626115930382' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '222145' WHERE ordernumber = 'P180626120206981' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '222145' WHERE ordernumber = 'P180626120440182' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '385059' WHERE ordernumber = 'P180626120841802' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '397487' WHERE ordernumber = 'P200626120902721' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '272572' WHERE ordernumber = 'P420626120934991' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398146' WHERE ordernumber = 'P630626121148783' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398147' WHERE ordernumber = 'P630626121331145' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398149' WHERE ordernumber = 'P180626121424163' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '219485' WHERE ordernumber = 'P200626121651723' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '111265' WHERE ordernumber = 'P200626122014814' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398150' WHERE ordernumber = 'P420626122041965' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398151' WHERE ordernumber = 'P420626122203920' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '396710' WHERE ordernumber = 'P420626122345111' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '396710' WHERE ordernumber = 'P420626122440485' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '276877' WHERE ordernumber = 'P200626122612384' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398152' WHERE ordernumber = 'P630626122651517' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '311162' WHERE ordernumber = 'P200626122804615' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398153' WHERE ordernumber = 'P180626122819342' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '313121' WHERE ordernumber = 'P200626123013307' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '342873' WHERE ordernumber = 'P420626123114494' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '296964' WHERE ordernumber = 'P420626123520563' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398154' WHERE ordernumber = 'P180626123532471' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '274900' WHERE ordernumber = 'P190626123653850' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398157' WHERE ordernumber = 'P180626123824476' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '113698' WHERE ordernumber = 'P190626124139345' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398158' WHERE ordernumber = 'P630626124451981' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398159' WHERE ordernumber = 'P200626124546883' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398160' WHERE ordernumber = 'P420626124804396' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '174924' WHERE ordernumber = 'P190626125140474' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '129730' WHERE ordernumber = 'P180626125615953' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '274011' WHERE ordernumber = 'P420626125729311' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '281429' WHERE ordernumber = 'P200626130035785' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '349641' WHERE ordernumber = 'P180626130145699' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '390391' WHERE ordernumber = 'P420626130230785' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '314019' WHERE ordernumber = 'P200626130317481' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398163' WHERE ordernumber = 'P200626130426474' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '137769' WHERE ordernumber = 'P200626130449605' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '314019' WHERE ordernumber = 'P200626130520840' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '235779' WHERE ordernumber = 'P200626130744378' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '94993' WHERE ordernumber = 'P200626130844361' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '379131' WHERE ordernumber = 'P180626130908370' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '233100' WHERE ordernumber = 'P780626131013803' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398164' WHERE ordernumber = 'P630626131340966' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398165' WHERE ordernumber = 'P420626131726818' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398166' WHERE ordernumber = 'P630626131807974' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '141401' WHERE ordernumber = 'P180626132048517' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '141401' WHERE ordernumber = 'P180626132128347' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '305270' WHERE ordernumber = 'P180626132525437' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398168' WHERE ordernumber = 'P630626132547745' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '223982' WHERE ordernumber = 'P180626132830272' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398170' WHERE ordernumber = 'P630626133623629' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '226630' WHERE ordernumber = 'P200626133948604' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '297785' WHERE ordernumber = 'P420626134519527' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '281971' WHERE ordernumber = 'P180626134605920' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '101090' WHERE ordernumber = 'P630626134613781' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398173' WHERE ordernumber = 'P420626134651171' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '98694' WHERE ordernumber = 'P420626134726451' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '386388' WHERE ordernumber = 'P590626134732137' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '281971' WHERE ordernumber = 'P180626134812341' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398172' WHERE ordernumber = 'P420626135022114' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '160035' WHERE ordernumber = 'P200626135101665' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398175' WHERE ordernumber = 'P190626135256335' 2024-06-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398176' WHERE ordernumber = 'P630626135427490' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '238188' WHERE ordernumber = 'P200626135431567' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398177' WHERE ordernumber = 'P630626135541176' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '397859' WHERE ordernumber = 'P420626135549883' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '132376' WHERE ordernumber = 'P180626135723492' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '217542' WHERE ordernumber = 'P420626135818787' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398178' WHERE ordernumber = 'P180626140025308' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '127514' WHERE ordernumber = 'P200626140100657' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398179' WHERE ordernumber = 'P200626140205169' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398180' WHERE ordernumber = 'P420626140639840' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '348250' WHERE ordernumber = 'P630626140730772' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398181' WHERE ordernumber = 'P420626140830220' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398183' WHERE ordernumber = 'P630626140840723' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398184' WHERE ordernumber = 'P180626141319768' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398186' WHERE ordernumber = 'P200626142048685' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398187' WHERE ordernumber = 'P420626142227511' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '339857' WHERE ordernumber = 'P420626142527935' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398188' WHERE ordernumber = 'P180626142639992' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398189' WHERE ordernumber = 'P190626142726955' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '68724' WHERE ordernumber = 'P180626142856731' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398188' WHERE ordernumber = 'P190626143025933' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398190' WHERE ordernumber = 'P420626143047653' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398191' WHERE ordernumber = 'P180626143225443' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '378033' WHERE ordernumber = 'P200626143335918' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398192' WHERE ordernumber = 'P200626143531569' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398192' WHERE ordernumber = 'P200626143603484' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P190626143653165' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398193' WHERE ordernumber = 'P630626143915671' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '394135' WHERE ordernumber = 'P200626144028647' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '283963' WHERE ordernumber = 'P420626144131388' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398195' WHERE ordernumber = 'P180626144550521' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398194' WHERE ordernumber = 'P200626144557501' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '319017' WHERE ordernumber = 'P200626144759401' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398198' WHERE ordernumber = 'P420626145300217' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398199' WHERE ordernumber = 'P630626145315810' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '369819' WHERE ordernumber = 'P190626145554390' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '92525' WHERE ordernumber = 'P780626145616664' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '344831' WHERE ordernumber = 'P190626145643547' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '147946' WHERE ordernumber = 'P180626150054198' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398200' WHERE ordernumber = 'P190626150210396' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398201' WHERE ordernumber = 'P200626150346778' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '394112' WHERE ordernumber = 'P180626150421545' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '394343' WHERE ordernumber = 'P200626150622607' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398202' WHERE ordernumber = 'P180626150925179' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '136511' WHERE ordernumber = 'P200626151037137' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398203' WHERE ordernumber = 'P420626151151843' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '289954' WHERE ordernumber = 'P180626151201447' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '287790' WHERE ordernumber = 'P200626151207656' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '395143' WHERE ordernumber = 'P180626151502862' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398204' WHERE ordernumber = 'P780626151526324' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398205' WHERE ordernumber = 'P420626151611365' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '86039' WHERE ordernumber = 'P200626151613504' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398206' WHERE ordernumber = 'P630626151629929' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '287203' WHERE ordernumber = 'P200626151809321' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '94068' WHERE ordernumber = 'P180626151846756' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398207' WHERE ordernumber = 'P630626151848230' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '342339' WHERE ordernumber = 'P420626151956860' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '395886' WHERE ordernumber = 'P200626152021345' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '391133' WHERE ordernumber = 'P180626152043725' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398208' WHERE ordernumber = 'P200626152204501' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398209' WHERE ordernumber = 'P630626152231332' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '217187' WHERE ordernumber = 'P180626152234958' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398210' WHERE ordernumber = 'P200626152424224' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '393625' WHERE ordernumber = 'P180626152516784' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398211' WHERE ordernumber = 'P630626152605813' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398212' WHERE ordernumber = 'P190626152644620' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398213' WHERE ordernumber = 'P420626152826587' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '391953' WHERE ordernumber = 'P190626152847863' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '114760' WHERE ordernumber = 'P630626153209979' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398215' WHERE ordernumber = 'P180626153222928' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398217' WHERE ordernumber = 'P190626153932335' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '176077' WHERE ordernumber = 'P420626154015758' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '394386' WHERE ordernumber = 'P630626154043433' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398218' WHERE ordernumber = 'P190626154140577' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '291866' WHERE ordernumber = 'P180626154236748' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '352383' WHERE ordernumber = 'P180626154630945' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398219' WHERE ordernumber = 'P420626154833376' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398220' WHERE ordernumber = 'P630626155058137' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '285181' WHERE ordernumber = 'P180626155101234' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398049' WHERE ordernumber = 'P180626155239617' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '352011' WHERE ordernumber = 'P180626155433380' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398223' WHERE ordernumber = 'P630626155435920' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '385866' WHERE ordernumber = 'P630626155439503' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '67684' WHERE ordernumber = 'P200626155742897' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398224' WHERE ordernumber = 'P420626155849572' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398225' WHERE ordernumber = 'P630626160247508' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '291510' WHERE ordernumber = 'P200626160420800' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '176077' WHERE ordernumber = 'P630626160444116' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398226' WHERE ordernumber = 'P190626160447226' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '93488' WHERE ordernumber = 'P180626160710902' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398228' WHERE ordernumber = 'P200626160733583' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '383852' WHERE ordernumber = 'P420626160835259' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398229' WHERE ordernumber = 'P190626161058968' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398231' WHERE ordernumber = 'P630626161405695' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398232' WHERE ordernumber = 'P200626161909473' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398233' WHERE ordernumber = 'P180626162057972' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '385033' WHERE ordernumber = 'P200626162240125' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '167345' WHERE ordernumber = 'P200626162613771' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '133146' WHERE ordernumber = 'P200626162745293' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '296784' WHERE ordernumber = 'P420626162754261' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '344749' WHERE ordernumber = 'P420626163038263' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398235' WHERE ordernumber = 'P200626163107309' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398238' WHERE ordernumber = 'P420626163347270' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '398237' WHERE ordernumber = 'P630626163424623' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '165627' WHERE ordernumber = 'P200626163425459' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '395576' WHERE ordernumber = 'P190626163511918' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '397165' WHERE ordernumber = 'P180626163522889' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '395576' WHERE ordernumber = 'P190626163609193' 2024-06-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '367327' WHERE ordernumber = 'P180626163643456' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '229420' WHERE ordernumber = 'P180626163735399' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '248429' WHERE ordernumber = 'P180626163855169' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398240' WHERE ordernumber = 'P420626163912753' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '393966' WHERE ordernumber = 'P630626163955858' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '309204' WHERE ordernumber = 'P200626164001193' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '191005' WHERE ordernumber = 'P190626164054380' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398241' WHERE ordernumber = 'P200626164200449' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '230554' WHERE ordernumber = 'P180626164436943' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398242' WHERE ordernumber = 'P200626164457944' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398243' WHERE ordernumber = 'P630626164610602' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398071' WHERE ordernumber = 'P190626164737156' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398244' WHERE ordernumber = 'P180626164747285' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '338630' WHERE ordernumber = 'P200626164802543' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398071' WHERE ordernumber = 'P190626164840553' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398246' WHERE ordernumber = 'P630626164840727' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '321680' WHERE ordernumber = 'P180626165358917' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398247' WHERE ordernumber = 'P630626165510409' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398250' WHERE ordernumber = 'P180626165806884' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398252' WHERE ordernumber = 'P420626165823609' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398251' WHERE ordernumber = 'P780626165832353' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '87366' WHERE ordernumber = 'P780626170229330' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '124407' WHERE ordernumber = 'P180626170345501' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '388901' WHERE ordernumber = 'P420626170527625' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398249' WHERE ordernumber = 'P190626170600778' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398249' WHERE ordernumber = 'P190626170641886' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '252044' WHERE ordernumber = 'P200626171257750' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '369737' WHERE ordernumber = 'P190626171310198' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '101538' WHERE ordernumber = 'P180626172121325' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398255' WHERE ordernumber = 'P200626172634299' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '397899' WHERE ordernumber = 'P200626173107616' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '164332' WHERE ordernumber = 'P420626173626560' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '270641' WHERE ordernumber = 'P200626174033693' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398256' WHERE ordernumber = 'P180626174208451' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '397238' WHERE ordernumber = 'P200626174319752' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '304306' WHERE ordernumber = 'P180626174349730' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '397238' WHERE ordernumber = 'P200626174353915' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398259' WHERE ordernumber = 'P630626174644184' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398260' WHERE ordernumber = 'P200626174842967' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '275455' WHERE ordernumber = 'P180626175014666' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398261' WHERE ordernumber = 'P200626175016675' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398262' WHERE ordernumber = 'P190626175130858' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '279902' WHERE ordernumber = 'P180626175212906' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398263' WHERE ordernumber = 'P420626175335464' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '391559' WHERE ordernumber = 'P200626175624741' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398264' WHERE ordernumber = 'P780626175641961' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398267' WHERE ordernumber = 'P200626175804606' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398266' WHERE ordernumber = 'P780626175840925' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '391559' WHERE ordernumber = 'P200626175919300' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '114141' WHERE ordernumber = 'P180626180126121' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '378114' WHERE ordernumber = 'P200626180419202' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '383682' WHERE ordernumber = 'P420626180519129' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398268' WHERE ordernumber = 'P200626180633879' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '305897' WHERE ordernumber = 'P630626180930264' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398269' WHERE ordernumber = 'P630626181107565' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '366710' WHERE ordernumber = 'P420626181302755' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398271' WHERE ordernumber = 'P180626181316432' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398272' WHERE ordernumber = 'P200626181324450' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398270' WHERE ordernumber = 'P630626181330523' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398273' WHERE ordernumber = 'P630626181718890' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '164650' WHERE ordernumber = 'P200626181737563' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398274' WHERE ordernumber = 'P420626181752908' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398275' WHERE ordernumber = 'P630626181912573' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '251302' WHERE ordernumber = 'P780626181930638' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '254938' WHERE ordernumber = 'P630626181935245' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '312073' WHERE ordernumber = 'P180626182107860' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398278' WHERE ordernumber = 'P180626182430225' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398279' WHERE ordernumber = 'P180626182720475' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '281302' WHERE ordernumber = 'P180626182856573' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398280' WHERE ordernumber = 'P200626183130992' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '121743' WHERE ordernumber = 'P180626183248257' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '98000' WHERE ordernumber = 'P200626183341907' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398281' WHERE ordernumber = 'P630626183537377' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '219172' WHERE ordernumber = 'P200626183708326' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '376139' WHERE ordernumber = 'P420626183906261' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398282' WHERE ordernumber = 'P180626183946483' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398283' WHERE ordernumber = 'P200626184211434' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398285' WHERE ordernumber = 'P180626184413509' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398284' WHERE ordernumber = 'P780626184444455' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398286' WHERE ordernumber = 'P180626184541798' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '366349' WHERE ordernumber = 'P590626184619358' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398287' WHERE ordernumber = 'P190626184712501' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398288' WHERE ordernumber = 'P180626184724758' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398289' WHERE ordernumber = 'P630626184842808' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '380916' WHERE ordernumber = 'P420626185049576' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '345655' WHERE ordernumber = 'P200626185749161' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398290' WHERE ordernumber = 'P630626185848493' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '333856' WHERE ordernumber = 'P200626190050718' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '313332' WHERE ordernumber = 'P200626190210911' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '210626' WHERE ordernumber = 'P630626190245281' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '231037' WHERE ordernumber = 'P200626190342469' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398107' WHERE ordernumber = 'P630626190516256' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '375030' WHERE ordernumber = 'P190626190522130' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398291' WHERE ordernumber = 'P190626190635513' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '390002' WHERE ordernumber = 'P590626190714138' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '391788' WHERE ordernumber = 'P200626190755590' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '174924' WHERE ordernumber = 'P190626191025883' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398292' WHERE ordernumber = 'P200626191148985' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398294' WHERE ordernumber = 'P200626191603532' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398297' WHERE ordernumber = 'P630626192159220' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398298' WHERE ordernumber = 'P630626192301399' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398299' WHERE ordernumber = 'P190626192301730' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '303307' WHERE ordernumber = 'P200626192339332' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398300' WHERE ordernumber = 'P190626192531353' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '317371' WHERE ordernumber = 'P190626192655997' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398301' WHERE ordernumber = 'P630626192702257' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398303' WHERE ordernumber = 'P200626192903435' 2024-06-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '398304' WHERE ordernumber = 'P190626192906758' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '20510' WHERE ordernumber = 'P200626193018826' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '166015' WHERE ordernumber = 'P190626193244538' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '105186' WHERE ordernumber = 'P190626193452846' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398305' WHERE ordernumber = 'P630626193656168' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398306' WHERE ordernumber = 'P200626193813737' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398309' WHERE ordernumber = 'P200626194306156' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '393594' WHERE ordernumber = 'P200626194321992' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398302' WHERE ordernumber = 'P190626194401895' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398307' WHERE ordernumber = 'P630626194504949' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398310' WHERE ordernumber = 'P190626194545881' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398311' WHERE ordernumber = 'P190626194741704' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398312' WHERE ordernumber = 'P780626194856539' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '340806' WHERE ordernumber = 'P190626195039116' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '209842' WHERE ordernumber = 'P190626195430233' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '307491' WHERE ordernumber = 'P190626195728126' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '94945' WHERE ordernumber = 'P630626201136808' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '398317' WHERE ordernumber = 'P630626201831670' 2024-06-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '317477' WHERE ordernumber = 'P590626211408854'