2024-09-12 01:00:01 -- 將會員中心id寫入data-lake 2024-09-12 01:00:01 -- 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-11%'; 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '298067' WHERE ordernumber = 'P630911105728127' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '401503' WHERE ordernumber = 'P190911110119725' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '382266' WHERE ordernumber = 'P420911110217362' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '379873' WHERE ordernumber = 'P420911110325922' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '319423' WHERE ordernumber = 'P200911110338652' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '375845' WHERE ordernumber = 'P200911110428855' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420544' WHERE ordernumber = 'P420911110507236' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '221129' WHERE ordernumber = 'P180911110639233' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420543' WHERE ordernumber = 'P200911110701979' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '387378' WHERE ordernumber = 'P200911110740278' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420546' WHERE ordernumber = 'P420911110807306' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420534' WHERE ordernumber = 'P420911110851918' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420547' WHERE ordernumber = 'P420911111050626' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '280528' WHERE ordernumber = 'P630911111212993' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420548' WHERE ordernumber = 'P420911111225911' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '393401' WHERE ordernumber = 'P200911111248869' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '103830' WHERE ordernumber = 'P180911111432621' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420550' WHERE ordernumber = 'P420911111719779' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '332904' WHERE ordernumber = 'P190911111739391' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '140097' WHERE ordernumber = 'P200911111841999' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420551' WHERE ordernumber = 'P420911111845608' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '338198' WHERE ordernumber = 'P190911111853312' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '130464' WHERE ordernumber = 'P190911111939808' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420536' WHERE ordernumber = 'P180911111949144' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '127058' WHERE ordernumber = 'P200911112023322' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420535' WHERE ordernumber = 'P190911112045346' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '251511' WHERE ordernumber = 'P180911112133513' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '419586' WHERE ordernumber = 'P200911112330512' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '235236' WHERE ordernumber = 'P190911112336584' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420554' WHERE ordernumber = 'P420911112516317' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '306735' WHERE ordernumber = 'P200911112526190' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420555' WHERE ordernumber = 'P420911112602635' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '231103' WHERE ordernumber = 'P200911112614784' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420540' WHERE ordernumber = 'P420911112628692' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420545' WHERE ordernumber = 'P420911112702490' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '314363' WHERE ordernumber = 'P200911112824657' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180911112857453' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420556' WHERE ordernumber = 'P420911112958763' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '19198' WHERE ordernumber = 'P420911113039720' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '416062' WHERE ordernumber = 'P420911113204694' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '302780' WHERE ordernumber = 'P200911113217888' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '393401' WHERE ordernumber = 'P200911113326692' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '314080' WHERE ordernumber = 'P190911113527473' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '394483' WHERE ordernumber = 'P420911113609746' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420553' WHERE ordernumber = 'P180911113622942' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '417912' WHERE ordernumber = 'P190911113657583' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420559' WHERE ordernumber = 'P420911113738654' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420560' WHERE ordernumber = 'P420911114130194' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420561' WHERE ordernumber = 'P420911114235700' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '419991' WHERE ordernumber = 'P630911114259769' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420558' WHERE ordernumber = 'P190911114346481' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420562' WHERE ordernumber = 'P420911114421527' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420563' WHERE ordernumber = 'P420911114546405' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '412239' WHERE ordernumber = 'P180911114744546' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '415342' WHERE ordernumber = 'P180911114830944' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '339637' WHERE ordernumber = 'P420911114923959' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '391265' WHERE ordernumber = 'P180911115041791' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '98694' WHERE ordernumber = 'P420911115153309' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '263124' WHERE ordernumber = 'P200911115206358' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420566' WHERE ordernumber = 'P420911115305419' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420567' WHERE ordernumber = 'P200911115405788' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420568' WHERE ordernumber = 'P420911115429507' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '257301' WHERE ordernumber = 'P200911115512658' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '299325' WHERE ordernumber = 'P420911115606633' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '342013' WHERE ordernumber = 'P420911115706750' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '216656' WHERE ordernumber = 'P630911115714496' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '420570' WHERE ordernumber = 'P420911115812512' 2024-09-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '271320' WHERE ordernumber = 'P190911115905194' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420572' WHERE ordernumber = 'P420911120101902' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420573' WHERE ordernumber = 'P420911120207936' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364589' WHERE ordernumber = 'P420911120230196' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '416288' WHERE ordernumber = 'P420911120350395' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '336157' WHERE ordernumber = 'P180911120644746' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '163315' WHERE ordernumber = 'P420911120719958' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '97441' WHERE ordernumber = 'P200911120720893' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '129715' WHERE ordernumber = 'P190911120838483' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '336956' WHERE ordernumber = 'P420911120913486' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '397967' WHERE ordernumber = 'P190911120928497' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '230728' WHERE ordernumber = 'P200911120935770' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '394590' WHERE ordernumber = 'P200911121020459' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '418418' WHERE ordernumber = 'P180911121100189' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '334435' WHERE ordernumber = 'P180911121147331' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '125914' WHERE ordernumber = 'P180911121219123' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '133753' WHERE ordernumber = 'P200911121346572' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420575' WHERE ordernumber = 'P200911121547661' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '418418' WHERE ordernumber = 'P180911121703820' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '214255' WHERE ordernumber = 'P420911121737957' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420576' WHERE ordernumber = 'P420911122223211' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '137217' WHERE ordernumber = 'P200911122420321' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '303682' WHERE ordernumber = 'P420911122430231' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420577' WHERE ordernumber = 'P420911122623193' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '331449' WHERE ordernumber = 'P190911122633347' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420577' WHERE ordernumber = 'P420911122728462' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '311190' WHERE ordernumber = 'P180911122752571' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420578' WHERE ordernumber = 'P420911123142146' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420579' WHERE ordernumber = 'P420911123320749' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200911123326923' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '209438' WHERE ordernumber = 'P180911123332149' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '141153' WHERE ordernumber = 'P180911123458794' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420580' WHERE ordernumber = 'P420911123636717' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '403089' WHERE ordernumber = 'P200911124046328' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '355703' WHERE ordernumber = 'P200911124151603' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '86775' WHERE ordernumber = 'P190911124559148' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '347715' WHERE ordernumber = 'P180911124853241' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '385806' WHERE ordernumber = 'P420911124857495' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '279239' WHERE ordernumber = 'P200911124906729' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420541' WHERE ordernumber = 'P180911125055247' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420541' WHERE ordernumber = 'P180911125127826' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420584' WHERE ordernumber = 'P420911125211361' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420585' WHERE ordernumber = 'P420911125412514' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '161810' WHERE ordernumber = 'P420911125620851' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420586' WHERE ordernumber = 'P200911125636531' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '338424' WHERE ordernumber = 'P420911130222680' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '416147' WHERE ordernumber = 'P190911130304799' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420588' WHERE ordernumber = 'P420911130509896' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '418368' WHERE ordernumber = 'P190911130801865' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '403535' WHERE ordernumber = 'P630911130806540' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '397257' WHERE ordernumber = 'P200911130946979' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420590' WHERE ordernumber = 'P420911131147897' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '83903' WHERE ordernumber = 'P200911131249586' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420592' WHERE ordernumber = 'P420911131306777' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '137430' WHERE ordernumber = 'P200911131450187' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '30133' WHERE ordernumber = 'P420911131507648' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420593' WHERE ordernumber = 'P420911131609418' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '336197' WHERE ordernumber = 'P190911131903718' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '393447' WHERE ordernumber = 'P420911131914728' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '263553' WHERE ordernumber = 'P200911132143388' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '376504' WHERE ordernumber = 'P420911132419753' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '93882' WHERE ordernumber = 'P200911132945525' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420598' WHERE ordernumber = 'P200911133333202' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420599' WHERE ordernumber = 'P200911133517148' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '315266' WHERE ordernumber = 'P420911133644401' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '72166' WHERE ordernumber = 'P420911134053218' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '129132' WHERE ordernumber = 'P180911134708990' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '305700' WHERE ordernumber = 'P180911134836599' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '130214' WHERE ordernumber = 'P180911135131747' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '108927' WHERE ordernumber = 'P180911135639392' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '404754' WHERE ordernumber = 'P180911135739316' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '287199' WHERE ordernumber = 'P180911135817777' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420605' WHERE ordernumber = 'P420911140256798' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '420606' WHERE ordernumber = 'P420911140447625' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '303878' WHERE ordernumber = 'P200911140613915' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '303878' WHERE ordernumber = 'P200911140615795' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '298853' WHERE ordernumber = 'P190911140703668' 2024-09-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '233522' WHERE ordernumber = 'P180911140710295' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '170426' WHERE ordernumber = 'P180911140811720' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '411783' WHERE ordernumber = 'P420911141031250' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '411783' WHERE ordernumber = 'P420911141118783' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '291826' WHERE ordernumber = 'P180911141214158' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420609' WHERE ordernumber = 'P420911141237596' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '248077' WHERE ordernumber = 'P180911141245198' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420611' WHERE ordernumber = 'P420911141405149' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '161566' WHERE ordernumber = 'P200911141501369' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420612' WHERE ordernumber = 'P420911141609170' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '378150' WHERE ordernumber = 'P180911141746620' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '279483' WHERE ordernumber = 'P420911142026394' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420613' WHERE ordernumber = 'P420911142504957' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '414177' WHERE ordernumber = 'P180911142649150' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420613' WHERE ordernumber = 'P420911142716527' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '298619' WHERE ordernumber = 'P420911143028541' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '211521' WHERE ordernumber = 'P180911143035381' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '72720' WHERE ordernumber = 'P420911143436762' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '384231' WHERE ordernumber = 'P200911143516994' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '405508' WHERE ordernumber = 'P190911143558254' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '385933' WHERE ordernumber = 'P190911143743465' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '27462' WHERE ordernumber = 'P200911143803115' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420618' WHERE ordernumber = 'P420911143855518' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '418230' WHERE ordernumber = 'P180911143856559' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '402072' WHERE ordernumber = 'P420911144147765' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420620' WHERE ordernumber = 'P420911144308646' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '417764' WHERE ordernumber = 'P190911144706763' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '417764' WHERE ordernumber = 'P190911144723272' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '374913' WHERE ordernumber = 'P180911144752897' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '377310' WHERE ordernumber = 'P200911144848849' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420624' WHERE ordernumber = 'P420911144904373' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '251464' WHERE ordernumber = 'P420911145018253' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '266572' WHERE ordernumber = 'P200911145047508' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '59627' WHERE ordernumber = 'P420911145114634' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '98042' WHERE ordernumber = 'P200911145216492' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '346360' WHERE ordernumber = 'P420911145420238' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '44959' WHERE ordernumber = 'P420911145608725' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '262664' WHERE ordernumber = 'P180911145640878' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '302736' WHERE ordernumber = 'P420911145645892' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420627' WHERE ordernumber = 'P420911145844882' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '342660' WHERE ordernumber = 'P420911145940318' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '50726' WHERE ordernumber = 'P180911150531422' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '415423' WHERE ordernumber = 'P420911150735955' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '419582' WHERE ordernumber = 'P180911151041902' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '104726' WHERE ordernumber = 'P420911151234973' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '340805' WHERE ordernumber = 'P180911151313823' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '340805' WHERE ordernumber = 'P180911151344191' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '297229' WHERE ordernumber = 'P420911151442349' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420629' WHERE ordernumber = 'P420911151826402' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '99638' WHERE ordernumber = 'P180911151851471' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '392985' WHERE ordernumber = 'P200911151944654' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420271' WHERE ordernumber = 'P180911152144210' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '415682' WHERE ordernumber = 'P180911152351815' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '328429' WHERE ordernumber = 'P200911152434463' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '413129' WHERE ordernumber = 'P180911152506274' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '400381' WHERE ordernumber = 'P180911152540354' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420631' WHERE ordernumber = 'P200911152606759' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '241783' WHERE ordernumber = 'P180911152624384' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '416163' WHERE ordernumber = 'P180911152700152' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '416163' WHERE ordernumber = 'P180911152739469' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '419134' WHERE ordernumber = 'P180911152848366' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '339499' WHERE ordernumber = 'P190911152908666' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420615' WHERE ordernumber = 'P180911153045837' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420630' WHERE ordernumber = 'P190911153220615' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '377920' WHERE ordernumber = 'P420911153318607' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '352298' WHERE ordernumber = 'P190911153359893' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '317293' WHERE ordernumber = 'P420911153406442' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420635' WHERE ordernumber = 'P200911153635631' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420634' WHERE ordernumber = 'P190911153734599' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '255531' WHERE ordernumber = 'P200911153819609' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '88985' WHERE ordernumber = 'P180911154111585' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '367975' WHERE ordernumber = 'P200911154602183' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '89674' WHERE ordernumber = 'P200911154753282' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '237250' WHERE ordernumber = 'P200911154923376' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '329997' WHERE ordernumber = 'P180911155133883' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '288934' WHERE ordernumber = 'P190911155621288' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '389538' WHERE ordernumber = 'P420911155812375' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '337912' WHERE ordernumber = 'P190911160006359' 2024-09-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '420606' WHERE ordernumber = 'P420911160518669' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '279648' WHERE ordernumber = 'P180911160523917' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420637' WHERE ordernumber = 'P420911160711151' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420638' WHERE ordernumber = 'P420911161022163' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '337425' WHERE ordernumber = 'P420911161135118' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '385158' WHERE ordernumber = 'P420911161234263' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420639' WHERE ordernumber = 'P420911161435894' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420640' WHERE ordernumber = 'P420911161607902' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '408489' WHERE ordernumber = 'P200911161618921' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '255814' WHERE ordernumber = 'P180911161635419' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420641' WHERE ordernumber = 'P420911161713627' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419566' WHERE ordernumber = 'P420911161814527' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419566' WHERE ordernumber = 'P420911161851315' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420640' WHERE ordernumber = 'P420911162001483' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '413187' WHERE ordernumber = 'P420911162127301' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '293455' WHERE ordernumber = 'P420911162246336' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420440' WHERE ordernumber = 'P420911162552670' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420440' WHERE ordernumber = 'P420911162704825' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420644' WHERE ordernumber = 'P420911162802935' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420640' WHERE ordernumber = 'P420911162826270' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '405413' WHERE ordernumber = 'P420911162927882' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '352489' WHERE ordernumber = 'P420911163016954' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '233788' WHERE ordernumber = 'P180911163030437' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '339242' WHERE ordernumber = 'P420911163051621' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '352410' WHERE ordernumber = 'P190911163059554' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '343618' WHERE ordernumber = 'P180911163200466' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '333059' WHERE ordernumber = 'P420911163255871' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '333059' WHERE ordernumber = 'P420911163345463' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '323051' WHERE ordernumber = 'P180911163601548' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419354' WHERE ordernumber = 'P420911163704122' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419354' WHERE ordernumber = 'P420911163759314' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '339724' WHERE ordernumber = 'P200911163832931' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '208646' WHERE ordernumber = 'P420911163847528' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420646' WHERE ordernumber = 'P420911163951519' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420648' WHERE ordernumber = 'P420911164132599' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '417146' WHERE ordernumber = 'P180911164307439' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '405259' WHERE ordernumber = 'P180911164417517' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419601' WHERE ordernumber = 'P200911164432363' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '282853' WHERE ordernumber = 'P200911164620797' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420649' WHERE ordernumber = 'P420911164913184' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '409248' WHERE ordernumber = 'P630911165301759' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '414905' WHERE ordernumber = 'P180911165453420' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '280528' WHERE ordernumber = 'P630911170811394' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '337922' WHERE ordernumber = 'P200911170850129' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '396663' WHERE ordernumber = 'P180911171026415' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420626' WHERE ordernumber = 'P180911171336355' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420652' WHERE ordernumber = 'P420911171932946' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420653' WHERE ordernumber = 'P420911172704561' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '337912' WHERE ordernumber = 'P710911173338842' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '337912' WHERE ordernumber = 'P710911173946552' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '319058' WHERE ordernumber = 'P180911174321168' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '162907' WHERE ordernumber = 'P420911175012942' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '117544' WHERE ordernumber = 'P420911175108331' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420656' WHERE ordernumber = 'P420911175444819' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420658' WHERE ordernumber = 'P420911175553968' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420659' WHERE ordernumber = 'P420911180031735' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '113566' WHERE ordernumber = 'P200911180041411' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '419466' WHERE ordernumber = 'P200911180242930' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '376291' WHERE ordernumber = 'P200911180343633' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '401583' WHERE ordernumber = 'P200911180435820' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420661' WHERE ordernumber = 'P200911180549523' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '389408' WHERE ordernumber = 'P420911180807495' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '294578' WHERE ordernumber = 'P420911181534439' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '99048' WHERE ordernumber = 'P420911181615297' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '382548' WHERE ordernumber = 'P590911182657216' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '65992' WHERE ordernumber = 'P180911182758825' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '386162' WHERE ordernumber = 'P180911183012671' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '93654' WHERE ordernumber = 'P200911183037987' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '206878' WHERE ordernumber = 'P180911183217743' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '64829' WHERE ordernumber = 'P200911183311523' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '380081' WHERE ordernumber = 'P180911183503618' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '398514' WHERE ordernumber = 'P180911183735458' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '286232' WHERE ordernumber = 'P180911183858288' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420662' WHERE ordernumber = 'P180911183958392' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '229606' WHERE ordernumber = 'P180911184606384' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '283290' WHERE ordernumber = 'P200911184758621' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '250772' WHERE ordernumber = 'P180911184920360' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '324599' WHERE ordernumber = 'P180911185047410' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '111738' WHERE ordernumber = 'P180911185327269' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '248612' WHERE ordernumber = 'P190911185701740' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '291739' WHERE ordernumber = 'P190911185818542' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '420665' WHERE ordernumber = 'P200911185959767' 2024-09-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '393998' WHERE ordernumber = 'P200911190118804' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '420147' WHERE ordernumber = 'P190911190335160' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '214777' WHERE ordernumber = 'P200911190531763' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '420667' WHERE ordernumber = 'P190911190616387' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '395878' WHERE ordernumber = 'P200911190621896' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '395878' WHERE ordernumber = 'P200911190754499' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '398936' WHERE ordernumber = 'P190911191632289' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '372758' WHERE ordernumber = 'P200911192239594' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '111049' WHERE ordernumber = 'P190911192316930' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '324120' WHERE ordernumber = 'P190911193000671' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '409502' WHERE ordernumber = 'P190911193634774' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '420673' WHERE ordernumber = 'P200911194411345' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '420666' WHERE ordernumber = 'P200911194604944' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '351381' WHERE ordernumber = 'P200911194634981' 2024-09-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '420530' WHERE ordernumber = 'P200911194917269'