2024-01-02 01:00:03 -- 將會員中心id寫入data-lake 2024-01-02 01:00:03 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-01-01%'; 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '271536' WHERE ordernumber = 'P180101110204554' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '271536' WHERE ordernumber = 'P180101110241952' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '140776' WHERE ordernumber = 'P190101110249591' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357401' WHERE ordernumber = 'P420101110249638' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357402' WHERE ordernumber = 'P420101110522291' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '328436' WHERE ordernumber = 'P420101110536641' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357403' WHERE ordernumber = 'P180101110548714' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '233617' WHERE ordernumber = 'P190101110703658' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '283083' WHERE ordernumber = 'P200101110809585' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357404' WHERE ordernumber = 'P190101111033544' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '330303' WHERE ordernumber = 'P420101111057336' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357406' WHERE ordernumber = 'P200101111249685' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357407' WHERE ordernumber = 'P180101111403646' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357408' WHERE ordernumber = 'P180101111449323' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357409' WHERE ordernumber = 'P180101111549117' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357412' WHERE ordernumber = 'P180101111838882' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200101112048671' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '114408' WHERE ordernumber = 'P180101112306364' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357415' WHERE ordernumber = 'P420101112738288' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '325175' WHERE ordernumber = 'P200101112837835' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '349727' WHERE ordernumber = 'P180101113022742' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '259769' WHERE ordernumber = 'P200101113036314' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357416' WHERE ordernumber = 'P190101113056838' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357406' WHERE ordernumber = 'P200101113234875' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357417' WHERE ordernumber = 'P180101113307528' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357418' WHERE ordernumber = 'P200101113506575' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357419' WHERE ordernumber = 'P180101113600537' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357420' WHERE ordernumber = 'P200101113613958' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '345470' WHERE ordernumber = 'P420101113631885' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '356885' WHERE ordernumber = 'P420101113744248' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357422' WHERE ordernumber = 'P190101113830519' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357424' WHERE ordernumber = 'P180101114234901' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357424' WHERE ordernumber = 'P180101114431693' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357425' WHERE ordernumber = 'P420101114502784' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '275290' WHERE ordernumber = 'P180101114614165' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '342322' WHERE ordernumber = 'P180101114718923' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357428' WHERE ordernumber = 'P420101114749788' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357423' WHERE ordernumber = 'P190101115002200' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357429' WHERE ordernumber = 'P420101115020557' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357423' WHERE ordernumber = 'P190101115029927' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '209586' WHERE ordernumber = 'P190101115155383' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '350507' WHERE ordernumber = 'P180101115258127' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '225352' WHERE ordernumber = 'P190101115335480' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '305159' WHERE ordernumber = 'P200101115345421' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357430' WHERE ordernumber = 'P420101115503804' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '340806' WHERE ordernumber = 'P190101115523708' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '81433' WHERE ordernumber = 'P200101115938796' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '212612' WHERE ordernumber = 'P180101120000489' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '267896' WHERE ordernumber = 'P200101120154702' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357433' WHERE ordernumber = 'P180101120342858' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357435' WHERE ordernumber = 'P180101120748346' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '355398' WHERE ordernumber = 'P200101120748700' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '84903' WHERE ordernumber = 'P190101120857813' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357437' WHERE ordernumber = 'P180101120916711' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357438' WHERE ordernumber = 'P180101121030222' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357439' WHERE ordernumber = 'P190101121116818' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357440' WHERE ordernumber = 'P420101121321131' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '341315' WHERE ordernumber = 'P420101121423185' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357441' WHERE ordernumber = 'P420101121708831' 2024-01-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '357443' WHERE ordernumber = 'P180101121931143' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357444' WHERE ordernumber = 'P180101122120162' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '355511' WHERE ordernumber = 'P420101122354957' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '88405' WHERE ordernumber = 'P180101122630116' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357448' WHERE ordernumber = 'P180101122935559' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357449' WHERE ordernumber = 'P420101123028932' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '160566' WHERE ordernumber = 'P200101123159289' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357450' WHERE ordernumber = 'P180101123236866' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '127022' WHERE ordernumber = 'P200101123356532' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357450' WHERE ordernumber = 'P180101123433793' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '318103' WHERE ordernumber = 'P420101123516847' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357454' WHERE ordernumber = 'P420101123627167' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '127022' WHERE ordernumber = 'P200101123701151' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357455' WHERE ordernumber = 'P200101123832253' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357457' WHERE ordernumber = 'P420101124004740' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357458' WHERE ordernumber = 'P420101124105792' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '133133' WHERE ordernumber = 'P180101124212314' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357463' WHERE ordernumber = 'P420101124822736' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357465' WHERE ordernumber = 'P180101125422190' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '244313' WHERE ordernumber = 'P190101125741509' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '234882' WHERE ordernumber = 'P200101125847257' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '165317' WHERE ordernumber = 'P200101125935542' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357468' WHERE ordernumber = 'P180101130359294' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '273868' WHERE ordernumber = 'P200101130616660' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357470' WHERE ordernumber = 'P190101130758847' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357471' WHERE ordernumber = 'P180101130901145' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357473' WHERE ordernumber = 'P190101131008401' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357474' WHERE ordernumber = 'P180101131451563' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '356990' WHERE ordernumber = 'P420101131503890' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357475' WHERE ordernumber = 'P180101131547455' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357476' WHERE ordernumber = 'P180101131740742' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '45552' WHERE ordernumber = 'P180101131822574' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357478' WHERE ordernumber = 'P180101131947696' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '264675' WHERE ordernumber = 'P180101132059237' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '290716' WHERE ordernumber = 'P190101132113717' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '219229' WHERE ordernumber = 'P180101132147721' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '238634' WHERE ordernumber = 'P200101132301906' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '350815' WHERE ordernumber = 'P180101132322623' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357480' WHERE ordernumber = 'P420101132740371' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357481' WHERE ordernumber = 'P420101132926133' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357483' WHERE ordernumber = 'P420101133149417' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357484' WHERE ordernumber = 'P180101133231475' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357485' WHERE ordernumber = 'P180101133354546' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '111252' WHERE ordernumber = 'P200101133408272' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357487' WHERE ordernumber = 'P180101133547407' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357488' WHERE ordernumber = 'P180101133658580' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357489' WHERE ordernumber = 'P420101133715628' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '76246' WHERE ordernumber = 'P420101133851860' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357491' WHERE ordernumber = 'P180101134031691' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '262344' WHERE ordernumber = 'P420101134341622' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '221028' WHERE ordernumber = 'P200101134639859' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357492' WHERE ordernumber = 'P420101135031382' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357493' WHERE ordernumber = 'P420101135425992' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357494' WHERE ordernumber = 'P180101135427898' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357495' WHERE ordernumber = 'P420101135545615' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '223124' WHERE ordernumber = 'P180101135643268' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357498' WHERE ordernumber = 'P420101135849205' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '340385' WHERE ordernumber = 'P420101140049417' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357499' WHERE ordernumber = 'P180101140137685' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357500' WHERE ordernumber = 'P200101140152125' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357501' WHERE ordernumber = 'P180101140302290' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '354678' WHERE ordernumber = 'P190101140819738' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '354678' WHERE ordernumber = 'P190101140912311' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '113099' WHERE ordernumber = 'P420101140928731' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357508' WHERE ordernumber = 'P420101141018195' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357509' WHERE ordernumber = 'P420101141320284' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '161876' WHERE ordernumber = 'P200101141334989' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '140655' WHERE ordernumber = 'P420101141701879' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '352098' WHERE ordernumber = 'P180101141800179' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '161876' WHERE ordernumber = 'P200101142014242' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357511' WHERE ordernumber = 'P420101142037925' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '356954' WHERE ordernumber = 'P180101142317468' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357512' WHERE ordernumber = 'P420101142402150' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357513' WHERE ordernumber = 'P420101142454553' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357517' WHERE ordernumber = 'P180101142742766' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '252808' WHERE ordernumber = 'P200101142922677' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '355682' WHERE ordernumber = 'P200101143109416' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '98145' WHERE ordernumber = 'P200101143226469' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '168765' WHERE ordernumber = 'P180101143325931' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357521' WHERE ordernumber = 'P200101143331909' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357523' WHERE ordernumber = 'P420101143627508' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '282036' WHERE ordernumber = 'P200101143759337' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357525' WHERE ordernumber = 'P180101144020113' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '349236' WHERE ordernumber = 'P200101144557168' 2024-01-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357527' WHERE ordernumber = 'P420101144853624' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357528' WHERE ordernumber = 'P420101144951432' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '215035' WHERE ordernumber = 'P180101145108115' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '218140' WHERE ordernumber = 'P180101145200213' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '349236' WHERE ordernumber = 'P200101145240352' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '253335' WHERE ordernumber = 'P180101145328677' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357530' WHERE ordernumber = 'P180101145429519' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357531' WHERE ordernumber = 'P200101145535837' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '346844' WHERE ordernumber = 'P190101145658146' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '352887' WHERE ordernumber = 'P180101145823634' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357535' WHERE ordernumber = 'P190101145854948' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '304578' WHERE ordernumber = 'P420101145902368' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357536' WHERE ordernumber = 'P190101145936173' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '258822' WHERE ordernumber = 'P200101150032289' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357537' WHERE ordernumber = 'P180101150042210' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357539' WHERE ordernumber = 'P420101150205463' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357540' WHERE ordernumber = 'P420101150320861' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357533' WHERE ordernumber = 'P180101150329761' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357538' WHERE ordernumber = 'P180101150417733' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357541' WHERE ordernumber = 'P420101150556319' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357542' WHERE ordernumber = 'P190101150810222' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357543' WHERE ordernumber = 'P180101150946770' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357545' WHERE ordernumber = 'P190101151019722' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357546' WHERE ordernumber = 'P420101151128337' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357547' WHERE ordernumber = 'P190101151207874' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357549' WHERE ordernumber = 'P420101151604334' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357550' WHERE ordernumber = 'P420101151744525' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '93821' WHERE ordernumber = 'P180101151823815' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357551' WHERE ordernumber = 'P420101151858399' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '356589' WHERE ordernumber = 'P200101151957148' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '283571' WHERE ordernumber = 'P200101152126826' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '280508' WHERE ordernumber = 'P200101152237235' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357555' WHERE ordernumber = 'P420101152808640' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357556' WHERE ordernumber = 'P180101152858281' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357524' WHERE ordernumber = 'P190101152955120' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '98145' WHERE ordernumber = 'P200101152959328' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357558' WHERE ordernumber = 'P180101153053267' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357557' WHERE ordernumber = 'P180101153148754' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '350370' WHERE ordernumber = 'P180101153216787' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357559' WHERE ordernumber = 'P420101153303502' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357561' WHERE ordernumber = 'P190101153332894' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '114299' WHERE ordernumber = 'P180101153446755' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357562' WHERE ordernumber = 'P190101153452291' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357563' WHERE ordernumber = 'P420101153531775' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '352675' WHERE ordernumber = 'P180101153535913' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357564' WHERE ordernumber = 'P190101153541999' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '336135' WHERE ordernumber = 'P420101153622678' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '354373' WHERE ordernumber = 'P180101153802893' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357565' WHERE ordernumber = 'P420101153841511' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357567' WHERE ordernumber = 'P420101153951705' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357568' WHERE ordernumber = 'P190101154001461' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357569' WHERE ordernumber = 'P420101154049173' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '97792' WHERE ordernumber = 'P190101154130517' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '294668' WHERE ordernumber = 'P180101154701978' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '133035' WHERE ordernumber = 'P190101154809943' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357571' WHERE ordernumber = 'P420101154857238' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357571' WHERE ordernumber = 'P420101154946800' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357574' WHERE ordernumber = 'P180101155029291' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '350648' WHERE ordernumber = 'P420101155035990' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357575' WHERE ordernumber = 'P190101155139695' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357576' WHERE ordernumber = 'P180101155253557' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357577' WHERE ordernumber = 'P420101155253147' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357579' WHERE ordernumber = 'P180101155449660' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357578' WHERE ordernumber = 'P200101155449657' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '314097' WHERE ordernumber = 'P190101155500845' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357580' WHERE ordernumber = 'P420101155536811' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357582' WHERE ordernumber = 'P420101155634684' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357581' WHERE ordernumber = 'P180101155711153' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357584' WHERE ordernumber = 'P420101155733129' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357583' WHERE ordernumber = 'P180101155759423' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '340332' WHERE ordernumber = 'P420101155813596' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '90101' WHERE ordernumber = 'P200101155826972' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '162148' WHERE ordernumber = 'P180101155853839' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357585' WHERE ordernumber = 'P420101155910759' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '162148' WHERE ordernumber = 'P180101155919569' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357591' WHERE ordernumber = 'P190101160603827' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '314363' WHERE ordernumber = 'P200101160735234' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357592' WHERE ordernumber = 'P200101161227719' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357594' WHERE ordernumber = 'P180101161335576' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '284608' WHERE ordernumber = 'P180101161430402' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '311243' WHERE ordernumber = 'P200101161515147' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357595' WHERE ordernumber = 'P420101161601903' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357598' WHERE ordernumber = 'P180101161750425' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '284608' WHERE ordernumber = 'P180101161856695' 2024-01-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '77723' WHERE ordernumber = 'P420101162129779' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357599' WHERE ordernumber = 'P200101162207784' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '213454' WHERE ordernumber = 'P180101162333657' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357600' WHERE ordernumber = 'P200101162402617' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357602' WHERE ordernumber = 'P180101162441463' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '329304' WHERE ordernumber = 'P180101162709229' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357606' WHERE ordernumber = 'P200101162711950' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '285394' WHERE ordernumber = 'P180101163001170' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '96185' WHERE ordernumber = 'P190101163008804' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357608' WHERE ordernumber = 'P420101163149561' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357609' WHERE ordernumber = 'P180101163214525' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357612' WHERE ordernumber = 'P180101163410215' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357612' WHERE ordernumber = 'P180101163501633' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357613' WHERE ordernumber = 'P190101163547858' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357614' WHERE ordernumber = 'P180101163656752' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357615' WHERE ordernumber = 'P420101163732192' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357616' WHERE ordernumber = 'P420101163933836' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357618' WHERE ordernumber = 'P180101164143630' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357620' WHERE ordernumber = 'P420101164307745' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357622' WHERE ordernumber = 'P420101164503134' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357623' WHERE ordernumber = 'P420101164536306' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '335331' WHERE ordernumber = 'P200101164627372' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357630' WHERE ordernumber = 'P420101165638270' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357631' WHERE ordernumber = 'P180101165650291' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357632' WHERE ordernumber = 'P420101165729968' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '294360' WHERE ordernumber = 'P200101165742701' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357633' WHERE ordernumber = 'P180101165852244' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '305124' WHERE ordernumber = 'P200101165949670' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357634' WHERE ordernumber = 'P200101170239907' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357636' WHERE ordernumber = 'P420101170328413' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '305775' WHERE ordernumber = 'P200101170443772' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357637' WHERE ordernumber = 'P180101170530712' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '257564' WHERE ordernumber = 'P420101170617765' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357640' WHERE ordernumber = 'P180101170949432' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '272140' WHERE ordernumber = 'P180101171218120' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '257564' WHERE ordernumber = 'P420101171317202' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357641' WHERE ordernumber = 'P200101171420260' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357642' WHERE ordernumber = 'P200101171611563' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357643' WHERE ordernumber = 'P420101171715329' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357644' WHERE ordernumber = 'P180101171820862' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357645' WHERE ordernumber = 'P420101171943329' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357646' WHERE ordernumber = 'P420101172037522' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357650' WHERE ordernumber = 'P180101172411937' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '222289' WHERE ordernumber = 'P200101172506155' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357652' WHERE ordernumber = 'P420101172555263' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357654' WHERE ordernumber = 'P200101172650467' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357656' WHERE ordernumber = 'P180101172725380' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357655' WHERE ordernumber = 'P420101172737398' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357657' WHERE ordernumber = 'P200101172827878' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '219323' WHERE ordernumber = 'P180101172906548' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '157035' WHERE ordernumber = 'P200101173102579' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357660' WHERE ordernumber = 'P180101173259181' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '323498' WHERE ordernumber = 'P420101173630243' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357664' WHERE ordernumber = 'P200101173745194' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357663' WHERE ordernumber = 'P200101173859774' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '100681' WHERE ordernumber = 'P200101174228600' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357665' WHERE ordernumber = 'P200101174757921' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357667' WHERE ordernumber = 'P420101175050697' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357669' WHERE ordernumber = 'P420101175209354' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '353122' WHERE ordernumber = 'P200101175213601' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357671' WHERE ordernumber = 'P190101175247179' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357670' WHERE ordernumber = 'P180101175256347' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '130119' WHERE ordernumber = 'P180101175342478' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357671' WHERE ordernumber = 'P190101175355538' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '155221' WHERE ordernumber = 'P420101175406733' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '259448' WHERE ordernumber = 'P200101175418491' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '317026' WHERE ordernumber = 'P200101175712248' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357672' WHERE ordernumber = 'P420101175713129' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357675' WHERE ordernumber = 'P200101180050935' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '271548' WHERE ordernumber = 'P200101180328610' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357680' WHERE ordernumber = 'P420101180446460' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357683' WHERE ordernumber = 'P420101180533772' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357686' WHERE ordernumber = 'P190101180707690' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357689' WHERE ordernumber = 'P200101180845439' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '354926' WHERE ordernumber = 'P200101181132455' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '160024' WHERE ordernumber = 'P200101181416995' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '293690' WHERE ordernumber = 'P190101181420652' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357690' WHERE ordernumber = 'P420101181454541' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '101181' WHERE ordernumber = 'P200101181618165' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357691' WHERE ordernumber = 'P200101181730385' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '356468' WHERE ordernumber = 'P200101182125553' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '356393' WHERE ordernumber = 'P190101182356542' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357698' WHERE ordernumber = 'P420101182420983' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357700' WHERE ordernumber = 'P420101182731819' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357701' WHERE ordernumber = 'P190101183019990' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357702' WHERE ordernumber = 'P420101183106742' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '279678' WHERE ordernumber = 'P180101183118295' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '344328' WHERE ordernumber = 'P190101183907380' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '275421' WHERE ordernumber = 'P190101184616963' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '357705' WHERE ordernumber = 'P420101184618284' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '348545' WHERE ordernumber = 'P420101184917499' 2024-01-02 01:00:06 -- UPDATE `omo_order_list` SET userId = '344671' WHERE ordernumber = 'P190101184944235' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357712' WHERE ordernumber = 'P190101190230324' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357714' WHERE ordernumber = 'P420101190729670' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357713' WHERE ordernumber = 'P420101191028780' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357716' WHERE ordernumber = 'P420101191231637' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '286606' WHERE ordernumber = 'P200101191448525' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '213764' WHERE ordernumber = 'P190101191510869' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P190101191631575' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357719' WHERE ordernumber = 'P190101191927842' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357720' WHERE ordernumber = 'P420101192139352' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357721' WHERE ordernumber = 'P190101192145685' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '219084' WHERE ordernumber = 'P190101192253409' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '213764' WHERE ordernumber = 'P190101192559429' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '355886' WHERE ordernumber = 'P190101193445869' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357726' WHERE ordernumber = 'P200101193518337' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '355886' WHERE ordernumber = 'P190101193524940' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357728' WHERE ordernumber = 'P420101194051989' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '305277' WHERE ordernumber = 'P200101194301202' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357729' WHERE ordernumber = 'P200101195006894' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '238684' WHERE ordernumber = 'P200101195149182' 2024-01-02 01:00:07 -- UPDATE `omo_order_list` SET userId = '357733' WHERE ordernumber = 'P200101195624194'