2025-02-10 01:00:01 -- 將會員中心id寫入data-lake 2025-02-10 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 '2025-02-09%'; 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '72395' WHERE ordernumber = 'P2502090000019' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '452710' WHERE ordernumber = 'P2502090000022' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455288' WHERE ordernumber = 'P2502090000033' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '454097' WHERE ordernumber = 'P2502090000034' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455289' WHERE ordernumber = 'P2502090000035' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455292' WHERE ordernumber = 'P2502090000037' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455293' WHERE ordernumber = 'P2502090000038' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '427361' WHERE ordernumber = 'P2502090000046' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455296' WHERE ordernumber = 'P2502090000047' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '97847' WHERE ordernumber = 'P2502090000052' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '158930' WHERE ordernumber = 'P2502090000060' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '244638' WHERE ordernumber = 'P2502090000068' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '294112' WHERE ordernumber = 'P2502090000070' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '454407' WHERE ordernumber = 'P2502090000076' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455297' WHERE ordernumber = 'P2502090000078' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '352417' WHERE ordernumber = 'P2502090000083' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '352417' WHERE ordernumber = 'P2502090000085' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '253185' WHERE ordernumber = 'P2502090000090' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '433514' WHERE ordernumber = 'P2502090000091' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '389812' WHERE ordernumber = 'P2502090000096' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '440902' WHERE ordernumber = 'P2502090000098' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455298' WHERE ordernumber = 'P2502090000099' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '453713' WHERE ordernumber = 'P2502090000102' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455299' WHERE ordernumber = 'P2502090000103' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455300' WHERE ordernumber = 'P2502090000106' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455301' WHERE ordernumber = 'P2502090000107' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '128783' WHERE ordernumber = 'P2502090000109' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '394739' WHERE ordernumber = 'P2502090000111' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455302' WHERE ordernumber = 'P2502090000113' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '329316' WHERE ordernumber = 'P2502090000115' 2025-02-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '455303' WHERE ordernumber = 'P2502090000116' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '394739' WHERE ordernumber = 'P2502090000118' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455304' WHERE ordernumber = 'P2502090000119' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '424331' WHERE ordernumber = 'P2502090000122' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '122758' WHERE ordernumber = 'P2502090000125' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455305' WHERE ordernumber = 'P2502090000126' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '112941' WHERE ordernumber = 'P2502090000128' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455306' WHERE ordernumber = 'P2502090000135' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '385853' WHERE ordernumber = 'P2502090000138' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455307' WHERE ordernumber = 'P2502090000139' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '132796' WHERE ordernumber = 'P2502090000141' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455308' WHERE ordernumber = 'P2502090000142' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455309' WHERE ordernumber = 'P2502090000143' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455310' WHERE ordernumber = 'P2502090000144' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455310' WHERE ordernumber = 'P2502090000146' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455312' WHERE ordernumber = 'P2502090000147' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455311' WHERE ordernumber = 'P2502090000148' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455313' WHERE ordernumber = 'P2502090000149' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455314' WHERE ordernumber = 'P2502090000151' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455316' WHERE ordernumber = 'P2502090000153' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455315' WHERE ordernumber = 'P2502090000154' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '102962' WHERE ordernumber = 'P2502090000158' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '315794' WHERE ordernumber = 'P2502090000160' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455317' WHERE ordernumber = 'P2502090000165' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455318' WHERE ordernumber = 'P2502090000168' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '227056' WHERE ordernumber = 'P2502090000171' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455319' WHERE ordernumber = 'P2502090000174' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '406303' WHERE ordernumber = 'P2502090000175' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '105986' WHERE ordernumber = 'P2502090000177' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455320' WHERE ordernumber = 'P2502090000178' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '446818' WHERE ordernumber = 'P2502090000180' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '379013' WHERE ordernumber = 'P2502090000183' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '70593' WHERE ordernumber = 'P2502090000189' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '434625' WHERE ordernumber = 'P2502090000190' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455322' WHERE ordernumber = 'P2502090000191' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '401740' WHERE ordernumber = 'P2502090000193' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '447235' WHERE ordernumber = 'P2502090000196' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455323' WHERE ordernumber = 'P2502090000199' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455324' WHERE ordernumber = 'P2502090000200' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455325' WHERE ordernumber = 'P2502090000217' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '378996' WHERE ordernumber = 'P2502090000221' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '378996' WHERE ordernumber = 'P2502090000226' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455328' WHERE ordernumber = 'P2502090000228' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '447179' WHERE ordernumber = 'P2502090000233' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '298460' WHERE ordernumber = 'P2502090000235' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '425486' WHERE ordernumber = 'P2502090000236' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '405426' WHERE ordernumber = 'P2502090000237' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455329' WHERE ordernumber = 'P2502090000240' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '420582' WHERE ordernumber = 'P2502090000242' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455329' WHERE ordernumber = 'P2502090000243' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455330' WHERE ordernumber = 'P2502090000244' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455331' WHERE ordernumber = 'P2502090000250' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455332' WHERE ordernumber = 'P2502090000252' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '329753' WHERE ordernumber = 'P2502090000258' 2025-02-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '455334' WHERE ordernumber = 'P2502090000262' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '161060' WHERE ordernumber = 'P2502090000266' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '337219' WHERE ordernumber = 'P2502090000267' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455335' WHERE ordernumber = 'P2502090000268' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '349764' WHERE ordernumber = 'P2502090000277' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455336' WHERE ordernumber = 'P2502090000282' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455228' WHERE ordernumber = 'P2502090000287' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455338' WHERE ordernumber = 'P2502090000290' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455339' WHERE ordernumber = 'P2502090000291' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '387207' WHERE ordernumber = 'P2502090000292' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455339' WHERE ordernumber = 'P2502090000293' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '111140' WHERE ordernumber = 'P2502090000294' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455340' WHERE ordernumber = 'P2502090000296' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '418607' WHERE ordernumber = 'P2502090000303' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455341' WHERE ordernumber = 'P2502090000307' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455342' WHERE ordernumber = 'P2502090000315' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455228' WHERE ordernumber = 'P2502090000317' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455344' WHERE ordernumber = 'P2502090000325' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '386085' WHERE ordernumber = 'P2502090000330' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455345' WHERE ordernumber = 'P2502090000333' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '413128' WHERE ordernumber = 'P2502090000337' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455346' WHERE ordernumber = 'P2502090000340' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455348' WHERE ordernumber = 'P2502090000343' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '447623' WHERE ordernumber = 'P2502090000344' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '377914' WHERE ordernumber = 'P2502090000346' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455347' WHERE ordernumber = 'P2502090000347' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455349' WHERE ordernumber = 'P2502090000349' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455349' WHERE ordernumber = 'P2502090000351' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '384983' WHERE ordernumber = 'P2502090000359' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455350' WHERE ordernumber = 'P2502090000360' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455351' WHERE ordernumber = 'P2502090000363' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455352' WHERE ordernumber = 'P2502090000365' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455353' WHERE ordernumber = 'P2502090000369' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455354' WHERE ordernumber = 'P2502090000372' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455355' WHERE ordernumber = 'P2502090000375' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455356' WHERE ordernumber = 'P2502090000387' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455356' WHERE ordernumber = 'P2502090000389' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '453633' WHERE ordernumber = 'P2502090000390' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455357' WHERE ordernumber = 'P2502090000393' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455359' WHERE ordernumber = 'P2502090000400' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455360' WHERE ordernumber = 'P2502090000401' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455361' WHERE ordernumber = 'P2502090000402' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455362' WHERE ordernumber = 'P2502090000405' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '454983' WHERE ordernumber = 'P2502090000409' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '242073' WHERE ordernumber = 'P2502090000410' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '288749' WHERE ordernumber = 'P2502090000419' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '434131' WHERE ordernumber = 'P2502090000420' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '445143' WHERE ordernumber = 'P2502090000426' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '430530' WHERE ordernumber = 'P2502090000427' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455364' WHERE ordernumber = 'P2502090000428' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455365' WHERE ordernumber = 'P2502090000429' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '343720' WHERE ordernumber = 'P2502090000430' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455366' WHERE ordernumber = 'P2502090000435' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '455367' WHERE ordernumber = 'P2502090000440' 2025-02-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '450685' WHERE ordernumber = 'P2502090000442' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '426798' WHERE ordernumber = 'P2502090000447' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455369' WHERE ordernumber = 'P2502090000450' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455370' WHERE ordernumber = 'P2502090000451' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455371' WHERE ordernumber = 'P2502090000452' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '422704' WHERE ordernumber = 'P2502090000457' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '270641' WHERE ordernumber = 'P2502090000459' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '280830' WHERE ordernumber = 'P2502090000463' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '331595' WHERE ordernumber = 'P2502090000464' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455373' WHERE ordernumber = 'P2502090000466' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455372' WHERE ordernumber = 'P2502090000467' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455375' WHERE ordernumber = 'P2502090000474' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '453581' WHERE ordernumber = 'P2502090000481' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '392861' WHERE ordernumber = 'P2502090000488' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '252406' WHERE ordernumber = 'P2502090000489' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '430870' WHERE ordernumber = 'P2502090000492' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '423349' WHERE ordernumber = 'P2502090000494' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455378' WHERE ordernumber = 'P2502090000501' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455379' WHERE ordernumber = 'P2502090000503' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '438258' WHERE ordernumber = 'P2502090000507' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '105063' WHERE ordernumber = 'P2502090000510' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '438258' WHERE ordernumber = 'P2502090000513' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '396977' WHERE ordernumber = 'P2502090000515' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '345666' WHERE ordernumber = 'P2502090000518' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '438258' WHERE ordernumber = 'P2502090000521' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '131486' WHERE ordernumber = 'P2502090000522' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '429982' WHERE ordernumber = 'P2502090000533' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455381' WHERE ordernumber = 'P2502090000534' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '351732' WHERE ordernumber = 'P2502090000536' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '256394' WHERE ordernumber = 'P2502090000537' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455382' WHERE ordernumber = 'P2502090000538' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455384' WHERE ordernumber = 'P2502090000546' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455385' WHERE ordernumber = 'P2502090000547' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '221617' WHERE ordernumber = 'P2502090000548' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455383' WHERE ordernumber = 'P2502090000557' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455383' WHERE ordernumber = 'P2502090000558' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '426897' WHERE ordernumber = 'P2502090000559' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '116975' WHERE ordernumber = 'P2502090000560' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455388' WHERE ordernumber = 'P2502090000561' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '284320' WHERE ordernumber = 'P2502090000567' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '305273' WHERE ordernumber = 'P2502090000580' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '455391' WHERE ordernumber = 'P2502090000585' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '225071' WHERE ordernumber = 'P2502090000589' 2025-02-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '432160' WHERE ordernumber = 'P2502090000598'