2024-07-28 01:00:03 -- 將會員中心id寫入data-lake 2024-07-28 01:00:03 -- 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-07-27%'; 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '276154' WHERE ordernumber = 'P630727103114778' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '368246' WHERE ordernumber = 'P180727110313765' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '377666' WHERE ordernumber = 'P180727110413440' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '266162' WHERE ordernumber = 'P200727110902342' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '402459' WHERE ordernumber = 'P200727111038882' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '307428' WHERE ordernumber = 'P420727111838555' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '151394' WHERE ordernumber = 'P180727111933909' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403275' WHERE ordernumber = 'P200727111956792' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403276' WHERE ordernumber = 'P420727112041941' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403277' WHERE ordernumber = 'P180727112050460' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403278' WHERE ordernumber = 'P190727112136774' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403280' WHERE ordernumber = 'P420727112226817' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403279' WHERE ordernumber = 'P200727112225991' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403281' WHERE ordernumber = 'P200727112357629' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403282' WHERE ordernumber = 'P200727113006546' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403283' WHERE ordernumber = 'P200727113158664' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403284' WHERE ordernumber = 'P420727113219685' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403285' WHERE ordernumber = 'P180727113306603' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403286' WHERE ordernumber = 'P420727113342382' 2024-07-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '399295' WHERE ordernumber = 'P630727113410307' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '376882' WHERE ordernumber = 'P420727113457395' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403287' WHERE ordernumber = 'P180727113624563' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403288' WHERE ordernumber = 'P420727113634198' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '375005' WHERE ordernumber = 'P180727113955113' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '383099' WHERE ordernumber = 'P190727114034318' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403288' WHERE ordernumber = 'P420727114228916' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '365868' WHERE ordernumber = 'P190727114322752' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403289' WHERE ordernumber = 'P420727114357213' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '328377' WHERE ordernumber = 'P190727114411779' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403290' WHERE ordernumber = 'P420727114520439' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '91119' WHERE ordernumber = 'P180727114525433' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '169960' WHERE ordernumber = 'P200727114647839' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '303263' WHERE ordernumber = 'P190727114703195' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403290' WHERE ordernumber = 'P420727114704249' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '234025' WHERE ordernumber = 'P180727114729910' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403290' WHERE ordernumber = 'P420727114749784' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403291' WHERE ordernumber = 'P190727115140972' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '359878' WHERE ordernumber = 'P200727115516746' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403292' WHERE ordernumber = 'P190727115643219' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '167846' WHERE ordernumber = 'P190727115803165' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '288246' WHERE ordernumber = 'P180727115826642' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '83927' WHERE ordernumber = 'P190727120039111' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403294' WHERE ordernumber = 'P180727120246681' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403295' WHERE ordernumber = 'P200727120456871' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '400781' WHERE ordernumber = 'P180727120534658' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '390543' WHERE ordernumber = 'P200727120541646' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403296' WHERE ordernumber = 'P190727120701313' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '169122' WHERE ordernumber = 'P420727120931869' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403297' WHERE ordernumber = 'P200727121046717' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '225202' WHERE ordernumber = 'P180727121335957' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403299' WHERE ordernumber = 'P420727121805379' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '349196' WHERE ordernumber = 'P200727122208570' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403300' WHERE ordernumber = 'P180727122219467' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '354039' WHERE ordernumber = 'P180727122413784' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '230861' WHERE ordernumber = 'P200727122539257' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '280392' WHERE ordernumber = 'P420727122544758' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403301' WHERE ordernumber = 'P420727122806173' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '314086' WHERE ordernumber = 'P180727122901683' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403303' WHERE ordernumber = 'P180727123117330' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '343973' WHERE ordernumber = 'P200727123327116' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403305' WHERE ordernumber = 'P180727123502906' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403307' WHERE ordernumber = 'P420727123554488' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '137729' WHERE ordernumber = 'P200727124009944' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403308' WHERE ordernumber = 'P180727124211982' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403309' WHERE ordernumber = 'P200727124401209' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403310' WHERE ordernumber = 'P180727124655472' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '296280' WHERE ordernumber = 'P180727125101862' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '276267' WHERE ordernumber = 'P180727125354858' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403311' WHERE ordernumber = 'P190727125419158' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '242929' WHERE ordernumber = 'P200727125606712' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '354150' WHERE ordernumber = 'P180727125820576' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403313' WHERE ordernumber = 'P180727130656251' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '281733' WHERE ordernumber = 'P180727130737355' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '395384' WHERE ordernumber = 'P180727130848939' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '330762' WHERE ordernumber = 'P180727131331194' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403315' WHERE ordernumber = 'P200727131333951' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403059' WHERE ordernumber = 'P190727131437764' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403316' WHERE ordernumber = 'P180727131513679' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403318' WHERE ordernumber = 'P200727131544779' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403317' WHERE ordernumber = 'P190727131607178' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403319' WHERE ordernumber = 'P420727131846160' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '280077' WHERE ordernumber = 'P180727132203808' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403048' WHERE ordernumber = 'P180727132242719' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '353827' WHERE ordernumber = 'P200727132250282' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '390653' WHERE ordernumber = 'P180727132523195' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403320' WHERE ordernumber = 'P200727132540307' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403322' WHERE ordernumber = 'P420727132857315' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403323' WHERE ordernumber = 'P180727133013164' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403324' WHERE ordernumber = 'P200727133019117' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '349955' WHERE ordernumber = 'P200727133245447' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403327' WHERE ordernumber = 'P420727133506670' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '80992' WHERE ordernumber = 'P180727133621263' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403328' WHERE ordernumber = 'P420727133725127' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '93730' WHERE ordernumber = 'P200727134055382' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '382646' WHERE ordernumber = 'P420727134113433' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403330' WHERE ordernumber = 'P190727134141627' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403332' WHERE ordernumber = 'P420727134406144' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403331' WHERE ordernumber = 'P190727134551846' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403333' WHERE ordernumber = 'P180727134612650' 2024-07-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '403334' WHERE ordernumber = 'P200727135008113' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403335' WHERE ordernumber = 'P420727135513234' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403336' WHERE ordernumber = 'P420727135628830' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403337' WHERE ordernumber = 'P190727135922772' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403338' WHERE ordernumber = 'P200727135947544' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '373116' WHERE ordernumber = 'P420727135956409' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403339' WHERE ordernumber = 'P200727140123429' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403341' WHERE ordernumber = 'P190727140519217' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '241198' WHERE ordernumber = 'P200727140618251' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403342' WHERE ordernumber = 'P420727140759456' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '398498' WHERE ordernumber = 'P420727141101379' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '341209' WHERE ordernumber = 'P190727141306143' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '390324' WHERE ordernumber = 'P190727141406478' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '375327' WHERE ordernumber = 'P200727141510579' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '226927' WHERE ordernumber = 'P190727141529279' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403343' WHERE ordernumber = 'P180727141631598' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '397129' WHERE ordernumber = 'P420727141657297' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403345' WHERE ordernumber = 'P420727141843517' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '375277' WHERE ordernumber = 'P180727142458412' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403347' WHERE ordernumber = 'P420727142827445' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '384161' WHERE ordernumber = 'P180727142914370' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '401237' WHERE ordernumber = 'P180727143218432' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403348' WHERE ordernumber = 'P200727143343399' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403349' WHERE ordernumber = 'P420727143626929' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '133899' WHERE ordernumber = 'P200727143702116' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403350' WHERE ordernumber = 'P420727143850527' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '108038' WHERE ordernumber = 'P180727144323496' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403351' WHERE ordernumber = 'P420727144549517' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403352' WHERE ordernumber = 'P180727144916170' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403353' WHERE ordernumber = 'P180727145319769' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '96677' WHERE ordernumber = 'P190727145359868' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '393138' WHERE ordernumber = 'P180727145438515' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '148175' WHERE ordernumber = 'P190727145506241' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403357' WHERE ordernumber = 'P180727150019862' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '381828' WHERE ordernumber = 'P420727150109814' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403358' WHERE ordernumber = 'P180727150325504' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '389962' WHERE ordernumber = 'P420727150430329' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403359' WHERE ordernumber = 'P190727150556712' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '244308' WHERE ordernumber = 'P200727150735651' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403360' WHERE ordernumber = 'P420727150825241' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '241062' WHERE ordernumber = 'P180727150834499' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '105625' WHERE ordernumber = 'P590727150922817' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '230115' WHERE ordernumber = 'P180727151207407' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403363' WHERE ordernumber = 'P200727151219168' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '256540' WHERE ordernumber = 'P200727151344781' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403364' WHERE ordernumber = 'P180727151403876' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '379300' WHERE ordernumber = 'P420727151533223' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403361' WHERE ordernumber = 'P180727151622638' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403365' WHERE ordernumber = 'P200727151632302' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '360017' WHERE ordernumber = 'P180727151715350' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403367' WHERE ordernumber = 'P200727151914119' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403267' WHERE ordernumber = 'P180727151946334' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403368' WHERE ordernumber = 'P420727152010871' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403030' WHERE ordernumber = 'P200727152121477' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403030' WHERE ordernumber = 'P200727152130117' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403369' WHERE ordernumber = 'P420727152312180' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403370' WHERE ordernumber = 'P180727152403443' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403371' WHERE ordernumber = 'P420727152451262' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403373' WHERE ordernumber = 'P420727152602493' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403374' WHERE ordernumber = 'P420727152732440' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403376' WHERE ordernumber = 'P180727152914337' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '166785' WHERE ordernumber = 'P180727153056586' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '342343' WHERE ordernumber = 'P180727153323115' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403378' WHERE ordernumber = 'P420727153411825' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403379' WHERE ordernumber = 'P630727153509945' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '168576' WHERE ordernumber = 'P200727153523124' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403380' WHERE ordernumber = 'P420727153604876' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403381' WHERE ordernumber = 'P190727153709677' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403382' WHERE ordernumber = 'P180727153827416' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403384' WHERE ordernumber = 'P420727154035955' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403385' WHERE ordernumber = 'P200727154044184' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403386' WHERE ordernumber = 'P420727154216871' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403387' WHERE ordernumber = 'P180727154241838' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '395776' WHERE ordernumber = 'P200727154335690' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403384' WHERE ordernumber = 'P420727154344813' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '209597' WHERE ordernumber = 'P180727154834526' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403387' WHERE ordernumber = 'P190727154906344' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '403388' WHERE ordernumber = 'P420727155000433' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '27604' WHERE ordernumber = 'P200727155139268' 2024-07-28 01:00:05 -- UPDATE `omo_order_list` SET userId = '163636' WHERE ordernumber = 'P200727155338145' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '233369' WHERE ordernumber = 'P200727155526904' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403390' WHERE ordernumber = 'P180727155603542' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '356107' WHERE ordernumber = 'P420727155638354' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403391' WHERE ordernumber = 'P200727155738597' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '394214' WHERE ordernumber = 'P180727155844361' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '140470' WHERE ordernumber = 'P180727160021831' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '343808' WHERE ordernumber = 'P630727160027318' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '213847' WHERE ordernumber = 'P200727160123192' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '304795' WHERE ordernumber = 'P200727160216286' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '381816' WHERE ordernumber = 'P420727160404314' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403392' WHERE ordernumber = 'P630727160509680' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403393' WHERE ordernumber = 'P420727160726517' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403395' WHERE ordernumber = 'P420727160839482' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403394' WHERE ordernumber = 'P180727160938804' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '345765' WHERE ordernumber = 'P190727161014299' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403354' WHERE ordernumber = 'P420727161112807' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403396' WHERE ordernumber = 'P180727161114785' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '315800' WHERE ordernumber = 'P180727161149561' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '401779' WHERE ordernumber = 'P180727161440246' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '401779' WHERE ordernumber = 'P180727161626912' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '345765' WHERE ordernumber = 'P190727161642450' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '395430' WHERE ordernumber = 'P420727161836688' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '395430' WHERE ordernumber = 'P420727161952871' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '338083' WHERE ordernumber = 'P190727162014726' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '306264' WHERE ordernumber = 'P180727162027334' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '298992' WHERE ordernumber = 'P200727162123747' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403397' WHERE ordernumber = 'P180727162338120' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403398' WHERE ordernumber = 'P420727162344137' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403400' WHERE ordernumber = 'P180727162709251' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '400157' WHERE ordernumber = 'P180727162903310' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403402' WHERE ordernumber = 'P180727163013152' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403403' WHERE ordernumber = 'P420727163056533' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '302662' WHERE ordernumber = 'P200727163059855' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403404' WHERE ordernumber = 'P180727163135149' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '395884' WHERE ordernumber = 'P420727163136345' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '119816' WHERE ordernumber = 'P190727163522770' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '62775' WHERE ordernumber = 'P200727163636335' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '218997' WHERE ordernumber = 'P190727163652995' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '321904' WHERE ordernumber = 'P200727163731411' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403407' WHERE ordernumber = 'P180727163826178' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '103395' WHERE ordernumber = 'P200727163841605' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403409' WHERE ordernumber = 'P190727164123428' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403410' WHERE ordernumber = 'P180727164153386' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403411' WHERE ordernumber = 'P420727164231658' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403412' WHERE ordernumber = 'P200727164327566' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403413' WHERE ordernumber = 'P180727164420564' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403414' WHERE ordernumber = 'P200727164425377' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '344260' WHERE ordernumber = 'P420727164503795' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403415' WHERE ordernumber = 'P190727164539768' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '117587' WHERE ordernumber = 'P200727164658631' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '278660' WHERE ordernumber = 'P180727164811820' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403416' WHERE ordernumber = 'P420727164918502' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '163759' WHERE ordernumber = 'P200727165044395' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403418' WHERE ordernumber = 'P180727165100408' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '220300' WHERE ordernumber = 'P190727165101682' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '342437' WHERE ordernumber = 'P180727165233877' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403419' WHERE ordernumber = 'P190727165409356' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403420' WHERE ordernumber = 'P200727165613271' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '102280' WHERE ordernumber = 'P420727165737364' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403421' WHERE ordernumber = 'P180727165740297' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403422' WHERE ordernumber = 'P420727170343513' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '398349' WHERE ordernumber = 'P190727170453695' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '236671' WHERE ordernumber = 'P190727170715974' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403424' WHERE ordernumber = 'P190727170933513' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '339179' WHERE ordernumber = 'P420727171047178' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403426' WHERE ordernumber = 'P180727171104196' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '365729' WHERE ordernumber = 'P190727171134976' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403428' WHERE ordernumber = 'P420727171205887' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403427' WHERE ordernumber = 'P200727171303931' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '252320' WHERE ordernumber = 'P200727171421696' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '321885' WHERE ordernumber = 'P420727171502958' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '349315' WHERE ordernumber = 'P420727171557454' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403429' WHERE ordernumber = 'P420727171733830' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403430' WHERE ordernumber = 'P180727171756443' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '96480' WHERE ordernumber = 'P180727171938177' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '402146' WHERE ordernumber = 'P200727172353454' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '81669' WHERE ordernumber = 'P180727172434285' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '120211' WHERE ordernumber = 'P180727172557336' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '95188' WHERE ordernumber = 'P420727172733198' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '382939' WHERE ordernumber = 'P180727172746495' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403432' WHERE ordernumber = 'P190727172820392' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403433' WHERE ordernumber = 'P420727172943914' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403434' WHERE ordernumber = 'P180727172954898' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403435' WHERE ordernumber = 'P180727173051820' 2024-07-28 01:00:06 -- UPDATE `omo_order_list` SET userId = '403436' WHERE ordernumber = 'P190727173134824' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '250093' WHERE ordernumber = 'P180727173555128' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403182' WHERE ordernumber = 'P180727173639200' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403436' WHERE ordernumber = 'P190727173657415' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403437' WHERE ordernumber = 'P180727173800485' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403436' WHERE ordernumber = 'P190727173838195' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403438' WHERE ordernumber = 'P420727173854680' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403439' WHERE ordernumber = 'P180727174033622' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '304603' WHERE ordernumber = 'P200727174053751' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403440' WHERE ordernumber = 'P420727174326932' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403442' WHERE ordernumber = 'P180727175050558' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403444' WHERE ordernumber = 'P180727175210961' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403443' WHERE ordernumber = 'P200727175211509' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '103922' WHERE ordernumber = 'P180727175254766' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403446' WHERE ordernumber = 'P200727175342971' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403445' WHERE ordernumber = 'P420727175346420' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '386499' WHERE ordernumber = 'P180727175642141' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '391604' WHERE ordernumber = 'P200727175818449' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403449' WHERE ordernumber = 'P420727175901775' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403450' WHERE ordernumber = 'P200727175910216' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '96658' WHERE ordernumber = 'P420727180003578' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '250155' WHERE ordernumber = 'P180727180029819' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '111012' WHERE ordernumber = 'P190727180056611' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403452' WHERE ordernumber = 'P190727180238848' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403454' WHERE ordernumber = 'P180727180356725' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '214862' WHERE ordernumber = 'P200727180406346' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403455' WHERE ordernumber = 'P190727180435265' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403457' WHERE ordernumber = 'P180727181108253' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403346' WHERE ordernumber = 'P180727181533910' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403458' WHERE ordernumber = 'P420727181652875' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403459' WHERE ordernumber = 'P200727181708163' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '269074' WHERE ordernumber = 'P180727181933889' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403462' WHERE ordernumber = 'P180727182400996' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403463' WHERE ordernumber = 'P200727182626818' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403463' WHERE ordernumber = 'P200727182651391' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403463' WHERE ordernumber = 'P200727182747292' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P180727182845411' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '397509' WHERE ordernumber = 'P190727182854273' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403464' WHERE ordernumber = 'P420727182912341' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '249603' WHERE ordernumber = 'P180727183056354' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '399307' WHERE ordernumber = 'P200727183114988' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '249603' WHERE ordernumber = 'P180727183144845' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403465' WHERE ordernumber = 'P200727183234674' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403467' WHERE ordernumber = 'P420727183315763' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403468' WHERE ordernumber = 'P180727183448927' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '311550' WHERE ordernumber = 'P180727183637920' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '224002' WHERE ordernumber = 'P200727184029464' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '305073' WHERE ordernumber = 'P200727184149321' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403469' WHERE ordernumber = 'P180727184214586' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403471' WHERE ordernumber = 'P180727184634129' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403472' WHERE ordernumber = 'P190727185204590' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403473' WHERE ordernumber = 'P420727185227573' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403472' WHERE ordernumber = 'P190727185400777' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403474' WHERE ordernumber = 'P420727185651679' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403475' WHERE ordernumber = 'P420727185821935' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403476' WHERE ordernumber = 'P420727190121800' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403478' WHERE ordernumber = 'P200727190352421' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403479' WHERE ordernumber = 'P190727190731446' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '283169' WHERE ordernumber = 'P190727191532633' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '354668' WHERE ordernumber = 'P190727192157981' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403482' WHERE ordernumber = 'P200727192328643' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403483' WHERE ordernumber = 'P190727192342228' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403485' WHERE ordernumber = 'P190727194012823' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '215207' WHERE ordernumber = 'P200727195444766' 2024-07-28 01:00:07 -- UPDATE `omo_order_list` SET userId = '403486' WHERE ordernumber = 'P200727195615523'