2024-02-06 01:00:02 -- 將會員中心id寫入data-lake 2024-02-06 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-02-05%'; 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '272568' WHERE ordernumber = 'P420205095636938' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '272568' WHERE ordernumber = 'P420205095744891' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375806' WHERE ordernumber = 'P200205110259217' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '237916' WHERE ordernumber = 'P200205110513203' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375811' WHERE ordernumber = 'P190205110707644' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375783' WHERE ordernumber = 'P180205110808826' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375783' WHERE ordernumber = 'P180205110836858' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '354279' WHERE ordernumber = 'P200205110857420' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '254543' WHERE ordernumber = 'P190205111216384' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375812' WHERE ordernumber = 'P420205111311999' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375347' WHERE ordernumber = 'P200205111320653' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375785' WHERE ordernumber = 'P190205111412446' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '327875' WHERE ordernumber = 'P200205111445225' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '287774' WHERE ordernumber = 'P180205111510553' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '363409' WHERE ordernumber = 'P190205111801542' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375795' WHERE ordernumber = 'P180205111841560' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '355693' WHERE ordernumber = 'P190205111950642' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375786' WHERE ordernumber = 'P180205112004276' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '37371' WHERE ordernumber = 'P200205112015934' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375791' WHERE ordernumber = 'P180205112105467' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '355693' WHERE ordernumber = 'P190205112107440' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '308350' WHERE ordernumber = 'P190205112235168' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375803' WHERE ordernumber = 'P190205112442392' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375810' WHERE ordernumber = 'P190205112640864' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '272510' WHERE ordernumber = 'P420205112814798' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375814' WHERE ordernumber = 'P180205112818579' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '375789' WHERE ordernumber = 'P190205112911649' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '123223' WHERE ordernumber = 'P200205113019848' 2024-02-06 01:00:02 -- UPDATE `omo_order_list` SET userId = '255698' WHERE ordernumber = 'P190205113108791' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '348429' WHERE ordernumber = 'P200205113113667' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375807' WHERE ordernumber = 'P180205113123392' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375807' WHERE ordernumber = 'P180205113207798' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375807' WHERE ordernumber = 'P180205113252949' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375805' WHERE ordernumber = 'P190205113346213' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '245747' WHERE ordernumber = 'P200205113433531' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375802' WHERE ordernumber = 'P180205113524226' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '145291' WHERE ordernumber = 'P190205113625142' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '89527' WHERE ordernumber = 'P200205113636918' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375830' WHERE ordernumber = 'P180205113655529' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '272510' WHERE ordernumber = 'P420205113659460' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375794' WHERE ordernumber = 'P190205113818704' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '224149' WHERE ordernumber = 'P180205113909321' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '294485' WHERE ordernumber = 'P190205113922910' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '294487' WHERE ordernumber = 'P180205114011374' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375793' WHERE ordernumber = 'P190205114028460' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '367339' WHERE ordernumber = 'P200205114404996' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '206790' WHERE ordernumber = 'P180205114417444' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '206790' WHERE ordernumber = 'P180205114525278' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375826' WHERE ordernumber = 'P190205114643830' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '206790' WHERE ordernumber = 'P180205114702363' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '279648' WHERE ordernumber = 'P190205114730817' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '240946' WHERE ordernumber = 'P180205114815563' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '315535' WHERE ordernumber = 'P200205114848765' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375799' WHERE ordernumber = 'P180205114924792' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '362039' WHERE ordernumber = 'P200205114927786' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375790' WHERE ordernumber = 'P190205114946163' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '356589' WHERE ordernumber = 'P200205115026634' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375796' WHERE ordernumber = 'P190205115315435' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375800' WHERE ordernumber = 'P180205115317493' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375836' WHERE ordernumber = 'P200205115331537' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375683' WHERE ordernumber = 'P190205115453355' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375798' WHERE ordernumber = 'P180205115511500' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '125502' WHERE ordernumber = 'P200205115600576' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '125502' WHERE ordernumber = 'P200205115700973' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375792' WHERE ordernumber = 'P180205115731139' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375627' WHERE ordernumber = 'P190205115732793' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '220043' WHERE ordernumber = 'P200205115753927' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375834' WHERE ordernumber = 'P180205115858819' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '97477' WHERE ordernumber = 'P200205115910493' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375827' WHERE ordernumber = 'P190205115914308' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375823' WHERE ordernumber = 'P190205120041256' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '286083' WHERE ordernumber = 'P200205120055357' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375833' WHERE ordernumber = 'P180205120112466' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '154128' WHERE ordernumber = 'P190205120248750' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '168033' WHERE ordernumber = 'P200205120343607' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375821' WHERE ordernumber = 'P180205120446730' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '159425' WHERE ordernumber = 'P200205120520331' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '80877' WHERE ordernumber = 'P190205120533271' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375824' WHERE ordernumber = 'P180205120547683' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '346678' WHERE ordernumber = 'P200205120614427' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '233704' WHERE ordernumber = 'P190205120713697' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375828' WHERE ordernumber = 'P180205120714992' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '313542' WHERE ordernumber = 'P200205120846750' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '80962' WHERE ordernumber = 'P190205121106696' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '350632' WHERE ordernumber = 'P200205121140483' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375822' WHERE ordernumber = 'P180205121243643' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '229641' WHERE ordernumber = 'P200205121437225' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '273295' WHERE ordernumber = 'P200205121506244' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '251022' WHERE ordernumber = 'P180205121507205' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '16386' WHERE ordernumber = 'P180205121607461' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '216595' WHERE ordernumber = 'P200205121659799' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '276704' WHERE ordernumber = 'P190205121732803' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '104603' WHERE ordernumber = 'P200205121748662' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375825' WHERE ordernumber = 'P190205122032129' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '351819' WHERE ordernumber = 'P200205122303415' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '35387' WHERE ordernumber = 'P180205122334320' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375816' WHERE ordernumber = 'P190205122339519' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375630' WHERE ordernumber = 'P180205122619132' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '326142' WHERE ordernumber = 'P200205122655253' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '359403' WHERE ordernumber = 'P190205123048710' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '237041' WHERE ordernumber = 'P530205123114942' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '52698' WHERE ordernumber = 'P180205123200509' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '353203' WHERE ordernumber = 'P200205123307485' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '343585' WHERE ordernumber = 'P190205123352798' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '252357' WHERE ordernumber = 'P200205123442553' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '214477' WHERE ordernumber = 'P180205123601530' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375815' WHERE ordernumber = 'P190205123633754' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '366576' WHERE ordernumber = 'P420205124016368' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375829' WHERE ordernumber = 'P180205124125577' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375849' WHERE ordernumber = 'P200205124137592' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '321455' WHERE ordernumber = 'P200205124310871' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '345799' WHERE ordernumber = 'P180205124330559' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '342330' WHERE ordernumber = 'P200205124421201' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '343931' WHERE ordernumber = 'P180205124614972' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375832' WHERE ordernumber = 'P190205124702319' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '93427' WHERE ordernumber = 'P200205124816230' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '282719' WHERE ordernumber = 'P200205124840369' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375831' WHERE ordernumber = 'P190205125006644' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '160648' WHERE ordernumber = 'P200205125253244' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '297814' WHERE ordernumber = 'P530205125319909' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '226896' WHERE ordernumber = 'P200205125434172' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375853' WHERE ordernumber = 'P180205125503170' 2024-02-06 01:00:03 -- UPDATE `omo_order_list` SET userId = '375835' WHERE ordernumber = 'P180205125729843' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '356293' WHERE ordernumber = 'P200205125806543' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '273238' WHERE ordernumber = 'P190205125952946' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '330771' WHERE ordernumber = 'P200205130024412' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '214639' WHERE ordernumber = 'P180205130121337' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '374291' WHERE ordernumber = 'P200205130139663' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '363919' WHERE ordernumber = 'P420205130153890' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '374291' WHERE ordernumber = 'P200205130212396' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '363919' WHERE ordernumber = 'P420205130253282' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '350632' WHERE ordernumber = 'P200205130312237' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '285283' WHERE ordernumber = 'P200205130354544' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375839' WHERE ordernumber = 'P180205130421814' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '164932' WHERE ordernumber = 'P200205130740195' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '247846' WHERE ordernumber = 'P200205131050986' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '368254' WHERE ordernumber = 'P180205131105753' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '104603' WHERE ordernumber = 'P200205131138154' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '374079' WHERE ordernumber = 'P190205131654332' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '359921' WHERE ordernumber = 'P190205131819255' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '291689' WHERE ordernumber = 'P180205131819719' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '118379' WHERE ordernumber = 'P180205131948736' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375860' WHERE ordernumber = 'P200205132627643' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '347680' WHERE ordernumber = 'P190205133047644' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '99654' WHERE ordernumber = 'P200205133128595' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '289111' WHERE ordernumber = 'P180205133159690' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '94902' WHERE ordernumber = 'P190205133550563' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '349191' WHERE ordernumber = 'P180205133653961' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '259250' WHERE ordernumber = 'P420205133956794' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '308008' WHERE ordernumber = 'P200205134100486' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '103922' WHERE ordernumber = 'P190205134243792' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '103922' WHERE ordernumber = 'P190205134352565' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375859' WHERE ordernumber = 'P180205134802675' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '257536' WHERE ordernumber = 'P190205134958759' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '275581' WHERE ordernumber = 'P200205135000128' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '228138' WHERE ordernumber = 'P190205135111828' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '372278' WHERE ordernumber = 'P200205135204960' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '255002' WHERE ordernumber = 'P190205135249598' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '271040' WHERE ordernumber = 'P200205135818850' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '158487' WHERE ordernumber = 'P190205135902294' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '344831' WHERE ordernumber = 'P180205135906581' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '272770' WHERE ordernumber = 'P190205140035845' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '296766' WHERE ordernumber = 'P420205140043700' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375865' WHERE ordernumber = 'P190205140536494' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375868' WHERE ordernumber = 'P180205140657512' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '326784' WHERE ordernumber = 'P420205140929323' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375863' WHERE ordernumber = 'P190205140945549' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '274699' WHERE ordernumber = 'P200205141258734' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '330642' WHERE ordernumber = 'P420205141312383' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375866' WHERE ordernumber = 'P190205141341917' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '330642' WHERE ordernumber = 'P420205141359343' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375867' WHERE ordernumber = 'P180205141631484' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375872' WHERE ordernumber = 'P180205141924816' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375871' WHERE ordernumber = 'P180205142002455' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375276' WHERE ordernumber = 'P190205142104745' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '98293' WHERE ordernumber = 'P200205142304427' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '166622' WHERE ordernumber = 'P180205142322610' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '160307' WHERE ordernumber = 'P180205142521637' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '221489' WHERE ordernumber = 'P200205142541528' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '113525' WHERE ordernumber = 'P420205142956244' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '140097' WHERE ordernumber = 'P200205143111298' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '360029' WHERE ordernumber = 'P190205143151903' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375142' WHERE ordernumber = 'P180205143439633' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '261075' WHERE ordernumber = 'P200205143514242' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '166622' WHERE ordernumber = 'P180205143642725' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375874' WHERE ordernumber = 'P190205143712526' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '238243' WHERE ordernumber = 'P180205143826507' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '253399' WHERE ordernumber = 'P200205144001176' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '297297' WHERE ordernumber = 'P190205144135641' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375878' WHERE ordernumber = 'P180205144245490' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375890' WHERE ordernumber = 'P190205144334133' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '232628' WHERE ordernumber = 'P190205144517235' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375020' WHERE ordernumber = 'P420205144539354' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '374158' WHERE ordernumber = 'P420205144639208' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375879' WHERE ordernumber = 'P190205144856410' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '279256' WHERE ordernumber = 'P420205144913594' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '100490' WHERE ordernumber = 'P200205145121351' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375882' WHERE ordernumber = 'P190205145625572' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375883' WHERE ordernumber = 'P180205145755209' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375881' WHERE ordernumber = 'P190205145859826' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '366819' WHERE ordernumber = 'P200205150417954' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375885' WHERE ordernumber = 'P180205150419391' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '217881' WHERE ordernumber = 'P180205150506190' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '146510' WHERE ordernumber = 'P190205150722406' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '337867' WHERE ordernumber = 'P200205150801488' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375888' WHERE ordernumber = 'P190205151235934' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '148238' WHERE ordernumber = 'P420205151311804' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375905' WHERE ordernumber = 'P200205151345821' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '235094' WHERE ordernumber = 'P190205151408185' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375906' WHERE ordernumber = 'P180205151437744' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '218734' WHERE ordernumber = 'P200205151453215' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '266104' WHERE ordernumber = 'P190205151622908' 2024-02-06 01:00:04 -- UPDATE `omo_order_list` SET userId = '375884' WHERE ordernumber = 'P180205151739122' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '96929' WHERE ordernumber = 'P180205151912786' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375892' WHERE ordernumber = 'P190205151928936' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375892' WHERE ordernumber = 'P190205151942181' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375206' WHERE ordernumber = 'P180205152016962' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375909' WHERE ordernumber = 'P200205152215694' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '359896' WHERE ordernumber = 'P180205152404629' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375898' WHERE ordernumber = 'P180205152545692' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375898' WHERE ordernumber = 'P180205152613576' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375897' WHERE ordernumber = 'P180205152713281' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375897' WHERE ordernumber = 'P180205152800323' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375903' WHERE ordernumber = 'P190205153130758' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '339940' WHERE ordernumber = 'P200205153217178' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '359086' WHERE ordernumber = 'P190205153459359' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375907' WHERE ordernumber = 'P190205153805996' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375904' WHERE ordernumber = 'P180205154114480' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375910' WHERE ordernumber = 'P190205154205701' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375913' WHERE ordernumber = 'P180205154824792' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '158781' WHERE ordernumber = 'P190205155057942' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '327716' WHERE ordernumber = 'P420205155437862' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '327716' WHERE ordernumber = 'P420205155513628' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '159648' WHERE ordernumber = 'P200205155624897' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '109535' WHERE ordernumber = 'P190205155731306' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375917' WHERE ordernumber = 'P180205155805445' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375917' WHERE ordernumber = 'P180205155845241' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '244056' WHERE ordernumber = 'P190205155853852' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375919' WHERE ordernumber = 'P190205160010445' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375931' WHERE ordernumber = 'P180205160027994' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '280856' WHERE ordernumber = 'P200205160247230' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375918' WHERE ordernumber = 'P190205160303309' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375932' WHERE ordernumber = 'P420205160433855' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '228553' WHERE ordernumber = 'P190205160539337' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375916' WHERE ordernumber = 'P180205160542259' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '356000' WHERE ordernumber = 'P190205160651443' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '374504' WHERE ordernumber = 'P420205160739975' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '355105' WHERE ordernumber = 'P190205161339741' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '304095' WHERE ordernumber = 'P180205161422445' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '114061' WHERE ordernumber = 'P190205161615501' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375934' WHERE ordernumber = 'P190205161745553' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '373832' WHERE ordernumber = 'P190205161940157' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '279074' WHERE ordernumber = 'P180205162027762' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '282785' WHERE ordernumber = 'P190205162720598' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375936' WHERE ordernumber = 'P180205163246684' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '164535' WHERE ordernumber = 'P200205163347672' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375944' WHERE ordernumber = 'P190205163640403' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '292328' WHERE ordernumber = 'P200205164144256' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '368751' WHERE ordernumber = 'P190205164206848' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '325206' WHERE ordernumber = 'P180205164334791' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '273470' WHERE ordernumber = 'P190205164540320' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '196393' WHERE ordernumber = 'P200205164700412' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '306355' WHERE ordernumber = 'P180205164802426' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375943' WHERE ordernumber = 'P180205165025930' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '234324' WHERE ordernumber = 'P200205165906702' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '99903' WHERE ordernumber = 'P180205170000222' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '330225' WHERE ordernumber = 'P190205170032776' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '345453' WHERE ordernumber = 'P200205170348446' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200205170628396' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '329715' WHERE ordernumber = 'P190205170849490' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '157554' WHERE ordernumber = 'P190205171229370' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375942' WHERE ordernumber = 'P180205171313902' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '297582' WHERE ordernumber = 'P420205171403380' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375941' WHERE ordernumber = 'P180205171417630' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '24223' WHERE ordernumber = 'P180205171652655' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '253962' WHERE ordernumber = 'P190205172039903' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '348793' WHERE ordernumber = 'P190205172139547' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '353385' WHERE ordernumber = 'P190205172403972' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '328200' WHERE ordernumber = 'P190205172434662' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375952' WHERE ordernumber = 'P190205172633639' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '282597' WHERE ordernumber = 'P200205173406173' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '287023' WHERE ordernumber = 'P190205173454698' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '220125' WHERE ordernumber = 'P190205173752809' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '256273' WHERE ordernumber = 'P190205173927741' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375953' WHERE ordernumber = 'P180205174102783' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '317097' WHERE ordernumber = 'P200205174158352' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375929' WHERE ordernumber = 'P180205174226996' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '334518' WHERE ordernumber = 'P200205174257595' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '367555' WHERE ordernumber = 'P180205174425111' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '358450' WHERE ordernumber = 'P180205175106206' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '121542' WHERE ordernumber = 'P200205175342278' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '216886' WHERE ordernumber = 'P420205175441606' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '282963' WHERE ordernumber = 'P180205175955520' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '266261' WHERE ordernumber = 'P200205180043245' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '162746' WHERE ordernumber = 'P180205180123492' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375902' WHERE ordernumber = 'P420205180613834' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '237023' WHERE ordernumber = 'P200205180738301' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '87734' WHERE ordernumber = 'P200205180917336' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '237023' WHERE ordernumber = 'P200205181009598' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '375440' WHERE ordernumber = 'P180205181104588' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '207480' WHERE ordernumber = 'P200205181203782' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '297154' WHERE ordernumber = 'P180205181205145' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '160211' WHERE ordernumber = 'P200205181326758' 2024-02-06 01:00:05 -- UPDATE `omo_order_list` SET userId = '273711' WHERE ordernumber = 'P200205182559235' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '375964' WHERE ordernumber = 'P200205182711952' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '375963' WHERE ordernumber = 'P180205182802387' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '368344' WHERE ordernumber = 'P180205182925767' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '355782' WHERE ordernumber = 'P200205182943492' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '240659' WHERE ordernumber = 'P200205183042167' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '209460' WHERE ordernumber = 'P180205183050246' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '240659' WHERE ordernumber = 'P200205183202368' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '339987' WHERE ordernumber = 'P200205183513133' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '357650' WHERE ordernumber = 'P180205183534294' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '251715' WHERE ordernumber = 'P200205183742801' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '225202' WHERE ordernumber = 'P180205184454707' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '271522' WHERE ordernumber = 'P200205184515406' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '101636' WHERE ordernumber = 'P180205184912965' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '64798' WHERE ordernumber = 'P180205185401212' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '120468' WHERE ordernumber = 'P190205185729632' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '363423' WHERE ordernumber = 'P180205190225643' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '103961' WHERE ordernumber = 'P200205191108655' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '123367' WHERE ordernumber = 'P190205191351843' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '240328' WHERE ordernumber = 'P180205191626123' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '233032' WHERE ordernumber = 'P180205192003919' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '198191' WHERE ordernumber = 'P180205192117667' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '116084' WHERE ordernumber = 'P190205192553398' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '346379' WHERE ordernumber = 'P180205192746851' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '352546' WHERE ordernumber = 'P180205193050720' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '213859' WHERE ordernumber = 'P190205193236235' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '286030' WHERE ordernumber = 'P200205193726878' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '342347' WHERE ordernumber = 'P180205193824244' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '340551' WHERE ordernumber = 'P420205194015537' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '349135' WHERE ordernumber = 'P200205194123121' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '255493' WHERE ordernumber = 'P180205194403642' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '359366' WHERE ordernumber = 'P180205194820898' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '57435' WHERE ordernumber = 'P180205195040513' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '375978' WHERE ordernumber = 'P180205195350860' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '344784' WHERE ordernumber = 'P180205195453937' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '64798' WHERE ordernumber = 'P180205195603256' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '359252' WHERE ordernumber = 'P190205195620143' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '375980' WHERE ordernumber = 'P420205195633293' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '65608' WHERE ordernumber = 'P200205195747677' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '375981' WHERE ordernumber = 'P180205200138142' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '348393' WHERE ordernumber = 'P420205210240675' 2024-02-06 01:00:06 -- UPDATE `omo_order_list` SET userId = '154777' WHERE ordernumber = 'P530205211713818'