2024-02-02 01:00:01 -- 將會員中心id寫入data-lake 2024-02-02 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-01%'; 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '264365' WHERE ordernumber = 'P200201110140293' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '262406' WHERE ordernumber = 'P190201110327579' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '371414' WHERE ordernumber = 'P200201110435223' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '374676' WHERE ordernumber = 'P190201110518531' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '374546' WHERE ordernumber = 'P180201110617870' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '374675' WHERE ordernumber = 'P190201110721139' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '349552' WHERE ordernumber = 'P420201110857801' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '371414' WHERE ordernumber = 'P200201110901191' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '273385' WHERE ordernumber = 'P180201110907252' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '275684' WHERE ordernumber = 'P420201111100826' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '365488' WHERE ordernumber = 'P190201111158294' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '130301' WHERE ordernumber = 'P180201111220112' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '374693' WHERE ordernumber = 'P180201111357560' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '339179' WHERE ordernumber = 'P420201111453720' 2024-02-02 01:00:01 -- UPDATE `omo_order_list` SET userId = '173014' WHERE ordernumber = 'P190201111517153' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '289783' WHERE ordernumber = 'P200201111529842' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '373872' WHERE ordernumber = 'P180201111554241' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374699' WHERE ordernumber = 'P420201111600235' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374681' WHERE ordernumber = 'P190201111626291' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374681' WHERE ordernumber = 'P190201111708704' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374680' WHERE ordernumber = 'P180201111820727' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374680' WHERE ordernumber = 'P180201111824137' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374692' WHERE ordernumber = 'P190201111840119' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374686' WHERE ordernumber = 'P180201111928475' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374695' WHERE ordernumber = 'P190201112045384' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374682' WHERE ordernumber = 'P180201112157998' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374683' WHERE ordernumber = 'P180201112319149' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374691' WHERE ordernumber = 'P190201112323149' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '289480' WHERE ordernumber = 'P180201112451963' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374711' WHERE ordernumber = 'P420201112535889' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374694' WHERE ordernumber = 'P190201112605745' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '237106' WHERE ordernumber = 'P180201112643809' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '26071' WHERE ordernumber = 'P190201112703712' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '159028' WHERE ordernumber = 'P200201112803991' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '259988' WHERE ordernumber = 'P190201112823240' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '259988' WHERE ordernumber = 'P190201112902116' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374696' WHERE ordernumber = 'P180201112924581' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '347684' WHERE ordernumber = 'P190201113004584' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '259988' WHERE ordernumber = 'P180201113050513' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '136443' WHERE ordernumber = 'P200201113103898' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374708' WHERE ordernumber = 'P190201113130819' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374685' WHERE ordernumber = 'P180201113403845' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '215819' WHERE ordernumber = 'P190201113544739' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '293195' WHERE ordernumber = 'P200201113554636' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '343882' WHERE ordernumber = 'P190201113647435' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '343882' WHERE ordernumber = 'P190201113740901' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '185350' WHERE ordernumber = 'P200201113955471' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374685' WHERE ordernumber = 'P180201114018268' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374697' WHERE ordernumber = 'P180201114123611' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374703' WHERE ordernumber = 'P190201114208732' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '269416' WHERE ordernumber = 'P180201114227936' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '359813' WHERE ordernumber = 'P200201114321251' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374704' WHERE ordernumber = 'P180201114500167' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374706' WHERE ordernumber = 'P180201114545179' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '118873' WHERE ordernumber = 'P190201114609938' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374684' WHERE ordernumber = 'P180201114750456' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374709' WHERE ordernumber = 'P190201114828623' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374687' WHERE ordernumber = 'P180201114928537' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '369295' WHERE ordernumber = 'P200201115103276' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374727' WHERE ordernumber = 'P420201115104940' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374688' WHERE ordernumber = 'P190201115125560' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374726' WHERE ordernumber = 'P420201115211532' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374701' WHERE ordernumber = 'P180201115211829' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374713' WHERE ordernumber = 'P190201115328833' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374729' WHERE ordernumber = 'P420201115411456' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '372953' WHERE ordernumber = 'P190201115517950' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '46468' WHERE ordernumber = 'P420201115522374' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '230671' WHERE ordernumber = 'P190201115621138' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374714' WHERE ordernumber = 'P180201115724994' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374719' WHERE ordernumber = 'P190201115724295' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374716' WHERE ordernumber = 'P190201115813615' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374700' WHERE ordernumber = 'P180201115940120' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374700' WHERE ordernumber = 'P180201120003328' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374732' WHERE ordernumber = 'P420201120136708' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374720' WHERE ordernumber = 'P190201120219429' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374702' WHERE ordernumber = 'P180201120259983' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374733' WHERE ordernumber = 'P420201120310481' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '368627' WHERE ordernumber = 'P420201120408781' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '357870' WHERE ordernumber = 'P420201120445220' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374717' WHERE ordernumber = 'P180201120451684' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '295667' WHERE ordernumber = 'P420201120542351' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '229596' WHERE ordernumber = 'P180201120702733' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '157526' WHERE ordernumber = 'P200201120901584' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '104585' WHERE ordernumber = 'P190201120938813' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '326248' WHERE ordernumber = 'P190201121117469' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '168576' WHERE ordernumber = 'P200201121138955' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374718' WHERE ordernumber = 'P180201121207567' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374718' WHERE ordernumber = 'P180201121211176' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '306937' WHERE ordernumber = 'P190201121245258' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '306957' WHERE ordernumber = 'P190201121444843' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '230172' WHERE ordernumber = 'P190201121554229' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '341396' WHERE ordernumber = 'P180201121631551' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '374724' WHERE ordernumber = 'P190201121707668' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '367366' WHERE ordernumber = 'P180201121952764' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '353719' WHERE ordernumber = 'P190201122049938' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '289794' WHERE ordernumber = 'P200201122113925' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '289794' WHERE ordernumber = 'P200201122206941' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '369123' WHERE ordernumber = 'P190201122240159' 2024-02-02 01:00:02 -- UPDATE `omo_order_list` SET userId = '359102' WHERE ordernumber = 'P200201122333210' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374731' WHERE ordernumber = 'P190201122356568' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '356885' WHERE ordernumber = 'P420201122430363' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '212324' WHERE ordernumber = 'P200201122448855' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374728' WHERE ordernumber = 'P190201122507777' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '18366' WHERE ordernumber = 'P180201122510397' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374722' WHERE ordernumber = 'P180201122858322' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '219481' WHERE ordernumber = 'P190201122924971' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374730' WHERE ordernumber = 'P180201123130192' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374725' WHERE ordernumber = 'P190201123227817' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '64131' WHERE ordernumber = 'P190201123306724' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '257412' WHERE ordernumber = 'P180201123315443' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '86038' WHERE ordernumber = 'P200201123342542' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '251088' WHERE ordernumber = 'P200201123451997' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374734' WHERE ordernumber = 'P180201123455563' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374735' WHERE ordernumber = 'P190201123507743' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '296397' WHERE ordernumber = 'P200201123557254' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '270548' WHERE ordernumber = 'P200201123817807' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374738' WHERE ordernumber = 'P190201124055366' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200201124247415' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '221699' WHERE ordernumber = 'P190201124312146' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374737' WHERE ordernumber = 'P180201124346489' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '221699' WHERE ordernumber = 'P190201124403729' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374741' WHERE ordernumber = 'P180201124610628' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '300866' WHERE ordernumber = 'P200201124621483' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374740' WHERE ordernumber = 'P190201124644624' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '339790' WHERE ordernumber = 'P420201124843537' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '65111' WHERE ordernumber = 'P200201124958375' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '288426' WHERE ordernumber = 'P180201125007232' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374742' WHERE ordernumber = 'P190201125029262' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '372125' WHERE ordernumber = 'P180201125327527' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '371403' WHERE ordernumber = 'P420201125407927' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374743' WHERE ordernumber = 'P180201125606643' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374747' WHERE ordernumber = 'P190201125647327' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374745' WHERE ordernumber = 'P180201125656298' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '371691' WHERE ordernumber = 'P200201125802386' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374750' WHERE ordernumber = 'P190201125827461' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374744' WHERE ordernumber = 'P180201125926176' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '195487' WHERE ordernumber = 'P200201125937754' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '280152' WHERE ordernumber = 'P180201130039777' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374752' WHERE ordernumber = 'P180201130143897' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '358524' WHERE ordernumber = 'P200201130249783' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '339295' WHERE ordernumber = 'P180201130343754' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374749' WHERE ordernumber = 'P190201130354964' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '89926' WHERE ordernumber = 'P180201130444807' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374751' WHERE ordernumber = 'P180201130657115' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '233000' WHERE ordernumber = 'P200201130725172' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '133688' WHERE ordernumber = 'P200201130815335' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '359988' WHERE ordernumber = 'P200201130941707' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374761' WHERE ordernumber = 'P180201131029478' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374753' WHERE ordernumber = 'P190201131200264' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '233596' WHERE ordernumber = 'P200201131235682' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '289464' WHERE ordernumber = 'P200201131320504' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374771' WHERE ordernumber = 'P180201131356779' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '367988' WHERE ordernumber = 'P200201131406795' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '373335' WHERE ordernumber = 'P190201131503663' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374742' WHERE ordernumber = 'P190201131705821' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374763' WHERE ordernumber = 'P180201131712833' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '368841' WHERE ordernumber = 'P200201131721890' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '222004' WHERE ordernumber = 'P200201131826693' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '352667' WHERE ordernumber = 'P180201131909563' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '65401' WHERE ordernumber = 'P200201132056147' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374757' WHERE ordernumber = 'P180201132138357' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374780' WHERE ordernumber = 'P180201132428142' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374769' WHERE ordernumber = 'P190201132616193' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '270528' WHERE ordernumber = 'P200201132802921' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '233060' WHERE ordernumber = 'P200201132857831' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '297500' WHERE ordernumber = 'P420201132912185' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374768' WHERE ordernumber = 'P180201132941964' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '337116' WHERE ordernumber = 'P200201133008980' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '67081' WHERE ordernumber = 'P200201133211431' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374762' WHERE ordernumber = 'P180201133618245' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '161566' WHERE ordernumber = 'P200201133715586' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374770' WHERE ordernumber = 'P180201133737762' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374767' WHERE ordernumber = 'P180201133904365' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '295740' WHERE ordernumber = 'P200201133917976' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '245053' WHERE ordernumber = 'P200201134147768' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374788' WHERE ordernumber = 'P420201134230949' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374765' WHERE ordernumber = 'P180201134243794' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374765' WHERE ordernumber = 'P180201134255274' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374772' WHERE ordernumber = 'P190201134545981' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '97833' WHERE ordernumber = 'P180201134940170' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374797' WHERE ordernumber = 'P420201135040813' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374772' WHERE ordernumber = 'P190201135105786' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '131958' WHERE ordernumber = 'P180201135122221' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '356730' WHERE ordernumber = 'P200201135132910' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374779' WHERE ordernumber = 'P180201135220570' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '268561' WHERE ordernumber = 'P200201135308805' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374776' WHERE ordernumber = 'P180201135326156' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374775' WHERE ordernumber = 'P180201135537399' 2024-02-02 01:00:03 -- UPDATE `omo_order_list` SET userId = '374785' WHERE ordernumber = 'P180201135633964' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '141373' WHERE ordernumber = 'P180201135742708' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '339952' WHERE ordernumber = 'P190201135755434' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '126043' WHERE ordernumber = 'P200201135850223' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '339952' WHERE ordernumber = 'P190201140000322' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '352093' WHERE ordernumber = 'P200201140004472' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '284241' WHERE ordernumber = 'P180201140020444' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '278878' WHERE ordernumber = 'P180201140147402' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '201095' WHERE ordernumber = 'P420201140243588' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '354074' WHERE ordernumber = 'P200201140308482' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '160744' WHERE ordernumber = 'P200201140427909' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374787' WHERE ordernumber = 'P180201140447360' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374789' WHERE ordernumber = 'P190201140534347' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '363631' WHERE ordernumber = 'P200201140801159' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374786' WHERE ordernumber = 'P180201140810466' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '359260' WHERE ordernumber = 'P190201140827139' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374790' WHERE ordernumber = 'P180201141000370' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374793' WHERE ordernumber = 'P190201141020406' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374793' WHERE ordernumber = 'P190201141051376' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374795' WHERE ordernumber = 'P180201141123763' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '304878' WHERE ordernumber = 'P200201141252398' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374791' WHERE ordernumber = 'P180201141349881' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374800' WHERE ordernumber = 'P190201141532910' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374794' WHERE ordernumber = 'P180201141554658' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374796' WHERE ordernumber = 'P190201141707412' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '286248' WHERE ordernumber = 'P180201141823394' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374794' WHERE ordernumber = 'P180201141842731' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374798' WHERE ordernumber = 'P180201142154824' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '213832' WHERE ordernumber = 'P200201142242716' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '213832' WHERE ordernumber = 'P200201142304612' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '154928' WHERE ordernumber = 'P420201142424192' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374806' WHERE ordernumber = 'P200201142435136' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '118908' WHERE ordernumber = 'P190201142831390' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '346710' WHERE ordernumber = 'P180201143058733' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '370717' WHERE ordernumber = 'P190201143256470' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '98582' WHERE ordernumber = 'P200201143441146' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '355766' WHERE ordernumber = 'P200201143526189' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '222061' WHERE ordernumber = 'P190201143549365' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '44823' WHERE ordernumber = 'P420201143602517' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '352098' WHERE ordernumber = 'P190201143632798' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '370459' WHERE ordernumber = 'P200201143703856' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374809' WHERE ordernumber = 'P180201143747937' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '310745' WHERE ordernumber = 'P420201143826533' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '362189' WHERE ordernumber = 'P420201144041608' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374807' WHERE ordernumber = 'P180201144122764' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '233854' WHERE ordernumber = 'P190201144336337' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '364415' WHERE ordernumber = 'P180201144351644' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374582' WHERE ordernumber = 'P420201144653112' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374808' WHERE ordernumber = 'P190201144732431' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '118897' WHERE ordernumber = 'P190201145148376' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '369059' WHERE ordernumber = 'P200201145533680' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '212221' WHERE ordernumber = 'P180201145558819' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '133547' WHERE ordernumber = 'P200201145728539' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '300104' WHERE ordernumber = 'P180201150417572' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '326230' WHERE ordernumber = 'P200201150528984' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374815' WHERE ordernumber = 'P180201150835871' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '330151' WHERE ordernumber = 'P200201150840255' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374813' WHERE ordernumber = 'P190201150846158' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '264110' WHERE ordernumber = 'P200201150926970' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374808' WHERE ordernumber = 'P180201150935801' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '244672' WHERE ordernumber = 'P190201150950259' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '318869' WHERE ordernumber = 'P200201151055198' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '117103' WHERE ordernumber = 'P190201151140151' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '336990' WHERE ordernumber = 'P190201151453337' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '107734' WHERE ordernumber = 'P180201151701673' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '326866' WHERE ordernumber = 'P180201152039889' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '356435' WHERE ordernumber = 'P200201152102438' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '369290' WHERE ordernumber = 'P420201152247606' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '369290' WHERE ordernumber = 'P420201152330765' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '206872' WHERE ordernumber = 'P180201152442710' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '87091' WHERE ordernumber = 'P190201153724557' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '287216' WHERE ordernumber = 'P200201153817769' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '372374' WHERE ordernumber = 'P190201153847964' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374819' WHERE ordernumber = 'P180201154202293' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '243575' WHERE ordernumber = 'P200201154258906' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '255121' WHERE ordernumber = 'P180201154337946' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374630' WHERE ordernumber = 'P420201154443743' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '299626' WHERE ordernumber = 'P200201154521236' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '251791' WHERE ordernumber = 'P420201154639559' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '336352' WHERE ordernumber = 'P420201154755213' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '287285' WHERE ordernumber = 'P200201155155678' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '369358' WHERE ordernumber = 'P420201160410806' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '95730' WHERE ordernumber = 'P200201160718432' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '129983' WHERE ordernumber = 'P190201160815663' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '365213' WHERE ordernumber = 'P420201160816684' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '357564' WHERE ordernumber = 'P190201161210814' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '122364' WHERE ordernumber = 'P190201161243406' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '314307' WHERE ordernumber = 'P200201161446982' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '103210' WHERE ordernumber = 'P180201161558484' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374823' WHERE ordernumber = 'P190201162424833' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '374823' WHERE ordernumber = 'P190201162453876' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '315332' WHERE ordernumber = 'P180201162607724' 2024-02-02 01:00:04 -- UPDATE `omo_order_list` SET userId = '325629' WHERE ordernumber = 'P180201162642945' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '277354' WHERE ordernumber = 'P180201162747579' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '340662' WHERE ordernumber = 'P190201162820909' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '275564' WHERE ordernumber = 'P180201162944316' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374827' WHERE ordernumber = 'P420201163001795' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '354214' WHERE ordernumber = 'P190201163040597' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '85910' WHERE ordernumber = 'P180201163145485' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '371004' WHERE ordernumber = 'P190201163207785' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '308700' WHERE ordernumber = 'P190201163345519' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '372470' WHERE ordernumber = 'P180201163406335' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '234534' WHERE ordernumber = 'P200201163424597' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '313586' WHERE ordernumber = 'P190201163708314' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '215023' WHERE ordernumber = 'P190201163949674' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '261941' WHERE ordernumber = 'P180201164323366' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374829' WHERE ordernumber = 'P190201164624528' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '114299' WHERE ordernumber = 'P180201164755456' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374581' WHERE ordernumber = 'P420201164920552' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '310090' WHERE ordernumber = 'P180201165147340' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '373285' WHERE ordernumber = 'P420201165330745' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '152681' WHERE ordernumber = 'P200201165513858' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374833' WHERE ordernumber = 'P180201165556123' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374834' WHERE ordernumber = 'P180201165643120' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '345368' WHERE ordernumber = 'P200201165812584' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '336720' WHERE ordernumber = 'P180201165914248' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '107912' WHERE ordernumber = 'P190201170027909' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '220701' WHERE ordernumber = 'P190201170317975' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '214860' WHERE ordernumber = 'P200201170505320' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '114299' WHERE ordernumber = 'P180201170705170' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374838' WHERE ordernumber = 'P420201170728851' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '296829' WHERE ordernumber = 'P420201171114424' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '97967' WHERE ordernumber = 'P180201171216165' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '216595' WHERE ordernumber = 'P200201171643383' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374299' WHERE ordernumber = 'P180201171759404' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '367002' WHERE ordernumber = 'P200201172404394' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374840' WHERE ordernumber = 'P420201172417222' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374840' WHERE ordernumber = 'P420201172632990' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '281283' WHERE ordernumber = 'P180201172649987' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '364058' WHERE ordernumber = 'P200201172732403' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374758' WHERE ordernumber = 'P420201172910257' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '364000' WHERE ordernumber = 'P200201173718862' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '94716' WHERE ordernumber = 'P190201173813128' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '367141' WHERE ordernumber = 'P420201173843240' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '363412' WHERE ordernumber = 'P180201174301804' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '134240' WHERE ordernumber = 'P180201174405892' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '348429' WHERE ordernumber = 'P200201175318111' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '165045' WHERE ordernumber = 'P180201175459849' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '85019' WHERE ordernumber = 'P180201180843600' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '138130' WHERE ordernumber = 'P420201181306175' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '142262' WHERE ordernumber = 'P180201182201784' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '351417' WHERE ordernumber = 'P200201182317912' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '142262' WHERE ordernumber = 'P180201182443807' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '114695' WHERE ordernumber = 'P180201183348305' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '286305' WHERE ordernumber = 'P180201183434277' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '256571' WHERE ordernumber = 'P200201183911206' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '335884' WHERE ordernumber = 'P200201185325816' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '364715' WHERE ordernumber = 'P420201185622833' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '4562' WHERE ordernumber = 'P200201185927947' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374856' WHERE ordernumber = 'P420201185929182' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '139299' WHERE ordernumber = 'P200201190301602' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '157217' WHERE ordernumber = 'P200201190422781' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '304565' WHERE ordernumber = 'P200201190524185' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374858' WHERE ordernumber = 'P420201190800928' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '253198' WHERE ordernumber = 'P200201190946620' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '242407' WHERE ordernumber = 'P200201191104318' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '259486' WHERE ordernumber = 'P200201192705134' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374864' WHERE ordernumber = 'P200201193209114' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200201193230888' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374867' WHERE ordernumber = 'P420201194212359' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374868' WHERE ordernumber = 'P420201194439451' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '323792' WHERE ordernumber = 'P420201195149342' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '252809' WHERE ordernumber = 'P190201195558436' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374871' WHERE ordernumber = 'P420201200924966' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357928' WHERE ordernumber = 'P420201201309912' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '373451' WHERE ordernumber = 'P420201203514459' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '357928' WHERE ordernumber = 'P420201203627124' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '252199' WHERE ordernumber = 'P420201204042501' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '374877' WHERE ordernumber = 'P420201205833267' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '371785' WHERE ordernumber = 'P420201210812835' 2024-02-02 01:00:05 -- UPDATE `omo_order_list` SET userId = '318317' WHERE ordernumber = 'P420201211948384'