2024-06-23 01:00:01 -- 將會員中心id寫入data-lake 2024-06-23 01:00:01 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-06-22%'; 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397319' WHERE ordernumber = 'P630622100655298' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '303073' WHERE ordernumber = 'P630622104753292' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '230299' WHERE ordernumber = 'P190622110151975' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '378584' WHERE ordernumber = 'P420622110257763' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397323' WHERE ordernumber = 'P180622110316446' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397324' WHERE ordernumber = 'P190622110323713' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '247643' WHERE ordernumber = 'P190622110437929' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '301300' WHERE ordernumber = 'P180622110455673' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '368008' WHERE ordernumber = 'P420622110525338' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '217757' WHERE ordernumber = 'P190622110553380' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '294511' WHERE ordernumber = 'P180622110607968' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '391898' WHERE ordernumber = 'P180622110801441' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '233602' WHERE ordernumber = 'P190622110827131' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '309298' WHERE ordernumber = 'P180622110954401' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '342512' WHERE ordernumber = 'P190622111125352' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '309133' WHERE ordernumber = 'P200622111136412' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '251277' WHERE ordernumber = 'P180622111148488' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397328' WHERE ordernumber = 'P190622111303497' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397329' WHERE ordernumber = 'P180622111321411' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397326' WHERE ordernumber = 'P780622111348297' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '382784' WHERE ordernumber = 'P180622111444219' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '113698' WHERE ordernumber = 'P180622111653589' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '388841' WHERE ordernumber = 'P190622111725961' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '206405' WHERE ordernumber = 'P180622111848671' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '386200' WHERE ordernumber = 'P180622112426625' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397332' WHERE ordernumber = 'P420622112629271' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '350278' WHERE ordernumber = 'P200622112750144' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P200622112910293' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '334081' WHERE ordernumber = 'P420622113132238' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '101496' WHERE ordernumber = 'P200622113239662' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '82642' WHERE ordernumber = 'P420622113337629' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '393537' WHERE ordernumber = 'P180622113559752' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '259307' WHERE ordernumber = 'P190622113650931' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397333' WHERE ordernumber = 'P200622113720932' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '135490' WHERE ordernumber = 'P190622113849878' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '395766' WHERE ordernumber = 'P200622113920539' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '382980' WHERE ordernumber = 'P190622114133333' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '298137' WHERE ordernumber = 'P420622114439197' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397334' WHERE ordernumber = 'P190622114510186' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397335' WHERE ordernumber = 'P200622114643209' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397336' WHERE ordernumber = 'P420622114726470' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '247440' WHERE ordernumber = 'P190622114806523' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '155914' WHERE ordernumber = 'P630622115009690' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '159147' WHERE ordernumber = 'P630622115230243' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '383860' WHERE ordernumber = 'P200622115301360' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397339' WHERE ordernumber = 'P190622115959138' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397340' WHERE ordernumber = 'P200622120203696' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '304095' WHERE ordernumber = 'P180622120720141' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '224687' WHERE ordernumber = 'P200622120902739' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '317218' WHERE ordernumber = 'P420622121009345' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '373684' WHERE ordernumber = 'P420622121100395' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '135710' WHERE ordernumber = 'P200622121128252' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '381303' WHERE ordernumber = 'P420622121210288' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397343' WHERE ordernumber = 'P420622121431142' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397344' WHERE ordernumber = 'P420622121606977' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '396477' WHERE ordernumber = 'P420622121657967' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397345' WHERE ordernumber = 'P200622121924510' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '297597' WHERE ordernumber = 'P200622122222331' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397346' WHERE ordernumber = 'P420622122843861' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397347' WHERE ordernumber = 'P630622122917747' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '244286' WHERE ordernumber = 'P200622123006878' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '269551' WHERE ordernumber = 'P630622123116527' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '118801' WHERE ordernumber = 'P180622123337715' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397348' WHERE ordernumber = 'P200622123517511' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397349' WHERE ordernumber = 'P630622123535553' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '394729' WHERE ordernumber = 'P180622123604517' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '378798' WHERE ordernumber = 'P200622123630584' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397350' WHERE ordernumber = 'P200622123821495' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397351' WHERE ordernumber = 'P190622123821471' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397353' WHERE ordernumber = 'P180622123908388' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '390879' WHERE ordernumber = 'P200622124002757' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '145854' WHERE ordernumber = 'P200622124327876' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '339374' WHERE ordernumber = 'P180622124705265' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '272810' WHERE ordernumber = 'P200622124832624' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '396717' WHERE ordernumber = 'P180622125034834' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '282521' WHERE ordernumber = 'P180622125239279' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '210700' WHERE ordernumber = 'P420622125702404' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '250051' WHERE ordernumber = 'P180622125753224' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397356' WHERE ordernumber = 'P420622125853469' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '390116' WHERE ordernumber = 'P200622130144609' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397357' WHERE ordernumber = 'P420622130145168' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '278656' WHERE ordernumber = 'P420622130338748' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '87294' WHERE ordernumber = 'P200622130625639' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397358' WHERE ordernumber = 'P420622130638123' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397359' WHERE ordernumber = 'P200622131146133' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '280056' WHERE ordernumber = 'P180622131210677' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '318159' WHERE ordernumber = 'P200622131309560' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397360' WHERE ordernumber = 'P190622131452488' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '395878' WHERE ordernumber = 'P200622132143612' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '397361' WHERE ordernumber = 'P200622132512819' 2024-06-23 01:00:02 -- UPDATE `omo_order_list` SET userId = '386850' WHERE ordernumber = 'P420622132831685' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '382224' WHERE ordernumber = 'P190622133226259' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397363' WHERE ordernumber = 'P420622133429650' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '111540' WHERE ordernumber = 'P190622134019802' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '396398' WHERE ordernumber = 'P180622134054274' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397364' WHERE ordernumber = 'P180622134237589' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397365' WHERE ordernumber = 'P420622134304870' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397366' WHERE ordernumber = 'P190622134334478' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '266436' WHERE ordernumber = 'P200622134419170' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '380915' WHERE ordernumber = 'P180622134434906' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397367' WHERE ordernumber = 'P630622134601681' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397368' WHERE ordernumber = 'P180622134636418' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397369' WHERE ordernumber = 'P190622134738719' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397370' WHERE ordernumber = 'P180622134844741' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '247692' WHERE ordernumber = 'P180622135052987' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397371' WHERE ordernumber = 'P420622135317973' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '313523' WHERE ordernumber = 'P180622135344418' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397372' WHERE ordernumber = 'P420622135812139' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397373' WHERE ordernumber = 'P190622140006409' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397374' WHERE ordernumber = 'P180622140055451' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '128944' WHERE ordernumber = 'P420622140127473' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397375' WHERE ordernumber = 'P180622140224262' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397376' WHERE ordernumber = 'P420622140443864' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '302966' WHERE ordernumber = 'P420622140556962' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '302967' WHERE ordernumber = 'P420622140638621' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P180622140646118' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397378' WHERE ordernumber = 'P630622140824369' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397377' WHERE ordernumber = 'P190622140922572' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '142572' WHERE ordernumber = 'P180622141304678' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '342562' WHERE ordernumber = 'P420622141551343' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '396681' WHERE ordernumber = 'P200622141750788' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397379' WHERE ordernumber = 'P180622141831136' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '386617' WHERE ordernumber = 'P630622142136289' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397380' WHERE ordernumber = 'P630622142204219' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '371632' WHERE ordernumber = 'P180622142205527' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397380' WHERE ordernumber = 'P630622142450141' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '389531' WHERE ordernumber = 'P180622142635661' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397382' WHERE ordernumber = 'P180622142809221' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397381' WHERE ordernumber = 'P630622142906843' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '250883' WHERE ordernumber = 'P200622142941142' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397383' WHERE ordernumber = 'P180622143016961' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397384' WHERE ordernumber = 'P420622143608358' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397385' WHERE ordernumber = 'P420622143746357' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '378599' WHERE ordernumber = 'P200622143751201' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '393101' WHERE ordernumber = 'P420622143920718' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397386' WHERE ordernumber = 'P180622144029180' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '71888' WHERE ordernumber = 'P180622144123876' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '277459' WHERE ordernumber = 'P200622144415261' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397387' WHERE ordernumber = 'P180622144556736' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '108371' WHERE ordernumber = 'P190622144701406' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397388' WHERE ordernumber = 'P180622144828516' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '313882' WHERE ordernumber = 'P180622144927622' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397390' WHERE ordernumber = 'P190622145245170' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397391' WHERE ordernumber = 'P420622145347329' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '174924' WHERE ordernumber = 'P190622145359253' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '383186' WHERE ordernumber = 'P180622145743763' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '390558' WHERE ordernumber = 'P420622145824976' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '304835' WHERE ordernumber = 'P180622145951779' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397392' WHERE ordernumber = 'P780622150051925' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397393' WHERE ordernumber = 'P180622150125495' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397394' WHERE ordernumber = 'P190622150509406' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397395' WHERE ordernumber = 'P180622150622256' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '114540' WHERE ordernumber = 'P190622150649599' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397396' WHERE ordernumber = 'P630622150730369' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397397' WHERE ordernumber = 'P180622150747585' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '97872' WHERE ordernumber = 'P200622150759183' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397398' WHERE ordernumber = 'P190622151034354' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397400' WHERE ordernumber = 'P630622151050405' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397399' WHERE ordernumber = 'P420622151115249' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397281' WHERE ordernumber = 'P180622151226261' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '112335' WHERE ordernumber = 'P180622151526471' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397402' WHERE ordernumber = 'P180622151706622' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397403' WHERE ordernumber = 'P190622151913431' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397401' WHERE ordernumber = 'P200622151927412' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397401' WHERE ordernumber = 'P200622152037287' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '282716' WHERE ordernumber = 'P420622152247391' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '377338' WHERE ordernumber = 'P200622152324649' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397405' WHERE ordernumber = 'P180622152457570' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '379718' WHERE ordernumber = 'P590622152555599' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '396343' WHERE ordernumber = 'P190622152638393' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397406' WHERE ordernumber = 'P180622152738399' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '349215' WHERE ordernumber = 'P200622152906925' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397407' WHERE ordernumber = 'P190622152914212' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '386269' WHERE ordernumber = 'P420622152928111' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '386269' WHERE ordernumber = 'P420622153000740' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '237179' WHERE ordernumber = 'P200622153311868' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '396070' WHERE ordernumber = 'P180622153330805' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397408' WHERE ordernumber = 'P420622153415422' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '349215' WHERE ordernumber = 'P200622153424701' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '384933' WHERE ordernumber = 'P420622153651896' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397409' WHERE ordernumber = 'P190622153724861' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '389745' WHERE ordernumber = 'P200622154330118' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397410' WHERE ordernumber = 'P420622154416932' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '343011' WHERE ordernumber = 'P420622154547553' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '74761' WHERE ordernumber = 'P420622154739232' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '251669' WHERE ordernumber = 'P180622155007311' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397411' WHERE ordernumber = 'P200622155010438' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397409' WHERE ordernumber = 'P190622155104718' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397413' WHERE ordernumber = 'P190622155233333' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397412' WHERE ordernumber = 'P180622155247886' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397414' WHERE ordernumber = 'P420622155258768' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397415' WHERE ordernumber = 'P200622155350263' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '368913' WHERE ordernumber = 'P420622155406892' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '379932' WHERE ordernumber = 'P190622155417689' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397417' WHERE ordernumber = 'P180622155541677' 2024-06-23 01:00:03 -- UPDATE `omo_order_list` SET userId = '397418' WHERE ordernumber = 'P200622155910498' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '67138' WHERE ordernumber = 'P630622160225296' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397419' WHERE ordernumber = 'P180622160301588' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '118708' WHERE ordernumber = 'P190622160732935' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '345734' WHERE ordernumber = 'P200622160809975' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397420' WHERE ordernumber = 'P420622160824772' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '280256' WHERE ordernumber = 'P180622160910459' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397314' WHERE ordernumber = 'P420622160942473' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '248158' WHERE ordernumber = 'P200622161236353' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397421' WHERE ordernumber = 'P200622161410908' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397422' WHERE ordernumber = 'P180622161450529' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '389260' WHERE ordernumber = 'P200622161553911' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397423' WHERE ordernumber = 'P200622161815840' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397425' WHERE ordernumber = 'P180622162339218' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '281958' WHERE ordernumber = 'P190622162354744' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397424' WHERE ordernumber = 'P780622162436834' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '280487' WHERE ordernumber = 'P180622162503634' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '313838' WHERE ordernumber = 'P180622162650827' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '244886' WHERE ordernumber = 'P200622162808662' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397427' WHERE ordernumber = 'P200622162941304' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397428' WHERE ordernumber = 'P180622163018600' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397429' WHERE ordernumber = 'P200622163254287' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397430' WHERE ordernumber = 'P420622163447179' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '213101' WHERE ordernumber = 'P200622163447839' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397432' WHERE ordernumber = 'P180622163657413' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397431' WHERE ordernumber = 'P420622163943608' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397433' WHERE ordernumber = 'P780622164102440' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '232646' WHERE ordernumber = 'P180622164332550' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397434' WHERE ordernumber = 'P420622164508931' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397435' WHERE ordernumber = 'P420622164730757' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '344768' WHERE ordernumber = 'P180622164824120' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397437' WHERE ordernumber = 'P180622164952121' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397436' WHERE ordernumber = 'P420622164953205' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '316090' WHERE ordernumber = 'P200622165155140' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '258037' WHERE ordernumber = 'P180622165342449' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '327457' WHERE ordernumber = 'P420622165445768' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397439' WHERE ordernumber = 'P180622165545153' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '360735' WHERE ordernumber = 'P180622165630923' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397440' WHERE ordernumber = 'P630622165718543' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397441' WHERE ordernumber = 'P420622170211468' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397442' WHERE ordernumber = 'P180622170252620' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397443' WHERE ordernumber = 'P420622170656220' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '396213' WHERE ordernumber = 'P420622171054451' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397445' WHERE ordernumber = 'P180622171525863' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397444' WHERE ordernumber = 'P180622171638636' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '391016' WHERE ordernumber = 'P420622171909482' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '344320' WHERE ordernumber = 'P420622172014279' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '381854' WHERE ordernumber = 'P200622172052393' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '282264' WHERE ordernumber = 'P200622172326400' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '126910' WHERE ordernumber = 'P420622172616795' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '388070' WHERE ordernumber = 'P180622172930317' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397449' WHERE ordernumber = 'P190622173043157' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '390624' WHERE ordernumber = 'P420622173058692' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '307508' WHERE ordernumber = 'P420622173220570' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397448' WHERE ordernumber = 'P420622173408404' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '299907' WHERE ordernumber = 'P420622173507620' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397451' WHERE ordernumber = 'P190622173514640' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397450' WHERE ordernumber = 'P200622173533160' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397452' WHERE ordernumber = 'P420622173640774' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397453' WHERE ordernumber = 'P180622173740894' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397056' WHERE ordernumber = 'P180622173909188' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '395665' WHERE ordernumber = 'P420622173909633' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397456' WHERE ordernumber = 'P590622174244561' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397457' WHERE ordernumber = 'P590622174356317' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '388070' WHERE ordernumber = 'P180622174434283' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '307412' WHERE ordernumber = 'P420622174516269' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397455' WHERE ordernumber = 'P630622174545354' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '388070' WHERE ordernumber = 'P180622174618283' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '387322' WHERE ordernumber = 'P200622174642320' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397458' WHERE ordernumber = 'P420622174658528' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397459' WHERE ordernumber = 'P590622174715489' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180622174842265' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397460' WHERE ordernumber = 'P420622174853721' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397461' WHERE ordernumber = 'P190622174945650' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '286713' WHERE ordernumber = 'P180622175011473' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397463' WHERE ordernumber = 'P420622175025402' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '305270' WHERE ordernumber = 'P190622175115953' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397464' WHERE ordernumber = 'P420622175217400' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397465' WHERE ordernumber = 'P180622175436902' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397466' WHERE ordernumber = 'P420622175610217' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '110374' WHERE ordernumber = 'P200622175649808' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397467' WHERE ordernumber = 'P190622175725195' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397187' WHERE ordernumber = 'P190622180014365' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397468' WHERE ordernumber = 'P420622180030200' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397469' WHERE ordernumber = 'P590622180106966' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '379652' WHERE ordernumber = 'P420622180707502' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397472' WHERE ordernumber = 'P590622180758561' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '277476' WHERE ordernumber = 'P180622180858214' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '396984' WHERE ordernumber = 'P180622181356833' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397473' WHERE ordernumber = 'P420622181414495' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397474' WHERE ordernumber = 'P180622181545183' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '356808' WHERE ordernumber = 'P190622181604497' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '371075' WHERE ordernumber = 'P200622181611286' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '392641' WHERE ordernumber = 'P180622181713769' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397475' WHERE ordernumber = 'P190622181824298' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397476' WHERE ordernumber = 'P180622181905981' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '310212' WHERE ordernumber = 'P180622182144610' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397477' WHERE ordernumber = 'P190622182329736' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397478' WHERE ordernumber = 'P420622182748146' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '344815' WHERE ordernumber = 'P200622182902403' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '396121' WHERE ordernumber = 'P200622183101347' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397479' WHERE ordernumber = 'P420622183134926' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '284832' WHERE ordernumber = 'P200622183430763' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '312829' WHERE ordernumber = 'P180622183654827' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '239611' WHERE ordernumber = 'P200622183758586' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397480' WHERE ordernumber = 'P780622183957139' 2024-06-23 01:00:04 -- UPDATE `omo_order_list` SET userId = '397481' WHERE ordernumber = 'P190622184308603' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397482' WHERE ordernumber = 'P180622184344280' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '371315' WHERE ordernumber = 'P780622184544139' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '235451' WHERE ordernumber = 'P200622184733979' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397483' WHERE ordernumber = 'P190622184756574' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '395880' WHERE ordernumber = 'P200622184822438' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397485' WHERE ordernumber = 'P190622185719282' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397486' WHERE ordernumber = 'P200622185930326' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397487' WHERE ordernumber = 'P200622190103923' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '384677' WHERE ordernumber = 'P630622190227228' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397484' WHERE ordernumber = 'P190622190247544' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '396050' WHERE ordernumber = 'P190622190334813' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397480' WHERE ordernumber = 'P780622190510959' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '395105' WHERE ordernumber = 'P780622190830357' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397489' WHERE ordernumber = 'P190622190952676' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '221443' WHERE ordernumber = 'P630622191254727' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397111' WHERE ordernumber = 'P200622191400999' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397492' WHERE ordernumber = 'P190622191550193' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397493' WHERE ordernumber = 'P190622191749697' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '360486' WHERE ordernumber = 'P630622192042223' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '272405' WHERE ordernumber = 'P190622192448541' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '304756' WHERE ordernumber = 'P200622192547720' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '396679' WHERE ordernumber = 'P190622192634133' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '383006' WHERE ordernumber = 'P190622192716281' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '97849' WHERE ordernumber = 'P200622193334575' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '276120' WHERE ordernumber = 'P200622193843471' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '138079' WHERE ordernumber = 'P190622193928193' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397494' WHERE ordernumber = 'P780622194048480' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397495' WHERE ordernumber = 'P190622194142484' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '389556' WHERE ordernumber = 'P200622194213199' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397496' WHERE ordernumber = 'P780622194745687' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '396634' WHERE ordernumber = 'P200622194808919' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397497' WHERE ordernumber = 'P780622195228188' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '239248' WHERE ordernumber = 'P630622200151833' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397498' WHERE ordernumber = 'P590622200327546' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '81111' WHERE ordernumber = 'P590622201409129' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397501' WHERE ordernumber = 'P590622201934402' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '60999' WHERE ordernumber = 'P590622203756940' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397502' WHERE ordernumber = 'P780622204558573' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '397503' WHERE ordernumber = 'P630622205722144' 2024-06-23 01:00:05 -- UPDATE `omo_order_list` SET userId = '390926' WHERE ordernumber = 'P780622211004996'