2024-09-01 01:00:02 -- 將會員中心id寫入data-lake 2024-09-01 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-08-31%'; 2024-09-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '416708' WHERE ordernumber = 'P180831110222686' 2024-09-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '416709' WHERE ordernumber = 'P420831110306551' 2024-09-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '311920' WHERE ordernumber = 'P420831110406317' 2024-09-01 01:00:02 -- UPDATE `omo_order_list` SET userId = '391020' WHERE ordernumber = 'P190831110439694' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '384747' WHERE ordernumber = 'P420831110551788' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '256310' WHERE ordernumber = 'P200831110657489' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '343537' WHERE ordernumber = 'P190831110703915' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '311531' WHERE ordernumber = 'P190831110819139' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '354331' WHERE ordernumber = 'P420831110835603' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416713' WHERE ordernumber = 'P180831110941669' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '413989' WHERE ordernumber = 'P190831110954912' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '273089' WHERE ordernumber = 'P420831111044161' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416715' WHERE ordernumber = 'P180831111136903' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '193972' WHERE ordernumber = 'P190831111211965' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416718' WHERE ordernumber = 'P180831111343683' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416721' WHERE ordernumber = 'P190831111535958' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416719' WHERE ordernumber = 'P180831111536956' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416720' WHERE ordernumber = 'P420831111607887' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416725' WHERE ordernumber = 'P180831111704558' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416724' WHERE ordernumber = 'P190831111706411' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '235821' WHERE ordernumber = 'P180831111802928' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '267874' WHERE ordernumber = 'P180831111928452' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '111810' WHERE ordernumber = 'P180831112106135' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '401541' WHERE ordernumber = 'P200831112258307' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416728' WHERE ordernumber = 'P190831112344866' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '302281' WHERE ordernumber = 'P180831112505271' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '380735' WHERE ordernumber = 'P180831112606984' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '409894' WHERE ordernumber = 'P190831112621685' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416731' WHERE ordernumber = 'P420831112648728' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180831112813759' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416733' WHERE ordernumber = 'P190831112828761' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416726' WHERE ordernumber = 'P190831113056584' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416734' WHERE ordernumber = 'P180831113108144' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416735' WHERE ordernumber = 'P180831113317681' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416736' WHERE ordernumber = 'P420831113349790' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '218997' WHERE ordernumber = 'P190831113354528' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '153983' WHERE ordernumber = 'P180831113426312' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416738' WHERE ordernumber = 'P190831113525374' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '149063' WHERE ordernumber = 'P420831113603410' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416739' WHERE ordernumber = 'P180831113740435' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '320007' WHERE ordernumber = 'P200831113802149' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416740' WHERE ordernumber = 'P190831113809995' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416741' WHERE ordernumber = 'P420831113921120' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '103211' WHERE ordernumber = 'P180831113928504' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '411640' WHERE ordernumber = 'P200831114102570' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '413593' WHERE ordernumber = 'P420831114233828' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '95208' WHERE ordernumber = 'P180831114244452' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '343422' WHERE ordernumber = 'P420831114420497' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '319288' WHERE ordernumber = 'P200831114519632' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '390288' WHERE ordernumber = 'P190831114547144' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416744' WHERE ordernumber = 'P420831114704517' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416745' WHERE ordernumber = 'P190831114743253' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '256716' WHERE ordernumber = 'P190831114931923' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '395377' WHERE ordernumber = 'P200831114943716' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '345866' WHERE ordernumber = 'P420831115135340' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '256761' WHERE ordernumber = 'P200831115442900' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '82363' WHERE ordernumber = 'P190831115631944' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '415657' WHERE ordernumber = 'P180831115730953' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '301599' WHERE ordernumber = 'P180831115849254' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416750' WHERE ordernumber = 'P190831120032450' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416750' WHERE ordernumber = 'P190831120355158' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '16516' WHERE ordernumber = 'P420831120525894' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '412239' WHERE ordernumber = 'P180831120549326' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '402992' WHERE ordernumber = 'P180831120700989' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '415327' WHERE ordernumber = 'P180831120814723' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416755' WHERE ordernumber = 'P420831120920822' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416753' WHERE ordernumber = 'P420831121002606' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '172599' WHERE ordernumber = 'P180831121242443' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '225197' WHERE ordernumber = 'P180831121537354' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '222335' WHERE ordernumber = 'P200831121853854' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416762' WHERE ordernumber = 'P420831121919538' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '410379' WHERE ordernumber = 'P190831121928570' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '96793' WHERE ordernumber = 'P200831121945698' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '182173' WHERE ordernumber = 'P180831122018373' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416763' WHERE ordernumber = 'P420831122122808' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416764' WHERE ordernumber = 'P420831122220190' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '332354' WHERE ordernumber = 'P420831122529283' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '407861' WHERE ordernumber = 'P420831122725271' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '288035' WHERE ordernumber = 'P200831122914872' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416768' WHERE ordernumber = 'P200831123247417' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '247476' WHERE ordernumber = 'P190831123413527' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '416769' WHERE ordernumber = 'P420831123429532' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '410507' WHERE ordernumber = 'P180831123525698' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '136864' WHERE ordernumber = 'P180831123952671' 2024-09-01 01:00:03 -- UPDATE `omo_order_list` SET userId = '382974' WHERE ordernumber = 'P420831124534216' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416775' WHERE ordernumber = 'P420831124908228' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '97026' WHERE ordernumber = 'P200831124923358' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '218997' WHERE ordernumber = 'P180831124924476' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '242227' WHERE ordernumber = 'P180831125018905' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416776' WHERE ordernumber = 'P420831125047118' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '304095' WHERE ordernumber = 'P190831125756982' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416779' WHERE ordernumber = 'P420831125820479' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '267873' WHERE ordernumber = 'P190831125925218' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '410805' WHERE ordernumber = 'P420831125947230' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '408963' WHERE ordernumber = 'P420831130353398' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416786' WHERE ordernumber = 'P420831130655450' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '397556' WHERE ordernumber = 'P180831130703905' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '397556' WHERE ordernumber = 'P180831130759936' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '299325' WHERE ordernumber = 'P420831130904262' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416326' WHERE ordernumber = 'P630831131015586' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '322554' WHERE ordernumber = 'P420831131113177' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '345803' WHERE ordernumber = 'P190831131315549' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '252711' WHERE ordernumber = 'P180831131904709' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '144753' WHERE ordernumber = 'P200831132033476' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '410433' WHERE ordernumber = 'P420831132148366' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '100271' WHERE ordernumber = 'P180831132245587' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '415364' WHERE ordernumber = 'P420831132608348' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '379476' WHERE ordernumber = 'P200831132703351' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416789' WHERE ordernumber = 'P200831132842271' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '141618' WHERE ordernumber = 'P180831133027583' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416799' WHERE ordernumber = 'P420831133117376' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '241316' WHERE ordernumber = 'P200831133241642' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416801' WHERE ordernumber = 'P420831133301900' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416773' WHERE ordernumber = 'P190831133326655' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416803' WHERE ordernumber = 'P180831133526134' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '239163' WHERE ordernumber = 'P200831133622498' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '259711' WHERE ordernumber = 'P420831133653414' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '346652' WHERE ordernumber = 'P200831133717822' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '273089' WHERE ordernumber = 'P420831134438861' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '293302' WHERE ordernumber = 'P200831134516319' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416805' WHERE ordernumber = 'P190831134553429' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '257466' WHERE ordernumber = 'P200831134703216' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416807' WHERE ordernumber = 'P420831134848156' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416809' WHERE ordernumber = 'P180831134901395' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '413001' WHERE ordernumber = 'P420831134957188' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416812' WHERE ordernumber = 'P420831135638888' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416813' WHERE ordernumber = 'P420831135739160' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416816' WHERE ordernumber = 'P420831135924505' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '95033' WHERE ordernumber = 'P200831135939662' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416819' WHERE ordernumber = 'P420831140119578' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416820' WHERE ordernumber = 'P200831140201142' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416824' WHERE ordernumber = 'P420831140742286' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '248237' WHERE ordernumber = 'P180831140808335' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '412456' WHERE ordernumber = 'P420831141203325' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '412456' WHERE ordernumber = 'P420831141235203' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '390360' WHERE ordernumber = 'P420831141408548' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '390360' WHERE ordernumber = 'P420831141456355' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '403574' WHERE ordernumber = 'P420831142015728' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '401083' WHERE ordernumber = 'P200831142047953' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416831' WHERE ordernumber = 'P420831142309491' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '66752' WHERE ordernumber = 'P200831142752829' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '300645' WHERE ordernumber = 'P420831142850443' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416834' WHERE ordernumber = 'P200831142907249' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '307192' WHERE ordernumber = 'P420831143000791' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '233250' WHERE ordernumber = 'P200831143605616' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416838' WHERE ordernumber = 'P420831143658356' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '132786' WHERE ordernumber = 'P180831143734336' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416840' WHERE ordernumber = 'P420831143753471' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '277458' WHERE ordernumber = 'P180831143858679' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '149888' WHERE ordernumber = 'P200831143922903' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416843' WHERE ordernumber = 'P200831144144143' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '67708' WHERE ordernumber = 'P190831144540177' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '277423' WHERE ordernumber = 'P180831144624904' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '306112' WHERE ordernumber = 'P630831144852583' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '98533' WHERE ordernumber = 'P200831144852881' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '111694' WHERE ordernumber = 'P420831144932457' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416485' WHERE ordernumber = 'P200831144944150' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '360238' WHERE ordernumber = 'P180831145547745' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '410615' WHERE ordernumber = 'P180831145750392' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '413167' WHERE ordernumber = 'P420831150004308' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416665' WHERE ordernumber = 'P180831150227702' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416847' WHERE ordernumber = 'P420831150233212' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '216860' WHERE ordernumber = 'P420831150421351' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416851' WHERE ordernumber = 'P180831150902409' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '338100' WHERE ordernumber = 'P420831151018636' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '414301' WHERE ordernumber = 'P190831151221803' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '367183' WHERE ordernumber = 'P200831151359295' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416855' WHERE ordernumber = 'P420831151550673' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '409667' WHERE ordernumber = 'P180831151742758' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '256639' WHERE ordernumber = 'P200831151953634' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '416859' WHERE ordernumber = 'P420831152032612' 2024-09-01 01:00:04 -- UPDATE `omo_order_list` SET userId = '190703' WHERE ordernumber = 'P200831152124172' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '256464' WHERE ordernumber = 'P200831152227527' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416863' WHERE ordernumber = 'P200831152343455' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416864' WHERE ordernumber = 'P420831152608160' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '397894' WHERE ordernumber = 'P420831152652357' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '217317' WHERE ordernumber = 'P200831152813884' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416866' WHERE ordernumber = 'P200831152933446' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416867' WHERE ordernumber = 'P420831153038651' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '84647' WHERE ordernumber = 'P180831153055165' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '100714' WHERE ordernumber = 'P180831153159822' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '231689' WHERE ordernumber = 'P190831153248326' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '415603' WHERE ordernumber = 'P180831153510305' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '248383' WHERE ordernumber = 'P200831153510201' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416871' WHERE ordernumber = 'P420831153858961' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416872' WHERE ordernumber = 'P420831154029466' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '248383' WHERE ordernumber = 'P200831154115970' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '222877' WHERE ordernumber = 'P190831154123556' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416868' WHERE ordernumber = 'P180831154355573' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '77222' WHERE ordernumber = 'P190831154606251' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '242818' WHERE ordernumber = 'P200831154907461' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '394594' WHERE ordernumber = 'P180831154928937' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '153510' WHERE ordernumber = 'P630831155137111' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '368511' WHERE ordernumber = 'P180831155247885' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '243071' WHERE ordernumber = 'P200831155411925' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '260330' WHERE ordernumber = 'P190831155438674' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '293978' WHERE ordernumber = 'P180831155800464' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416878' WHERE ordernumber = 'P190831160111702' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '414561' WHERE ordernumber = 'P180831160142981' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416879' WHERE ordernumber = 'P420831160227706' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416857' WHERE ordernumber = 'P180831160231562' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416508' WHERE ordernumber = 'P190831160315560' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '328399' WHERE ordernumber = 'P420831160414487' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416882' WHERE ordernumber = 'P190831160418152' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '379769' WHERE ordernumber = 'P420831160602276' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '106349' WHERE ordernumber = 'P190831160634397' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416878' WHERE ordernumber = 'P180831160820210' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '100070' WHERE ordernumber = 'P200831161104515' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '52705' WHERE ordernumber = 'P420831161136162' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '100070' WHERE ordernumber = 'P200831161228336' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P200831161510874' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '326866' WHERE ordernumber = 'P190831161523562' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '220496' WHERE ordernumber = 'P420831161631352' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '232313' WHERE ordernumber = 'P190831161752757' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '404099' WHERE ordernumber = 'P200831161849261' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '414707' WHERE ordernumber = 'P420831161921483' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '415603' WHERE ordernumber = 'P180831161956294' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416885' WHERE ordernumber = 'P200831162053766' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '341912' WHERE ordernumber = 'P200831162449740' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '413405' WHERE ordernumber = 'P180831162536802' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416887' WHERE ordernumber = 'P180831162651679' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '390110' WHERE ordernumber = 'P180831163225259' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '385062' WHERE ordernumber = 'P420831163520499' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416893' WHERE ordernumber = 'P420831163649508' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '333117' WHERE ordernumber = 'P420831163804235' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416894' WHERE ordernumber = 'P420831163915361' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416895' WHERE ordernumber = 'P420831164008715' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416897' WHERE ordernumber = 'P420831164132725' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416896' WHERE ordernumber = 'P200831164200548' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '402675' WHERE ordernumber = 'P420831164300362' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416894' WHERE ordernumber = 'P420831164408133' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416899' WHERE ordernumber = 'P420831164532916' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '413717' WHERE ordernumber = 'P420831164744741' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416898' WHERE ordernumber = 'P420831165012657' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '415763' WHERE ordernumber = 'P180831165030729' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416898' WHERE ordernumber = 'P420831165050466' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416903' WHERE ordernumber = 'P420831165706715' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '378213' WHERE ordernumber = 'P200831165758829' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416904' WHERE ordernumber = 'P420831165829723' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '159220' WHERE ordernumber = 'P200831165914811' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '116859' WHERE ordernumber = 'P190831170217289' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416907' WHERE ordernumber = 'P200831170526857' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '385967' WHERE ordernumber = 'P630831170856319' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '324120' WHERE ordernumber = 'P180831171230316' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '292263' WHERE ordernumber = 'P200831171615728' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416913' WHERE ordernumber = 'P420831171640314' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416915' WHERE ordernumber = 'P180831171747661' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416914' WHERE ordernumber = 'P180831172030576' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416917' WHERE ordernumber = 'P420831172041678' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '412987' WHERE ordernumber = 'P200831172231512' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416919' WHERE ordernumber = 'P420831172316294' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416915' WHERE ordernumber = 'P190831172335148' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416920' WHERE ordernumber = 'P420831172554747' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416921' WHERE ordernumber = 'P200831172612695' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '400901' WHERE ordernumber = 'P420831172659734' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416923' WHERE ordernumber = 'P200831172753749' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416919' WHERE ordernumber = 'P420831172819798' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '336222' WHERE ordernumber = 'P180831172948648' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416921' WHERE ordernumber = 'P200831173031711' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '256804' WHERE ordernumber = 'P180831173338113' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '119508' WHERE ordernumber = 'P190831173501744' 2024-09-01 01:00:05 -- UPDATE `omo_order_list` SET userId = '416926' WHERE ordernumber = 'P420831173547538' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '246500' WHERE ordernumber = 'P190831173642633' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416929' WHERE ordernumber = 'P420831174245844' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416931' WHERE ordernumber = 'P420831174412152' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '327850' WHERE ordernumber = 'P590831175001579' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416934' WHERE ordernumber = 'P420831175920573' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416936' WHERE ordernumber = 'P190831180224536' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416937' WHERE ordernumber = 'P420831180230167' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '253262' WHERE ordernumber = 'P420831180339473' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '225562' WHERE ordernumber = 'P180831180642635' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416940' WHERE ordernumber = 'P200831180803123' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416936' WHERE ordernumber = 'P180831180921940' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '351168' WHERE ordernumber = 'P200831181138884' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '411711' WHERE ordernumber = 'P180831181225885' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '413337' WHERE ordernumber = 'P200831181330310' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416940' WHERE ordernumber = 'P200831181529212' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '341049' WHERE ordernumber = 'P190831181539874' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '341049' WHERE ordernumber = 'P180831181541673' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '415746' WHERE ordernumber = 'P180831181637787' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '381545' WHERE ordernumber = 'P200831182112794' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '110935' WHERE ordernumber = 'P180831182158916' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416947' WHERE ordernumber = 'P420831182514258' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '99647' WHERE ordernumber = 'P180831182555366' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416949' WHERE ordernumber = 'P420831182706459' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '217934' WHERE ordernumber = 'P190831183034238' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416951' WHERE ordernumber = 'P180831183100268' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416952' WHERE ordernumber = 'P200831183329351' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416953' WHERE ordernumber = 'P420831183446486' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416954' WHERE ordernumber = 'P420831183612477' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '281709' WHERE ordernumber = 'P180831183641646' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '401625' WHERE ordernumber = 'P190831184317692' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '234432' WHERE ordernumber = 'P180831184515703' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416959' WHERE ordernumber = 'P420831184619205' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '262058' WHERE ordernumber = 'P180831185316361' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416963' WHERE ordernumber = 'P200831185434945' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416964' WHERE ordernumber = 'P420831185537700' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416966' WHERE ordernumber = 'P420831185656244' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '107559' WHERE ordernumber = 'P180831185725535' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416969' WHERE ordernumber = 'P420831185951127' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '300330' WHERE ordernumber = 'P200831190057430' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '410507' WHERE ordernumber = 'P180831190154292' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416965' WHERE ordernumber = 'P590831190207302' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416971' WHERE ordernumber = 'P200831190408936' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '390093' WHERE ordernumber = 'P200831190656973' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '403141' WHERE ordernumber = 'P180831191137165' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '219160' WHERE ordernumber = 'P200831191410536' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '106569' WHERE ordernumber = 'P190831191518356' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '412759' WHERE ordernumber = 'P190831191648923' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '412759' WHERE ordernumber = 'P190831191703656' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416976' WHERE ordernumber = 'P200831193023616' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P190831193521309' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '416284' WHERE ordernumber = 'P200831194737256' 2024-09-01 01:00:06 -- UPDATE `omo_order_list` SET userId = '412202' WHERE ordernumber = 'P200831200458823'