2024-08-26 01:00:02 -- 將會員中心id寫入data-lake 2024-08-26 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-08-25%'; 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '156399' WHERE ordernumber = 'P200825110249504' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '222226' WHERE ordernumber = 'P420825110344521' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '350377' WHERE ordernumber = 'P200825110346442' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '118273' WHERE ordernumber = 'P180825110406857' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '269604' WHERE ordernumber = 'P200825110423774' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '136223' WHERE ordernumber = 'P200825110449691' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '259519' WHERE ordernumber = 'P180825110629540' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413432' WHERE ordernumber = 'P200825110815336' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413434' WHERE ordernumber = 'P180825110827994' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '68918' WHERE ordernumber = 'P180825111028754' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '294892' WHERE ordernumber = 'P200825111043268' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '412000' WHERE ordernumber = 'P180825111240694' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413436' WHERE ordernumber = 'P420825111518467' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413437' WHERE ordernumber = 'P180825111527480' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413438' WHERE ordernumber = 'P180825111639981' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413439' WHERE ordernumber = 'P420825111822905' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '413440' WHERE ordernumber = 'P180825112017653' 2024-08-26 01:00:02 -- UPDATE `omo_order_list` SET userId = '106026' WHERE ordernumber = 'P180825112417414' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '410124' WHERE ordernumber = 'P200825112516462' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413442' WHERE ordernumber = 'P180825112623984' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413444' WHERE ordernumber = 'P200825112720790' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '412159' WHERE ordernumber = 'P180825112730805' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413445' WHERE ordernumber = 'P180825112905571' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '1785' WHERE ordernumber = 'P180825112936151' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413446' WHERE ordernumber = 'P200825112950153' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413449' WHERE ordernumber = 'P180825113243432' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413455' WHERE ordernumber = 'P180825113939746' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413457' WHERE ordernumber = 'P420825114016403' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413459' WHERE ordernumber = 'P180825114042921' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '402720' WHERE ordernumber = 'P200825114128934' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413460' WHERE ordernumber = 'P180825114244539' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '300259' WHERE ordernumber = 'P180825114359576' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '349741' WHERE ordernumber = 'P420825114409717' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413461' WHERE ordernumber = 'P190825114627838' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413462' WHERE ordernumber = 'P420825114634157' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '357041' WHERE ordernumber = 'P190825114807417' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413466' WHERE ordernumber = 'P180825114849222' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413467' WHERE ordernumber = 'P180825115055918' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '326171' WHERE ordernumber = 'P200825115157593' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '383695' WHERE ordernumber = 'P190825115402828' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '223633' WHERE ordernumber = 'P200825115522645' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413469' WHERE ordernumber = 'P200825115810713' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '399512' WHERE ordernumber = 'P200825115905672' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '280616' WHERE ordernumber = 'P200825115932457' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '29842' WHERE ordernumber = 'P180825120535282' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '399512' WHERE ordernumber = 'P200825120612541' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413474' WHERE ordernumber = 'P420825120852369' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413476' WHERE ordernumber = 'P420825121423235' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '386282' WHERE ordernumber = 'P420825121520363' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413478' WHERE ordernumber = 'P190825121522679' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '379878' WHERE ordernumber = 'P200825121714139' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '246488' WHERE ordernumber = 'P200825121812279' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413482' WHERE ordernumber = 'P190825121840708' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413480' WHERE ordernumber = 'P180825121916633' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '341143' WHERE ordernumber = 'P200825121941404' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '245875' WHERE ordernumber = 'P190825122034382' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '294774' WHERE ordernumber = 'P420825122036654' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '128882' WHERE ordernumber = 'P200825122434134' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '165594' WHERE ordernumber = 'P420825122624564' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '219239' WHERE ordernumber = 'P190825122654332' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413294' WHERE ordernumber = 'P180825122733886' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413484' WHERE ordernumber = 'P420825122737961' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '121164' WHERE ordernumber = 'P190825122818334' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413486' WHERE ordernumber = 'P420825122831222' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '215246' WHERE ordernumber = 'P190825122920348' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '215246' WHERE ordernumber = 'P190825123210282' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413487' WHERE ordernumber = 'P180825123241884' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413490' WHERE ordernumber = 'P180825123414632' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413491' WHERE ordernumber = 'P190825123520649' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '223893' WHERE ordernumber = 'P190825123546181' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413492' WHERE ordernumber = 'P180825123555824' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '327173' WHERE ordernumber = 'P180825123646269' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413493' WHERE ordernumber = 'P420825123733721' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413494' WHERE ordernumber = 'P190825123812697' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '390927' WHERE ordernumber = 'P180825123847177' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413495' WHERE ordernumber = 'P190825123928439' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '282014' WHERE ordernumber = 'P180825124006269' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '359928' WHERE ordernumber = 'P190825124059608' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '153166' WHERE ordernumber = 'P190825124132633' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413496' WHERE ordernumber = 'P180825124303713' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '359928' WHERE ordernumber = 'P180825124720377' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '262125' WHERE ordernumber = 'P180825124830185' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '389128' WHERE ordernumber = 'P180825125039801' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413499' WHERE ordernumber = 'P180825125233183' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413499' WHERE ordernumber = 'P180825125237569' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '185948' WHERE ordernumber = 'P420825130007573' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413506' WHERE ordernumber = 'P180825130316551' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '384547' WHERE ordernumber = 'P180825130709535' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413511' WHERE ordernumber = 'P420825130938570' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '372118' WHERE ordernumber = 'P200825131108606' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413514' WHERE ordernumber = 'P420825131242390' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413516' WHERE ordernumber = 'P420825131515285' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '142209' WHERE ordernumber = 'P200825131538411' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413518' WHERE ordernumber = 'P180825131723323' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413519' WHERE ordernumber = 'P200825131900790' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '360449' WHERE ordernumber = 'P420825132048614' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413520' WHERE ordernumber = 'P200825132223136' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '406034' WHERE ordernumber = 'P190825132516613' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413521' WHERE ordernumber = 'P180825132518403' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '408261' WHERE ordernumber = 'P180825133020159' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413523' WHERE ordernumber = 'P200825133045462' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '284155' WHERE ordernumber = 'P200825133128319' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '114065' WHERE ordernumber = 'P420825133210467' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '387798' WHERE ordernumber = 'P200825133359248' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '81676' WHERE ordernumber = 'P190825133433863' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413526' WHERE ordernumber = 'P190825133535513' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413527' WHERE ordernumber = 'P420825133803700' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413528' WHERE ordernumber = 'P420825133918728' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413530' WHERE ordernumber = 'P420825134027676' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '413533' WHERE ordernumber = 'P180825134231588' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '412194' WHERE ordernumber = 'P420825134243604' 2024-08-26 01:00:03 -- UPDATE `omo_order_list` SET userId = '412702' WHERE ordernumber = 'P180825134426444' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '412194' WHERE ordernumber = 'P420825134502980' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '280100' WHERE ordernumber = 'P180825134546402' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413537' WHERE ordernumber = 'P420825134636754' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '238860' WHERE ordernumber = 'P180825134824273' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '412194' WHERE ordernumber = 'P420825135049331' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413540' WHERE ordernumber = 'P190825135226674' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '387581' WHERE ordernumber = 'P200825140030727' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '367392' WHERE ordernumber = 'P180825140203932' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413544' WHERE ordernumber = 'P190825140812396' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413546' WHERE ordernumber = 'P190825141134610' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '403794' WHERE ordernumber = 'P420825141258763' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413548' WHERE ordernumber = 'P190825141438492' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413549' WHERE ordernumber = 'P180825141451645' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '16934' WHERE ordernumber = 'P180825141948193' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '412032' WHERE ordernumber = 'P180825142310683' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413553' WHERE ordernumber = 'P180825142442533' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413547' WHERE ordernumber = 'P180825142620628' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '399441' WHERE ordernumber = 'P200825142747582' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413546' WHERE ordernumber = 'P190825142825858' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413546' WHERE ordernumber = 'P190825142938637' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413556' WHERE ordernumber = 'P180825143106324' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413558' WHERE ordernumber = 'P630825143135346' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413557' WHERE ordernumber = 'P420825143155881' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413559' WHERE ordernumber = 'P190825143407925' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413551' WHERE ordernumber = 'P180825143616325' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413563' WHERE ordernumber = 'P190825143646653' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413564' WHERE ordernumber = 'P180825143721281' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '411580' WHERE ordernumber = 'P190825143737684' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '216574' WHERE ordernumber = 'P190825143832141' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413565' WHERE ordernumber = 'P190825144053919' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '153301' WHERE ordernumber = 'P180825144159635' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413566' WHERE ordernumber = 'P180825144358232' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '115196' WHERE ordernumber = 'P190825144420176' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413568' WHERE ordernumber = 'P180825144601982' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '284929' WHERE ordernumber = 'P180825144702554' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413569' WHERE ordernumber = 'P190825144748709' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '324752' WHERE ordernumber = 'P190825145149672' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '324752' WHERE ordernumber = 'P190825145235572' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413572' WHERE ordernumber = 'P190825145424913' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '340126' WHERE ordernumber = 'P180825145423231' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '33159' WHERE ordernumber = 'P180825145736180' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '385657' WHERE ordernumber = 'P180825150023312' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '342635' WHERE ordernumber = 'P420825150205752' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '278230' WHERE ordernumber = 'P590825150208250' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413573' WHERE ordernumber = 'P190825150317326' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413574' WHERE ordernumber = 'P180825150355521' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '408725' WHERE ordernumber = 'P420825150429930' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413575' WHERE ordernumber = 'P190825150459796' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413576' WHERE ordernumber = 'P180825150507546' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '407329' WHERE ordernumber = 'P420825150655175' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413577' WHERE ordernumber = 'P180825150828116' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413578' WHERE ordernumber = 'P420825150844395' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413580' WHERE ordernumber = 'P420825151049536' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '234548' WHERE ordernumber = 'P420825151142616' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413583' WHERE ordernumber = 'P420825151325824' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '371156' WHERE ordernumber = 'P180825151416758' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413584' WHERE ordernumber = 'P420825151436649' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '360167' WHERE ordernumber = 'P420825151641355' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '395703' WHERE ordernumber = 'P180825151812707' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '407329' WHERE ordernumber = 'P420825151827622' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413586' WHERE ordernumber = 'P200825152355940' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413587' WHERE ordernumber = 'P180825152402143' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '406103' WHERE ordernumber = 'P190825152633249' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413592' WHERE ordernumber = 'P180825152714647' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413594' WHERE ordernumber = 'P190825152939192' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413596' WHERE ordernumber = 'P420825153258896' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413597' WHERE ordernumber = 'P180825153521794' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413598' WHERE ordernumber = 'P420825153524778' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413596' WHERE ordernumber = 'P420825153717684' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '368344' WHERE ordernumber = 'P190825153739161' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413600' WHERE ordernumber = 'P180825153852737' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '153765' WHERE ordernumber = 'P180825154130287' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '105075' WHERE ordernumber = 'P200825154133304' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413603' WHERE ordernumber = 'P420825154229567' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413604' WHERE ordernumber = 'P180825154332214' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413606' WHERE ordernumber = 'P200825154557852' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413607' WHERE ordernumber = 'P420825154726444' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413604' WHERE ordernumber = 'P180825154843724' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '267697' WHERE ordernumber = 'P200825155144753' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413611' WHERE ordernumber = 'P180825155159533' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413614' WHERE ordernumber = 'P180825155436849' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413617' WHERE ordernumber = 'P180825155733541' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413619' WHERE ordernumber = 'P180825155911581' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413620' WHERE ordernumber = 'P200825160051116' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413623' WHERE ordernumber = 'P190825160244593' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '360311' WHERE ordernumber = 'P190825160413392' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '356346' WHERE ordernumber = 'P180825160500733' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '356346' WHERE ordernumber = 'P180825160544217' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413627' WHERE ordernumber = 'P180825160730860' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '282810' WHERE ordernumber = 'P200825160859693' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413621' WHERE ordernumber = 'P180825160926633' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '108312' WHERE ordernumber = 'P190825160959980' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '108312' WHERE ordernumber = 'P190825161032667' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413628' WHERE ordernumber = 'P420825161143612' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413629' WHERE ordernumber = 'P180825161219912' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '3093' WHERE ordernumber = 'P420825161304203' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '280479' WHERE ordernumber = 'P200825161419744' 2024-08-26 01:00:04 -- UPDATE `omo_order_list` SET userId = '413631' WHERE ordernumber = 'P180825161511497' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413633' WHERE ordernumber = 'P180825161852255' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413634' WHERE ordernumber = 'P190825161948803' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '95460' WHERE ordernumber = 'P180825162151198' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413635' WHERE ordernumber = 'P190825162225111' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413637' WHERE ordernumber = 'P190825162439792' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413638' WHERE ordernumber = 'P180825162450859' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413640' WHERE ordernumber = 'P420825162633240' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413641' WHERE ordernumber = 'P180825162654532' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '355406' WHERE ordernumber = 'P190825162827449' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413642' WHERE ordernumber = 'P420825163003700' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413643' WHERE ordernumber = 'P180825163018622' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413646' WHERE ordernumber = 'P420825163120645' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '294025' WHERE ordernumber = 'P190825163123919' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413647' WHERE ordernumber = 'P180825163156931' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '244826' WHERE ordernumber = 'P190825163207117' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413648' WHERE ordernumber = 'P200825163306693' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413649' WHERE ordernumber = 'P190825163333507' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '338997' WHERE ordernumber = 'P420825163340394' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '271302' WHERE ordernumber = 'P200825163405904' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413650' WHERE ordernumber = 'P180825163444701' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '95987' WHERE ordernumber = 'P200825163450372' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413652' WHERE ordernumber = 'P200825163542219' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413653' WHERE ordernumber = 'P420825163738879' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '72853' WHERE ordernumber = 'P190825163828317' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '31936' WHERE ordernumber = 'P190825163938544' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413654' WHERE ordernumber = 'P180825163954423' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '305928' WHERE ordernumber = 'P180825164045608' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413656' WHERE ordernumber = 'P420825164047473' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '340778' WHERE ordernumber = 'P180825164126978' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '120506' WHERE ordernumber = 'P420825164129794' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413657' WHERE ordernumber = 'P420825164221683' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413658' WHERE ordernumber = 'P190825164320207' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413659' WHERE ordernumber = 'P420825164443450' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '406476' WHERE ordernumber = 'P180825164452777' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '210763' WHERE ordernumber = 'P190825164631257' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413665' WHERE ordernumber = 'P200825165502192' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413666' WHERE ordernumber = 'P180825165636673' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '412391' WHERE ordernumber = 'P190825165658233' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '412391' WHERE ordernumber = 'P190825165752356' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413651' WHERE ordernumber = 'P180825165814492' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '285232' WHERE ordernumber = 'P190825165850958' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '227967' WHERE ordernumber = 'P180825170142911' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '408033' WHERE ordernumber = 'P180825170430487' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413669' WHERE ordernumber = 'P420825170629121' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '105625' WHERE ordernumber = 'P590825170637429' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '376813' WHERE ordernumber = 'P200825170946317' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '395534' WHERE ordernumber = 'P190825171041137' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '23083' WHERE ordernumber = 'P200825171118652' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413676' WHERE ordernumber = 'P420825171204876' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '142615' WHERE ordernumber = 'P200825171424837' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '105625' WHERE ordernumber = 'P590825171451685' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '296281' WHERE ordernumber = 'P180825171459415' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '308079' WHERE ordernumber = 'P180825171613407' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413678' WHERE ordernumber = 'P190825171636516' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413679' WHERE ordernumber = 'P420825171729787' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '320424' WHERE ordernumber = 'P200825171922364' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '119761' WHERE ordernumber = 'P200825172445330' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413677' WHERE ordernumber = 'P190825172646417' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '344253' WHERE ordernumber = 'P190825172935455' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413687' WHERE ordernumber = 'P420825173131980' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413689' WHERE ordernumber = 'P190825173350623' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '320225' WHERE ordernumber = 'P190825173556565' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413691' WHERE ordernumber = 'P420825173904917' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413692' WHERE ordernumber = 'P180825173931818' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '412987' WHERE ordernumber = 'P200825174039143' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '96510' WHERE ordernumber = 'P180825174212206' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413699' WHERE ordernumber = 'P180825174550171' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413700' WHERE ordernumber = 'P420825174718215' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413701' WHERE ordernumber = 'P200825174934595' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '343671' WHERE ordernumber = 'P420825174939748' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413702' WHERE ordernumber = 'P420825175040984' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413539' WHERE ordernumber = 'P200825175206736' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413704' WHERE ordernumber = 'P180825175352590' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413706' WHERE ordernumber = 'P420825175521343' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '288433' WHERE ordernumber = 'P200825175615887' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '393093' WHERE ordernumber = 'P180825175913192' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413707' WHERE ordernumber = 'P420825180019892' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413709' WHERE ordernumber = 'P420825180247932' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413710' WHERE ordernumber = 'P180825180339193' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '325651' WHERE ordernumber = 'P180825180452120' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413711' WHERE ordernumber = 'P420825180532860' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413713' WHERE ordernumber = 'P420825180835852' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '126674' WHERE ordernumber = 'P200825180836510' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413714' WHERE ordernumber = 'P420825180937673' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '403559' WHERE ordernumber = 'P180825181015722' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413715' WHERE ordernumber = 'P190825181112362' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413717' WHERE ordernumber = 'P200825181354383' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413718' WHERE ordernumber = 'P420825181414249' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '94025' WHERE ordernumber = 'P200825181504816' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413720' WHERE ordernumber = 'P420825181612954' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413721' WHERE ordernumber = 'P420825181822681' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413722' WHERE ordernumber = 'P190825181912393' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413723' WHERE ordernumber = 'P420825182026634' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413725' WHERE ordernumber = 'P190825182147333' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '290096' WHERE ordernumber = 'P420825182344311' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '219477' WHERE ordernumber = 'P190825182551918' 2024-08-26 01:00:05 -- UPDATE `omo_order_list` SET userId = '413726' WHERE ordernumber = 'P200825182643827' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413728' WHERE ordernumber = 'P420825182948471' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '281512' WHERE ordernumber = 'P190825183143824' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413730' WHERE ordernumber = 'P420825183219230' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413724' WHERE ordernumber = 'P180825183237698' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '164814' WHERE ordernumber = 'P180825183327227' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413734' WHERE ordernumber = 'P180825183926776' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413736' WHERE ordernumber = 'P180825184040934' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '383343' WHERE ordernumber = 'P180825184236943' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '410963' WHERE ordernumber = 'P180825184719924' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413739' WHERE ordernumber = 'P420825184846300' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413322' WHERE ordernumber = 'P190825184900383' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413738' WHERE ordernumber = 'P200825184900549' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '411443' WHERE ordernumber = 'P190825185138352' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413741' WHERE ordernumber = 'P200825185157341' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '140218' WHERE ordernumber = 'P200825185418633' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '410963' WHERE ordernumber = 'P190825185520697' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '323002' WHERE ordernumber = 'P630825191125334' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413748' WHERE ordernumber = 'P190825191129517' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413748' WHERE ordernumber = 'P190825191405426' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '280922' WHERE ordernumber = 'P190825192056912' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413753' WHERE ordernumber = 'P190825192326960' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413754' WHERE ordernumber = 'P190825192429112' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413755' WHERE ordernumber = 'P190825192608841' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413756' WHERE ordernumber = 'P190825192834363' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '413624' WHERE ordernumber = 'P190825193210600' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '97764' WHERE ordernumber = 'P190825193646586' 2024-08-26 01:00:06 -- UPDATE `omo_order_list` SET userId = '404296' WHERE ordernumber = 'P630825200728879'