2025-01-19 01:00:02 -- 將會員中心id寫入data-lake 2025-01-19 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-18%'; 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '374877' WHERE ordernumber = 'P2501180000016' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '449508' WHERE ordernumber = 'P2501180000020' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '305861' WHERE ordernumber = 'P2501180000022' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '139189' WHERE ordernumber = 'P2501180000024' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '305861' WHERE ordernumber = 'P2501180000025' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '429060' WHERE ordernumber = 'P2501180000027' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '301167' WHERE ordernumber = 'P2501180000029' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '361626' WHERE ordernumber = 'P2501180000034' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '450025' WHERE ordernumber = 'P2501180000037' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '450251' WHERE ordernumber = 'P2501180000042' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '81476' WHERE ordernumber = 'P2501180000043' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451509' WHERE ordernumber = 'P2501180000048' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '379941' WHERE ordernumber = 'P2501180000051' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '266360' WHERE ordernumber = 'P2501180000053' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '102171' WHERE ordernumber = 'P2501180000056' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '314307' WHERE ordernumber = 'P2501180000061' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451549' WHERE ordernumber = 'P2501180000065' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '93822' WHERE ordernumber = 'P2501180000067' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '412100' WHERE ordernumber = 'P2501180000068' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '447600' WHERE ordernumber = 'P2501180000072' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '442433' WHERE ordernumber = 'P2501180000073' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '450432' WHERE ordernumber = 'P2501180000075' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '421969' WHERE ordernumber = 'P2501180000076' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '421969' WHERE ordernumber = 'P2501180000080' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '416069' WHERE ordernumber = 'P2501180000081' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '210827' WHERE ordernumber = 'P2501180000085' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '25521' WHERE ordernumber = 'P2501180000091' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '419538' WHERE ordernumber = 'P2501180000092' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '136062' WHERE ordernumber = 'P2501180000094' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '442726' WHERE ordernumber = 'P2501180000100' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '91872' WHERE ordernumber = 'P2501180000101' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '381639' WHERE ordernumber = 'P2501180000104' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451555' WHERE ordernumber = 'P2501180000106' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '273831' WHERE ordernumber = 'P2501180000108' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '434124' WHERE ordernumber = 'P2501180000110' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451557' WHERE ordernumber = 'P2501180000113' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451559' WHERE ordernumber = 'P2501180000116' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451558' WHERE ordernumber = 'P2501180000117' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '449008' WHERE ordernumber = 'P2501180000120' 2025-01-19 01:00:02 -- UPDATE `omo_order_list` SET userId = '451560' WHERE ordernumber = 'P2501180000121' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '356234' WHERE ordernumber = 'P2501180000126' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451537' WHERE ordernumber = 'P2501180000130' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '369692' WHERE ordernumber = 'P2501180000133' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451569' WHERE ordernumber = 'P2501180000138' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451571' WHERE ordernumber = 'P2501180000141' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '257299' WHERE ordernumber = 'P2501180000144' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '449658' WHERE ordernumber = 'P2501180000147' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451548' WHERE ordernumber = 'P2501180000149' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '445561' WHERE ordernumber = 'P2501180000150' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '314912' WHERE ordernumber = 'P2501180000151' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '238685' WHERE ordernumber = 'P2501180000157' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451086' WHERE ordernumber = 'P2501180000159' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '445804' WHERE ordernumber = 'P2501180000161' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451086' WHERE ordernumber = 'P2501180000162' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451542' WHERE ordernumber = 'P2501180000163' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '40430' WHERE ordernumber = 'P2501180000164' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451540' WHERE ordernumber = 'P2501180000167' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451534' WHERE ordernumber = 'P2501180000169' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451581' WHERE ordernumber = 'P2501180000170' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451582' WHERE ordernumber = 'P2501180000173' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '34850' WHERE ordernumber = 'P2501180000177' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '267874' WHERE ordernumber = 'P2501180000179' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451538' WHERE ordernumber = 'P2501180000180' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451546' WHERE ordernumber = 'P2501180000181' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451538' WHERE ordernumber = 'P2501180000182' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '449995' WHERE ordernumber = 'P2501180000184' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '422350' WHERE ordernumber = 'P2501180000185' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451585' WHERE ordernumber = 'P2501180000188' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '431199' WHERE ordernumber = 'P2501180000189' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '240424' WHERE ordernumber = 'P2501180000190' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451553' WHERE ordernumber = 'P2501180000191' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '422350' WHERE ordernumber = 'P2501180000193' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '387231' WHERE ordernumber = 'P2501180000194' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '437583' WHERE ordernumber = 'P2501180000196' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451587' WHERE ordernumber = 'P2501180000199' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451551' WHERE ordernumber = 'P2501180000200' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '115320' WHERE ordernumber = 'P2501180000208' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '230318' WHERE ordernumber = 'P2501180000210' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451391' WHERE ordernumber = 'P2501180000214' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451591' WHERE ordernumber = 'P2501180000216' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451596' WHERE ordernumber = 'P2501180000220' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '433514' WHERE ordernumber = 'P2501180000224' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '448918' WHERE ordernumber = 'P2501180000229' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451580' WHERE ordernumber = 'P2501180000230' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451599' WHERE ordernumber = 'P2501180000231' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '428336' WHERE ordernumber = 'P2501180000234' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451566' WHERE ordernumber = 'P2501180000237' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '146448' WHERE ordernumber = 'P2501180000239' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451602' WHERE ordernumber = 'P2501180000240' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451604' WHERE ordernumber = 'P2501180000249' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451606' WHERE ordernumber = 'P2501180000251' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '70766' WHERE ordernumber = 'P2501180000252' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '305707' WHERE ordernumber = 'P2501180000253' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451579' WHERE ordernumber = 'P2501180000256' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '406753' WHERE ordernumber = 'P2501180000261' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451583' WHERE ordernumber = 'P2501180000265' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451578' WHERE ordernumber = 'P2501180000266' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '370263' WHERE ordernumber = 'P2501180000268' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '278108' WHERE ordernumber = 'P2501180000271' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451576' WHERE ordernumber = 'P2501180000274' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451572' WHERE ordernumber = 'P2501180000275' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451572' WHERE ordernumber = 'P2501180000276' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '450082' WHERE ordernumber = 'P2501180000282' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '374408' WHERE ordernumber = 'P2501180000284' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451609' WHERE ordernumber = 'P2501180000291' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '449237' WHERE ordernumber = 'P2501180000294' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '351944' WHERE ordernumber = 'P2501180000305' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '234079' WHERE ordernumber = 'P2501180000306' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451605' WHERE ordernumber = 'P2501180000307' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451615' WHERE ordernumber = 'P2501180000309' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '449459' WHERE ordernumber = 'P2501180000312' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451617' WHERE ordernumber = 'P2501180000313' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '388456' WHERE ordernumber = 'P2501180000315' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451594' WHERE ordernumber = 'P2501180000317' 2025-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '451618' WHERE ordernumber = 'P2501180000318' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '101475' WHERE ordernumber = 'P2501180000325' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451595' WHERE ordernumber = 'P2501180000327' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451620' WHERE ordernumber = 'P2501180000328' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451621' WHERE ordernumber = 'P2501180000331' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '355605' WHERE ordernumber = 'P2501180000336' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '339107' WHERE ordernumber = 'P2501180000340' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '380926' WHERE ordernumber = 'P2501180000342' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451624' WHERE ordernumber = 'P2501180000351' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '383754' WHERE ordernumber = 'P2501180000353' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451601' WHERE ordernumber = 'P2501180000354' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451603' WHERE ordernumber = 'P2501180000359' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451627' WHERE ordernumber = 'P2501180000366' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451629' WHERE ordernumber = 'P2501180000368' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451611' WHERE ordernumber = 'P2501180000375' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '365564' WHERE ordernumber = 'P2501180000377' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451633' WHERE ordernumber = 'P2501180000378' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451636' WHERE ordernumber = 'P2501180000384' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '377598' WHERE ordernumber = 'P2501180000387' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '379334' WHERE ordernumber = 'P2501180000388' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '326480' WHERE ordernumber = 'P2501180000389' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451639' WHERE ordernumber = 'P2501180000393' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451616' WHERE ordernumber = 'P2501180000394' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '433642' WHERE ordernumber = 'P2501180000398' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '395568' WHERE ordernumber = 'P2501180000401' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '434522' WHERE ordernumber = 'P2501180000402' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451642' WHERE ordernumber = 'P2501180000404' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '283090' WHERE ordernumber = 'P2501180000406' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451648' WHERE ordernumber = 'P2501180000415' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451650' WHERE ordernumber = 'P2501180000422' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '220190' WHERE ordernumber = 'P2501180000424' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '238440' WHERE ordernumber = 'P2501180000429' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451654' WHERE ordernumber = 'P2501180000439' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451631' WHERE ordernumber = 'P2501180000442' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '444181' WHERE ordernumber = 'P2501180000443' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '313963' WHERE ordernumber = 'P2501180000446' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451655' WHERE ordernumber = 'P2501180000451' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451641' WHERE ordernumber = 'P2501180000455' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '234493' WHERE ordernumber = 'P2501180000457' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '389453' WHERE ordernumber = 'P2501180000458' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '349347' WHERE ordernumber = 'P2501180000461' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '391890' WHERE ordernumber = 'P2501180000464' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '444638' WHERE ordernumber = 'P2501180000467' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '47022' WHERE ordernumber = 'P2501180000468' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '298889' WHERE ordernumber = 'P2501180000470' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '298026' WHERE ordernumber = 'P2501180000472' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451647' WHERE ordernumber = 'P2501180000473' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451658' WHERE ordernumber = 'P2501180000475' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '444347' WHERE ordernumber = 'P2501180000487' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451659' WHERE ordernumber = 'P2501180000490' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451660' WHERE ordernumber = 'P2501180000495' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '127058' WHERE ordernumber = 'P2501180000496' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '267291' WHERE ordernumber = 'P2501180000500' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '103865' WHERE ordernumber = 'P2501180000503' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451662' WHERE ordernumber = 'P2501180000504' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '284608' WHERE ordernumber = 'P2501180000510' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451663' WHERE ordernumber = 'P2501180000513' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '375491' WHERE ordernumber = 'P2501180000518' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '104601' WHERE ordernumber = 'P2501180000533' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '284702' WHERE ordernumber = 'P2501180000540' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '451668' WHERE ordernumber = 'P2501180000542' 2025-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '284702' WHERE ordernumber = 'P2501180000545' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '441095' WHERE ordernumber = 'P2501180000548' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '395651' WHERE ordernumber = 'P2501180000549' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '399046' WHERE ordernumber = 'P2501180000552' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '325362' WHERE ordernumber = 'P2501180000558' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '437553' WHERE ordernumber = 'P2501180000559' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451670' WHERE ordernumber = 'P2501180000560' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '335311' WHERE ordernumber = 'P2501180000563' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '443644' WHERE ordernumber = 'P2501180000566' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '443644' WHERE ordernumber = 'P2501180000567' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '335311' WHERE ordernumber = 'P2501180000569' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451671' WHERE ordernumber = 'P2501180000570' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451673' WHERE ordernumber = 'P2501180000574' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '271040' WHERE ordernumber = 'P2501180000579' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451675' WHERE ordernumber = 'P2501180000580' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '426927' WHERE ordernumber = 'P2501180000581' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '382985' WHERE ordernumber = 'P2501180000585' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '135003' WHERE ordernumber = 'P2501180000586' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '428495' WHERE ordernumber = 'P2501180000587' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451677' WHERE ordernumber = 'P2501180000589' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '450142' WHERE ordernumber = 'P2501180000590' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451678' WHERE ordernumber = 'P2501180000594' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '419737' WHERE ordernumber = 'P2501180000597' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451680' WHERE ordernumber = 'P2501180000602' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '442725' WHERE ordernumber = 'P2501180000605' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451682' WHERE ordernumber = 'P2501180000607' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '430660' WHERE ordernumber = 'P2501180000608' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451683' WHERE ordernumber = 'P2501180000611' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '298067' WHERE ordernumber = 'P2501180000614' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451686' WHERE ordernumber = 'P2501180000623' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451672' WHERE ordernumber = 'P2501180000626' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '430004' WHERE ordernumber = 'P2501180000628' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '340849' WHERE ordernumber = 'P2501180000632' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451692' WHERE ordernumber = 'P2501180000634' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '381996' WHERE ordernumber = 'P2501180000636' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '365686' WHERE ordernumber = 'P2501180000638' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451681' WHERE ordernumber = 'P2501180000640' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '106210' WHERE ordernumber = 'P2501180000643' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451676' WHERE ordernumber = 'P2501180000644' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451696' WHERE ordernumber = 'P2501180000645' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '237810' WHERE ordernumber = 'P2501180000646' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '438502' WHERE ordernumber = 'P2501180000647' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '367508' WHERE ordernumber = 'P2501180000650' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '390008' WHERE ordernumber = 'P2501180000652' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '226927' WHERE ordernumber = 'P2501180000654' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '441049' WHERE ordernumber = 'P2501180000657' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451700' WHERE ordernumber = 'P2501180000663' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451701' WHERE ordernumber = 'P2501180000667' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451702' WHERE ordernumber = 'P2501180000669' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '299720' WHERE ordernumber = 'P2501180000671' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '165839' WHERE ordernumber = 'P2501180000673' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451704' WHERE ordernumber = 'P2501180000676' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '81433' WHERE ordernumber = 'P2501180000684' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451705' WHERE ordernumber = 'P2501180000685' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451679' WHERE ordernumber = 'P2501180000689' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451707' WHERE ordernumber = 'P2501180000691' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '434289' WHERE ordernumber = 'P2501180000693' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '443392' WHERE ordernumber = 'P2501180000701' 2025-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '451713' WHERE ordernumber = 'P2501180000718' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '99942' WHERE ordernumber = 'P2501180000719' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '234548' WHERE ordernumber = 'P2501180000722' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '96208' WHERE ordernumber = 'P2501180000726' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '448892' WHERE ordernumber = 'P2501180000727' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451715' WHERE ordernumber = 'P2501180000729' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '448756' WHERE ordernumber = 'P2501180000733' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451716' WHERE ordernumber = 'P2501180000741' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451717' WHERE ordernumber = 'P2501180000745' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451699' WHERE ordernumber = 'P2501180000748' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451684' WHERE ordernumber = 'P2501180000751' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451720' WHERE ordernumber = 'P2501180000755' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '213719' WHERE ordernumber = 'P2501180000760' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451723' WHERE ordernumber = 'P2501180000763' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '401179' WHERE ordernumber = 'P2501180000765' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '278926' WHERE ordernumber = 'P2501180000769' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451724' WHERE ordernumber = 'P2501180000771' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '433552' WHERE ordernumber = 'P2501180000772' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451725' WHERE ordernumber = 'P2501180000775' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '439831' WHERE ordernumber = 'P2501180000781' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '357571' WHERE ordernumber = 'P2501180000783' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451727' WHERE ordernumber = 'P2501180000785' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '449864' WHERE ordernumber = 'P2501180000786' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '378722' WHERE ordernumber = 'P2501180000787' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '224965' WHERE ordernumber = 'P2501180000793' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '355398' WHERE ordernumber = 'P2501180000795' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451730' WHERE ordernumber = 'P2501180000796' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '352827' WHERE ordernumber = 'P2501180000799' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '334889' WHERE ordernumber = 'P2501180000800' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451732' WHERE ordernumber = 'P2501180000802' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451733' WHERE ordernumber = 'P2501180000808' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '352827' WHERE ordernumber = 'P2501180000809' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '63554' WHERE ordernumber = 'P2501180000810' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '446386' WHERE ordernumber = 'P2501180000811' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '342735' WHERE ordernumber = 'P2501180000815' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '450763' WHERE ordernumber = 'P2501180000816' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '308229' WHERE ordernumber = 'P2501180000817' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451737' WHERE ordernumber = 'P2501180000821' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '393212' WHERE ordernumber = 'P2501180000824' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '108976' WHERE ordernumber = 'P2501180000825' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '447306' WHERE ordernumber = 'P2501180000828' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '91816' WHERE ordernumber = 'P2501180000834' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '425409' WHERE ordernumber = 'P2501180000838' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '419669' WHERE ordernumber = 'P2501180000851' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '325115' WHERE ordernumber = 'P2501180000857' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '273088' WHERE ordernumber = 'P2501180000868' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '427106' WHERE ordernumber = 'P2501180000871' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '266404' WHERE ordernumber = 'P2501180000903' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '434739' WHERE ordernumber = 'P2501180000932' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '443101' WHERE ordernumber = 'P2501180000936' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451751' WHERE ordernumber = 'P2501180000956' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451752' WHERE ordernumber = 'P2501180000957' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '323769' WHERE ordernumber = 'P2501180000959' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '411501' WHERE ordernumber = 'P2501180000963' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '202046' WHERE ordernumber = 'P2501180000964' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '423113' WHERE ordernumber = 'P2501180000965' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '269894' WHERE ordernumber = 'P2501180000966' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451756' WHERE ordernumber = 'P2501180000980' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '436007' WHERE ordernumber = 'P2501180000981' 2025-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '451757' WHERE ordernumber = 'P2501180000983' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451759' WHERE ordernumber = 'P2501180000986' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451444' WHERE ordernumber = 'P2501180000994' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '313966' WHERE ordernumber = 'P2501180001000' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '146731' WHERE ordernumber = 'P2501180001007' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '444037' WHERE ordernumber = 'P2501180001016' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '105137' WHERE ordernumber = 'P2501180001030' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451768' WHERE ordernumber = 'P2501180001033' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451770' WHERE ordernumber = 'P2501180001040' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451772' WHERE ordernumber = 'P2501180001044' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '288395' WHERE ordernumber = 'P2501180001051' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '288395' WHERE ordernumber = 'P2501180001058' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451776' WHERE ordernumber = 'P2501180001065' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451777' WHERE ordernumber = 'P2501180001067' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451778' WHERE ordernumber = 'P2501180001069' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '155767' WHERE ordernumber = 'P2501180001085' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '283039' WHERE ordernumber = 'P2501180001089' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451780' WHERE ordernumber = 'P2501180001090' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '274974' WHERE ordernumber = 'P2501180001095' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451783' WHERE ordernumber = 'P2501180001100' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '269774' WHERE ordernumber = 'P2501180001106' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '143274' WHERE ordernumber = 'P2501180001108' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451788' WHERE ordernumber = 'P2501180001136' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '425426' WHERE ordernumber = 'P2501180001143' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '400783' WHERE ordernumber = 'P2501180001161' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '383557' WHERE ordernumber = 'P2501180001170' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '339488' WHERE ordernumber = 'P2501180001172' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '239380' WHERE ordernumber = 'P2501180001179' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451810' WHERE ordernumber = 'P2501180001210' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '402193' WHERE ordernumber = 'P2501180001213' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '413455' WHERE ordernumber = 'P2501180001221' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451814' WHERE ordernumber = 'P2501180001227' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '322122' WHERE ordernumber = 'P2501180001241' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '264365' WHERE ordernumber = 'P2501180001244' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451817' WHERE ordernumber = 'P2501180001247' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '245454' WHERE ordernumber = 'P2501180001249' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '421566' WHERE ordernumber = 'P2501180001257' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '97445' WHERE ordernumber = 'P2501180001260' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '234436' WHERE ordernumber = 'P2501180001261' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '424331' WHERE ordernumber = 'P2501180001268' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '375473' WHERE ordernumber = 'P2501180001282' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '386014' WHERE ordernumber = 'P2501180001291' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '103913' WHERE ordernumber = 'P2501180001300' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451831' WHERE ordernumber = 'P2501180001305' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451832' WHERE ordernumber = 'P2501180001311' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '250455' WHERE ordernumber = 'P2501180001321' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451836' WHERE ordernumber = 'P2501180001331' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451837' WHERE ordernumber = 'P2501180001332' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '444982' WHERE ordernumber = 'P2501180001335' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451841' WHERE ordernumber = 'P2501180001347' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '106434' WHERE ordernumber = 'P2501180001358' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '255978' WHERE ordernumber = 'P2501180001365' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451857' WHERE ordernumber = 'P2501180001392' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451857' WHERE ordernumber = 'P2501180001395' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '129974' WHERE ordernumber = 'P2501180001402' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451863' WHERE ordernumber = 'P2501180001407' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '447131' WHERE ordernumber = 'P2501180001409' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451863' WHERE ordernumber = 'P2501180001411' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '263343' WHERE ordernumber = 'P2501180001419' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '451863' WHERE ordernumber = 'P2501180001422' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '214506' WHERE ordernumber = 'P2501180001443' 2025-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '431549' WHERE ordernumber = 'P2501180001449'