2024-06-09 01:00:02 -- 將會員中心id寫入data-lake 2024-06-09 01:00:02 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-06-08%'; 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '350393' WHERE ordernumber = 'P630608105832852' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394918' WHERE ordernumber = 'P710608110056488' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '247023' WHERE ordernumber = 'P200608110221984' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '363315' WHERE ordernumber = 'P190608110741784' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394917' WHERE ordernumber = 'P180608110812535' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394917' WHERE ordernumber = 'P180608110841898' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394920' WHERE ordernumber = 'P190608110959185' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394921' WHERE ordernumber = 'P420608111021674' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '226733' WHERE ordernumber = 'P180608111319677' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394922' WHERE ordernumber = 'P190608111507423' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '388269' WHERE ordernumber = 'P180608111611865' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '209575' WHERE ordernumber = 'P190608111635924' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394923' WHERE ordernumber = 'P420608111713237' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394924' WHERE ordernumber = 'P190608111805543' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '393444' WHERE ordernumber = 'P190608111940606' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '271320' WHERE ordernumber = 'P180608112145797' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394925' WHERE ordernumber = 'P420608112305643' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '283628' WHERE ordernumber = 'P200608112321941' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394926' WHERE ordernumber = 'P200608112541870' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394927' WHERE ordernumber = 'P200608113239206' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '161959' WHERE ordernumber = 'P590608113729160' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394928' WHERE ordernumber = 'P420608113900902' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394929' WHERE ordernumber = 'P180608113944431' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '213823' WHERE ordernumber = 'P200608114242250' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '261738' WHERE ordernumber = 'P180608114320245' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394931' WHERE ordernumber = 'P420608114449867' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '393210' WHERE ordernumber = 'P200608114537235' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394932' WHERE ordernumber = 'P420608114559183' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394512' WHERE ordernumber = 'P420608114812303' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '387919' WHERE ordernumber = 'P190608114827442' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '387736' WHERE ordernumber = 'P630608114835358' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '301862' WHERE ordernumber = 'P200608115522341' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394933' WHERE ordernumber = 'P200608115753217' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394135' WHERE ordernumber = 'P420608115755562' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394935' WHERE ordernumber = 'P710608120310289' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394934' WHERE ordernumber = 'P420608120341540' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '302120' WHERE ordernumber = 'P180608120531910' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '378584' WHERE ordernumber = 'P420608120553306' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608120735212' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '280868' WHERE ordernumber = 'P200608120905616' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608120930352' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '385099' WHERE ordernumber = 'P200608121134872' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608121212180' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394936' WHERE ordernumber = 'P420608121252583' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '255478' WHERE ordernumber = 'P180608121354250' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608121619366' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '224194' WHERE ordernumber = 'P200608121717824' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608121813665' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394937' WHERE ordernumber = 'P180608121846540' 2024-06-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '394938' WHERE ordernumber = 'P200608121928365' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P190608121943335' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '379963' WHERE ordernumber = 'P180608122539663' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '109486' WHERE ordernumber = 'P200608122545576' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '393992' WHERE ordernumber = 'P180608122734517' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '383296' WHERE ordernumber = 'P630608123109969' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394940' WHERE ordernumber = 'P180608123411586' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '311575' WHERE ordernumber = 'P420608123556127' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394941' WHERE ordernumber = 'P180608124028436' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '383504' WHERE ordernumber = 'P180608124200996' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394942' WHERE ordernumber = 'P420608124228135' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '251557' WHERE ordernumber = 'P180608124545567' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '381805' WHERE ordernumber = 'P200608124713229' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '151370' WHERE ordernumber = 'P420608124752373' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394943' WHERE ordernumber = 'P710608125112339' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '218049' WHERE ordernumber = 'P710608125240453' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394944' WHERE ordernumber = 'P420608125818835' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394910' WHERE ordernumber = 'P180608125928570' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394945' WHERE ordernumber = 'P180608130117958' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394946' WHERE ordernumber = 'P190608130644538' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394948' WHERE ordernumber = 'P420608130707718' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394950' WHERE ordernumber = 'P190608130913752' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394951' WHERE ordernumber = 'P190608131158394' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '345801' WHERE ordernumber = 'P420608131203754' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394947' WHERE ordernumber = 'P180608131318918' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394947' WHERE ordernumber = 'P180608131407137' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394952' WHERE ordernumber = 'P190608131419584' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394818' WHERE ordernumber = 'P420608131420901' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P200608131547818' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '289765' WHERE ordernumber = 'P190608131630773' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394952' WHERE ordernumber = 'P180608131652115' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '202994' WHERE ordernumber = 'P200608131845536' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '114260' WHERE ordernumber = 'P200608132021551' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394954' WHERE ordernumber = 'P200608132311820' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394955' WHERE ordernumber = 'P190608132816549' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394956' WHERE ordernumber = 'P420608133100640' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394957' WHERE ordernumber = 'P190608133234629' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394958' WHERE ordernumber = 'P200608133439129' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394959' WHERE ordernumber = 'P420608134205655' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394960' WHERE ordernumber = 'P420608134428197' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '223678' WHERE ordernumber = 'P200608134456354' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394961' WHERE ordernumber = 'P200608134623565' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394963' WHERE ordernumber = 'P420608134733808' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '375239' WHERE ordernumber = 'P180608134808207' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '206289' WHERE ordernumber = 'P180608134959882' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '224258' WHERE ordernumber = 'P420608135008746' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394964' WHERE ordernumber = 'P200608135134188' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394965' WHERE ordernumber = 'P200608135312240' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '230871' WHERE ordernumber = 'P180608135417836' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '307686' WHERE ordernumber = 'P200608135512967' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '385153' WHERE ordernumber = 'P200608135555845' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '224258' WHERE ordernumber = 'P420608135555964' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394966' WHERE ordernumber = 'P180608135735937' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '350792' WHERE ordernumber = 'P190608135847743' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '347408' WHERE ordernumber = 'P180608135951791' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '388328' WHERE ordernumber = 'P420608140421893' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394968' WHERE ordernumber = 'P200608140431925' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394969' WHERE ordernumber = 'P630608140449399' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '94536' WHERE ordernumber = 'P200608140543861' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394970' WHERE ordernumber = 'P180608140642862' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '234346' WHERE ordernumber = 'P200608140828483' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394971' WHERE ordernumber = 'P420608140917623' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '105283' WHERE ordernumber = 'P710608141053808' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '390602' WHERE ordernumber = 'P200608141142185' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '312854' WHERE ordernumber = 'P200608141448483' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '158000' WHERE ordernumber = 'P200608141700863' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394972' WHERE ordernumber = 'P710608142127602' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '390927' WHERE ordernumber = 'P180608142336613' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394974' WHERE ordernumber = 'P190608142343240' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394976' WHERE ordernumber = 'P200608142553294' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394973' WHERE ordernumber = 'P710608142647122' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394977' WHERE ordernumber = 'P180608142736343' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394975' WHERE ordernumber = 'P710608142838629' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '216512' WHERE ordernumber = 'P180608142912905' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '387207' WHERE ordernumber = 'P420608143039181' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '390854' WHERE ordernumber = 'P200608143131737' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '289937' WHERE ordernumber = 'P180608143456397' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394978' WHERE ordernumber = 'P190608143500402' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '341736' WHERE ordernumber = 'P180608143716298' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394979' WHERE ordernumber = 'P190608143733784' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '341364' WHERE ordernumber = 'P200608144019624' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394980' WHERE ordernumber = 'P200608144741569' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394981' WHERE ordernumber = 'P190608145120616' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394982' WHERE ordernumber = 'P420608145227161' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394983' WHERE ordernumber = 'P180608145259821' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '301501' WHERE ordernumber = 'P200608145606360' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '273486' WHERE ordernumber = 'P190608145634384' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394985' WHERE ordernumber = 'P420608145654281' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394986' WHERE ordernumber = 'P200608145910217' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394987' WHERE ordernumber = 'P420608150037744' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '196998' WHERE ordernumber = 'P200608150100875' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394988' WHERE ordernumber = 'P190608150213268' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394989' WHERE ordernumber = 'P710608150345145' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394990' WHERE ordernumber = 'P420608150503492' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '284320' WHERE ordernumber = 'P200608150811413' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '383852' WHERE ordernumber = 'P420608150820710' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '387508' WHERE ordernumber = 'P180608151247616' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394992' WHERE ordernumber = 'P190608151340591' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '312217' WHERE ordernumber = 'P200608151354714' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394993' WHERE ordernumber = 'P420608151452328' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394995' WHERE ordernumber = 'P420608151805230' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '326272' WHERE ordernumber = 'P180608152242796' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394996' WHERE ordernumber = 'P780608152320178' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394997' WHERE ordernumber = 'P180608152416456' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '298816' WHERE ordernumber = 'P180608152543416' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '123302' WHERE ordernumber = 'P200608152920507' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '394998' WHERE ordernumber = 'P180608153005738' 2024-06-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '274772' WHERE ordernumber = 'P420608153010265' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '95826' WHERE ordernumber = 'P180608153056230' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '123302' WHERE ordernumber = 'P200608153135323' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '383909' WHERE ordernumber = 'P630608153558374' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394999' WHERE ordernumber = 'P180608153603744' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '306855' WHERE ordernumber = 'P200608153720220' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395001' WHERE ordernumber = 'P190608153735535' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395002' WHERE ordernumber = 'P420608153821130' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395003' WHERE ordernumber = 'P180608154033352' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '302951' WHERE ordernumber = 'P190608154214633' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395004' WHERE ordernumber = 'P180608154313431' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '276843' WHERE ordernumber = 'P420608154947963' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '282860' WHERE ordernumber = 'P180608155116884' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '179596' WHERE ordernumber = 'P420608155254546' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '112837' WHERE ordernumber = 'P200608155624213' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '238362' WHERE ordernumber = 'P190608155735749' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '308715' WHERE ordernumber = 'P200608155840439' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395005' WHERE ordernumber = 'P420608155904502' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395006' WHERE ordernumber = 'P420608160051180' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395007' WHERE ordernumber = 'P180608160148632' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '365728' WHERE ordernumber = 'P180608160315887' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395008' WHERE ordernumber = 'P780608160322967' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '245369' WHERE ordernumber = 'P200608160543927' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '243453' WHERE ordernumber = 'P200608160718890' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395010' WHERE ordernumber = 'P420608160826812' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395011' WHERE ordernumber = 'P200608160904691' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394065' WHERE ordernumber = 'P180608161207982' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395013' WHERE ordernumber = 'P190608161313538' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395015' WHERE ordernumber = 'P420608162311760' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395014' WHERE ordernumber = 'P180608162341888' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395016' WHERE ordernumber = 'P190608162523674' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395017' WHERE ordernumber = 'P180608162526296' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '275037' WHERE ordernumber = 'P190608162638866' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395019' WHERE ordernumber = 'P180608162641197' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395020' WHERE ordernumber = 'P200608162722373' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395018' WHERE ordernumber = 'P710608162743257' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '234481' WHERE ordernumber = 'P180608163112876' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '345922' WHERE ordernumber = 'P200608163349137' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395021' WHERE ordernumber = 'P180608163648569' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395022' WHERE ordernumber = 'P420608163706246' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '213967' WHERE ordernumber = 'P420608163857682' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '388053' WHERE ordernumber = 'P200608164139133' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '128240' WHERE ordernumber = 'P180608164341968' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '287188' WHERE ordernumber = 'P190608164906948' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '274152' WHERE ordernumber = 'P180608165040136' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395025' WHERE ordernumber = 'P190608165154924' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '238603' WHERE ordernumber = 'P200608165159814' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395026' WHERE ordernumber = 'P180608165235439' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395027' WHERE ordernumber = 'P420608165255720' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395028' WHERE ordernumber = 'P180608165445640' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '238604' WHERE ordernumber = 'P200608165558826' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394011' WHERE ordernumber = 'P180608165718402' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395029' WHERE ordernumber = 'P180608165841715' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '341644' WHERE ordernumber = 'P200608170237280' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394011' WHERE ordernumber = 'P180608170329392' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395030' WHERE ordernumber = 'P200608170342141' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395031' WHERE ordernumber = 'P180608170619699' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '382269' WHERE ordernumber = 'P180608170703859' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395032' WHERE ordernumber = 'P420608170745621' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395033' WHERE ordernumber = 'P180608170934636' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '78710' WHERE ordernumber = 'P180608171146471' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395036' WHERE ordernumber = 'P420608171431549' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395037' WHERE ordernumber = 'P420608171549380' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394941' WHERE ordernumber = 'P190608171629567' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395038' WHERE ordernumber = 'P420608171705622' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '394632' WHERE ordernumber = 'P190608171727912' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '339468' WHERE ordernumber = 'P200608171757816' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395034' WHERE ordernumber = 'P190608171858905' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395039' WHERE ordernumber = 'P180608171902921' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395040' WHERE ordernumber = 'P180608172013737' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395041' WHERE ordernumber = 'P420608172024495' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395042' WHERE ordernumber = 'P780608172122976' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '342558' WHERE ordernumber = 'P190608172430787' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '302174' WHERE ordernumber = 'P780608172507733' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '390602' WHERE ordernumber = 'P200608172637978' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395043' WHERE ordernumber = 'P420608172926158' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '342558' WHERE ordernumber = 'P190608173001671' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '215016' WHERE ordernumber = 'P630608173029426' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395045' WHERE ordernumber = 'P420608173033713' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395046' WHERE ordernumber = 'P420608173207267' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395047' WHERE ordernumber = 'P420608173329517' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '385398' WHERE ordernumber = 'P200608173416643' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '380927' WHERE ordernumber = 'P180608173835248' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395048' WHERE ordernumber = 'P200608174034734' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '346631' WHERE ordernumber = 'P200608174140330' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '301862' WHERE ordernumber = 'P200608174630252' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395050' WHERE ordernumber = 'P200608174822292' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '122234' WHERE ordernumber = 'P190608174943387' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '270218' WHERE ordernumber = 'P590608175538951' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '393377' WHERE ordernumber = 'P630608175658424' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '236370' WHERE ordernumber = 'P180608175724248' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '276117' WHERE ordernumber = 'P200608175803507' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395053' WHERE ordernumber = 'P190608175817299' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395055' WHERE ordernumber = 'P190608180109376' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395056' WHERE ordernumber = 'P180608180535792' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '354252' WHERE ordernumber = 'P180608180713262' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '118107' WHERE ordernumber = 'P180608180928487' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395057' WHERE ordernumber = 'P420608181118372' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395058' WHERE ordernumber = 'P200608181142128' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395061' WHERE ordernumber = 'P420608181423138' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395062' WHERE ordernumber = 'P180608181733746' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '391228' WHERE ordernumber = 'P190608181741687' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395063' WHERE ordernumber = 'P200608181829449' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '395064' WHERE ordernumber = 'P180608181906865' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '335204' WHERE ordernumber = 'P190608181908599' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '372052' WHERE ordernumber = 'P420608182053348' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '372052' WHERE ordernumber = 'P420608182159234' 2024-06-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '278533' WHERE ordernumber = 'P630608182209715' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395049' WHERE ordernumber = 'P190608182219425' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '390631' WHERE ordernumber = 'P180608182505941' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '161831' WHERE ordernumber = 'P200608182636421' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '393826' WHERE ordernumber = 'P190608182638312' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '393826' WHERE ordernumber = 'P190608182730134' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395065' WHERE ordernumber = 'P420608182810977' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395049' WHERE ordernumber = 'P180608183009296' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '98228' WHERE ordernumber = 'P200608183013152' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395066' WHERE ordernumber = 'P180608183422741' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '391928' WHERE ordernumber = 'P190608183555206' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '341564' WHERE ordernumber = 'P180608183719373' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '160961' WHERE ordernumber = 'P200608183801486' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '183490' WHERE ordernumber = 'P710608183837463' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '375132' WHERE ordernumber = 'P710608184108847' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '207861' WHERE ordernumber = 'P180608184132572' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '301837' WHERE ordernumber = 'P420608184231330' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395068' WHERE ordernumber = 'P710608184300695' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395069' WHERE ordernumber = 'P420608184357489' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '39674' WHERE ordernumber = 'P630608184622200' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '305141' WHERE ordernumber = 'P180608184649458' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '305627' WHERE ordernumber = 'P710608184808270' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '216514' WHERE ordernumber = 'P200608184816312' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395071' WHERE ordernumber = 'P190608184823799' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395072' WHERE ordernumber = 'P420608184845829' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395073' WHERE ordernumber = 'P420608184950633' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395074' WHERE ordernumber = 'P200608185030498' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395075' WHERE ordernumber = 'P190608185431942' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '98135' WHERE ordernumber = 'P200608185431437' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '224258' WHERE ordernumber = 'P420608185446180' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395077' WHERE ordernumber = 'P780608185538452' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395071' WHERE ordernumber = 'P190608185812881' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395078' WHERE ordernumber = 'P190608185918125' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '391240' WHERE ordernumber = 'P190608190013838' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395079' WHERE ordernumber = 'P710608190556841' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395080' WHERE ordernumber = 'P710608190741214' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395081' WHERE ordernumber = 'P780608191023781' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395082' WHERE ordernumber = 'P190608191054569' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '279621' WHERE ordernumber = 'P200608191120739' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395083' WHERE ordernumber = 'P200608191551618' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395084' WHERE ordernumber = 'P190608192039658' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395085' WHERE ordernumber = 'P200608192834155' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395086' WHERE ordernumber = 'P200608193345366' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395083' WHERE ordernumber = 'P200608193614488' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395050' WHERE ordernumber = 'P200608193902378' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '99566' WHERE ordernumber = 'P190608193931223' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395087' WHERE ordernumber = 'P200608194110403' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '343074' WHERE ordernumber = 'P190608194138630' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '391982' WHERE ordernumber = 'P190608194331384' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '391982' WHERE ordernumber = 'P190608194601478' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '298396' WHERE ordernumber = 'P200608194850679' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376402' WHERE ordernumber = 'P710608195130284' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395088' WHERE ordernumber = 'P200608195151948' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395087' WHERE ordernumber = 'P200608195833178' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395092' WHERE ordernumber = 'P780608202648708' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395093' WHERE ordernumber = 'P710608204108129' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395096' WHERE ordernumber = 'P780608205258599' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395097' WHERE ordernumber = 'P710608205951480' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395098' WHERE ordernumber = 'P710608210440955' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '327770' WHERE ordernumber = 'P780608211233280' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '272286' WHERE ordernumber = 'P630608212026625' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395100' WHERE ordernumber = 'P710608212703931' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '382250' WHERE ordernumber = 'P590608214424265' 2024-06-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '395101' WHERE ordernumber = 'P780608215524186'