2024-04-04 01:00:02 -- 將會員中心id寫入data-lake 2024-04-04 01:00:02 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-04-03%'; 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '111709' WHERE ordernumber = 'P180403110137387' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '337747' WHERE ordernumber = 'P420403110344773' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '329680' WHERE ordernumber = 'P420403111202827' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '327285' WHERE ordernumber = 'P180403112424807' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '159220' WHERE ordernumber = 'P200403112546273' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '355398' WHERE ordernumber = 'P200403112756684' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384224' WHERE ordernumber = 'P420403113403977' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '331800' WHERE ordernumber = 'P200403113428684' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '360735' WHERE ordernumber = 'P180403113634563' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '93028' WHERE ordernumber = 'P200403113919356' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '140849' WHERE ordernumber = 'P190403114835457' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384227' WHERE ordernumber = 'P200403115217521' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '348860' WHERE ordernumber = 'P200403120136204' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '305084' WHERE ordernumber = 'P420403120845866' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384229' WHERE ordernumber = 'P420403121158489' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384184' WHERE ordernumber = 'P180403121215942' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384230' WHERE ordernumber = 'P420403121326601' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384231' WHERE ordernumber = 'P200403121442125' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '255812' WHERE ordernumber = 'P180403121653610' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384232' WHERE ordernumber = 'P420403121744977' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '365462' WHERE ordernumber = 'P200403122536177' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '380329' WHERE ordernumber = 'P180403123000433' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384233' WHERE ordernumber = 'P630403123111370' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '377884' WHERE ordernumber = 'P180403123114387' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '350153' WHERE ordernumber = 'P200403123323437' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384234' WHERE ordernumber = 'P420403123529855' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '382078' WHERE ordernumber = 'P420403123606757' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '152496' WHERE ordernumber = 'P200403123703136' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '339542' WHERE ordernumber = 'P420403125120998' 2024-04-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '99620' WHERE ordernumber = 'P180403125533558' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384235' WHERE ordernumber = 'P190403130438707' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '97773' WHERE ordernumber = 'P200403130524886' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '339683' WHERE ordernumber = 'P420403130801693' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '383688' WHERE ordernumber = 'P180403131510155' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384238' WHERE ordernumber = 'P180403131621817' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '327300' WHERE ordernumber = 'P200403131809682' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384239' WHERE ordernumber = 'P630403132545793' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384240' WHERE ordernumber = 'P180403132616723' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '356808' WHERE ordernumber = 'P180403133106897' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384243' WHERE ordernumber = 'P420403133948195' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '285705' WHERE ordernumber = 'P200403134937870' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '382088' WHERE ordernumber = 'P180403135351630' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '235879' WHERE ordernumber = 'P180403135859577' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '346862' WHERE ordernumber = 'P200403140309319' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '283536' WHERE ordernumber = 'P200403140438381' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '303390' WHERE ordernumber = 'P180403141026226' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '376378' WHERE ordernumber = 'P180403141344791' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384092' WHERE ordernumber = 'P180403141505416' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '82089' WHERE ordernumber = 'P180403141645665' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '335718' WHERE ordernumber = 'P630403142112791' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '285580' WHERE ordernumber = 'P190403142158496' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '314080' WHERE ordernumber = 'P190403142413640' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384245' WHERE ordernumber = 'P200403143258256' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384245' WHERE ordernumber = 'P200403143347715' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '234552' WHERE ordernumber = 'P200403143605865' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384246' WHERE ordernumber = 'P190403144617961' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '242525' WHERE ordernumber = 'P190403144817689' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '332912' WHERE ordernumber = 'P190403145410670' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '227698' WHERE ordernumber = 'P190403145642644' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '349380' WHERE ordernumber = 'P190403145716753' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '289652' WHERE ordernumber = 'P190403145803750' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384248' WHERE ordernumber = 'P420403150217562' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '258918' WHERE ordernumber = 'P190403150936167' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '377492' WHERE ordernumber = 'P190403151220142' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '368615' WHERE ordernumber = 'P190403151518521' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '323130' WHERE ordernumber = 'P190403151851126' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '73683' WHERE ordernumber = 'P190403152129745' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384250' WHERE ordernumber = 'P190403152408786' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '117743' WHERE ordernumber = 'P190403153010680' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '109585' WHERE ordernumber = 'P190403153216838' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '382540' WHERE ordernumber = 'P190403153259197' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '295546' WHERE ordernumber = 'P200403153313175' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '237035' WHERE ordernumber = 'P200403153428399' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384251' WHERE ordernumber = 'P190403154230418' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '383540' WHERE ordernumber = 'P190403154320912' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '26' WHERE ordernumber = 'P420403154523989' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '380414' WHERE ordernumber = 'P630403154702384' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '369981' WHERE ordernumber = 'P420403154844878' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384254' WHERE ordernumber = 'P190403155222954' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '316629' WHERE ordernumber = 'P190403155322788' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '133056' WHERE ordernumber = 'P200403155433480' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '382466' WHERE ordernumber = 'P420403155438123' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '297594' WHERE ordernumber = 'P180403155614594' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '170857' WHERE ordernumber = 'P190403155635345' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384255' WHERE ordernumber = 'P420403155936115' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '383647' WHERE ordernumber = 'P200403160414251' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '379420' WHERE ordernumber = 'P200403160658369' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384256' WHERE ordernumber = 'P190403160717646' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384257' WHERE ordernumber = 'P190403161259235' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '281971' WHERE ordernumber = 'P190403161539865' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '221394' WHERE ordernumber = 'P200403161923335' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384259' WHERE ordernumber = 'P420403162609995' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384260' WHERE ordernumber = 'P420403162838773' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384260' WHERE ordernumber = 'P420403162944678' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '111560' WHERE ordernumber = 'P190403163109269' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '142266' WHERE ordernumber = 'P190403163711750' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '221667' WHERE ordernumber = 'P190403163814347' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384261' WHERE ordernumber = 'P420403163828427' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '282554' WHERE ordernumber = 'P190403164052958' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384262' WHERE ordernumber = 'P190403164221735' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '372284' WHERE ordernumber = 'P190403164409707' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '311329' WHERE ordernumber = 'P190403164540248' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '161919' WHERE ordernumber = 'P180403164753607' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384263' WHERE ordernumber = 'P190403165115290' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384258' WHERE ordernumber = 'P190403165322881' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '281459' WHERE ordernumber = 'P190403165422804' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '99455' WHERE ordernumber = 'P180403165559375' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '98919' WHERE ordernumber = 'P190403165941328' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '287854' WHERE ordernumber = 'P630403170629377' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '381857' WHERE ordernumber = 'P180403170841415' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '152024' WHERE ordernumber = 'P420403171033233' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '294872' WHERE ordernumber = 'P180403171115542' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '379965' WHERE ordernumber = 'P200403171302223' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '358902' WHERE ordernumber = 'P190403171547625' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '97587' WHERE ordernumber = 'P420403171605154' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '237023' WHERE ordernumber = 'P200403171750492' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384264' WHERE ordernumber = 'P420403171931577' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384265' WHERE ordernumber = 'P190403172714368' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '344253' WHERE ordernumber = 'P190403173009575' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '116724' WHERE ordernumber = 'P190403173324153' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384266' WHERE ordernumber = 'P190403174022378' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384268' WHERE ordernumber = 'P190403174923606' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384267' WHERE ordernumber = 'P420403174931356' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '356437' WHERE ordernumber = 'P630403175455460' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '216382' WHERE ordernumber = 'P180403175812298' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384270' WHERE ordernumber = 'P200403180403747' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384271' WHERE ordernumber = 'P630403180534367' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384272' WHERE ordernumber = 'P630403180935967' 2024-04-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '384274' WHERE ordernumber = 'P200403181249936' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '105101' WHERE ordernumber = 'P180403181309932' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384275' WHERE ordernumber = 'P630403181347446' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384276' WHERE ordernumber = 'P420403181737984' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '27925' WHERE ordernumber = 'P190403182035192' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '303228' WHERE ordernumber = 'P180403182105343' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '245377' WHERE ordernumber = 'P200403182126872' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '239505' WHERE ordernumber = 'P190403182220977' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384277' WHERE ordernumber = 'P630403182456115' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384278' WHERE ordernumber = 'P190403182511359' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384279' WHERE ordernumber = 'P190403182649468' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '304297' WHERE ordernumber = 'P200403182721875' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384281' WHERE ordernumber = 'P590403182832566' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '382920' WHERE ordernumber = 'P190403182842618' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384280' WHERE ordernumber = 'P200403182847791' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '382014' WHERE ordernumber = 'P190403182948276' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '382690' WHERE ordernumber = 'P200403183044120' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384282' WHERE ordernumber = 'P190403183215601' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '98721' WHERE ordernumber = 'P190403183334337' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '339433' WHERE ordernumber = 'P200403183721769' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '288664' WHERE ordernumber = 'P190403183724746' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '247871' WHERE ordernumber = 'P190403183926854' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '329931' WHERE ordernumber = 'P200403184247152' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384284' WHERE ordernumber = 'P630403184349483' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384286' WHERE ordernumber = 'P190403184611497' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384287' WHERE ordernumber = 'P190403184739840' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384288' WHERE ordernumber = 'P190403184928388' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '100581' WHERE ordernumber = 'P190403185126413' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384289' WHERE ordernumber = 'P200403185237377' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384290' WHERE ordernumber = 'P190403185259376' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '115459' WHERE ordernumber = 'P200403185402196' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '298995' WHERE ordernumber = 'P190403185444881' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384291' WHERE ordernumber = 'P190403185621729' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384293' WHERE ordernumber = 'P200403185627338' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '302554' WHERE ordernumber = 'P190403185811113' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '93821' WHERE ordernumber = 'P190403190049551' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384292' WHERE ordernumber = 'P190403190501547' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384292' WHERE ordernumber = 'P190403190514995' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '207380' WHERE ordernumber = 'P190403190705159' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384294' WHERE ordernumber = 'P200403190721759' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '248048' WHERE ordernumber = 'P190403190808525' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384295' WHERE ordernumber = 'P420403191012879' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '213908' WHERE ordernumber = 'P420403191535357' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384296' WHERE ordernumber = 'P190403191557461' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '381017' WHERE ordernumber = 'P200403192242546' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384298' WHERE ordernumber = 'P630403192420694' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '52469' WHERE ordernumber = 'P420403193829449' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '257342' WHERE ordernumber = 'P200403194045920' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '293371' WHERE ordernumber = 'P630403194358695' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '254549' WHERE ordernumber = 'P190403200017154' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '382338' WHERE ordernumber = 'P630403202935159' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384300' WHERE ordernumber = 'P630403205016429' 2024-04-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '384301' WHERE ordernumber = 'P630403210127772'