2024-01-12 01:00:01 -- 將會員中心id寫入data-lake 2024-01-12 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-01-11%'; 2024-01-12 01:00:01 -- UPDATE `omo_order_list` SET userId = '261941' WHERE ordernumber = 'P190111110112205' 2024-01-12 01:00:01 -- UPDATE `omo_order_list` SET userId = '345490' WHERE ordernumber = 'P200111110217524' 2024-01-12 01:00:01 -- UPDATE `omo_order_list` SET userId = '345490' WHERE ordernumber = 'P200111110314642' 2024-01-12 01:00:01 -- UPDATE `omo_order_list` SET userId = '338277' WHERE ordernumber = 'P180111110333913' 2024-01-12 01:00:01 -- UPDATE `omo_order_list` SET userId = '103993' WHERE ordernumber = 'P200111110706522' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '281355' WHERE ordernumber = 'P190111110715378' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '312498' WHERE ordernumber = 'P180111110840801' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364397' WHERE ordernumber = 'P190111111020858' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364395' WHERE ordernumber = 'P420111111044295' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '220138' WHERE ordernumber = 'P180111111212693' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364398' WHERE ordernumber = 'P420111111218313' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '245055' WHERE ordernumber = 'P200111111317450' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364398' WHERE ordernumber = 'P420111111321507' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '159760' WHERE ordernumber = 'P200111111716194' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364400' WHERE ordernumber = 'P190111111755578' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364402' WHERE ordernumber = 'P200111112316525' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364404' WHERE ordernumber = 'P180111112425503' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '266932' WHERE ordernumber = 'P190111112453137' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364406' WHERE ordernumber = 'P180111112547381' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '358327' WHERE ordernumber = 'P180111112700967' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '139462' WHERE ordernumber = 'P200111112713255' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364407' WHERE ordernumber = 'P180111112936754' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364408' WHERE ordernumber = 'P420111113001356' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364409' WHERE ordernumber = 'P180111113144862' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '362258' WHERE ordernumber = 'P200111113228479' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '119536' WHERE ordernumber = 'P190111113232559' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '301857' WHERE ordernumber = 'P200111113410531' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364411' WHERE ordernumber = 'P180111113436461' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364417' WHERE ordernumber = 'P420111113940202' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364418' WHERE ordernumber = 'P200111114000970' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '341291' WHERE ordernumber = 'P420111114056245' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '342689' WHERE ordernumber = 'P190111114357481' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '84659' WHERE ordernumber = 'P190111114531577' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364420' WHERE ordernumber = 'P190111114624833' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364422' WHERE ordernumber = 'P420111114706989' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364423' WHERE ordernumber = 'P190111114944273' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '363947' WHERE ordernumber = 'P200111114952845' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '118593' WHERE ordernumber = 'P190111115155624' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P190111115233974' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '363947' WHERE ordernumber = 'P200111115237119' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364426' WHERE ordernumber = 'P190111115448458' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364427' WHERE ordernumber = 'P420111115608949' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364428' WHERE ordernumber = 'P200111115625140' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '277291' WHERE ordernumber = 'P180111115656222' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364429' WHERE ordernumber = 'P190111115758144' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364430' WHERE ordernumber = 'P420111115911262' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '225010' WHERE ordernumber = 'P200111115924773' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '284276' WHERE ordernumber = 'P200111120003671' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '323526' WHERE ordernumber = 'P190111120148325' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364346' WHERE ordernumber = 'P180111120159313' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364429' WHERE ordernumber = 'P180111120330752' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364436' WHERE ordernumber = 'P420111120626393' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364437' WHERE ordernumber = 'P200111120654231' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200111120822632' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364438' WHERE ordernumber = 'P190111121232927' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '99926' WHERE ordernumber = 'P180111121408144' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200111121448738' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '118642' WHERE ordernumber = 'P190111121523617' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '344253' WHERE ordernumber = 'P180111121524560' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364443' WHERE ordernumber = 'P180111121742994' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364444' WHERE ordernumber = 'P420111121837332' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '351726' WHERE ordernumber = 'P200111121941467' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '357748' WHERE ordernumber = 'P190111122038944' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '354128' WHERE ordernumber = 'P190111122131416' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '233276' WHERE ordernumber = 'P200111122322720' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '357748' WHERE ordernumber = 'P190111122453265' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '253062' WHERE ordernumber = 'P190111122724422' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '236243' WHERE ordernumber = 'P200111122927425' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364448' WHERE ordernumber = 'P420111123106736' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364450' WHERE ordernumber = 'P420111123320999' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '363941' WHERE ordernumber = 'P200111123400486' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364452' WHERE ordernumber = 'P190111123431839' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '246322' WHERE ordernumber = 'P200111123440626' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '126571' WHERE ordernumber = 'P420111123448743' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364454' WHERE ordernumber = 'P420111123727224' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '159216' WHERE ordernumber = 'P190111123738196' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '246322' WHERE ordernumber = 'P200111123852863' 2024-01-12 01:00:02 -- UPDATE `omo_order_list` SET userId = '364456' WHERE ordernumber = 'P420111123932595' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364458' WHERE ordernumber = 'P420111124025871' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364459' WHERE ordernumber = 'P420111124122774' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '246060' WHERE ordernumber = 'P180111124225274' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364460' WHERE ordernumber = 'P420111124243980' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '270895' WHERE ordernumber = 'P200111124312166' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '94226' WHERE ordernumber = 'P200111124425981' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '363995' WHERE ordernumber = 'P200111124602119' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '102473' WHERE ordernumber = 'P180111124649588' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '356316' WHERE ordernumber = 'P200111125245569' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '220826' WHERE ordernumber = 'P420111125451444' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '41896' WHERE ordernumber = 'P180111125503817' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '237378' WHERE ordernumber = 'P190111125810404' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '57803' WHERE ordernumber = 'P420111125829179' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364466' WHERE ordernumber = 'P180111125840930' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '161585' WHERE ordernumber = 'P190111125915214' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '250715' WHERE ordernumber = 'P200111125952354' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '315249' WHERE ordernumber = 'P180111130052811' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '283039' WHERE ordernumber = 'P190111130055394' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364468' WHERE ordernumber = 'P420111130151872' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '212504' WHERE ordernumber = 'P190111130232513' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '291969' WHERE ordernumber = 'P180111130241334' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364470' WHERE ordernumber = 'P420111130531523' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '306439' WHERE ordernumber = 'P200111130659829' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '294892' WHERE ordernumber = 'P420111131240295' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '142353' WHERE ordernumber = 'P420111131338387' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364475' WHERE ordernumber = 'P420111131510239' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '217717' WHERE ordernumber = 'P420111131731159' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364480' WHERE ordernumber = 'P200111132052411' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '348919' WHERE ordernumber = 'P420111132425133' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364485' WHERE ordernumber = 'P420111132621717' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364487' WHERE ordernumber = 'P200111132647817' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364490' WHERE ordernumber = 'P180111133105758' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '94455' WHERE ordernumber = 'P180111133347206' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364491' WHERE ordernumber = 'P180111133549496' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364494' WHERE ordernumber = 'P420111133814967' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '232816' WHERE ordernumber = 'P200111133918306' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '284789' WHERE ordernumber = 'P420111134045494' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '338262' WHERE ordernumber = 'P200111134157956' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364496' WHERE ordernumber = 'P420111134234165' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364495' WHERE ordernumber = 'P180111134235225' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364497' WHERE ordernumber = 'P180111134436365' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '338262' WHERE ordernumber = 'P200111134602118' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '346084' WHERE ordernumber = 'P180111134817530' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364498' WHERE ordernumber = 'P180111135032458' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364500' WHERE ordernumber = 'P420111135205990' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364502' WHERE ordernumber = 'P200111135250170' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '1540' WHERE ordernumber = 'P180111135435999' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364503' WHERE ordernumber = 'P420111135453633' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '356006' WHERE ordernumber = 'P180111135531240' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '350556' WHERE ordernumber = 'P420111135631838' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '99796' WHERE ordernumber = 'P200111135709757' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364507' WHERE ordernumber = 'P420111135751558' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '134258' WHERE ordernumber = 'P180111135842198' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364508' WHERE ordernumber = 'P200111135851116' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '312129' WHERE ordernumber = 'P420111135944588' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364511' WHERE ordernumber = 'P180111140130996' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364503' WHERE ordernumber = 'P420111140136983' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '357638' WHERE ordernumber = 'P180111140416266' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '269605' WHERE ordernumber = 'P420111140416594' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '357638' WHERE ordernumber = 'P180111140513959' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '352420' WHERE ordernumber = 'P190111140812901' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '357638' WHERE ordernumber = 'P180111140840554' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P190111141200332' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364516' WHERE ordernumber = 'P200111141253618' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '162980' WHERE ordernumber = 'P200111141645942' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364518' WHERE ordernumber = 'P200111141656224' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '213313' WHERE ordernumber = 'P180111141816681' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '120871' WHERE ordernumber = 'P180111142116811' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364527' WHERE ordernumber = 'P200111142354592' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364529' WHERE ordernumber = 'P190111142438577' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364530' WHERE ordernumber = 'P180111142521699' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '77985' WHERE ordernumber = 'P200111142750718' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364533' WHERE ordernumber = 'P190111142843482' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '161876' WHERE ordernumber = 'P200111142947902' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364534' WHERE ordernumber = 'P190111142953847' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364535' WHERE ordernumber = 'P180111143011277' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '342840' WHERE ordernumber = 'P190111143035796' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '36124' WHERE ordernumber = 'P420111143107574' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364536' WHERE ordernumber = 'P180111143155616' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '288868' WHERE ordernumber = 'P190111143355167' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '182156' WHERE ordernumber = 'P200111143400796' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364538' WHERE ordernumber = 'P420111143406453' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '364539' WHERE ordernumber = 'P420111143505804' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '288868' WHERE ordernumber = 'P190111143516285' 2024-01-12 01:00:03 -- UPDATE `omo_order_list` SET userId = '288868' WHERE ordernumber = 'P180111143605649' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '128240' WHERE ordernumber = 'P180111143800472' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364541' WHERE ordernumber = 'P200111143946364' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '268751' WHERE ordernumber = 'P180111144212698' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '111252' WHERE ordernumber = 'P200111144227238' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364403' WHERE ordernumber = 'P180111144308643' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364546' WHERE ordernumber = 'P420111144542685' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364547' WHERE ordernumber = 'P420111144634423' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '99903' WHERE ordernumber = 'P180111144651423' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364548' WHERE ordernumber = 'P420111144728559' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '116095' WHERE ordernumber = 'P200111144824556' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364551' WHERE ordernumber = 'P200111145044559' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364553' WHERE ordernumber = 'P200111145249587' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '207972' WHERE ordernumber = 'P420111145336257' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364556' WHERE ordernumber = 'P200111145407500' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '310720' WHERE ordernumber = 'P420111145509888' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '325603' WHERE ordernumber = 'P180111145631637' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '102557' WHERE ordernumber = 'P200111145646999' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '131182' WHERE ordernumber = 'P200111145908480' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364561' WHERE ordernumber = 'P180111150233905' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364564' WHERE ordernumber = 'P180111150631999' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364567' WHERE ordernumber = 'P180111150954777' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '356447' WHERE ordernumber = 'P200111151201771' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364569' WHERE ordernumber = 'P420111151427384' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364571' WHERE ordernumber = 'P200111151705465' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '137006' WHERE ordernumber = 'P420111151956274' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '98528' WHERE ordernumber = 'P180111152059334' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '98528' WHERE ordernumber = 'P180111152615714' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364578' WHERE ordernumber = 'P200111152917724' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364579' WHERE ordernumber = 'P420111153306366' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364580' WHERE ordernumber = 'P180111153323247' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364581' WHERE ordernumber = 'P420111153418409' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364583' WHERE ordernumber = 'P420111153556952' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364584' WHERE ordernumber = 'P180111153702664' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '155013' WHERE ordernumber = 'P420111154135921' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364589' WHERE ordernumber = 'P420111154444145' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364588' WHERE ordernumber = 'P190111154614514' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364591' WHERE ordernumber = 'P420111154635718' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '350776' WHERE ordernumber = 'P420111154729788' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '91679' WHERE ordernumber = 'P200111154905814' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364592' WHERE ordernumber = 'P180111154907933' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '359086' WHERE ordernumber = 'P190111154939847' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '81137' WHERE ordernumber = 'P190111155048149' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364595' WHERE ordernumber = 'P200111155248755' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '352383' WHERE ordernumber = 'P180111155350799' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364596' WHERE ordernumber = 'P200111155505876' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '305448' WHERE ordernumber = 'P180111155850271' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '281598' WHERE ordernumber = 'P200111160140933' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364600' WHERE ordernumber = 'P180111160326330' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364597' WHERE ordernumber = 'P200111160328509' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364597' WHERE ordernumber = 'P200111160330924' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '295570' WHERE ordernumber = 'P200111160436591' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '138935' WHERE ordernumber = 'P200111160548580' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '279885' WHERE ordernumber = 'P200111160631790' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '152095' WHERE ordernumber = 'P180111160636640' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '349761' WHERE ordernumber = 'P200111160739382' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364604' WHERE ordernumber = 'P420111160811708' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364606' WHERE ordernumber = 'P420111160949222' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364605' WHERE ordernumber = 'P200111160952201' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364582' WHERE ordernumber = 'P180111161028357' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364613' WHERE ordernumber = 'P200111161400898' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364614' WHERE ordernumber = 'P200111161445585' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '99780' WHERE ordernumber = 'P180111161620546' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '313957' WHERE ordernumber = 'P200111161642974' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '320337' WHERE ordernumber = 'P180111161712418' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '264540' WHERE ordernumber = 'P180111161848380' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364611' WHERE ordernumber = 'P180111161932959' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '346686' WHERE ordernumber = 'P180111162356449' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364620' WHERE ordernumber = 'P420111162401637' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364624' WHERE ordernumber = 'P180111163221939' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364625' WHERE ordernumber = 'P200111163409822' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364626' WHERE ordernumber = 'P200111163736176' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364628' WHERE ordernumber = 'P420111163754776' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364629' WHERE ordernumber = 'P420111163851873' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '226129' WHERE ordernumber = 'P200111164026644' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '326899' WHERE ordernumber = 'P180111164135416' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364630' WHERE ordernumber = 'P200111164211819' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364631' WHERE ordernumber = 'P420111164241518' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '275250' WHERE ordernumber = 'P200111164259502' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '324718' WHERE ordernumber = 'P190111164427919' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '310310' WHERE ordernumber = 'P200111164602173' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364635' WHERE ordernumber = 'P200111164841544' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364636' WHERE ordernumber = 'P420111165023834' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '354790' WHERE ordernumber = 'P180111165512663' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364638' WHERE ordernumber = 'P200111165520787' 2024-01-12 01:00:04 -- UPDATE `omo_order_list` SET userId = '364639' WHERE ordernumber = 'P180111165633397' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364640' WHERE ordernumber = 'P200111165709474' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '263337' WHERE ordernumber = 'P200111165737330' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '312829' WHERE ordernumber = 'P180111165745456' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '335013' WHERE ordernumber = 'P200111165857683' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '77799' WHERE ordernumber = 'P180111170001295' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '313349' WHERE ordernumber = 'P180111170125764' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '320360' WHERE ordernumber = 'P180111170223328' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '245116' WHERE ordernumber = 'P180111170339475' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364646' WHERE ordernumber = 'P200111170526226' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '229830' WHERE ordernumber = 'P200111170852463' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '272522' WHERE ordernumber = 'P200111171408265' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '104230' WHERE ordernumber = 'P180111171432367' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '170293' WHERE ordernumber = 'P180111171514178' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '245116' WHERE ordernumber = 'P180111171657641' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364653' WHERE ordernumber = 'P420111171834696' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364658' WHERE ordernumber = 'P200111172432529' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '345803' WHERE ordernumber = 'P180111172757745' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364664' WHERE ordernumber = 'P180111173354966' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '135314' WHERE ordernumber = 'P420111173526676' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '351265' WHERE ordernumber = 'P420111173702821' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '168151' WHERE ordernumber = 'P200111173754593' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '345721' WHERE ordernumber = 'P200111173852255' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364669' WHERE ordernumber = 'P420111174149487' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '213201' WHERE ordernumber = 'P180111174343914' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '230288' WHERE ordernumber = 'P200111174607804' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '352678' WHERE ordernumber = 'P180111174643781' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P180111174912403' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P180111175032157' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364673' WHERE ordernumber = 'P420111175306127' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364674' WHERE ordernumber = 'P200111175453466' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '99477' WHERE ordernumber = 'P190111175516966' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '345486' WHERE ordernumber = 'P180111175548834' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '99477' WHERE ordernumber = 'P190111175550628' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '328134' WHERE ordernumber = 'P180111180036825' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '285449' WHERE ordernumber = 'P200111180100658' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '356610' WHERE ordernumber = 'P180111180352628' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '272140' WHERE ordernumber = 'P180111180521871' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '319574' WHERE ordernumber = 'P420111180615602' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364685' WHERE ordernumber = 'P200111180631824' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '117532' WHERE ordernumber = 'P180111180838931' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '318688' WHERE ordernumber = 'P200111180930772' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '139381' WHERE ordernumber = 'P200111180954142' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '358875' WHERE ordernumber = 'P420111181230512' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '284824' WHERE ordernumber = 'P180111181245443' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364693' WHERE ordernumber = 'P200111181434635' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '112568' WHERE ordernumber = 'P180111181724981' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '253624' WHERE ordernumber = 'P200111181957164' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364703' WHERE ordernumber = 'P200111182333892' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364705' WHERE ordernumber = 'P200111182448793' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '284155' WHERE ordernumber = 'P200111182629442' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '202229' WHERE ordernumber = 'P180111182718531' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364709' WHERE ordernumber = 'P190111183004498' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364711' WHERE ordernumber = 'P200111183112268' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364710' WHERE ordernumber = 'P420111183225142' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '265715' WHERE ordernumber = 'P200111183242797' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364712' WHERE ordernumber = 'P180111183500348' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '346532' WHERE ordernumber = 'P180111183755672' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364715' WHERE ordernumber = 'P420111183908369' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '300839' WHERE ordernumber = 'P200111184035295' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '102151' WHERE ordernumber = 'P200111184242728' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '300839' WHERE ordernumber = 'P200111184305838' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364716' WHERE ordernumber = 'P420111184328375' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '362259' WHERE ordernumber = 'P200111184449192' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364719' WHERE ordernumber = 'P180111184730801' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364721' WHERE ordernumber = 'P180111184827961' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364720' WHERE ordernumber = 'P420111184853248' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '279917' WHERE ordernumber = 'P180111185253608' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364723' WHERE ordernumber = 'P180111185738980' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364726' WHERE ordernumber = 'P180111190157900' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '318094' WHERE ordernumber = 'P420111190518815' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '337355' WHERE ordernumber = 'P200111190826847' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '352688' WHERE ordernumber = 'P180111191009740' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364730' WHERE ordernumber = 'P200111191415427' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '67948' WHERE ordernumber = 'P200111191546671' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364734' WHERE ordernumber = 'P200111191637508' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '101791' WHERE ordernumber = 'P200111191909769' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364737' WHERE ordernumber = 'P200111192018546' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '350391' WHERE ordernumber = 'P200111192249737' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364739' WHERE ordernumber = 'P180111192342968' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '74449' WHERE ordernumber = 'P200111192411263' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364741' WHERE ordernumber = 'P190111192612579' 2024-01-12 01:00:05 -- UPDATE `omo_order_list` SET userId = '364742' WHERE ordernumber = 'P420111192632873' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364733' WHERE ordernumber = 'P190111192700601' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364733' WHERE ordernumber = 'P190111192724260' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364743' WHERE ordernumber = 'P190111192821342' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364745' WHERE ordernumber = 'P200111193138247' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364746' WHERE ordernumber = 'P200111193213277' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364747' WHERE ordernumber = 'P420111193231843' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '278251' WHERE ordernumber = 'P200111193353356' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '317194' WHERE ordernumber = 'P190111193558239' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364749' WHERE ordernumber = 'P190111194148687' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '135323' WHERE ordernumber = 'P200111194350787' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '297229' WHERE ordernumber = 'P420111194459180' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364757' WHERE ordernumber = 'P420111194624937' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364752' WHERE ordernumber = 'P190111194625952' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364760' WHERE ordernumber = 'P420111194720410' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364761' WHERE ordernumber = 'P200111194920819' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364759' WHERE ordernumber = 'P190111195021924' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '364762' WHERE ordernumber = 'P200111195125496' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '358909' WHERE ordernumber = 'P200111195245210' 2024-01-12 01:00:06 -- UPDATE `omo_order_list` SET userId = '259884' WHERE ordernumber = 'P200111195756984'