2024-02-05 01:00:01 -- 將會員中心id寫入data-lake 2024-02-05 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-02-04%'; 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '25' WHERE ordernumber = 'P190204090559599' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375511' WHERE ordernumber = 'P180204110129999' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375511' WHERE ordernumber = 'P180204110219872' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '251728' WHERE ordernumber = 'P200204110240559' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375523' WHERE ordernumber = 'P190204110245493' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375499' WHERE ordernumber = 'P180204110346248' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '82074' WHERE ordernumber = 'P200204110350299' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375501' WHERE ordernumber = 'P190204110416709' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '155222' WHERE ordernumber = 'P200204110512436' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '100097' WHERE ordernumber = 'P180204110531427' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375500' WHERE ordernumber = 'P190204110642151' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '374888' WHERE ordernumber = 'P180204110703140' 2024-02-05 01:00:01 -- UPDATE `omo_order_list` SET userId = '375373' WHERE ordernumber = 'P190204110858190' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375503' WHERE ordernumber = 'P180204111109450' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '306405' WHERE ordernumber = 'P200204111255803' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '126659' WHERE ordernumber = 'P190204111308224' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375506' WHERE ordernumber = 'P180204111548730' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375506' WHERE ordernumber = 'P180204111709250' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375522' WHERE ordernumber = 'P180204111833449' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375525' WHERE ordernumber = 'P190204111949989' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375342' WHERE ordernumber = 'P190204112110419' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375546' WHERE ordernumber = 'P180204112122775' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375509' WHERE ordernumber = 'P420204112249142' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '321169' WHERE ordernumber = 'P180204112328151' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375528' WHERE ordernumber = 'P190204112345533' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375509' WHERE ordernumber = 'P420204112350988' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375491' WHERE ordernumber = 'P180204112524781' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '258511' WHERE ordernumber = 'P190204112638676' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '227557' WHERE ordernumber = 'P180204112844374' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375531' WHERE ordernumber = 'P190204112917720' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375536' WHERE ordernumber = 'P180204112943182' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375539' WHERE ordernumber = 'P420204113008513' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '232359' WHERE ordernumber = 'P200204113030154' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375539' WHERE ordernumber = 'P420204113039944' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375520' WHERE ordernumber = 'P190204113046543' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '352578' WHERE ordernumber = 'P200204113115742' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '128361' WHERE ordernumber = 'P180204113129219' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375538' WHERE ordernumber = 'P420204113158776' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375529' WHERE ordernumber = 'P190204113336777' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '368960' WHERE ordernumber = 'P190204113616634' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '81106' WHERE ordernumber = 'P180204113809128' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375542' WHERE ordernumber = 'P180204114042228' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '232765' WHERE ordernumber = 'P200204114103198' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '354331' WHERE ordernumber = 'P420204114308530' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375512' WHERE ordernumber = 'P190204114349305' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375517' WHERE ordernumber = 'P190204114501922' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '127019' WHERE ordernumber = 'P180204114528603' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375526' WHERE ordernumber = 'P420204114629158' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375534' WHERE ordernumber = 'P180204114654889' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375515' WHERE ordernumber = 'P190204114704906' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375526' WHERE ordernumber = 'P420204114730975' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '360929' WHERE ordernumber = 'P190204114920765' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375543' WHERE ordernumber = 'P180204114947151' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '278706' WHERE ordernumber = 'P180204115057444' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '360929' WHERE ordernumber = 'P190204115212124' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375540' WHERE ordernumber = 'P180204115235244' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375510' WHERE ordernumber = 'P180204115443137' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '352515' WHERE ordernumber = 'P190204115500243' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375545' WHERE ordernumber = 'P180204115551691' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375524' WHERE ordernumber = 'P190204115559302' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375524' WHERE ordernumber = 'P190204115628203' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375514' WHERE ordernumber = 'P180204115732455' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '97019' WHERE ordernumber = 'P180204115821942' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '210035' WHERE ordernumber = 'P180204115856346' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '359401' WHERE ordernumber = 'P420204115905781' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375518' WHERE ordernumber = 'P180204115945739' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375504' WHERE ordernumber = 'P420204115951576' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375521' WHERE ordernumber = 'P190204120028282' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '262190' WHERE ordernumber = 'P420204120145281' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '225487' WHERE ordernumber = 'P190204120201242' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '135805' WHERE ordernumber = 'P200204120253866' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '208478' WHERE ordernumber = 'P200204120454143' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375537' WHERE ordernumber = 'P190204120610534' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '329441' WHERE ordernumber = 'P420204120719404' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375541' WHERE ordernumber = 'P180204120857235' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '296523' WHERE ordernumber = 'P190204120932785' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375565' WHERE ordernumber = 'P200204121009321' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '236966' WHERE ordernumber = 'P200204121308708' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '226652' WHERE ordernumber = 'P200204121421122' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '160428' WHERE ordernumber = 'P180204121544657' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375032' WHERE ordernumber = 'P190204121732946' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375559' WHERE ordernumber = 'P180204121805833' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '355780' WHERE ordernumber = 'P200204121812111' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375032' WHERE ordernumber = 'P190204121836780' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375032' WHERE ordernumber = 'P190204121911139' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375562' WHERE ordernumber = 'P180204122223690' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '279457' WHERE ordernumber = 'P200204122230973' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375544' WHERE ordernumber = 'P190204122245987' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '234079' WHERE ordernumber = 'P200204122417185' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375552' WHERE ordernumber = 'P180204122511282' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '338194' WHERE ordernumber = 'P190204122629638' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '356219' WHERE ordernumber = 'P200204122718563' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375549' WHERE ordernumber = 'P180204122801463' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '252894' WHERE ordernumber = 'P200204123227658' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375549' WHERE ordernumber = 'P180204123307975' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '252894' WHERE ordernumber = 'P200204123316758' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375554' WHERE ordernumber = 'P180204123419955' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '341262' WHERE ordernumber = 'P200204123451114' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '309836' WHERE ordernumber = 'P200204123714169' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375560' WHERE ordernumber = 'P190204123744271' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '365104' WHERE ordernumber = 'P180204123838979' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '96991' WHERE ordernumber = 'P200204123842669' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '360774' WHERE ordernumber = 'P190204123930709' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375569' WHERE ordernumber = 'P180204124155927' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375566' WHERE ordernumber = 'P190204124238638' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375573' WHERE ordernumber = 'P180204124358647' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '107233' WHERE ordernumber = 'P190204124556386' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '270764' WHERE ordernumber = 'P200204124722166' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '365262' WHERE ordernumber = 'P180204124727684' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '375550' WHERE ordernumber = 'P180204125119722' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '319126' WHERE ordernumber = 'P190204125159690' 2024-02-05 01:00:02 -- UPDATE `omo_order_list` SET userId = '161113' WHERE ordernumber = 'P200204125223313' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375570' WHERE ordernumber = 'P180204125428701' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '343181' WHERE ordernumber = 'P200204125457964' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375576' WHERE ordernumber = 'P190204125458962' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375582' WHERE ordernumber = 'P420204125513656' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '67887' WHERE ordernumber = 'P180204125823690' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '107603' WHERE ordernumber = 'P190204125829546' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '126731' WHERE ordernumber = 'P200204130015290' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375574' WHERE ordernumber = 'P180204130031538' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '313975' WHERE ordernumber = 'P190204130156972' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '321189' WHERE ordernumber = 'P420204130230340' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '164758' WHERE ordernumber = 'P180204130334916' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375585' WHERE ordernumber = 'P180204130422920' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375577' WHERE ordernumber = 'P180204130550573' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '268585' WHERE ordernumber = 'P200204130649818' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375579' WHERE ordernumber = 'P190204130654725' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '305159' WHERE ordernumber = 'P200204131102710' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '264691' WHERE ordernumber = 'P200204131154816' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '124235' WHERE ordernumber = 'P180204131557434' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '341667' WHERE ordernumber = 'P420204131757737' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '361149' WHERE ordernumber = 'P180204131837168' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375598' WHERE ordernumber = 'P420204132044213' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375584' WHERE ordernumber = 'P180204132128446' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '250272' WHERE ordernumber = 'P420204132224172' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375586' WHERE ordernumber = 'P180204132328713' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375430' WHERE ordernumber = 'P200204132513378' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375599' WHERE ordernumber = 'P200204132623535' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '249117' WHERE ordernumber = 'P190204132647353' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '149138' WHERE ordernumber = 'P200204132757572' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '273400' WHERE ordernumber = 'P180204132910953' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375495' WHERE ordernumber = 'P190204132942588' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375600' WHERE ordernumber = 'P420204132946590' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '311867' WHERE ordernumber = 'P200204132953241' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375592' WHERE ordernumber = 'P180204133413978' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '115397' WHERE ordernumber = 'P200204133431911' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '365330' WHERE ordernumber = 'P190204133442154' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '313696' WHERE ordernumber = 'P190204133523815' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '370699' WHERE ordernumber = 'P180204133532779' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '360812' WHERE ordernumber = 'P200204133555433' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '356104' WHERE ordernumber = 'P190204134021179' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375606' WHERE ordernumber = 'P200204134052493' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '366558' WHERE ordernumber = 'P190204134122779' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '164424' WHERE ordernumber = 'P200204134204281' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '146894' WHERE ordernumber = 'P190204134308215' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '279934' WHERE ordernumber = 'P180204134403983' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '229850' WHERE ordernumber = 'P180204134505694' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375594' WHERE ordernumber = 'P190204134538111' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '335311' WHERE ordernumber = 'P180204134722613' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '338679' WHERE ordernumber = 'P200204134843180' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '276908' WHERE ordernumber = 'P200204134921794' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '364970' WHERE ordernumber = 'P190204135454675' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375617' WHERE ordernumber = 'P200204135522508' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375603' WHERE ordernumber = 'P180204135946591' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375612' WHERE ordernumber = 'P190204135948368' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375362' WHERE ordernumber = 'P180204140037647' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375608' WHERE ordernumber = 'P180204140350811' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375607' WHERE ordernumber = 'P180204140555815' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375604' WHERE ordernumber = 'P180204140718799' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375624' WHERE ordernumber = 'P420204140737964' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375601' WHERE ordernumber = 'P190204140937143' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375610' WHERE ordernumber = 'P180204141004651' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '151567' WHERE ordernumber = 'P420204141029260' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '230562' WHERE ordernumber = 'P180204141128992' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '295851' WHERE ordernumber = 'P420204141130355' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375618' WHERE ordernumber = 'P180204141209310' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '361495' WHERE ordernumber = 'P190204141253370' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '306512' WHERE ordernumber = 'P190204141338274' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375614' WHERE ordernumber = 'P180204141354375' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '251748' WHERE ordernumber = 'P190204141433889' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '355532' WHERE ordernumber = 'P190204141541433' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375615' WHERE ordernumber = 'P180204141611804' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375628' WHERE ordernumber = 'P420204141716891' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375629' WHERE ordernumber = 'P180204141815653' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375632' WHERE ordernumber = 'P420204141835934' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375622' WHERE ordernumber = 'P180204142035641' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '372783' WHERE ordernumber = 'P420204142037466' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375620' WHERE ordernumber = 'P190204142138217' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375620' WHERE ordernumber = 'P190204142221265' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '370397' WHERE ordernumber = 'P180204142243510' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '321072' WHERE ordernumber = 'P200204142317820' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '373869' WHERE ordernumber = 'P190204142440383' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '284931' WHERE ordernumber = 'P200204142458665' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '101561' WHERE ordernumber = 'P200204142546381' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '93924' WHERE ordernumber = 'P190204142743981' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '165672' WHERE ordernumber = 'P200204142831207' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375621' WHERE ordernumber = 'P180204142918682' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375637' WHERE ordernumber = 'P190204143042972' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '268628' WHERE ordernumber = 'P200204143153804' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '367633' WHERE ordernumber = 'P420204143229777' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375640' WHERE ordernumber = 'P200204143352260' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375630' WHERE ordernumber = 'P180204143410490' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375633' WHERE ordernumber = 'P180204143501160' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375641' WHERE ordernumber = 'P200204143518449' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '374833' WHERE ordernumber = 'P190204143539601' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375642' WHERE ordernumber = 'P420204143643301' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '44246' WHERE ordernumber = 'P180204143848415' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375631' WHERE ordernumber = 'P190204143848544' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '264684' WHERE ordernumber = 'P190204144224355' 2024-02-05 01:00:03 -- UPDATE `omo_order_list` SET userId = '375645' WHERE ordernumber = 'P420204144230615' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375634' WHERE ordernumber = 'P180204144320305' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375647' WHERE ordernumber = 'P420204144402634' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '369714' WHERE ordernumber = 'P180204144530355' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375649' WHERE ordernumber = 'P420204144549210' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375651' WHERE ordernumber = 'P420204144805751' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375652' WHERE ordernumber = 'P420204145015265' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375639' WHERE ordernumber = 'P180204145143816' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '153389' WHERE ordernumber = 'P200204145145902' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '15565' WHERE ordernumber = 'P420204145418825' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '88654' WHERE ordernumber = 'P190204145433638' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '64136' WHERE ordernumber = 'P200204145437627' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '284870' WHERE ordernumber = 'P420204145516828' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '265626' WHERE ordernumber = 'P190204145558136' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '371663' WHERE ordernumber = 'P420204145606743' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375656' WHERE ordernumber = 'P420204145707408' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '317100' WHERE ordernumber = 'P420204145758722' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '242042' WHERE ordernumber = 'P180204145926608' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375657' WHERE ordernumber = 'P420204145927253' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375659' WHERE ordernumber = 'P420204150023792' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375660' WHERE ordernumber = 'P420204150134386' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375646' WHERE ordernumber = 'P180204150138335' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '10578' WHERE ordernumber = 'P420204150356787' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375662' WHERE ordernumber = 'P420204150506121' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '269396' WHERE ordernumber = 'P420204150601995' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375648' WHERE ordernumber = 'P180204150615632' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375664' WHERE ordernumber = 'P420204150750243' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375644' WHERE ordernumber = 'P180204150800303' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '136927' WHERE ordernumber = 'P420204151042401' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375668' WHERE ordernumber = 'P420204151320948' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '186790' WHERE ordernumber = 'P200204151333571' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375672' WHERE ordernumber = 'P180204151944657' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375675' WHERE ordernumber = 'P420204152524858' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '372932' WHERE ordernumber = 'P200204152650713' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375677' WHERE ordernumber = 'P180204152844491' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '206541' WHERE ordernumber = 'P180204153247675' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '270393' WHERE ordernumber = 'P180204153323248' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '240044' WHERE ordernumber = 'P180204153456851' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375680' WHERE ordernumber = 'P200204153457787' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '123869' WHERE ordernumber = 'P200204154003454' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '358775' WHERE ordernumber = 'P180204154033531' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '236690' WHERE ordernumber = 'P180204154648698' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '155900' WHERE ordernumber = 'P190204154738358' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '324813' WHERE ordernumber = 'P180204154758554' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '367572' WHERE ordernumber = 'P180204155125405' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '345721' WHERE ordernumber = 'P200204155537448' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '292014' WHERE ordernumber = 'P420204155705833' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '129784' WHERE ordernumber = 'P180204155832600' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '368696' WHERE ordernumber = 'P200204160117870' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '321719' WHERE ordernumber = 'P190204161244775' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '98919' WHERE ordernumber = 'P180204161330581' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '268279' WHERE ordernumber = 'P200204161847449' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '309969' WHERE ordernumber = 'P200204162220825' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '195324' WHERE ordernumber = 'P200204162410423' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '163771' WHERE ordernumber = 'P200204162519544' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '344621' WHERE ordernumber = 'P180204163036693' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375696' WHERE ordernumber = 'P420204163051596' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '308520' WHERE ordernumber = 'P200204163249420' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '220311' WHERE ordernumber = 'P190204163616633' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '342558' WHERE ordernumber = 'P180204163822683' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '128240' WHERE ordernumber = 'P180204164327462' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '37371' WHERE ordernumber = 'P200204164345443' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '346612' WHERE ordernumber = 'P180204164439501' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '286390' WHERE ordernumber = 'P200204165006475' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '213908' WHERE ordernumber = 'P200204165055745' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375701' WHERE ordernumber = 'P530204165414692' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '152524' WHERE ordernumber = 'P180204165433206' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375703' WHERE ordernumber = 'P420204165613229' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '243930' WHERE ordernumber = 'P200204165639136' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '240392' WHERE ordernumber = 'P200204165956691' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375704' WHERE ordernumber = 'P420204170013169' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375706' WHERE ordernumber = 'P190204170624524' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '373938' WHERE ordernumber = 'P420204170651470' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '298036' WHERE ordernumber = 'P200204172222875' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375498' WHERE ordernumber = 'P200204173253548' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '113277' WHERE ordernumber = 'P180204173342516' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '230296' WHERE ordernumber = 'P180204173645186' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '361561' WHERE ordernumber = 'P420204173727834' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '316282' WHERE ordernumber = 'P180204173825309' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '327936' WHERE ordernumber = 'P200204174022860' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '354986' WHERE ordernumber = 'P180204174108312' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '354986' WHERE ordernumber = 'P180204174145135' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '268943' WHERE ordernumber = 'P200204174333166' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '290789' WHERE ordernumber = 'P200204174425876' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '296073' WHERE ordernumber = 'P200204174813418' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375718' WHERE ordernumber = 'P420204175423685' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '340830' WHERE ordernumber = 'P190204180155382' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '368932' WHERE ordernumber = 'P200204180452828' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '339000' WHERE ordernumber = 'P180204181417921' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '141196' WHERE ordernumber = 'P200204182307242' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '361089' WHERE ordernumber = 'P180204183459123' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '285780' WHERE ordernumber = 'P180204183725951' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '310777' WHERE ordernumber = 'P200204184206804' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '135519' WHERE ordernumber = 'P180204185137351' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '280630' WHERE ordernumber = 'P180204185237982' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200204185739447' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '98093' WHERE ordernumber = 'P420204185911864' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '375733' WHERE ordernumber = 'P420204190133692' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '339317' WHERE ordernumber = 'P200204190816541' 2024-02-05 01:00:04 -- UPDATE `omo_order_list` SET userId = '353647' WHERE ordernumber = 'P180204191230425' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '375738' WHERE ordernumber = 'P180204192015976' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '239554' WHERE ordernumber = 'P190204192617561' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '239554' WHERE ordernumber = 'P190204192709187' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '279691' WHERE ordernumber = 'P200204192736203' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '119067' WHERE ordernumber = 'P200204192921365' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '310793' WHERE ordernumber = 'P190204194835886' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '342847' WHERE ordernumber = 'P200204195709622' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '256227' WHERE ordernumber = 'P420204201854659' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '90253' WHERE ordernumber = 'P420204205343686' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '318317' WHERE ordernumber = 'P420204210001814' 2024-02-05 01:00:05 -- UPDATE `omo_order_list` SET userId = '368032' WHERE ordernumber = 'P420204211805217'