2025-01-17 01:00:02 -- 將會員中心id寫入data-lake 2025-01-17 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-01-16%'; 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '361710' WHERE ordernumber = 'P2501160000018' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '260328' WHERE ordernumber = 'P2501160000021' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '419670' WHERE ordernumber = 'P2501160000024' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '286571' WHERE ordernumber = 'P2501160000025' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '286571' WHERE ordernumber = 'P2501160000028' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '267974' WHERE ordernumber = 'P2501160000031' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450548' WHERE ordernumber = 'P2501160000033' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450549' WHERE ordernumber = 'P2501160000036' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '304079' WHERE ordernumber = 'P2501160000040' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '348408' WHERE ordernumber = 'P2501160000041' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450438' WHERE ordernumber = 'P2501160000043' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '370780' WHERE ordernumber = 'P2501160000044' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '287062' WHERE ordernumber = 'P2501160000045' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450555' WHERE ordernumber = 'P2501160000046' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450557' WHERE ordernumber = 'P2501160000048' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '159187' WHERE ordernumber = 'P2501160000057' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '297481' WHERE ordernumber = 'P2501160000059' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450559' WHERE ordernumber = 'P2501160000060' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '101092' WHERE ordernumber = 'P2501160000061' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '319052' WHERE ordernumber = 'P2501160000065' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450554' WHERE ordernumber = 'P2501160000066' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '447175' WHERE ordernumber = 'P2501160000067' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '267400' WHERE ordernumber = 'P2501160000070' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450243' WHERE ordernumber = 'P2501160000071' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450243' WHERE ordernumber = 'P2501160000073' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450569' WHERE ordernumber = 'P2501160000075' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '337596' WHERE ordernumber = 'P2501160000079' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '383329' WHERE ordernumber = 'P2501160000082' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '364974' WHERE ordernumber = 'P2501160000084' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '302798' WHERE ordernumber = 'P2501160000086' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450573' WHERE ordernumber = 'P2501160000087' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450574' WHERE ordernumber = 'P2501160000088' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450082' WHERE ordernumber = 'P2501160000089' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '431975' WHERE ordernumber = 'P2501160000091' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450086' WHERE ordernumber = 'P2501160000092' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '441458' WHERE ordernumber = 'P2501160000093' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '38929' WHERE ordernumber = 'P2501160000095' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '357721' WHERE ordernumber = 'P2501160000097' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450403' WHERE ordernumber = 'P2501160000098' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '377844' WHERE ordernumber = 'P2501160000099' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450577' WHERE ordernumber = 'P2501160000102' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '275007' WHERE ordernumber = 'P2501160000109' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450552' WHERE ordernumber = 'P2501160000111' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '449559' WHERE ordernumber = 'P2501160000113' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '94201' WHERE ordernumber = 'P2501160000115' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450584' WHERE ordernumber = 'P2501160000117' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450540' WHERE ordernumber = 'P2501160000119' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '261164' WHERE ordernumber = 'P2501160000120' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450545' WHERE ordernumber = 'P2501160000123' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '90173' WHERE ordernumber = 'P2501160000124' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '270921' WHERE ordernumber = 'P2501160000127' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '319460' WHERE ordernumber = 'P2501160000128' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450403' WHERE ordernumber = 'P2501160000131' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450590' WHERE ordernumber = 'P2501160000135' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '308598' WHERE ordernumber = 'P2501160000137' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450555' WHERE ordernumber = 'P2501160000143' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '440709' WHERE ordernumber = 'P2501160000144' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '269427' WHERE ordernumber = 'P2501160000145' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '368596' WHERE ordernumber = 'P2501160000149' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '423370' WHERE ordernumber = 'P2501160000153' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450598' WHERE ordernumber = 'P2501160000154' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '423370' WHERE ordernumber = 'P2501160000155' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450578' WHERE ordernumber = 'P2501160000157' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '232297' WHERE ordernumber = 'P2501160000158' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '133357' WHERE ordernumber = 'P2501160000161' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '449709' WHERE ordernumber = 'P2501160000164' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450561' WHERE ordernumber = 'P2501160000166' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450599' WHERE ordernumber = 'P2501160000167' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450358' WHERE ordernumber = 'P2501160000171' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '260333' WHERE ordernumber = 'P2501160000172' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450561' WHERE ordernumber = 'P2501160000173' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '228958' WHERE ordernumber = 'P2501160000175' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450561' WHERE ordernumber = 'P2501160000176' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '376295' WHERE ordernumber = 'P2501160000179' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '233457' WHERE ordernumber = 'P2501160000184' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450571' WHERE ordernumber = 'P2501160000187' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450608' WHERE ordernumber = 'P2501160000188' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450582' WHERE ordernumber = 'P2501160000189' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450612' WHERE ordernumber = 'P2501160000191' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450541' WHERE ordernumber = 'P2501160000193' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450613' WHERE ordernumber = 'P2501160000196' 2025-01-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '450551' WHERE ordernumber = 'P2501160000198' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '337747' WHERE ordernumber = 'P2501160000205' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '446730' WHERE ordernumber = 'P2501160000220' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '443723' WHERE ordernumber = 'P2501160000223' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450622' WHERE ordernumber = 'P2501160000225' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '387761' WHERE ordernumber = 'P2501160000226' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450589' WHERE ordernumber = 'P2501160000227' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450624' WHERE ordernumber = 'P2501160000228' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450627' WHERE ordernumber = 'P2501160000230' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450543' WHERE ordernumber = 'P2501160000231' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '239766' WHERE ordernumber = 'P2501160000234' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '421932' WHERE ordernumber = 'P2501160000235' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450630' WHERE ordernumber = 'P2501160000236' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450631' WHERE ordernumber = 'P2501160000238' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '448569' WHERE ordernumber = 'P2501160000242' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450633' WHERE ordernumber = 'P2501160000247' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '185770' WHERE ordernumber = 'P2501160000249' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450636' WHERE ordernumber = 'P2501160000255' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450642' WHERE ordernumber = 'P2501160000261' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '439353' WHERE ordernumber = 'P2501160000263' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450644' WHERE ordernumber = 'P2501160000267' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '399308' WHERE ordernumber = 'P2501160000272' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '133744' WHERE ordernumber = 'P2501160000282' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '432367' WHERE ordernumber = 'P2501160000284' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450648' WHERE ordernumber = 'P2501160000289' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450649' WHERE ordernumber = 'P2501160000293' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '297061' WHERE ordernumber = 'P2501160000297' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450651' WHERE ordernumber = 'P2501160000302' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450602' WHERE ordernumber = 'P2501160000303' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '201811' WHERE ordernumber = 'P2501160000304' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450652' WHERE ordernumber = 'P2501160000307' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '412009' WHERE ordernumber = 'P2501160000312' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450655' WHERE ordernumber = 'P2501160000313' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450596' WHERE ordernumber = 'P2501160000315' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450571' WHERE ordernumber = 'P2501160000320' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '67700' WHERE ordernumber = 'P2501160000323' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450616' WHERE ordernumber = 'P2501160000324' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '422842' WHERE ordernumber = 'P2501160000325' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450617' WHERE ordernumber = 'P2501160000328' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450658' WHERE ordernumber = 'P2501160000326' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '214165' WHERE ordernumber = 'P2501160000330' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450660' WHERE ordernumber = 'P2501160000333' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '386961' WHERE ordernumber = 'P2501160000334' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450661' WHERE ordernumber = 'P2501160000338' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '383775' WHERE ordernumber = 'P2501160000341' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '304696' WHERE ordernumber = 'P2501160000343' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450664' WHERE ordernumber = 'P2501160000345' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450643' WHERE ordernumber = 'P2501160000347' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450669' WHERE ordernumber = 'P2501160000349' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '408675' WHERE ordernumber = 'P2501160000351' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352798' WHERE ordernumber = 'P2501160000352' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450673' WHERE ordernumber = 'P2501160000353' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '239484' WHERE ordernumber = 'P2501160000355' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450621' WHERE ordernumber = 'P2501160000356' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '418349' WHERE ordernumber = 'P2501160000357' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '216990' WHERE ordernumber = 'P2501160000358' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '153734' WHERE ordernumber = 'P2501160000362' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '388632' WHERE ordernumber = 'P2501160000364' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '80965' WHERE ordernumber = 'P2501160000374' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450646' WHERE ordernumber = 'P2501160000378' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '297438' WHERE ordernumber = 'P2501160000379' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '279562' WHERE ordernumber = 'P2501160000381' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450639' WHERE ordernumber = 'P2501160000387' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450637' WHERE ordernumber = 'P2501160000389' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450685' WHERE ordernumber = 'P2501160000391' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450686' WHERE ordernumber = 'P2501160000396' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '89284' WHERE ordernumber = 'P2501160000397' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '300589' WHERE ordernumber = 'P2501160000398' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '299811' WHERE ordernumber = 'P2501160000400' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '288984' WHERE ordernumber = 'P2501160000402' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '169788' WHERE ordernumber = 'P2501160000403' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450688' WHERE ordernumber = 'P2501160000404' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450629' WHERE ordernumber = 'P2501160000409' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450663' WHERE ordernumber = 'P2501160000411' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450694' WHERE ordernumber = 'P2501160000415' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450657' WHERE ordernumber = 'P2501160000421' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450695' WHERE ordernumber = 'P2501160000422' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450657' WHERE ordernumber = 'P2501160000424' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450662' WHERE ordernumber = 'P2501160000426' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450696' WHERE ordernumber = 'P2501160000427' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '347465' WHERE ordernumber = 'P2501160000429' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '20802' WHERE ordernumber = 'P2501160000430' 2025-01-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '450670' WHERE ordernumber = 'P2501160000431' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '367339' WHERE ordernumber = 'P2501160000432' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '432814' WHERE ordernumber = 'P2501160000433' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450698' WHERE ordernumber = 'P2501160000434' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450666' WHERE ordernumber = 'P2501160000436' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450675' WHERE ordernumber = 'P2501160000438' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450700' WHERE ordernumber = 'P2501160000440' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '102255' WHERE ordernumber = 'P2501160000442' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '161052' WHERE ordernumber = 'P2501160000445' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450676' WHERE ordernumber = 'P2501160000453' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '449052' WHERE ordernumber = 'P2501160000457' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '373285' WHERE ordernumber = 'P2501160000458' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450703' WHERE ordernumber = 'P2501160000463' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450690' WHERE ordernumber = 'P2501160000470' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '401905' WHERE ordernumber = 'P2501160000487' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450161' WHERE ordernumber = 'P2501160000488' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450708' WHERE ordernumber = 'P2501160000494' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '378295' WHERE ordernumber = 'P2501160000495' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450710' WHERE ordernumber = 'P2501160000500' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '145559' WHERE ordernumber = 'P2501160000503' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '437027' WHERE ordernumber = 'P2501160000505' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '145559' WHERE ordernumber = 'P2501160000507' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '445547' WHERE ordernumber = 'P2501160000513' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450717' WHERE ordernumber = 'P2501160000518' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '354173' WHERE ordernumber = 'P2501160000519' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '97677' WHERE ordernumber = 'P2501160000520' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '439415' WHERE ordernumber = 'P2501160000521' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '255158' WHERE ordernumber = 'P2501160000526' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450702' WHERE ordernumber = 'P2501160000529' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450720' WHERE ordernumber = 'P2501160000531' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450721' WHERE ordernumber = 'P2501160000532' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450702' WHERE ordernumber = 'P2501160000533' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '51171' WHERE ordernumber = 'P2501160000537' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '436412' WHERE ordernumber = 'P2501160000543' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450723' WHERE ordernumber = 'P2501160000544' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '357652' WHERE ordernumber = 'P2501160000552' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450500' WHERE ordernumber = 'P2501160000555' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450726' WHERE ordernumber = 'P2501160000559' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450727' WHERE ordernumber = 'P2501160000560' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450728' WHERE ordernumber = 'P2501160000563' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '395721' WHERE ordernumber = 'P2501160000564' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450729' WHERE ordernumber = 'P2501160000567' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '377282' WHERE ordernumber = 'P2501160000573' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450709' WHERE ordernumber = 'P2501160000576' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450730' WHERE ordernumber = 'P2501160000578' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '168576' WHERE ordernumber = 'P2501160000582' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '181764' WHERE ordernumber = 'P2501160000583' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450732' WHERE ordernumber = 'P2501160000585' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450438' WHERE ordernumber = 'P2501160000586' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '418493' WHERE ordernumber = 'P2501160000589' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450733' WHERE ordernumber = 'P2501160000592' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '323625' WHERE ordernumber = 'P2501160000594' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450735' WHERE ordernumber = 'P2501160000595' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450736' WHERE ordernumber = 'P2501160000599' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450713' WHERE ordernumber = 'P2501160000600' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450737' WHERE ordernumber = 'P2501160000601' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450738' WHERE ordernumber = 'P2501160000604' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450739' WHERE ordernumber = 'P2501160000607' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '387308' WHERE ordernumber = 'P2501160000609' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '441009' WHERE ordernumber = 'P2501160000610' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450172' WHERE ordernumber = 'P2501160000612' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '94980' WHERE ordernumber = 'P2501160000620' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450734' WHERE ordernumber = 'P2501160000623' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450734' WHERE ordernumber = 'P2501160000625' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '395168' WHERE ordernumber = 'P2501160000628' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '237842' WHERE ordernumber = 'P2501160000630' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450725' WHERE ordernumber = 'P2501160000634' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '315332' WHERE ordernumber = 'P2501160000635' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450744' WHERE ordernumber = 'P2501160000644' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '410639' WHERE ordernumber = 'P2501160000650' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '421653' WHERE ordernumber = 'P2501160000652' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '439699' WHERE ordernumber = 'P2501160000653' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '443931' WHERE ordernumber = 'P2501160000661' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '448917' WHERE ordernumber = 'P2501160000663' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '355184' WHERE ordernumber = 'P2501160000667' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '426756' WHERE ordernumber = 'P2501160000669' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '358803' WHERE ordernumber = 'P2501160000682' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '107391' WHERE ordernumber = 'P2501160000684' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450753' WHERE ordernumber = 'P2501160000688' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '143474' WHERE ordernumber = 'P2501160000691' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450752' WHERE ordernumber = 'P2501160000696' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '446716' WHERE ordernumber = 'P2501160000701' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '446716' WHERE ordernumber = 'P2501160000705' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '175200' WHERE ordernumber = 'P2501160000708' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '437952' WHERE ordernumber = 'P2501160000710' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '368042' WHERE ordernumber = 'P2501160000712' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '339506' WHERE ordernumber = 'P2501160000714' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '84022' WHERE ordernumber = 'P2501160000717' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '429668' WHERE ordernumber = 'P2501160000723' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '450763' WHERE ordernumber = 'P2501160000727' 2025-01-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '445401' WHERE ordernumber = 'P2501160000731' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '443006' WHERE ordernumber = 'P2501160000732' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '445772' WHERE ordernumber = 'P2501160000743' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '445446' WHERE ordernumber = 'P2501160000745' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '446672' WHERE ordernumber = 'P2501160000753' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '100654' WHERE ordernumber = 'P2501160000769' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450768' WHERE ordernumber = 'P2501160000776' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '374513' WHERE ordernumber = 'P2501160000779' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450773' WHERE ordernumber = 'P2501160000792' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '433518' WHERE ordernumber = 'P2501160000800' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450780' WHERE ordernumber = 'P2501160000817' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '162907' WHERE ordernumber = 'P2501160000838' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '446339' WHERE ordernumber = 'P2501160000839' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450786' WHERE ordernumber = 'P2501160000841' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450152' WHERE ordernumber = 'P2501160000845' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450795' WHERE ordernumber = 'P2501160000867' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '100141' WHERE ordernumber = 'P2501160000870' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450797' WHERE ordernumber = 'P2501160000874' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '396460' WHERE ordernumber = 'P2501160000880' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450803' WHERE ordernumber = 'P2501160000884' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '441020' WHERE ordernumber = 'P2501160000891' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '385317' WHERE ordernumber = 'P2501160000892' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '373803' WHERE ordernumber = 'P2501160000893' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '164061' WHERE ordernumber = 'P2501160000905' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450809' WHERE ordernumber = 'P2501160000909' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450810' WHERE ordernumber = 'P2501160000910' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '448205' WHERE ordernumber = 'P2501160000912' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '442810' WHERE ordernumber = 'P2501160000917' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '439247' WHERE ordernumber = 'P2501160000922' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '420950' WHERE ordernumber = 'P2501160000926' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '208796' WHERE ordernumber = 'P2501160000928' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '439247' WHERE ordernumber = 'P2501160000931' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '442317' WHERE ordernumber = 'P2501160000942' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450824' WHERE ordernumber = 'P2501160000943' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450825' WHERE ordernumber = 'P2501160000948' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '407471' WHERE ordernumber = 'P2501160000949' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '439828' WHERE ordernumber = 'P2501160000967' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450832' WHERE ordernumber = 'P2501160000968' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450834' WHERE ordernumber = 'P2501160000976' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450833' WHERE ordernumber = 'P2501160000977' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450836' WHERE ordernumber = 'P2501160000983' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450839' WHERE ordernumber = 'P2501160000987' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450840' WHERE ordernumber = 'P2501160000991' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '158812' WHERE ordernumber = 'P2501160000992' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450841' WHERE ordernumber = 'P2501160000994' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '214112' WHERE ordernumber = 'P2501160001003' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '449147' WHERE ordernumber = 'P2501160001005' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '140387' WHERE ordernumber = 'P2501160001006' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '444309' WHERE ordernumber = 'P2501160001010' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '140387' WHERE ordernumber = 'P2501160001011' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '81972' WHERE ordernumber = 'P2501160001020' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450845' WHERE ordernumber = 'P2501160001024' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '266600' WHERE ordernumber = 'P2501160001026' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450848' WHERE ordernumber = 'P2501160001036' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450849' WHERE ordernumber = 'P2501160001037' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450850' WHERE ordernumber = 'P2501160001040' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450851' WHERE ordernumber = 'P2501160001045' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '104875' WHERE ordernumber = 'P2501160001048' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '283448' WHERE ordernumber = 'P2501160001050' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '448892' WHERE ordernumber = 'P2501160001053' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '280085' WHERE ordernumber = 'P2501160001057' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450855' WHERE ordernumber = 'P2501160001059' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450856' WHERE ordernumber = 'P2501160001062' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450854' WHERE ordernumber = 'P2501160001063' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '153164' WHERE ordernumber = 'P2501160001072' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '238188' WHERE ordernumber = 'P2501160001074' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450863' WHERE ordernumber = 'P2501160001084' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '447103' WHERE ordernumber = 'P2501160001088' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '134829' WHERE ordernumber = 'P2501160001089' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '234483' WHERE ordernumber = 'P2501160001092' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450865' WHERE ordernumber = 'P2501160001093' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450873' WHERE ordernumber = 'P2501160001109' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '445737' WHERE ordernumber = 'P2501160001115' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450878' WHERE ordernumber = 'P2501160001121' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '432705' WHERE ordernumber = 'P2501160001131' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '447368' WHERE ordernumber = 'P2501160001132' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '450882' WHERE ordernumber = 'P2501160001135' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '411697' WHERE ordernumber = 'P2501160001150' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '217700' WHERE ordernumber = 'P2501160001155' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '259562' WHERE ordernumber = 'P2501160001156' 2025-01-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '99210' WHERE ordernumber = 'P2501160001163'