2025-03-14 01:00:02 -- 將會員中心id寫入data-lake 2025-03-14 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 '2025-03-13%'; 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '287854' WHERE ordernumber = 'P2503130000012' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460758' WHERE ordernumber = 'P2503130000013' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '75232' WHERE ordernumber = 'P2503130000014' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '324254' WHERE ordernumber = 'P2503130000015' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '380735' WHERE ordernumber = 'P2503130000016' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '421932' WHERE ordernumber = 'P2503130000017' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '459199' WHERE ordernumber = 'P2503130000023' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '313055' WHERE ordernumber = 'P2503130000025' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460760' WHERE ordernumber = 'P2503130000026' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '372351' WHERE ordernumber = 'P2503130000028' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '112261' WHERE ordernumber = 'P2503130000031' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '154955' WHERE ordernumber = 'P2503130000033' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460762' WHERE ordernumber = 'P2503130000034' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '112073' WHERE ordernumber = 'P2503130000036' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '229589' WHERE ordernumber = 'P2503130000039' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460763' WHERE ordernumber = 'P2503130000040' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460764' WHERE ordernumber = 'P2503130000042' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460766' WHERE ordernumber = 'P2503130000048' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '266373' WHERE ordernumber = 'P2503130000049' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460767' WHERE ordernumber = 'P2503130000050' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '264519' WHERE ordernumber = 'P2503130000051' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460768' WHERE ordernumber = 'P2503130000054' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '398036' WHERE ordernumber = 'P2503130000055' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460769' WHERE ordernumber = 'P2503130000056' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '212021' WHERE ordernumber = 'P2503130000057' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '206620' WHERE ordernumber = 'P2503130000060' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '239322' WHERE ordernumber = 'P2503130000061' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '372261' WHERE ordernumber = 'P2503130000063' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '244192' WHERE ordernumber = 'P2503130000064' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460771' WHERE ordernumber = 'P2503130000069' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '293407' WHERE ordernumber = 'P2503130000071' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460773' WHERE ordernumber = 'P2503130000072' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460773' WHERE ordernumber = 'P2503130000075' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460773' WHERE ordernumber = 'P2503130000076' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460774' WHERE ordernumber = 'P2503130000078' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '460772' WHERE ordernumber = 'P2503130000080' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '282219' WHERE ordernumber = 'P2503130000081' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '289651' WHERE ordernumber = 'P2503130000085' 2025-03-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '66860' WHERE ordernumber = 'P2503130000086' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '426508' WHERE ordernumber = 'P2503130000087' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '245244' WHERE ordernumber = 'P2503130000088' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '384748' WHERE ordernumber = 'P2503130000095' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460776' WHERE ordernumber = 'P2503130000096' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460778' WHERE ordernumber = 'P2503130000099' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460777' WHERE ordernumber = 'P2503130000100' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '227305' WHERE ordernumber = 'P2503130000102' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460777' WHERE ordernumber = 'P2503130000105' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '412067' WHERE ordernumber = 'P2503130000107' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '251911' WHERE ordernumber = 'P2503130000110' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '423803' WHERE ordernumber = 'P2503130000117' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '134742' WHERE ordernumber = 'P2503130000118' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460779' WHERE ordernumber = 'P2503130000119' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '345997' WHERE ordernumber = 'P2503130000125' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '340551' WHERE ordernumber = 'P2503130000129' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '329435' WHERE ordernumber = 'P2503130000134' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '83448' WHERE ordernumber = 'P2503130000137' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '315067' WHERE ordernumber = 'P2503130000138' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '219359' WHERE ordernumber = 'P2503130000139' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '244646' WHERE ordernumber = 'P2503130000142' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '381374' WHERE ordernumber = 'P2503130000147' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '212049' WHERE ordernumber = 'P2503130000150' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460782' WHERE ordernumber = 'P2503130000151' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460783' WHERE ordernumber = 'P2503130000153' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '421498' WHERE ordernumber = 'P2503130000154' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '441049' WHERE ordernumber = 'P2503130000155' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '103342' WHERE ordernumber = 'P2503130000158' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '390546' WHERE ordernumber = 'P2503130000159' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '379462' WHERE ordernumber = 'P2503130000160' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '94256' WHERE ordernumber = 'P2503130000169' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '25121' WHERE ordernumber = 'P2503130000171' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460785' WHERE ordernumber = 'P2503130000176' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '340773' WHERE ordernumber = 'P2503130000178' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460786' WHERE ordernumber = 'P2503130000180' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '456345' WHERE ordernumber = 'P2503130000181' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460787' WHERE ordernumber = 'P2503130000187' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460788' WHERE ordernumber = 'P2503130000189' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460787' WHERE ordernumber = 'P2503130000190' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460789' WHERE ordernumber = 'P2503130000193' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '160685' WHERE ordernumber = 'P2503130000195' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '121498' WHERE ordernumber = 'P2503130000199' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '415264' WHERE ordernumber = 'P2503130000205' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '337747' WHERE ordernumber = 'P2503130000207' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460792' WHERE ordernumber = 'P2503130000208' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460792' WHERE ordernumber = 'P2503130000209' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '345309' WHERE ordernumber = 'P2503130000211' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '345309' WHERE ordernumber = 'P2503130000215' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '167970' WHERE ordernumber = 'P2503130000219' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '319343' WHERE ordernumber = 'P2503130000220' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '127285' WHERE ordernumber = 'P2503130000227' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460796' WHERE ordernumber = 'P2503130000229' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '402225' WHERE ordernumber = 'P2503130000231' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '289563' WHERE ordernumber = 'P2503130000232' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '231883' WHERE ordernumber = 'P2503130000237' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460797' WHERE ordernumber = 'P2503130000238' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '117187' WHERE ordernumber = 'P2503130000240' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460798' WHERE ordernumber = 'P2503130000241' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '367501' WHERE ordernumber = 'P2503130000242' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460799' WHERE ordernumber = 'P2503130000245' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460800' WHERE ordernumber = 'P2503130000246' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '392970' WHERE ordernumber = 'P2503130000247' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '435396' WHERE ordernumber = 'P2503130000248' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460740' WHERE ordernumber = 'P2503130000250' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460616' WHERE ordernumber = 'P2503130000254' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '433433' WHERE ordernumber = 'P2503130000263' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '246883' WHERE ordernumber = 'P2503130000264' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460802' WHERE ordernumber = 'P2503130000267' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460803' WHERE ordernumber = 'P2503130000269' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460804' WHERE ordernumber = 'P2503130000270' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '291320' WHERE ordernumber = 'P2503130000273' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '339728' WHERE ordernumber = 'P2503130000274' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460805' WHERE ordernumber = 'P2503130000286' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460806' WHERE ordernumber = 'P2503130000288' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '344539' WHERE ordernumber = 'P2503130000292' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460807' WHERE ordernumber = 'P2503130000293' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '344539' WHERE ordernumber = 'P2503130000294' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460809' WHERE ordernumber = 'P2503130000301' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '282965' WHERE ordernumber = 'P2503130000302' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '313833' WHERE ordernumber = 'P2503130000307' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460812' WHERE ordernumber = 'P2503130000312' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '456427' WHERE ordernumber = 'P2503130000321' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '388429' WHERE ordernumber = 'P2503130000324' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '431292' WHERE ordernumber = 'P2503130000329' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460813' WHERE ordernumber = 'P2503130000337' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460815' WHERE ordernumber = 'P2503130000338' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460816' WHERE ordernumber = 'P2503130000340' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '120502' WHERE ordernumber = 'P2503130000346' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460818' WHERE ordernumber = 'P2503130000349' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '457168' WHERE ordernumber = 'P2503130000352' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '111604' WHERE ordernumber = 'P2503130000353' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '430177' WHERE ordernumber = 'P2503130000361' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460820' WHERE ordernumber = 'P2503130000363' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460823' WHERE ordernumber = 'P2503130000368' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460821' WHERE ordernumber = 'P2503130000369' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460824' WHERE ordernumber = 'P2503130000372' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460822' WHERE ordernumber = 'P2503130000375' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '245266' WHERE ordernumber = 'P2503130000377' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '94223' WHERE ordernumber = 'P2503130000381' 2025-03-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '460822' WHERE ordernumber = 'P2503130000383' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460826' WHERE ordernumber = 'P2503130000385' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '245850' WHERE ordernumber = 'P2503130000390' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '276994' WHERE ordernumber = 'P2503130000392' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460819' WHERE ordernumber = 'P2503130000393' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460827' WHERE ordernumber = 'P2503130000395' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '403084' WHERE ordernumber = 'P2503130000399' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '380906' WHERE ordernumber = 'P2503130000400' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460829' WHERE ordernumber = 'P2503130000401' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '398072' WHERE ordernumber = 'P2503130000404' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460830' WHERE ordernumber = 'P2503130000413' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '454251' WHERE ordernumber = 'P2503130000424' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460831' WHERE ordernumber = 'P2503130000426' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '275404' WHERE ordernumber = 'P2503130000427' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460832' WHERE ordernumber = 'P2503130000429' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '302688' WHERE ordernumber = 'P2503130000437' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '347034' WHERE ordernumber = 'P2503130000438' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '453710' WHERE ordernumber = 'P2503130000439' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '413044' WHERE ordernumber = 'P2503130000440' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '212548' WHERE ordernumber = 'P2503130000444' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '432152' WHERE ordernumber = 'P2503130000450' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460834' WHERE ordernumber = 'P2503130000453' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '456235' WHERE ordernumber = 'P2503130000455' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '456235' WHERE ordernumber = 'P2503130000457' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '162902' WHERE ordernumber = 'P2503130000462' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '320713' WHERE ordernumber = 'P2503130000463' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460835' WHERE ordernumber = 'P2503130000465' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '310479' WHERE ordernumber = 'P2503130000471' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '93654' WHERE ordernumber = 'P2503130000472' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '334541' WHERE ordernumber = 'P2503130000473' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460836' WHERE ordernumber = 'P2503130000476' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '364203' WHERE ordernumber = 'P2503130000477' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '277412' WHERE ordernumber = 'P2503130000484' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '391497' WHERE ordernumber = 'P2503130000485' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '432887' WHERE ordernumber = 'P2503130000488' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '329945' WHERE ordernumber = 'P2503130000493' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '268408' WHERE ordernumber = 'P2503130000497' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460837' WHERE ordernumber = 'P2503130000503' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '399596' WHERE ordernumber = 'P2503130000513' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '460841' WHERE ordernumber = 'P2503130000527' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '97453' WHERE ordernumber = 'P2503130000529' 2025-03-14 01:00:04 -- UPDATE `omo_order_list` SET userId = '101105' WHERE ordernumber = 'P2503130000534'