2024-06-26 01:00:03 -- 將會員ä¸å¿ƒid寫入data-lake 2024-06-26 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-06-25%'; 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397954' WHERE ordernumber = 'P630625103844715' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '228920' WHERE ordernumber = 'P420625110147148' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397958' WHERE ordernumber = 'P200625110152417' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '49345' WHERE ordernumber = 'P200625110247794' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397960' WHERE ordernumber = 'P200625110459663' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '277935' WHERE ordernumber = 'P420625110511606' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '393057' WHERE ordernumber = 'P200625110551410' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397961' WHERE ordernumber = 'P190625110605954' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '214660' WHERE ordernumber = 'P180625110809694' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397962' WHERE ordernumber = 'P190625110821942' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '367851' WHERE ordernumber = 'P180625110940470' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397963' WHERE ordernumber = 'P420625110944132' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '300645' WHERE ordernumber = 'P420625111105508' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397964' WHERE ordernumber = 'P180625111123302' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '387701' WHERE ordernumber = 'P200625111154185' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397965' WHERE ordernumber = 'P190625111627424' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '218749' WHERE ordernumber = 'P190625111736535' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397966' WHERE ordernumber = 'P420625111756248' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '389016' WHERE ordernumber = 'P200625112452602' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '288562' WHERE ordernumber = 'P200625112541795' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '62458' WHERE ordernumber = 'P200625112655359' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '218728' WHERE ordernumber = 'P200625112836966' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '230111' WHERE ordernumber = 'P190625112955695' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397967' WHERE ordernumber = 'P180625113129764' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '217809' WHERE ordernumber = 'P200625113246558' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '217941' WHERE ordernumber = 'P180625114121837' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397968' WHERE ordernumber = 'P180625114412490' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397969' WHERE ordernumber = 'P200625114449527' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397970' WHERE ordernumber = 'P420625115310563' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '42491' WHERE ordernumber = 'P780625115402576' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '285872' WHERE ordernumber = 'P200625115510673' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '311997' WHERE ordernumber = 'P180625115911345' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '247344' WHERE ordernumber = 'P200625120311310' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '319052' WHERE ordernumber = 'P200625120407628' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397971' WHERE ordernumber = 'P420625120454408' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397973' WHERE ordernumber = 'P180625120931585' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '381089' WHERE ordernumber = 'P420625121034397' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397976' WHERE ordernumber = 'P200625121338725' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '269426' WHERE ordernumber = 'P180625121743208' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397977' WHERE ordernumber = 'P630625121836541' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397978' WHERE ordernumber = 'P200625121919303' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '388775' WHERE ordernumber = 'P200625122359574' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397741' WHERE ordernumber = 'P420625122521431' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '394739' WHERE ordernumber = 'P420625123016538' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397979' WHERE ordernumber = 'P590625123037146' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '228365' WHERE ordernumber = 'P180625123205300' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397980' WHERE ordernumber = 'P420625123244459' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '384050' WHERE ordernumber = 'P200625123257493' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '132247' WHERE ordernumber = 'P180625123408268' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397982' WHERE ordernumber = 'P180625123745426' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397983' WHERE ordernumber = 'P420625123837955' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397984' WHERE ordernumber = 'P420625124054116' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397985' WHERE ordernumber = 'P420625124300391' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '225631' WHERE ordernumber = 'P420625124439414' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '226376' WHERE ordernumber = 'P420625124544685' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397986' WHERE ordernumber = 'P200625124648172' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '141131' WHERE ordernumber = 'P200625124742328' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '313065' WHERE ordernumber = 'P180625125016422' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '210362' WHERE ordernumber = 'P200625125357280' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397987' WHERE ordernumber = 'P200625125551992' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '388814' WHERE ordernumber = 'P420625125921331' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397988' WHERE ordernumber = 'P180625125938207' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397990' WHERE ordernumber = 'P180625130602708' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '319392' WHERE ordernumber = 'P180625130741413' 2024-06-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '397991' WHERE ordernumber = 'P200625130800144' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '253543' WHERE ordernumber = 'P180625130957290' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '396528' WHERE ordernumber = 'P420625131334713' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397993' WHERE ordernumber = 'P630625131605700' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P190625131801566' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397994' WHERE ordernumber = 'P200625131838827' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '130570' WHERE ordernumber = 'P200625131918731' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '396528' WHERE ordernumber = 'P420625132050740' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '383057' WHERE ordernumber = 'P180625132059371' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '327308' WHERE ordernumber = 'P200625132109293' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '263388' WHERE ordernumber = 'P200625132159464' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397927' WHERE ordernumber = 'P420625132323511' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397927' WHERE ordernumber = 'P420625132537747' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397995' WHERE ordernumber = 'P180625132546222' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397996' WHERE ordernumber = 'P200625132605718' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '386860' WHERE ordernumber = 'P420625132658469' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '386969' WHERE ordernumber = 'P190625133003635' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397997' WHERE ordernumber = 'P180625133247147' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '244678' WHERE ordernumber = 'P200625133417759' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397998' WHERE ordernumber = 'P590625133722552' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397999' WHERE ordernumber = 'P200625134122978' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398000' WHERE ordernumber = 'P180625134217305' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398001' WHERE ordernumber = 'P180625134512856' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398001' WHERE ordernumber = 'P180625134554597' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '363403' WHERE ordernumber = 'P180625134945911' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398003' WHERE ordernumber = 'P630625135234731' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '309980' WHERE ordernumber = 'P180625135414315' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '143087' WHERE ordernumber = 'P200625135635684' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '309980' WHERE ordernumber = 'P180625135643357' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '305149' WHERE ordernumber = 'P200625140034819' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398004' WHERE ordernumber = 'P180625140100543' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '309849' WHERE ordernumber = 'P190625140213396' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398005' WHERE ordernumber = 'P630625140555197' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398006' WHERE ordernumber = 'P180625140626503' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398007' WHERE ordernumber = 'P190625140736863' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '384449' WHERE ordernumber = 'P180625140957958' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '206620' WHERE ordernumber = 'P180625141227990' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398009' WHERE ordernumber = 'P180625141707753' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398008' WHERE ordernumber = 'P630625141719129' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398010' WHERE ordernumber = 'P190625141823791' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '388940' WHERE ordernumber = 'P420625142235597' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '383634' WHERE ordernumber = 'P420625142459558' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398012' WHERE ordernumber = 'P200625142604221' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398004' WHERE ordernumber = 'P180625142729390' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398013' WHERE ordernumber = 'P180625143000350' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398012' WHERE ordernumber = 'P200625143024608' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398014' WHERE ordernumber = 'P420625143318148' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398015' WHERE ordernumber = 'P180625143412113' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398016' WHERE ordernumber = 'P200625143417980' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398017' WHERE ordernumber = 'P190625143513483' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '384329' WHERE ordernumber = 'P180625143523688' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398018' WHERE ordernumber = 'P180625143731745' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398019' WHERE ordernumber = 'P420625144005419' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398020' WHERE ordernumber = 'P180625144042292' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398022' WHERE ordernumber = 'P180625144316554' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398023' WHERE ordernumber = 'P180625144453851' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398021' WHERE ordernumber = 'P190625144506395' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '308062' WHERE ordernumber = 'P630625144646589' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '277459' WHERE ordernumber = 'P200625145224622' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '286885' WHERE ordernumber = 'P180625145356870' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '389066' WHERE ordernumber = 'P420625145402579' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '28051' WHERE ordernumber = 'P780625145658202' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '386359' WHERE ordernumber = 'P630625145823679' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '283036' WHERE ordernumber = 'P180625150103334' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398025' WHERE ordernumber = 'P420625150211974' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398026' WHERE ordernumber = 'P190625150251714' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '392841' WHERE ordernumber = 'P590625150452747' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '270938' WHERE ordernumber = 'P200625150609958' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '358902' WHERE ordernumber = 'P630625150617810' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398028' WHERE ordernumber = 'P630625150951955' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '297083' WHERE ordernumber = 'P630625151103463' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '279256' WHERE ordernumber = 'P630625151155752' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398030' WHERE ordernumber = 'P190625151445318' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398029' WHERE ordernumber = 'P420625151456764' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '297775' WHERE ordernumber = 'P190625151624918' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '396803' WHERE ordernumber = 'P190625152036555' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398031' WHERE ordernumber = 'P630625152147157' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398032' WHERE ordernumber = 'P630625152233758' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398033' WHERE ordernumber = 'P190625152712840' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398037' WHERE ordernumber = 'P180625152903986' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398035' WHERE ordernumber = 'P200625152916158' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398036' WHERE ordernumber = 'P190625152930199' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '353481' WHERE ordernumber = 'P420625153535305' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '118590' WHERE ordernumber = 'P180625153645831' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398038' WHERE ordernumber = 'P630625153820674' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '297104' WHERE ordernumber = 'P420625153825357' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '312687' WHERE ordernumber = 'P780625153942584' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398039' WHERE ordernumber = 'P200625154216625' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '387838' WHERE ordernumber = 'P200625154323434' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '218542' WHERE ordernumber = 'P180625154728923' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398040' WHERE ordernumber = 'P200625154813566' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398042' WHERE ordernumber = 'P190625155138987' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398043' WHERE ordernumber = 'P180625155355862' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '396127' WHERE ordernumber = 'P180625155813137' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '397051' WHERE ordernumber = 'P180625160121476' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '311361' WHERE ordernumber = 'P180625160348958' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398047' WHERE ordernumber = 'P180625161012858' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '398048' WHERE ordernumber = 'P180625161238116' 2024-06-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '333406' WHERE ordernumber = 'P180625161343505' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '102047' WHERE ordernumber = 'P200625161631488' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '394207' WHERE ordernumber = 'P180625161942807' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '366208' WHERE ordernumber = 'P420625162153244' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '326304' WHERE ordernumber = 'P180625162356447' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '384456' WHERE ordernumber = 'P180625162847907' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '334889' WHERE ordernumber = 'P180625163200849' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398052' WHERE ordernumber = 'P420625163413208' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '364418' WHERE ordernumber = 'P180625163451722' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '336368' WHERE ordernumber = 'P420625163503126' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398053' WHERE ordernumber = 'P780625163536847' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398054' WHERE ordernumber = 'P180625163632985' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '395978' WHERE ordernumber = 'P200625164110297' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398055' WHERE ordernumber = 'P200625164231283' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '87593' WHERE ordernumber = 'P180625164613494' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398056' WHERE ordernumber = 'P590625164734603' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398059' WHERE ordernumber = 'P630625165128823' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398058' WHERE ordernumber = 'P180625165138783' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398060' WHERE ordernumber = 'P190625165203321' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398061' WHERE ordernumber = 'P190625165520420' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '393290' WHERE ordernumber = 'P420625165957665' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '3159' WHERE ordernumber = 'P190625170340112' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398063' WHERE ordernumber = 'P190625170615511' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398064' WHERE ordernumber = 'P420625170950400' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '286027' WHERE ordernumber = 'P200625171240856' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '238134' WHERE ordernumber = 'P200625171310446' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '258005' WHERE ordernumber = 'P180625171455434' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398065' WHERE ordernumber = 'P200625171618941' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '116809' WHERE ordernumber = 'P190625171822906' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '105630' WHERE ordernumber = 'P200625172145155' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '379518' WHERE ordernumber = 'P180625172250636' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '348261' WHERE ordernumber = 'P180625172451239' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '328345' WHERE ordernumber = 'P180625172638757' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '395660' WHERE ordernumber = 'P180625172929340' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398066' WHERE ordernumber = 'P180625173525542' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398067' WHERE ordernumber = 'P630625173900752' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398068' WHERE ordernumber = 'P190625174019111' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '126645' WHERE ordernumber = 'P420625174033745' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '385831' WHERE ordernumber = 'P190625174117116' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398069' WHERE ordernumber = 'P200625174249884' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398070' WHERE ordernumber = 'P200625174505987' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398072' WHERE ordernumber = 'P180625175213552' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398074' WHERE ordernumber = 'P630625175630171' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '385796' WHERE ordernumber = 'P180625175827500' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398075' WHERE ordernumber = 'P630625175936958' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398076' WHERE ordernumber = 'P420625180002634' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398077' WHERE ordernumber = 'P630625180257266' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '741' WHERE ordernumber = 'P180625180629402' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398079' WHERE ordernumber = 'P630625180730202' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398080' WHERE ordernumber = 'P630625181443286' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '292079' WHERE ordernumber = 'P420625181512364' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '381358' WHERE ordernumber = 'P200625181525565' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398081' WHERE ordernumber = 'P200625181757631' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '196988' WHERE ordernumber = 'P200625182031199' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398082' WHERE ordernumber = 'P780625182235358' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '199954' WHERE ordernumber = 'P200625182248679' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '352951' WHERE ordernumber = 'P180625182415423' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398084' WHERE ordernumber = 'P630625182937874' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398085' WHERE ordernumber = 'P190625183053727' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398083' WHERE ordernumber = 'P180625183239376' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '242582' WHERE ordernumber = 'P190625183346234' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398086' WHERE ordernumber = 'P190625183518219' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '389634' WHERE ordernumber = 'P190625183645380' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '254652' WHERE ordernumber = 'P180625183957136' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '238944' WHERE ordernumber = 'P200625184131515' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '287062' WHERE ordernumber = 'P200625184549872' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398087' WHERE ordernumber = 'P180625184915548' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '137176' WHERE ordernumber = 'P630625185303562' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398088' WHERE ordernumber = 'P630625185433354' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '364705' WHERE ordernumber = 'P200625185906701' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '304793' WHERE ordernumber = 'P190625190043733' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '304793' WHERE ordernumber = 'P190625190152295' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398090' WHERE ordernumber = 'P190625190411641' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398091' WHERE ordernumber = 'P630625190514172' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398092' WHERE ordernumber = 'P190625190528899' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398093' WHERE ordernumber = 'P190625190706852' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398094' WHERE ordernumber = 'P630625190830699' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '308402' WHERE ordernumber = 'P200625190850257' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '337524' WHERE ordernumber = 'P190625190906454' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '217259' WHERE ordernumber = 'P630625190924758' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398095' WHERE ordernumber = 'P630625191039552' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398098' WHERE ordernumber = 'P630625191731297' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '138016' WHERE ordernumber = 'P630625191843437' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398097' WHERE ordernumber = 'P630625191854312' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '75881' WHERE ordernumber = 'P190625192447210' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '98198' WHERE ordernumber = 'P200625192639244' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398099' WHERE ordernumber = 'P630625192719231' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398100' WHERE ordernumber = 'P200625192828996' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '347522' WHERE ordernumber = 'P200625192922537' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '345628' WHERE ordernumber = 'P200625193029252' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '218516' WHERE ordernumber = 'P190625193141488' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398101' WHERE ordernumber = 'P630625193154907' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398102' WHERE ordernumber = 'P200625193154680' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '378295' WHERE ordernumber = 'P190625193404884' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398103' WHERE ordernumber = 'P630625193433617' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '236236' WHERE ordernumber = 'P200625193702541' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398105' WHERE ordernumber = 'P630625194116255' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '398107' WHERE ordernumber = 'P630625195649242' 2024-06-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '138293' WHERE ordernumber = 'P190625195928878' 2024-06-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '341869' WHERE ordernumber = 'P630625200532391' 2024-06-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '398108' WHERE ordernumber = 'P630625200729736' 2024-06-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '391975' WHERE ordernumber = 'P630625204045555' 2024-06-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '398109' WHERE ordernumber = 'P630625210519870' 2024-06-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '398110' WHERE ordernumber = 'P630625211157721'