2024-09-15 01:00:02 -- 將會員中心id寫入data-lake 2024-09-15 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-14%'; 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '291510' WHERE ordernumber = 'P200914110147430' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '228801' WHERE ordernumber = 'P190914110510325' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421076' WHERE ordernumber = 'P420914110516705' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '325364' WHERE ordernumber = 'P420914110556895' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '404969' WHERE ordernumber = 'P630914110647203' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421077' WHERE ordernumber = 'P420914110650327' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '348951' WHERE ordernumber = 'P200914110658418' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '404969' WHERE ordernumber = 'P630914111016690' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '419954' WHERE ordernumber = 'P420914111016353' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '394590' WHERE ordernumber = 'P200914111117927' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421075' WHERE ordernumber = 'P420914111145258' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421075' WHERE ordernumber = 'P420914111211358' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421074' WHERE ordernumber = 'P420914111348536' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '210827' WHERE ordernumber = 'P190914111439454' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '339983' WHERE ordernumber = 'P420914111502571' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '374703' WHERE ordernumber = 'P190914111527547' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '220663' WHERE ordernumber = 'P190914111606916' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '286550' WHERE ordernumber = 'P180914111624803' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '401994' WHERE ordernumber = 'P420914111728299' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '421072' WHERE ordernumber = 'P190914111805502' 2024-09-15 01:00:02 -- UPDATE `omo_order_list` SET userId = '419723' WHERE ordernumber = 'P180914111855922' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421073' WHERE ordernumber = 'P190914111913141' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421081' WHERE ordernumber = 'P200914111929869' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421083' WHERE ordernumber = 'P420914112149859' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421082' WHERE ordernumber = 'P200914112154468' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421018' WHERE ordernumber = 'P190914112308830' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421080' WHERE ordernumber = 'P190914112425315' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '420040' WHERE ordernumber = 'P200914112613251' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '410086' WHERE ordernumber = 'P190914112618311' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '420040' WHERE ordernumber = 'P200914112653242' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '319498' WHERE ordernumber = 'P200914112737870' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421086' WHERE ordernumber = 'P420914112742186' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421078' WHERE ordernumber = 'P180914112810731' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421079' WHERE ordernumber = 'P190914112841667' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421087' WHERE ordernumber = 'P420914112906890' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421088' WHERE ordernumber = 'P200914112941595' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '121488' WHERE ordernumber = 'P190914113027328' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '420763' WHERE ordernumber = 'P200914113051152' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '394555' WHERE ordernumber = 'P180914113109885' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '342452' WHERE ordernumber = 'P420914113301219' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421092' WHERE ordernumber = 'P420914113536857' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '30912' WHERE ordernumber = 'P420914113701475' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421091' WHERE ordernumber = 'P1050914113757389' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '342133' WHERE ordernumber = 'P420914113757932' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '420569' WHERE ordernumber = 'P190914113800749' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '161149' WHERE ordernumber = 'P420914113853980' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421085' WHERE ordernumber = 'P190914113903364' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421091' WHERE ordernumber = 'P1050914114011142' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421094' WHERE ordernumber = 'P420914114128217' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421096' WHERE ordernumber = 'P420914114252964' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '244638' WHERE ordernumber = 'P190914114419154' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421091' WHERE ordernumber = 'P1050914114547664' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '393722' WHERE ordernumber = 'P190914114628207' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421084' WHERE ordernumber = 'P180914114741252' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '416181' WHERE ordernumber = 'P420914114915870' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421093' WHERE ordernumber = 'P180914115009433' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '416181' WHERE ordernumber = 'P420914115114760' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421095' WHERE ordernumber = 'P190914115131883' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '125335' WHERE ordernumber = 'P180914115138323' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '98582' WHERE ordernumber = 'P200914115234950' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421068' WHERE ordernumber = 'P190914115237461' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '329017' WHERE ordernumber = 'P420914115405127' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421098' WHERE ordernumber = 'P200914115545828' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '420394' WHERE ordernumber = 'P190914115753852' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '225268' WHERE ordernumber = 'P190914115821129' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421047' WHERE ordernumber = 'P200914120156884' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421099' WHERE ordernumber = 'P190914120320197' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '164861' WHERE ordernumber = 'P180914120351347' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421101' WHERE ordernumber = 'P200914120813805' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '407288' WHERE ordernumber = 'P180914121015898' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '415949' WHERE ordernumber = 'P180914121154352' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '255516' WHERE ordernumber = 'P190914121259842' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121329740' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421104' WHERE ordernumber = 'P200914121400399' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121432952' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421086' WHERE ordernumber = 'P420914121504187' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121634753' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121658449' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121716794' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '268931' WHERE ordernumber = 'P200914121721459' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121733242' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121750847' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121808293' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121825581' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121841623' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121859124' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121915845' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421103' WHERE ordernumber = 'P420914121930277' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421105' WHERE ordernumber = 'P420914122329191' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421106' WHERE ordernumber = 'P420914122540114' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '414064' WHERE ordernumber = 'P200914122653404' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '393994' WHERE ordernumber = 'P180914122902240' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '102296' WHERE ordernumber = 'P190914122934170' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421107' WHERE ordernumber = 'P200914122943374' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '33821' WHERE ordernumber = 'P590914122951406' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '131941' WHERE ordernumber = 'P200914123020747' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '416763' WHERE ordernumber = 'P420914123027676' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421108' WHERE ordernumber = 'P420914123209968' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421109' WHERE ordernumber = 'P200914123250552' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421110' WHERE ordernumber = 'P420914123404182' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '404598' WHERE ordernumber = 'P200914123731236' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421111' WHERE ordernumber = 'P200914123836810' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421112' WHERE ordernumber = 'P420914124205345' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421113' WHERE ordernumber = 'P420914124601295' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421114' WHERE ordernumber = 'P420914124949623' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '82946' WHERE ordernumber = 'P180914125237999' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421116' WHERE ordernumber = 'P420914125751437' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '288874' WHERE ordernumber = 'P180914130356617' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421115' WHERE ordernumber = 'P1050914130406783' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '393560' WHERE ordernumber = 'P180914130532363' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '419867' WHERE ordernumber = 'P200914130743495' 2024-09-15 01:00:03 -- UPDATE `omo_order_list` SET userId = '421118' WHERE ordernumber = 'P420914130850676' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '419867' WHERE ordernumber = 'P200914131117277' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421120' WHERE ordernumber = 'P420914132428886' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '383119' WHERE ordernumber = 'P420914132509683' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421121' WHERE ordernumber = 'P200914133338160' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '411783' WHERE ordernumber = 'P420914133348593' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '392688' WHERE ordernumber = 'P200914133414323' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421122' WHERE ordernumber = 'P420914133456263' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '339792' WHERE ordernumber = 'P630914133732822' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '252711' WHERE ordernumber = 'P180914133829851' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421124' WHERE ordernumber = 'P420914134053733' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421123' WHERE ordernumber = 'P200914134158982' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '324722' WHERE ordernumber = 'P420914134522483' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421125' WHERE ordernumber = 'P420914134658395' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '334028' WHERE ordernumber = 'P180914134742712' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421126' WHERE ordernumber = 'P420914134750978' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '27325' WHERE ordernumber = 'P180914134904895' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421127' WHERE ordernumber = 'P420914134944849' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421125' WHERE ordernumber = 'P420914135025702' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '411501' WHERE ordernumber = 'P180914135135710' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421128' WHERE ordernumber = 'P420914135312580' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421129' WHERE ordernumber = 'P420914135400598' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '321130' WHERE ordernumber = 'P180914135426699' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '407724' WHERE ordernumber = 'P420914135455670' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421131' WHERE ordernumber = 'P420914135732491' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '339605' WHERE ordernumber = 'P420914135812636' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421132' WHERE ordernumber = 'P1050914135936429' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '411494' WHERE ordernumber = 'P180914140004785' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '418594' WHERE ordernumber = 'P180914140315379' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '379884' WHERE ordernumber = 'P420914140420902' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '351797' WHERE ordernumber = 'P180914140457651' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421125' WHERE ordernumber = 'P420914140515376' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '408384' WHERE ordernumber = 'P190914140859413' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '419542' WHERE ordernumber = 'P420914141251935' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421133' WHERE ordernumber = 'P190914141348664' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '150638' WHERE ordernumber = 'P420914141548553' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '419541' WHERE ordernumber = 'P200914141619282' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421134' WHERE ordernumber = 'P180914141715147' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '420611' WHERE ordernumber = 'P420914141846946' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '237468' WHERE ordernumber = 'P420914142127283' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421136' WHERE ordernumber = 'P180914142138284' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421137' WHERE ordernumber = 'P180914142253112' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '318103' WHERE ordernumber = 'P420914142502877' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '410640' WHERE ordernumber = 'P180914142527815' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421138' WHERE ordernumber = 'P180914142900918' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '237967' WHERE ordernumber = 'P180914143156225' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '267872' WHERE ordernumber = 'P200914143447361' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '408335' WHERE ordernumber = 'P420914143529212' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421052' WHERE ordernumber = 'P180914143534150' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '307014' WHERE ordernumber = 'P420914143606265' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '94994' WHERE ordernumber = 'P200914143641642' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421141' WHERE ordernumber = 'P200914143811970' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '334962' WHERE ordernumber = 'P180914143918420' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '403509' WHERE ordernumber = 'P190914144112641' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421142' WHERE ordernumber = 'P200914144240458' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421143' WHERE ordernumber = 'P420914144603783' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '241783' WHERE ordernumber = 'P180914144635755' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421144' WHERE ordernumber = 'P420914145115189' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421145' WHERE ordernumber = 'P1050914145242917' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421147' WHERE ordernumber = 'P420914145513403' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '415119' WHERE ordernumber = 'P420914145638340' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421148' WHERE ordernumber = 'P420914145815362' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '396508' WHERE ordernumber = 'P180914145856984' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '403286' WHERE ordernumber = 'P420914145916667' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '396508' WHERE ordernumber = 'P180914145949972' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '89714' WHERE ordernumber = 'P180914150317780' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421146' WHERE ordernumber = 'P200914150836650' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421151' WHERE ordernumber = 'P420914151012797' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421152' WHERE ordernumber = 'P420914151102219' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '420815' WHERE ordernumber = 'P180914151410899' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421153' WHERE ordernumber = 'P420914151524758' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '410867' WHERE ordernumber = 'P200914151547344' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421154' WHERE ordernumber = 'P200914151728758' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421155' WHERE ordernumber = 'P420914151921680' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '403286' WHERE ordernumber = 'P420914152014694' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '416926' WHERE ordernumber = 'P190914152228719' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '234151' WHERE ordernumber = 'P200914152732479' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '420856' WHERE ordernumber = 'P420914152807411' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421157' WHERE ordernumber = 'P420914153330725' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421158' WHERE ordernumber = 'P420914153545968' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '88527' WHERE ordernumber = 'P180914153548462' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421160' WHERE ordernumber = 'P420914153732326' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '236613' WHERE ordernumber = 'P180914153822478' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '344300' WHERE ordernumber = 'P180914153932655' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421161' WHERE ordernumber = 'P420914153933937' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421162' WHERE ordernumber = 'P420914154217566' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '409490' WHERE ordernumber = 'P200914154752458' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '417395' WHERE ordernumber = 'P200914154944763' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '401249' WHERE ordernumber = 'P420914155158973' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '259312' WHERE ordernumber = 'P180914155200833' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421163' WHERE ordernumber = 'P200914155335912' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '206525' WHERE ordernumber = 'P180914155405721' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '305057' WHERE ordernumber = 'P180914155436721' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421130' WHERE ordernumber = 'P420914155515758' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '386528' WHERE ordernumber = 'P180914155537304' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '407254' WHERE ordernumber = 'P420914155737535' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '319383' WHERE ordernumber = 'P180914155801471' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '407254' WHERE ordernumber = 'P420914155831464' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '421165' WHERE ordernumber = 'P200914155946322' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '128152' WHERE ordernumber = 'P180914160023413' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '128446' WHERE ordernumber = 'P420914160033270' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '128446' WHERE ordernumber = 'P420914160131684' 2024-09-15 01:00:04 -- UPDATE `omo_order_list` SET userId = '418143' WHERE ordernumber = 'P630914160340871' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '312129' WHERE ordernumber = 'P420914160457781' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '418752' WHERE ordernumber = 'P180914160719896' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421166' WHERE ordernumber = 'P200914160812305' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421167' WHERE ordernumber = 'P180914160949118' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421154' WHERE ordernumber = 'P200914161003150' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '214241' WHERE ordernumber = 'P180914161742969' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '212332' WHERE ordernumber = 'P420914161836697' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421169' WHERE ordernumber = 'P420914162141549' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421168' WHERE ordernumber = 'P180914162221629' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421170' WHERE ordernumber = 'P180914162349918' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '390315' WHERE ordernumber = 'P180914162527649' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '82363' WHERE ordernumber = 'P190914162803316' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '82363' WHERE ordernumber = 'P190914162835330' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '207279' WHERE ordernumber = 'P180914163029831' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '228920' WHERE ordernumber = 'P420914163136371' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '291067' WHERE ordernumber = 'P200914163339299' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421172' WHERE ordernumber = 'P420914163405342' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421174' WHERE ordernumber = 'P420914163935174' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '420631' WHERE ordernumber = 'P200914164011924' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '412617' WHERE ordernumber = 'P420914164036564' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '335273' WHERE ordernumber = 'P180914164047679' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421005' WHERE ordernumber = 'P420914164108549' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '400348' WHERE ordernumber = 'P420914164252362' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '343872' WHERE ordernumber = 'P180914164311553' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '317293' WHERE ordernumber = 'P420914164842755' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421175' WHERE ordernumber = 'P420914165034353' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421176' WHERE ordernumber = 'P420914165219957' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421177' WHERE ordernumber = 'P420914165355127' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '132799' WHERE ordernumber = 'P190914165858512' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '248181' WHERE ordernumber = 'P180914165908935' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '403176' WHERE ordernumber = 'P200914165922912' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '103452' WHERE ordernumber = 'P180914170028547' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '387413' WHERE ordernumber = 'P200914170032610' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '418305' WHERE ordernumber = 'P200914170218445' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421178' WHERE ordernumber = 'P420914170453202' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421180' WHERE ordernumber = 'P420914170625194' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '405468' WHERE ordernumber = 'P420914170653799' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '282202' WHERE ordernumber = 'P180914170707133' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '346781' WHERE ordernumber = 'P420914170733840' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421181' WHERE ordernumber = 'P420914170842271' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '410295' WHERE ordernumber = 'P420914171357635' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '420809' WHERE ordernumber = 'P420914171454295' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '420809' WHERE ordernumber = 'P420914171511771' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '50650' WHERE ordernumber = 'P200914171748847' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '418998' WHERE ordernumber = 'P420914172017892' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '111830' WHERE ordernumber = 'P180914172401927' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421184' WHERE ordernumber = 'P420914172406446' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '111830' WHERE ordernumber = 'P180914172439645' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '115842' WHERE ordernumber = 'P180914172552398' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '305594' WHERE ordernumber = 'P180914172640695' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421185' WHERE ordernumber = 'P180914172740278' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421186' WHERE ordernumber = 'P420914172816875' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '306854' WHERE ordernumber = 'P180914172832796' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '357914' WHERE ordernumber = 'P200914172941998' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '345067' WHERE ordernumber = 'P180914173127426' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '353236' WHERE ordernumber = 'P180914173428575' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421187' WHERE ordernumber = 'P420914173457525' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '67010' WHERE ordernumber = 'P180914173523858' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421188' WHERE ordernumber = 'P420914174800904' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '108080' WHERE ordernumber = 'P180914174831263' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421189' WHERE ordernumber = 'P420914174925281' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '208071' WHERE ordernumber = 'P180914175240743' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421191' WHERE ordernumber = 'P420914175414586' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '418784' WHERE ordernumber = 'P200914175532843' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '408880' WHERE ordernumber = 'P630914175649858' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '292023' WHERE ordernumber = 'P180914175747675' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '354668' WHERE ordernumber = 'P180914180117119' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '343807' WHERE ordernumber = 'P420914180233652' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '383119' WHERE ordernumber = 'P420914180428255' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '125140' WHERE ordernumber = 'P200914180506668' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421186' WHERE ordernumber = 'P420914180627640' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421192' WHERE ordernumber = 'P420914181503998' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421193' WHERE ordernumber = 'P420914181848673' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '292263' WHERE ordernumber = 'P630914181943638' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '212972' WHERE ordernumber = 'P420914182114546' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '340529' WHERE ordernumber = 'P200914182333949' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '420807' WHERE ordernumber = 'P180914182403596' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421194' WHERE ordernumber = 'P420914182407721' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421195' WHERE ordernumber = 'P420914182520368' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '396204' WHERE ordernumber = 'P630914182558622' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421196' WHERE ordernumber = 'P420914182655142' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421197' WHERE ordernumber = 'P420914182736874' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421198' WHERE ordernumber = 'P420914182824612' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421199' WHERE ordernumber = 'P420914182946444' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421200' WHERE ordernumber = 'P420914183207192' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '384016' WHERE ordernumber = 'P630914183456608' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '403115' WHERE ordernumber = 'P630914184109844' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '155836' WHERE ordernumber = 'P420914185112310' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '203120' WHERE ordernumber = 'P1050914185118905' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '364943' WHERE ordernumber = 'P200914185251438' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '343537' WHERE ordernumber = 'P190914190138281' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '93821' WHERE ordernumber = 'P190914190223517' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '322219' WHERE ordernumber = 'P420914190226884' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421202' WHERE ordernumber = 'P200914190325634' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '416947' WHERE ordernumber = 'P420914190335517' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '405890' WHERE ordernumber = 'P630914190421891' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '421203' WHERE ordernumber = 'P190914190541487' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '233214' WHERE ordernumber = 'P200914191202565' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '402128' WHERE ordernumber = 'P190914191844487' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '367556' WHERE ordernumber = 'P200914191941198' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '391255' WHERE ordernumber = 'P200914192658677' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '394641' WHERE ordernumber = 'P630914193558579' 2024-09-15 01:00:05 -- UPDATE `omo_order_list` SET userId = '256089' WHERE ordernumber = 'P190914194041355' 2024-09-15 01:00:06 -- UPDATE `omo_order_list` SET userId = '256089' WHERE ordernumber = 'P190914194335717' 2024-09-15 01:00:06 -- UPDATE `omo_order_list` SET userId = '416284' WHERE ordernumber = 'P1050914202227401' 2024-09-15 01:00:06 -- UPDATE `omo_order_list` SET userId = '157638' WHERE ordernumber = 'P630914203046365' 2024-09-15 01:00:06 -- UPDATE `omo_order_list` SET userId = '421206' WHERE ordernumber = 'P1050914203300170'