2024-08-25 01:00:01 -- 將會員中心id寫入data-lake 2024-08-25 01:00:01 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-08-24%'; 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412944' WHERE ordernumber = 'P180824110218258' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '353035' WHERE ordernumber = 'P180824110329699' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '394748' WHERE ordernumber = 'P180824110419288' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '311924' WHERE ordernumber = 'P200824110521358' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412951' WHERE ordernumber = 'P180824110619752' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '355211' WHERE ordernumber = 'P420824110707952' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '346654' WHERE ordernumber = 'P180824110725220' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '203511' WHERE ordernumber = 'P180824110758585' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412953' WHERE ordernumber = 'P180824110905521' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412948' WHERE ordernumber = 'P190824110927326' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412952' WHERE ordernumber = 'P180824111026347' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '325402' WHERE ordernumber = 'P190824111038681' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '328833' WHERE ordernumber = 'P420824111135849' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '107291' WHERE ordernumber = 'P180824111220415' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412954' WHERE ordernumber = 'P190824111229231' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412955' WHERE ordernumber = 'P180824111249864' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412956' WHERE ordernumber = 'P190824111337742' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412957' WHERE ordernumber = 'P180824111416837' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412957' WHERE ordernumber = 'P180824111439708' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '229396' WHERE ordernumber = 'P180824111546308' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '236193' WHERE ordernumber = 'P190824111740993' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '280361' WHERE ordernumber = 'P180824111841271' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412961' WHERE ordernumber = 'P190824112033938' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '111901' WHERE ordernumber = 'P200824112244698' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412962' WHERE ordernumber = 'P420824112302466' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '314292' WHERE ordernumber = 'P190824112348931' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412964' WHERE ordernumber = 'P180824112557204' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412966' WHERE ordernumber = 'P180824113003902' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '225290' WHERE ordernumber = 'P190824113118324' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '388926' WHERE ordernumber = 'P190824113237253' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412967' WHERE ordernumber = 'P180824113314471' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412968' WHERE ordernumber = 'P200824113422976' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '398996' WHERE ordernumber = 'P180824113552480' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '227708' WHERE ordernumber = 'P200824113559304' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412970' WHERE ordernumber = 'P180824113715581' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '97952' WHERE ordernumber = 'P200824113934704' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '233895' WHERE ordernumber = 'P180824114010665' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412965' WHERE ordernumber = 'P180824114333778' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412979' WHERE ordernumber = 'P180824115340271' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '301524' WHERE ordernumber = 'P420824115430337' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412980' WHERE ordernumber = 'P420824115548604' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '94055' WHERE ordernumber = 'P420824115724371' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '98694' WHERE ordernumber = 'P420824115922217' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412982' WHERE ordernumber = 'P420824120016535' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '393950' WHERE ordernumber = 'P420824120103235' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412984' WHERE ordernumber = 'P200824120146337' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412983' WHERE ordernumber = 'P190824120159186' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '309583' WHERE ordernumber = 'P180824120221328' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '285770' WHERE ordernumber = 'P180824120330517' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '123627' WHERE ordernumber = 'P190824120511762' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '279261' WHERE ordernumber = 'P200824120519268' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '123627' WHERE ordernumber = 'P190824120621626' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412986' WHERE ordernumber = 'P180824120653971' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412987' WHERE ordernumber = 'P200824120736746' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412987' WHERE ordernumber = 'P200824121106882' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412990' WHERE ordernumber = 'P190824121148550' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412993' WHERE ordernumber = 'P200824122108696' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '232318' WHERE ordernumber = 'P190824122121167' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412995' WHERE ordernumber = 'P190824122526684' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '387857' WHERE ordernumber = 'P180824122605568' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412997' WHERE ordernumber = 'P180824122750573' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412998' WHERE ordernumber = 'P200824122805447' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '295570' WHERE ordernumber = 'P630824122842650' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412999' WHERE ordernumber = 'P190824122935354' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413000' WHERE ordernumber = 'P180824123036821' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '329715' WHERE ordernumber = 'P180824123302211' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '137176' WHERE ordernumber = 'P630824123317200' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '381802' WHERE ordernumber = 'P420824123622981' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '411183' WHERE ordernumber = 'P180824124246977' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413002' WHERE ordernumber = 'P420824124341419' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '210039' WHERE ordernumber = 'P180824124651627' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413001' WHERE ordernumber = 'P420824124836278' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '412975' WHERE ordernumber = 'P180824124905919' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '54606' WHERE ordernumber = 'P200824124942643' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413007' WHERE ordernumber = 'P420824125237652' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413008' WHERE ordernumber = 'P180824125255116' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '274520' WHERE ordernumber = 'P200824125331984' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413010' WHERE ordernumber = 'P180824125434329' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '94311' WHERE ordernumber = 'P200824125620121' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '375511' WHERE ordernumber = 'P180824125708236' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '385439' WHERE ordernumber = 'P200824125836253' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '413013' WHERE ordernumber = 'P420824130207482' 2024-08-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '406411' WHERE ordernumber = 'P200824130225931' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '287589' WHERE ordernumber = 'P180824130736234' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '389567' WHERE ordernumber = 'P200824131001856' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413016' WHERE ordernumber = 'P420824131056927' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '338215' WHERE ordernumber = 'P180824131101646' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413020' WHERE ordernumber = 'P180824131424730' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '408954' WHERE ordernumber = 'P180824131524539' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '83959' WHERE ordernumber = 'P180824131842268' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413024' WHERE ordernumber = 'P200824132011965' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413026' WHERE ordernumber = 'P180824132600850' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413027' WHERE ordernumber = 'P200824132653307' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413028' WHERE ordernumber = 'P180824132715532' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '244732' WHERE ordernumber = 'P190824132740515' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '292048' WHERE ordernumber = 'P200824132842631' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '411761' WHERE ordernumber = 'P190824133222676' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413031' WHERE ordernumber = 'P180824133249332' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '345359' WHERE ordernumber = 'P200824133302705' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '284722' WHERE ordernumber = 'P420824133340302' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413034' WHERE ordernumber = 'P420824133502407' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413035' WHERE ordernumber = 'P200824133524736' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413037' WHERE ordernumber = 'P200824133803820' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413038' WHERE ordernumber = 'P420824133830205' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '406774' WHERE ordernumber = 'P180824134103903' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413040' WHERE ordernumber = 'P420824134447962' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '408775' WHERE ordernumber = 'P190824134720985' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413043' WHERE ordernumber = 'P180824135128761' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '410400' WHERE ordernumber = 'P420824135230226' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '215628' WHERE ordernumber = 'P200824135548528' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413044' WHERE ordernumber = 'P200824135817935' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '405798' WHERE ordernumber = 'P420824135850313' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413046' WHERE ordernumber = 'P420824140051264' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413047' WHERE ordernumber = 'P180824140126240' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413047' WHERE ordernumber = 'P180824140217428' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413051' WHERE ordernumber = 'P420824140523361' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '289207' WHERE ordernumber = 'P180824140533818' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '397805' WHERE ordernumber = 'P420824140633759' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413052' WHERE ordernumber = 'P200824140654315' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413045' WHERE ordernumber = 'P180824140757437' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413054' WHERE ordernumber = 'P180824141317885' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '361020' WHERE ordernumber = 'P420824141408852' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413057' WHERE ordernumber = 'P180824141526384' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413056' WHERE ordernumber = 'P200824141529818' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '393111' WHERE ordernumber = 'P420824141600233' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '217056' WHERE ordernumber = 'P200824141917293' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413060' WHERE ordernumber = 'P180824142003647' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413060' WHERE ordernumber = 'P180824142028219' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413059' WHERE ordernumber = 'P420824142036120' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413062' WHERE ordernumber = 'P180824142224845' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '323238' WHERE ordernumber = 'P190824142303291' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413066' WHERE ordernumber = 'P180824142834424' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '207130' WHERE ordernumber = 'P180824143002498' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413067' WHERE ordernumber = 'P200824143211815' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413069' WHERE ordernumber = 'P190824143347382' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413070' WHERE ordernumber = 'P200824143506989' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '409767' WHERE ordernumber = 'P180824143521719' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413071' WHERE ordernumber = 'P420824143635208' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '405765' WHERE ordernumber = 'P180824143634728' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413072' WHERE ordernumber = 'P190824143741732' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '401240' WHERE ordernumber = 'P420824143834958' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413073' WHERE ordernumber = 'P180824143858395' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '321680' WHERE ordernumber = 'P190824144036830' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '376279' WHERE ordernumber = 'P190824144141414' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413074' WHERE ordernumber = 'P180824144406360' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413075' WHERE ordernumber = 'P200824144410222' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '302233' WHERE ordernumber = 'P420824144442492' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '100643' WHERE ordernumber = 'P200824144606618' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '247544' WHERE ordernumber = 'P180824144801820' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '250390' WHERE ordernumber = 'P180824144833539' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413078' WHERE ordernumber = 'P200824145035563' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '407249' WHERE ordernumber = 'P180824145105409' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '146908' WHERE ordernumber = 'P180824145247417' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '310303' WHERE ordernumber = 'P190824145437939' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413082' WHERE ordernumber = 'P180824145548286' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '149388' WHERE ordernumber = 'P190824145655318' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413084' WHERE ordernumber = 'P180824145658855' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413085' WHERE ordernumber = 'P420824145748502' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '212791' WHERE ordernumber = 'P180824145750565' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413088' WHERE ordernumber = 'P200824150259519' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413090' WHERE ordernumber = 'P200824150345832' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '412456' WHERE ordernumber = 'P420824150449787' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413092' WHERE ordernumber = 'P200824150512443' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413091' WHERE ordernumber = 'P190824150527824' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '412456' WHERE ordernumber = 'P420824150548123' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '370891' WHERE ordernumber = 'P420824150650967' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '409686' WHERE ordernumber = 'P180824150919731' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '411553' WHERE ordernumber = 'P190824151013324' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413095' WHERE ordernumber = 'P200824151022732' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '364080' WHERE ordernumber = 'P630824151027816' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413096' WHERE ordernumber = 'P180824151039987' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413094' WHERE ordernumber = 'P200824151153216' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '410807' WHERE ordernumber = 'P190824151250992' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413094' WHERE ordernumber = 'P200824151349575' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '128152' WHERE ordernumber = 'P180824151614457' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '128152' WHERE ordernumber = 'P180824151652658' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413102' WHERE ordernumber = 'P200824151738617' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413101' WHERE ordernumber = 'P420824151739709' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '413103' WHERE ordernumber = 'P180824151813576' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '289491' WHERE ordernumber = 'P200824151831317' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '113760' WHERE ordernumber = 'P190824151922458' 2024-08-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '245886' WHERE ordernumber = 'P420824152011287' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413105' WHERE ordernumber = 'P420824152116221' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '207819' WHERE ordernumber = 'P190824152131230' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413103' WHERE ordernumber = 'P180824152154138' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '98814' WHERE ordernumber = 'P200824152226800' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413106' WHERE ordernumber = 'P190824152336479' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '120544' WHERE ordernumber = 'P190824152532196' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413109' WHERE ordernumber = 'P180824152724699' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '207819' WHERE ordernumber = 'P190824152833170' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '294118' WHERE ordernumber = 'P420824152949119' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '385403' WHERE ordernumber = 'P180824153005923' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '31591' WHERE ordernumber = 'P200824153101366' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413111' WHERE ordernumber = 'P180824153114787' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413112' WHERE ordernumber = 'P420824153123390' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '276292' WHERE ordernumber = 'P200824153346439' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413110' WHERE ordernumber = 'P200824153430611' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '54966' WHERE ordernumber = 'P200824153711469' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413115' WHERE ordernumber = 'P200824153903118' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413119' WHERE ordernumber = 'P180824154158374' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '409223' WHERE ordernumber = 'P200824154443134' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '330902' WHERE ordernumber = 'P420824154454679' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '392781' WHERE ordernumber = 'P190824154540792' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413122' WHERE ordernumber = 'P180824154600813' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '146376' WHERE ordernumber = 'P420824154709616' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '267843' WHERE ordernumber = 'P200824154904844' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413127' WHERE ordernumber = 'P420824155151848' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '409966' WHERE ordernumber = 'P180824155157453' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413128' WHERE ordernumber = 'P420824155331960' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413130' WHERE ordernumber = 'P420824155506206' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413131' WHERE ordernumber = 'P200824155628164' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '101902' WHERE ordernumber = 'P190824155935695' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413136' WHERE ordernumber = 'P420824155938230' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '287310' WHERE ordernumber = 'P200824160028241' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '121384' WHERE ordernumber = 'P190824160411933' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413141' WHERE ordernumber = 'P420824160839895' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '107234' WHERE ordernumber = 'P180824161006991' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '102068' WHERE ordernumber = 'P180824161137632' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413142' WHERE ordernumber = 'P420824161226376' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '356322' WHERE ordernumber = 'P180824161329139' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '102960' WHERE ordernumber = 'P200824161353112' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413144' WHERE ordernumber = 'P190824161615797' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '108605' WHERE ordernumber = 'P180824161627800' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413146' WHERE ordernumber = 'P190824161729357' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413148' WHERE ordernumber = 'P180824161906455' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413150' WHERE ordernumber = 'P200824162040823' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413151' WHERE ordernumber = 'P180824162106914' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '411376' WHERE ordernumber = 'P420824162223599' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '410522' WHERE ordernumber = 'P190824162223186' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413152' WHERE ordernumber = 'P180824162301352' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '331708' WHERE ordernumber = 'P200824162356316' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413155' WHERE ordernumber = 'P200824163100558' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '159739' WHERE ordernumber = 'P180824163158525' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '246958' WHERE ordernumber = 'P420824163243928' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413158' WHERE ordernumber = 'P200824163547544' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '242361' WHERE ordernumber = 'P200824163636547' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413161' WHERE ordernumber = 'P180824163753537' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '410027' WHERE ordernumber = 'P200824163922709' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413162' WHERE ordernumber = 'P180824163952551' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413163' WHERE ordernumber = 'P180824164240573' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413164' WHERE ordernumber = 'P420824164310849' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '407338' WHERE ordernumber = 'P180824164327658' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413168' WHERE ordernumber = 'P180824164551370' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413166' WHERE ordernumber = 'P190824164556140' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413167' WHERE ordernumber = 'P420824164618679' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413169' WHERE ordernumber = 'P420824164759908' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '272252' WHERE ordernumber = 'P180824164811883' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '392758' WHERE ordernumber = 'P190824164900675' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413172' WHERE ordernumber = 'P180824164956333' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '296280' WHERE ordernumber = 'P180824165151425' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413176' WHERE ordernumber = 'P180824165621901' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '376378' WHERE ordernumber = 'P190824165839922' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413180' WHERE ordernumber = 'P420824165930818' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '217676' WHERE ordernumber = 'P200824170335619' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '207801' WHERE ordernumber = 'P420824170530239' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '207801' WHERE ordernumber = 'P420824170634273' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413184' WHERE ordernumber = 'P200824170733828' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '411919' WHERE ordernumber = 'P200824170846199' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413187' WHERE ordernumber = 'P420824170857518' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '134565' WHERE ordernumber = 'P200824170936334' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '402561' WHERE ordernumber = 'P420824171031377' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413190' WHERE ordernumber = 'P420824171310335' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '410942' WHERE ordernumber = 'P180824171402298' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '409625' WHERE ordernumber = 'P180824171502893' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413191' WHERE ordernumber = 'P200824171625650' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413192' WHERE ordernumber = 'P420824172219834' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413195' WHERE ordernumber = 'P420824172519811' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413196' WHERE ordernumber = 'P180824172533195' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '95013' WHERE ordernumber = 'P190824172638631' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413199' WHERE ordernumber = 'P420824172935895' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413200' WHERE ordernumber = 'P180824173136953' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413202' WHERE ordernumber = 'P190824173223386' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413206' WHERE ordernumber = 'P180824173434945' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '314077' WHERE ordernumber = 'P420824173511178' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '395136' WHERE ordernumber = 'P190824173515374' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413207' WHERE ordernumber = 'P200824173517963' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '384264' WHERE ordernumber = 'P420824173713912' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413209' WHERE ordernumber = 'P190824174030463' 2024-08-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '413208' WHERE ordernumber = 'P420824174031708' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '407550' WHERE ordernumber = 'P200824174038126' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413211' WHERE ordernumber = 'P180824174136449' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413212' WHERE ordernumber = 'P200824174226827' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413213' WHERE ordernumber = 'P420824174251643' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '403141' WHERE ordernumber = 'P180824174323478' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413217' WHERE ordernumber = 'P200824174834311' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '344645' WHERE ordernumber = 'P180824175241482' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '411095' WHERE ordernumber = 'P190824175251651' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413219' WHERE ordernumber = 'P190824175444773' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413218' WHERE ordernumber = 'P190824175549473' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413221' WHERE ordernumber = 'P190824175638602' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '411369' WHERE ordernumber = 'P190824175815962' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '158915' WHERE ordernumber = 'P180824175903476' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413226' WHERE ordernumber = 'P200824180155467' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413227' WHERE ordernumber = 'P420824180206570' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '289133' WHERE ordernumber = 'P200824180417154' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413228' WHERE ordernumber = 'P180824180648745' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '222161' WHERE ordernumber = 'P200824181203692' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413232' WHERE ordernumber = 'P190824181357363' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413233' WHERE ordernumber = 'P180824181443215' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413230' WHERE ordernumber = 'P200824181551502' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '401948' WHERE ordernumber = 'P200824181630310' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413234' WHERE ordernumber = 'P180824181852956' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '220718' WHERE ordernumber = 'P200824182004343' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413237' WHERE ordernumber = 'P190824182108864' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413236' WHERE ordernumber = 'P420824182108360' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413238' WHERE ordernumber = 'P180824182147648' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '279381' WHERE ordernumber = 'P200824182155234' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '311095' WHERE ordernumber = 'P180824182304797' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413239' WHERE ordernumber = 'P190824182307369' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '382946' WHERE ordernumber = 'P420824182343915' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '276321' WHERE ordernumber = 'P180824182403964' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '230506' WHERE ordernumber = 'P190824182448339' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '396374' WHERE ordernumber = 'P200824182516495' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '396374' WHERE ordernumber = 'P200824182555812' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413242' WHERE ordernumber = 'P190824182602926' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '408115' WHERE ordernumber = 'P420824182849179' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '408115' WHERE ordernumber = 'P420824182935904' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413245' WHERE ordernumber = 'P180824182940221' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '244414' WHERE ordernumber = 'P200824183558864' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '131589' WHERE ordernumber = 'P190824183922352' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '412189' WHERE ordernumber = 'P180824184232876' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '141695' WHERE ordernumber = 'P200824184322402' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '99246' WHERE ordernumber = 'P180824184354755' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '412347' WHERE ordernumber = 'P180824184500995' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '173467' WHERE ordernumber = 'P190824184519627' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413249' WHERE ordernumber = 'P420824184614593' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413251' WHERE ordernumber = 'P180824184820910' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '398370' WHERE ordernumber = 'P420824185612445' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413256' WHERE ordernumber = 'P200824190149999' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '376380' WHERE ordernumber = 'P190824190220967' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413257' WHERE ordernumber = 'P200824190248694' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413257' WHERE ordernumber = 'P200824190451735' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413259' WHERE ordernumber = 'P200824190630863' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413260' WHERE ordernumber = 'P200824190827397' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413262' WHERE ordernumber = 'P190824190936383' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413263' WHERE ordernumber = 'P190824191055926' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413264' WHERE ordernumber = 'P190824191147991' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413265' WHERE ordernumber = 'P190824191240694' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '355158' WHERE ordernumber = 'P190824191331473' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '396832' WHERE ordernumber = 'P190824191428899' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413269' WHERE ordernumber = 'P190824191840886' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413272' WHERE ordernumber = 'P200824192911932' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413273' WHERE ordernumber = 'P190824192938767' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413129' WHERE ordernumber = 'P190824193110436' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413275' WHERE ordernumber = 'P190824193312825' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '321471' WHERE ordernumber = 'P190824193413364' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413277' WHERE ordernumber = 'P190824194429521' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413278' WHERE ordernumber = 'P190824194544380' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '273093' WHERE ordernumber = 'P200824194655872' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '249752' WHERE ordernumber = 'P200824195122790' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413279' WHERE ordernumber = 'P200824195426309' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '380642' WHERE ordernumber = 'P200824195748908' 2024-08-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '413282' WHERE ordernumber = 'P190824195842725'