2024-09-13 01:00:02 -- 將會員中心id寫入data-lake 2024-09-13 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-09-12%'; 2024-09-13 01:00:02 -- UPDATE `omo_order_list` SET userId = '121498' WHERE ordernumber = 'P200912110206140' 2024-09-13 01:00:02 -- UPDATE `omo_order_list` SET userId = '420720' WHERE ordernumber = 'P190912110435178' 2024-09-13 01:00:02 -- UPDATE `omo_order_list` SET userId = '420724' WHERE ordernumber = 'P420912110513570' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '310805' WHERE ordernumber = 'P180912110532681' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '310805' WHERE ordernumber = 'P180912110618161' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '310805' WHERE ordernumber = 'P180912110656823' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420727' WHERE ordernumber = 'P420912110737457' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420650' WHERE ordernumber = 'P190912110810330' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '392288' WHERE ordernumber = 'P420912110925601' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '316629' WHERE ordernumber = 'P190912110952765' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420728' WHERE ordernumber = 'P420912111022885' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '304909' WHERE ordernumber = 'P420912111111223' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '418589' WHERE ordernumber = 'P200912111126867' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420717' WHERE ordernumber = 'P180912111214190' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '418589' WHERE ordernumber = 'P200912111245157' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420729' WHERE ordernumber = 'P420912111330346' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '339395' WHERE ordernumber = 'P200912111435746' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420726' WHERE ordernumber = 'P420912111534120' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '227420' WHERE ordernumber = 'P200912111611537' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420721' WHERE ordernumber = 'P190912111625172' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420732' WHERE ordernumber = 'P420912111651720' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '277364' WHERE ordernumber = 'P200912111839314' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '338230' WHERE ordernumber = 'P420912111856686' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '338230' WHERE ordernumber = 'P420912111954880' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420733' WHERE ordernumber = 'P200912112029746' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '138351' WHERE ordernumber = 'P200912112142986' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420734' WHERE ordernumber = 'P420912112156715' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420723' WHERE ordernumber = 'P180912112232507' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420725' WHERE ordernumber = 'P180912112322876' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '418593' WHERE ordernumber = 'P420912112456782' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '306462' WHERE ordernumber = 'P180912112532828' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '396167' WHERE ordernumber = 'P200912112608569' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420740' WHERE ordernumber = 'P420912112633801' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '406328' WHERE ordernumber = 'P180912112702130' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420741' WHERE ordernumber = 'P420912112755674' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '353738' WHERE ordernumber = 'P190912112824460' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '333059' WHERE ordernumber = 'P420912112845258' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420742' WHERE ordernumber = 'P420912112947604' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '262949' WHERE ordernumber = 'P420912113031869' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '105788' WHERE ordernumber = 'P200912113109412' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '417152' WHERE ordernumber = 'P420912113132507' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '384758' WHERE ordernumber = 'P420912113226349' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420730' WHERE ordernumber = 'P180912113432948' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '355435' WHERE ordernumber = 'P200912113433544' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420744' WHERE ordernumber = 'P420912113500461' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '352547' WHERE ordernumber = 'P180912113606854' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '156763' WHERE ordernumber = 'P200912113623718' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420745' WHERE ordernumber = 'P420912113709156' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420145' WHERE ordernumber = 'P420912113809912' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420746' WHERE ordernumber = 'P200912113831393' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420748' WHERE ordernumber = 'P420912113856116' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420704' WHERE ordernumber = 'P190912113949969' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420705' WHERE ordernumber = 'P180912114005716' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '336173' WHERE ordernumber = 'P190912114032434' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420749' WHERE ordernumber = 'P420912114032774' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '416841' WHERE ordernumber = 'P180912114044616' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '410455' WHERE ordernumber = 'P420912114152510' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '410452' WHERE ordernumber = 'P420912114258566' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '417958' WHERE ordernumber = 'P420912114344245' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420731' WHERE ordernumber = 'P420912114521584' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420743' WHERE ordernumber = 'P190912114628993' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '98837' WHERE ordernumber = 'P180912114657705' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420752' WHERE ordernumber = 'P420912114727919' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420753' WHERE ordernumber = 'P420912114814502' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '379910' WHERE ordernumber = 'P590912114854750' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '337903' WHERE ordernumber = 'P200912114907288' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420755' WHERE ordernumber = 'P420912114908448' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '230073' WHERE ordernumber = 'P180912115055530' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '334590' WHERE ordernumber = 'P420912115123577' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420515' WHERE ordernumber = 'P420912115232627' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '401411' WHERE ordernumber = 'P200912115254989' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '275564' WHERE ordernumber = 'P180912115335456' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420757' WHERE ordernumber = 'P420912115339688' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '419299' WHERE ordernumber = 'P420912115421555' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420667' WHERE ordernumber = 'P180912115731710' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '98529' WHERE ordernumber = 'P190912115743671' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '392584' WHERE ordernumber = 'P420912115750639' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '43920' WHERE ordernumber = 'P180912115807596' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '98694' WHERE ordernumber = 'P420912115914343' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420759' WHERE ordernumber = 'P420912120028431' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '130968' WHERE ordernumber = 'P180912120325344' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '420752' WHERE ordernumber = 'P420912120334298' 2024-09-13 01:00:03 -- UPDATE `omo_order_list` SET userId = '419285' WHERE ordernumber = 'P420912120538672' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420760' WHERE ordernumber = 'P200912120550193' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420761' WHERE ordernumber = 'P420912121017631' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '192724' WHERE ordernumber = 'P1050912121138185' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '418340' WHERE ordernumber = 'P200912121345784' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '414877' WHERE ordernumber = 'P420912121421529' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '305137' WHERE ordernumber = 'P200912121552991' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420762' WHERE ordernumber = 'P420912121718268' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420763' WHERE ordernumber = 'P200912122128524' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '226549' WHERE ordernumber = 'P200912122349694' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '394739' WHERE ordernumber = 'P420912122404655' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420764' WHERE ordernumber = 'P200912122512710' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420484' WHERE ordernumber = 'P180912122514922' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '411210' WHERE ordernumber = 'P200912122612295' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '419643' WHERE ordernumber = 'P200912122914666' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '131159' WHERE ordernumber = 'P190912123017510' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '345359' WHERE ordernumber = 'P200912123051315' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '331477' WHERE ordernumber = 'P190912123206853' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '356002' WHERE ordernumber = 'P200912123327795' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420765' WHERE ordernumber = 'P180912123420884' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '69955' WHERE ordernumber = 'P200912123532433' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '315257' WHERE ordernumber = 'P200912123625201' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '253993' WHERE ordernumber = 'P420912123636728' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '359360' WHERE ordernumber = 'P200912123757439' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '334936' WHERE ordernumber = 'P190912123810713' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '373451' WHERE ordernumber = 'P420912124054319' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420758' WHERE ordernumber = 'P180912124203808' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420758' WHERE ordernumber = 'P180912124421604' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420769' WHERE ordernumber = 'P420912125159393' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '105625' WHERE ordernumber = 'P590912125351944' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '84477' WHERE ordernumber = 'P180912125427507' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '105984' WHERE ordernumber = 'P180912130209501' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420770' WHERE ordernumber = 'P200912130230522' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '344455' WHERE ordernumber = 'P420912130315565' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '374726' WHERE ordernumber = 'P420912130416300' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420772' WHERE ordernumber = 'P200912130523323' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420773' WHERE ordernumber = 'P420912130532756' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '339230' WHERE ordernumber = 'P200912130654464' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '339230' WHERE ordernumber = 'P200912130927178' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420775' WHERE ordernumber = 'P420912130944480' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '350835' WHERE ordernumber = 'P180912131024590' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '233982' WHERE ordernumber = 'P420912131113211' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '388538' WHERE ordernumber = 'P420912131151356' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420776' WHERE ordernumber = 'P200912131307892' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420777' WHERE ordernumber = 'P420912131353264' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420778' WHERE ordernumber = 'P420912131514860' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '418876' WHERE ordernumber = 'P420912131619230' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '105984' WHERE ordernumber = 'P180912131654856' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '394483' WHERE ordernumber = 'P420912131702467' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '266572' WHERE ordernumber = 'P200912131806519' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '365174' WHERE ordernumber = 'P200912132013185' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '153389' WHERE ordernumber = 'P200912132227799' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '128432' WHERE ordernumber = 'P180912132501636' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '418304' WHERE ordernumber = 'P420912132528257' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420547' WHERE ordernumber = 'P420912132700409' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '97984' WHERE ordernumber = 'P420912132751177' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '419651' WHERE ordernumber = 'P190912133009314' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '120508' WHERE ordernumber = 'P200912133401861' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420782' WHERE ordernumber = 'P420912133509164' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '143832' WHERE ordernumber = 'P420912134032891' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420783' WHERE ordernumber = 'P200912134114265' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420783' WHERE ordernumber = 'P200912134229617' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '388537' WHERE ordernumber = 'P200912134313711' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420784' WHERE ordernumber = 'P420912134412348' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '406353' WHERE ordernumber = 'P180912134527775' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '272693' WHERE ordernumber = 'P180912134550362' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420785' WHERE ordernumber = 'P200912134701504' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '331449' WHERE ordernumber = 'P180912134913210' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '417952' WHERE ordernumber = 'P200912134914531' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '153875' WHERE ordernumber = 'P200912135012837' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '55438' WHERE ordernumber = 'P630912135030882' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '403168' WHERE ordernumber = 'P200912135108961' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '195003' WHERE ordernumber = 'P200912135227474' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420787' WHERE ordernumber = 'P420912135540858' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '218565' WHERE ordernumber = 'P200912135615688' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420786' WHERE ordernumber = 'P420912135633224' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420789' WHERE ordernumber = 'P420912135912237' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '401852' WHERE ordernumber = 'P180912135917942' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420788' WHERE ordernumber = 'P200912140026396' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420790' WHERE ordernumber = 'P420912140138137' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420791' WHERE ordernumber = 'P200912140144879' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '344412' WHERE ordernumber = 'P200912140235238' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '161172' WHERE ordernumber = 'P200912140344318' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '282418' WHERE ordernumber = 'P200912140619287' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '420794' WHERE ordernumber = 'P420912141011974' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '120228' WHERE ordernumber = 'P190912141124378' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '271172' WHERE ordernumber = 'P190912141230617' 2024-09-13 01:00:04 -- UPDATE `omo_order_list` SET userId = '402838' WHERE ordernumber = 'P180912141334822' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '401852' WHERE ordernumber = 'P180912141557495' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '238603' WHERE ordernumber = 'P200912141646699' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '377556' WHERE ordernumber = 'P190912141659323' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '415481' WHERE ordernumber = 'P200912141936669' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '415481' WHERE ordernumber = 'P200912142030510' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '418825' WHERE ordernumber = 'P420912142421215' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '414829' WHERE ordernumber = 'P180912142441734' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '221500' WHERE ordernumber = 'P200912142713873' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '237023' WHERE ordernumber = 'P200912142823354' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420797' WHERE ordernumber = 'P420912142848967' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '279039' WHERE ordernumber = 'P200912143010358' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '255493' WHERE ordernumber = 'P180912143030188' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420796' WHERE ordernumber = 'P1050912143059882' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '230936' WHERE ordernumber = 'P200912143110653' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420796' WHERE ordernumber = 'P1050912143200846' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '263776' WHERE ordernumber = 'P190912143415233' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '419404' WHERE ordernumber = 'P180912143537916' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '290554' WHERE ordernumber = 'P630912143617647' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '209714' WHERE ordernumber = 'P180912143718256' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '419777' WHERE ordernumber = 'P190912143804494' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420798' WHERE ordernumber = 'P420912143858590' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '412167' WHERE ordernumber = 'P180912144042725' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420799' WHERE ordernumber = 'P420912144058896' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '219267' WHERE ordernumber = 'P200912144257704' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '365094' WHERE ordernumber = 'P200912144354210' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '93822' WHERE ordernumber = 'P200912144502943' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '251706' WHERE ordernumber = 'P420912144813354' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '291566' WHERE ordernumber = 'P420912144946713' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '288515' WHERE ordernumber = 'P1050912145101410' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420802' WHERE ordernumber = 'P180912145211367' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '418849' WHERE ordernumber = 'P630912145358599' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420710' WHERE ordernumber = 'P200912145615336' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420804' WHERE ordernumber = 'P200912145748791' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420793' WHERE ordernumber = 'P420912145833739' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420793' WHERE ordernumber = 'P420912145911418' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '261374' WHERE ordernumber = 'P420912150121182' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '279592' WHERE ordernumber = 'P200912150205744' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '286205' WHERE ordernumber = 'P200912150249926' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '394488' WHERE ordernumber = 'P200912150805496' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '416355' WHERE ordernumber = 'P420912150849472' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '419014' WHERE ordernumber = 'P200912151009309' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '336089' WHERE ordernumber = 'P420912151106986' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '328697' WHERE ordernumber = 'P180912151118974' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '336089' WHERE ordernumber = 'P420912151148983' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420810' WHERE ordernumber = 'P420912151254892' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '419269' WHERE ordernumber = 'P200912151319202' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '229855' WHERE ordernumber = 'P180912151441171' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '124590' WHERE ordernumber = 'P180912151635867' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420811' WHERE ordernumber = 'P420912151712259' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '419700' WHERE ordernumber = 'P420912152044435' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '82466' WHERE ordernumber = 'P200912152128989' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420809' WHERE ordernumber = 'P630912152320944' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '245094' WHERE ordernumber = 'P190912152639743' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '406647' WHERE ordernumber = 'P180912152708446' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '329883' WHERE ordernumber = 'P180912153248281' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420812' WHERE ordernumber = 'P420912153749372' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420813' WHERE ordernumber = 'P420912154147362' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '379217' WHERE ordernumber = 'P420912154242805' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '248048' WHERE ordernumber = 'P180912154440699' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '418349' WHERE ordernumber = 'P420912154826257' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420814' WHERE ordernumber = 'P420912155140876' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '348905' WHERE ordernumber = 'P200912155148831' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '417312' WHERE ordernumber = 'P420912155307907' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '413112' WHERE ordernumber = 'P420912155340333' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '418349' WHERE ordernumber = 'P420912155518119' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420817' WHERE ordernumber = 'P420912155913486' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420816' WHERE ordernumber = 'P1050912155949292' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '411212' WHERE ordernumber = 'P420912160115172' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '342363' WHERE ordernumber = 'P180912160620399' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '396154' WHERE ordernumber = 'P200912160755270' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '414626' WHERE ordernumber = 'P180912160821308' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '240610' WHERE ordernumber = 'P180912160933451' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '96012' WHERE ordernumber = 'P200912161045588' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '408327' WHERE ordernumber = 'P420912161329741' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420822' WHERE ordernumber = 'P200912161707147' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '251486' WHERE ordernumber = 'P180912161905654' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '416457' WHERE ordernumber = 'P200912162354912' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420823' WHERE ordernumber = 'P420912162529442' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '304730' WHERE ordernumber = 'P200912162709184' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '226927' WHERE ordernumber = 'P180912163034229' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420824' WHERE ordernumber = 'P200912163058777' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '406005' WHERE ordernumber = 'P180912163110834' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420825' WHERE ordernumber = 'P420912163215399' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '416341' WHERE ordernumber = 'P420912163404351' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '273049' WHERE ordernumber = 'P200912163628833' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '244648' WHERE ordernumber = 'P200912163806659' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420826' WHERE ordernumber = 'P200912163926540' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '323002' WHERE ordernumber = 'P180912165012446' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '163897' WHERE ordernumber = 'P200912165312309' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '305991' WHERE ordernumber = 'P420912165406609' 2024-09-13 01:00:05 -- UPDATE `omo_order_list` SET userId = '420831' WHERE ordernumber = 'P420912165606337' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P180912165627427' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '305991' WHERE ordernumber = 'P420912165655734' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420832' WHERE ordernumber = 'P420912165808847' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420832' WHERE ordernumber = 'P420912165932482' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '340529' WHERE ordernumber = 'P200912170053369' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420828' WHERE ordernumber = 'P1050912170152544' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '350922' WHERE ordernumber = 'P190912170227120' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '374729' WHERE ordernumber = 'P420912170255122' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420828' WHERE ordernumber = 'P1050912170334623' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '397209' WHERE ordernumber = 'P190912170522290' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '380438' WHERE ordernumber = 'P180912170615613' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '368042' WHERE ordernumber = 'P420912170733419' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '409166' WHERE ordernumber = 'P200912170905183' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '366196' WHERE ordernumber = 'P180912170908114' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420834' WHERE ordernumber = 'P420912170918448' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '409166' WHERE ordernumber = 'P200912170929359' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '366196' WHERE ordernumber = 'P180912170949307' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420835' WHERE ordernumber = 'P420912171025251' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '298481' WHERE ordernumber = 'P420912171224382' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '304198' WHERE ordernumber = 'P200912171531381' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '356068' WHERE ordernumber = 'P180912171601894' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420661' WHERE ordernumber = 'P630912171853844' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '121308' WHERE ordernumber = 'P420912172724520' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '416799' WHERE ordernumber = 'P420912172828930' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '366850' WHERE ordernumber = 'P420912172930994' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '412927' WHERE ordernumber = 'P180912173208805' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '353531' WHERE ordernumber = 'P180912173911233' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420840' WHERE ordernumber = 'P420912173929627' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '89714' WHERE ordernumber = 'P180912174137625' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420841' WHERE ordernumber = 'P420912174147391' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '333297' WHERE ordernumber = 'P180912174500515' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '311284' WHERE ordernumber = 'P200912174543541' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '107987' WHERE ordernumber = 'P590912175027856' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420843' WHERE ordernumber = 'P420912175110112' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420844' WHERE ordernumber = 'P420912175221206' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420845' WHERE ordernumber = 'P420912175547963' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '297678' WHERE ordernumber = 'P200912175703388' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420846' WHERE ordernumber = 'P420912175705868' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '350014' WHERE ordernumber = 'P200912175805971' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420847' WHERE ordernumber = 'P420912175833920' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420848' WHERE ordernumber = 'P420912180220526' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420850' WHERE ordernumber = 'P420912181030924' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '418097' WHERE ordernumber = 'P420912181352214' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '327471' WHERE ordernumber = 'P200912181410263' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420853' WHERE ordernumber = 'P200912181546671' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '417308' WHERE ordernumber = 'P180912182356257' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '67684' WHERE ordernumber = 'P200912182807180' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420854' WHERE ordernumber = 'P420912183115898' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '220826' WHERE ordernumber = 'P420912184121996' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420723' WHERE ordernumber = 'P180912184541898' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '219645' WHERE ordernumber = 'P180912184706599' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420857' WHERE ordernumber = 'P1050912184807896' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '196319' WHERE ordernumber = 'P200912184904853' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '82588' WHERE ordernumber = 'P200912185038815' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '64829' WHERE ordernumber = 'P200912185151188' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '305075' WHERE ordernumber = 'P200912185236155' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '293682' WHERE ordernumber = 'P200912185339134' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '16876' WHERE ordernumber = 'P420912185832415' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '398973' WHERE ordernumber = 'P630912185941868' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '266141' WHERE ordernumber = 'P200912190557220' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '88926' WHERE ordernumber = 'P190912191541312' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '88926' WHERE ordernumber = 'P190912191713775' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '20559' WHERE ordernumber = 'P190912192631165' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '339173' WHERE ordernumber = 'P190912192820888' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '126954' WHERE ordernumber = 'P630912193042360' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '98869' WHERE ordernumber = 'P200912193228342' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '23083' WHERE ordernumber = 'P200912194330413' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '384507' WHERE ordernumber = 'P190912194629550' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420868' WHERE ordernumber = 'P1050912201247410' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '353493' WHERE ordernumber = 'P630912201734111' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '98418' WHERE ordernumber = 'P630912203251641' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420869' WHERE ordernumber = 'P1050912205350453' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420871' WHERE ordernumber = 'P1050912205654818' 2024-09-13 01:00:06 -- UPDATE `omo_order_list` SET userId = '420833' WHERE ordernumber = 'P1050912210017929'