2024-08-18 01:00:02 -- 將會員中心id寫入data-lake 2024-08-18 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-17%'; 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409476' WHERE ordernumber = 'P420817110122939' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '253962' WHERE ordernumber = 'P180817110255272' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409479' WHERE ordernumber = 'P420817110727309' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '241932' WHERE ordernumber = 'P200817110810617' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409480' WHERE ordernumber = 'P420817110834632' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '4268' WHERE ordernumber = 'P180817110954715' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409480' WHERE ordernumber = 'P420817111040778' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '363750' WHERE ordernumber = 'P190817111241417' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '337808' WHERE ordernumber = 'P180817111329270' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409482' WHERE ordernumber = 'P420817111337282' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '388791' WHERE ordernumber = 'P180817111450151' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409483' WHERE ordernumber = 'P420817111543530' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409485' WHERE ordernumber = 'P190817111628506' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409486' WHERE ordernumber = 'P420817111655901' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409487' WHERE ordernumber = 'P180817111818817' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409489' WHERE ordernumber = 'P190817111910338' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '281785' WHERE ordernumber = 'P180817111940725' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '81134' WHERE ordernumber = 'P190817111953933' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409495' WHERE ordernumber = 'P190817112953255' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409496' WHERE ordernumber = 'P180817113058518' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409497' WHERE ordernumber = 'P420817113331454' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409498' WHERE ordernumber = 'P200817113420444' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '306553' WHERE ordernumber = 'P180817113714460' 2024-08-18 01:00:02 -- UPDATE `omo_order_list` SET userId = '409501' WHERE ordernumber = 'P180817113936347' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409502' WHERE ordernumber = 'P180817114105839' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409505' WHERE ordernumber = 'P180817114159958' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409507' WHERE ordernumber = 'P200817114738329' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409508' WHERE ordernumber = 'P180817114821504' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '216128' WHERE ordernumber = 'P180817114908598' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '263940' WHERE ordernumber = 'P200817115015553' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409512' WHERE ordernumber = 'P420817115135294' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '405724' WHERE ordernumber = 'P420817115225908' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '396598' WHERE ordernumber = 'P190817115520497' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409514' WHERE ordernumber = 'P180817115627660' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409517' WHERE ordernumber = 'P420817120007611' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409522' WHERE ordernumber = 'P420817120433158' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '319288' WHERE ordernumber = 'P200817120604557' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '275588' WHERE ordernumber = 'P180817120741617' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '408822' WHERE ordernumber = 'P420817120801538' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409526' WHERE ordernumber = 'P190817121029748' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '257096' WHERE ordernumber = 'P180817121044916' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409523' WHERE ordernumber = 'P420817121137597' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '88052' WHERE ordernumber = 'P180817121215757' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '301522' WHERE ordernumber = 'P420817121308484' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '100548' WHERE ordernumber = 'P180817121633935' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409530' WHERE ordernumber = 'P200817121820574' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409528' WHERE ordernumber = 'P630817121848464' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409531' WHERE ordernumber = 'P180817121926456' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '398350' WHERE ordernumber = 'P200817122059126' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '116809' WHERE ordernumber = 'P180817122446357' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '360096' WHERE ordernumber = 'P420817122528419' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '313363' WHERE ordernumber = 'P180817122724373' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '384779' WHERE ordernumber = 'P630817122950535' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409536' WHERE ordernumber = 'P180817123125202' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409537' WHERE ordernumber = 'P190817123239327' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '230254' WHERE ordernumber = 'P200817123321460' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409542' WHERE ordernumber = 'P190817123523657' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409532' WHERE ordernumber = 'P180817123524742' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409543' WHERE ordernumber = 'P190817123740436' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '99022' WHERE ordernumber = 'P180817123810804' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409546' WHERE ordernumber = 'P200817124254876' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409547' WHERE ordernumber = 'P420817124327584' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '321877' WHERE ordernumber = 'P420817124406235' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '364718' WHERE ordernumber = 'P200817124835297' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409553' WHERE ordernumber = 'P200817124952251' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409554' WHERE ordernumber = 'P180817125124837' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '406975' WHERE ordernumber = 'P190817125235719' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409556' WHERE ordernumber = 'P180817125301846' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409557' WHERE ordernumber = 'P180817125549860' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409559' WHERE ordernumber = 'P180817125732733' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '399910' WHERE ordernumber = 'P200817130122405' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '161151' WHERE ordernumber = 'P180817130228636' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '105192' WHERE ordernumber = 'P200817130336639' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '96074' WHERE ordernumber = 'P180817130525735' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '408986' WHERE ordernumber = 'P180817130708350' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409562' WHERE ordernumber = 'P420817130743303' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '408986' WHERE ordernumber = 'P180817130755240' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409565' WHERE ordernumber = 'P200817131107174' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409567' WHERE ordernumber = 'P180817131136227' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409566' WHERE ordernumber = 'P420817131156131' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409568' WHERE ordernumber = 'P420817131343946' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409570' WHERE ordernumber = 'P420817131440221' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409572' WHERE ordernumber = 'P180817131521330' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409573' WHERE ordernumber = 'P420817131559757' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409575' WHERE ordernumber = 'P420817131729139' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409577' WHERE ordernumber = 'P180817131842172' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409578' WHERE ordernumber = 'P420817132018467' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '354150' WHERE ordernumber = 'P180817132053374' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409580' WHERE ordernumber = 'P420817132240291' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '81096' WHERE ordernumber = 'P180817132350851' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '208656' WHERE ordernumber = 'P190817132925973' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409582' WHERE ordernumber = 'P420817133145218' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409583' WHERE ordernumber = 'P180817133151596' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409584' WHERE ordernumber = 'P200817133412369' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '208656' WHERE ordernumber = 'P180817133417574' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409587' WHERE ordernumber = 'P180817133649971' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409588' WHERE ordernumber = 'P190817133712165' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409590' WHERE ordernumber = 'P180817133939122' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '409589' WHERE ordernumber = 'P190817134005729' 2024-08-18 01:00:03 -- UPDATE `omo_order_list` SET userId = '354201' WHERE ordernumber = 'P180817134014743' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409591' WHERE ordernumber = 'P200817134112290' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '238611' WHERE ordernumber = 'P180817134144823' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '341299' WHERE ordernumber = 'P180817134547767' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409594' WHERE ordernumber = 'P200817134641763' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409590' WHERE ordernumber = 'P180817134801468' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409595' WHERE ordernumber = 'P190817134817287' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409596' WHERE ordernumber = 'P420817134831122' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409599' WHERE ordernumber = 'P420817135005266' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409600' WHERE ordernumber = 'P180817135346368' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409601' WHERE ordernumber = 'P420817135409551' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409603' WHERE ordernumber = 'P190817135440206' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409605' WHERE ordernumber = 'P200817135533256' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409606' WHERE ordernumber = 'P180817135621216' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409606' WHERE ordernumber = 'P180817135733839' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '312509' WHERE ordernumber = 'P190817135807685' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '312509' WHERE ordernumber = 'P190817135902334' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '195649' WHERE ordernumber = 'P180817135913842' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '312509' WHERE ordernumber = 'P190817135926300' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409608' WHERE ordernumber = 'P420817140019623' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409609' WHERE ordernumber = 'P200817140039654' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409610' WHERE ordernumber = 'P200817140209453' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409613' WHERE ordernumber = 'P180817140536197' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409616' WHERE ordernumber = 'P200817140817715' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409617' WHERE ordernumber = 'P420817140841176' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409250' WHERE ordernumber = 'P180817140940773' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '283248' WHERE ordernumber = 'P180817141148732' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '158000' WHERE ordernumber = 'P200817141220840' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409619' WHERE ordernumber = 'P420817141409583' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409620' WHERE ordernumber = 'P180817141427365' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409622' WHERE ordernumber = 'P180817142102281' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '112976' WHERE ordernumber = 'P180817142231215' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409623' WHERE ordernumber = 'P190817142248156' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '376131' WHERE ordernumber = 'P180817142428254' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409624' WHERE ordernumber = 'P190817142541944' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409625' WHERE ordernumber = 'P180817142646128' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '366281' WHERE ordernumber = 'P180817143305391' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '377676' WHERE ordernumber = 'P180817143504458' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '344885' WHERE ordernumber = 'P420817143508674' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '330642' WHERE ordernumber = 'P420817143705998' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409630' WHERE ordernumber = 'P200817144122512' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409630' WHERE ordernumber = 'P200817144145296' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '250026' WHERE ordernumber = 'P180817144342515' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '357019' WHERE ordernumber = 'P420817144343908' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409633' WHERE ordernumber = 'P200817144347645' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '130468' WHERE ordernumber = 'P200817144714670' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '115668' WHERE ordernumber = 'P180817144917276' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409640' WHERE ordernumber = 'P190817144959977' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409637' WHERE ordernumber = 'P190817145111494' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409641' WHERE ordernumber = 'P420817145135483' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '380028' WHERE ordernumber = 'P200817145327205' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '377804' WHERE ordernumber = 'P180817145450822' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409643' WHERE ordernumber = 'P190817145545543' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409644' WHERE ordernumber = 'P420817145619567' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '295700' WHERE ordernumber = 'P190817145706428' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '271033' WHERE ordernumber = 'P200817145749317' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409646' WHERE ordernumber = 'P200817150122245' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '343808' WHERE ordernumber = 'P630817150329851' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409648' WHERE ordernumber = 'P180817150635235' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409649' WHERE ordernumber = 'P190817150637832' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409650' WHERE ordernumber = 'P420817150720491' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '368850' WHERE ordernumber = 'P180817150752518' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409651' WHERE ordernumber = 'P190817150820789' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '194268' WHERE ordernumber = 'P200817150933152' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409653' WHERE ordernumber = 'P180817150951863' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '190556' WHERE ordernumber = 'P420817151059871' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409654' WHERE ordernumber = 'P180817151108908' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '324267' WHERE ordernumber = 'P180817151145232' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409656' WHERE ordernumber = 'P190817151517224' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409658' WHERE ordernumber = 'P420817151754714' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409657' WHERE ordernumber = 'P180817151820888' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '359847' WHERE ordernumber = 'P420817152409205' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '380270' WHERE ordernumber = 'P420817152537391' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '404391' WHERE ordernumber = 'P200817152602346' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '408819' WHERE ordernumber = 'P420817152740444' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P190817152907313' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409662' WHERE ordernumber = 'P420817152915306' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '87258' WHERE ordernumber = 'P180817152924854' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409663' WHERE ordernumber = 'P420817153014840' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '65003' WHERE ordernumber = 'P200817153336561' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409666' WHERE ordernumber = 'P190817153427165' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409667' WHERE ordernumber = 'P180817153448977' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '409668' WHERE ordernumber = 'P420817153646641' 2024-08-18 01:00:04 -- UPDATE `omo_order_list` SET userId = '390601' WHERE ordernumber = 'P420817153822589' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409244' WHERE ordernumber = 'P180817153952165' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '350656' WHERE ordernumber = 'P420817153959390' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409670' WHERE ordernumber = 'P180817154235651' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409671' WHERE ordernumber = 'P180817154420147' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '160508' WHERE ordernumber = 'P190817154433422' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '333856' WHERE ordernumber = 'P200817154537119' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '333856' WHERE ordernumber = 'P200817154539952' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '270283' WHERE ordernumber = 'P200817155636163' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '270283' WHERE ordernumber = 'P200817155759175' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409682' WHERE ordernumber = 'P180817155901879' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409678' WHERE ordernumber = 'P180817160045763' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '301855' WHERE ordernumber = 'P200817160159310' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409683' WHERE ordernumber = 'P180817160512328' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '234169' WHERE ordernumber = 'P200817160537900' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '209969' WHERE ordernumber = 'P190817160555468' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409684' WHERE ordernumber = 'P190817160810889' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '349339' WHERE ordernumber = 'P200817161019861' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409686' WHERE ordernumber = 'P180817161205393' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409690' WHERE ordernumber = 'P190817161318727' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409692' WHERE ordernumber = 'P420817161750459' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409693' WHERE ordernumber = 'P190817161918939' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409273' WHERE ordernumber = 'P180817162000365' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409695' WHERE ordernumber = 'P180817162421338' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409697' WHERE ordernumber = 'P180817162553570' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409698' WHERE ordernumber = 'P190817162658571' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409700' WHERE ordernumber = 'P190817162819689' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409699' WHERE ordernumber = 'P180817162848611' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '140510' WHERE ordernumber = 'P180817163321712' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409702' WHERE ordernumber = 'P200817163357325' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409703' WHERE ordernumber = 'P190817163406930' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409706' WHERE ordernumber = 'P180817163754235' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '405209' WHERE ordernumber = 'P420817164056955' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409707' WHERE ordernumber = 'P200817164242711' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '87862' WHERE ordernumber = 'P180817164318301' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '349210' WHERE ordernumber = 'P180817164517182' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '318742' WHERE ordernumber = 'P200817164638135' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409709' WHERE ordernumber = 'P180817164659308' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '337854' WHERE ordernumber = 'P200817164726867' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '388643' WHERE ordernumber = 'P180817164806266' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409711' WHERE ordernumber = 'P420817164843918' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '212161' WHERE ordernumber = 'P180817164922921' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '389418' WHERE ordernumber = 'P200817165147734' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409714' WHERE ordernumber = 'P200817165614658' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409716' WHERE ordernumber = 'P180817165931881' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '396477' WHERE ordernumber = 'P420817170121200' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409713' WHERE ordernumber = 'P180817170204780' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409720' WHERE ordernumber = 'P200817170313995' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409721' WHERE ordernumber = 'P190817170541361' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '292743' WHERE ordernumber = 'P420817170649191' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409724' WHERE ordernumber = 'P180817170826693' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '75238' WHERE ordernumber = 'P420817170939868' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '321877' WHERE ordernumber = 'P420817171313675' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409725' WHERE ordernumber = 'P420817171521560' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '391279' WHERE ordernumber = 'P180817171526731' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '392758' WHERE ordernumber = 'P190817171800611' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '302397' WHERE ordernumber = 'P180817172006608' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409728' WHERE ordernumber = 'P420817172301494' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409729' WHERE ordernumber = 'P420817172409529' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '373757' WHERE ordernumber = 'P420817172456428' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '405297' WHERE ordernumber = 'P200817173140565' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '401847' WHERE ordernumber = 'P180817173237547' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '312946' WHERE ordernumber = 'P200817173301982' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '401847' WHERE ordernumber = 'P180817173322270' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409732' WHERE ordernumber = 'P190817173446408' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '281536' WHERE ordernumber = 'P180817173536356' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '400648' WHERE ordernumber = 'P420817173634630' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '382824' WHERE ordernumber = 'P190817173743677' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409733' WHERE ordernumber = 'P180817173749267' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '406543' WHERE ordernumber = 'P420817173907662' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409734' WHERE ordernumber = 'P180817173934329' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409737' WHERE ordernumber = 'P420817174339533' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '318750' WHERE ordernumber = 'P420817174636650' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409738' WHERE ordernumber = 'P180817174657219' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409739' WHERE ordernumber = 'P190817174759141' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '321239' WHERE ordernumber = 'P420817174937172' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409741' WHERE ordernumber = 'P420817175151602' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409745' WHERE ordernumber = 'P180817175305798' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '223827' WHERE ordernumber = 'P190817175401348' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409746' WHERE ordernumber = 'P420817175526512' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409747' WHERE ordernumber = 'P180817175647733' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409748' WHERE ordernumber = 'P200817175814228' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '339377' WHERE ordernumber = 'P420817180348223' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '199266' WHERE ordernumber = 'P180817180350369' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '367890' WHERE ordernumber = 'P180817180827371' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409755' WHERE ordernumber = 'P180817180946115' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '325908' WHERE ordernumber = 'P420817181049268' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '236700' WHERE ordernumber = 'P180817181050355' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '409757' WHERE ordernumber = 'P200817181227552' 2024-08-18 01:00:05 -- UPDATE `omo_order_list` SET userId = '230309' WHERE ordernumber = 'P180817181324959' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409759' WHERE ordernumber = 'P180817181650455' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '408148' WHERE ordernumber = 'P420817181743781' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409760' WHERE ordernumber = 'P180817181834212' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '408146' WHERE ordernumber = 'P420817181834210' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '385450' WHERE ordernumber = 'P420817181913969' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '49053' WHERE ordernumber = 'P180817182611687' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409764' WHERE ordernumber = 'P190817182756280' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409766' WHERE ordernumber = 'P420817183331995' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '24' WHERE ordernumber = 'P200817183502533' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409770' WHERE ordernumber = 'P420817184002236' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409771' WHERE ordernumber = 'P180817184035810' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409772' WHERE ordernumber = 'P190817184038426' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409773' WHERE ordernumber = 'P180817184306439' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409744' WHERE ordernumber = 'P200817184421579' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '362427' WHERE ordernumber = 'P190817184530319' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409774' WHERE ordernumber = 'P200817184534204' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '298001' WHERE ordernumber = 'P190817184915240' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409778' WHERE ordernumber = 'P420817185233141' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409775' WHERE ordernumber = 'P190817185419766' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409775' WHERE ordernumber = 'P190817185456704' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '316315' WHERE ordernumber = 'P190817185753917' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409413' WHERE ordernumber = 'P420817185837286' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409782' WHERE ordernumber = 'P190817190143808' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '106172' WHERE ordernumber = 'P190817190242369' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '106172' WHERE ordernumber = 'P190817190600750' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409785' WHERE ordernumber = 'P200817190825968' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '139071' WHERE ordernumber = 'P200817191023549' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '346824' WHERE ordernumber = 'P200817191137289' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '93317' WHERE ordernumber = 'P190817191416932' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '403141' WHERE ordernumber = 'P190817191825384' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '240513' WHERE ordernumber = 'P190817191920776' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409788' WHERE ordernumber = 'P190817192051290' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409790' WHERE ordernumber = 'P190817192408621' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409791' WHERE ordernumber = 'P190817192507251' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '387199' WHERE ordernumber = 'P190817192554463' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '308373' WHERE ordernumber = 'P190817192723345' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409790' WHERE ordernumber = 'P190817192856248' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '387269' WHERE ordernumber = 'P590817192938849' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '266863' WHERE ordernumber = 'P200817192953483' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409793' WHERE ordernumber = 'P190817193050501' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409790' WHERE ordernumber = 'P190817193153470' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409796' WHERE ordernumber = 'P200817193855419' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409797' WHERE ordernumber = 'P190817194020223' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409800' WHERE ordernumber = 'P190817194659168' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409800' WHERE ordernumber = 'P190817194920774' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409804' WHERE ordernumber = 'P190817195110524' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '96452' WHERE ordernumber = 'P190817195226293' 2024-08-18 01:00:06 -- UPDATE `omo_order_list` SET userId = '409804' WHERE ordernumber = 'P190817195336746'