2025-01-04 01:00:01 -- 將會員中心id寫入data-lake 2025-01-04 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-01-03%'; 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '297325' WHERE ordernumber = 'P2501030000017' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '264540' WHERE ordernumber = 'P2501030000018' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443273' WHERE ordernumber = 'P2501030000019' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '440207' WHERE ordernumber = 'P2501030000020' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '437754' WHERE ordernumber = 'P2501030000023' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443274' WHERE ordernumber = 'P2501030000024' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '264540' WHERE ordernumber = 'P2501030000025' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '384359' WHERE ordernumber = 'P2501030000027' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '110649' WHERE ordernumber = 'P2501030000028' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '440207' WHERE ordernumber = 'P2501030000029' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '231698' WHERE ordernumber = 'P2501030000030' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443278' WHERE ordernumber = 'P2501030000032' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '304084' WHERE ordernumber = 'P2501030000033' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '435881' WHERE ordernumber = 'P2501030000035' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '244313' WHERE ordernumber = 'P2501030000036' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '267318' WHERE ordernumber = 'P2501030000037' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '286541' WHERE ordernumber = 'P2501030000041' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443282' WHERE ordernumber = 'P2501030000042' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443283' WHERE ordernumber = 'P2501030000043' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '382282' WHERE ordernumber = 'P2501030000044' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443285' WHERE ordernumber = 'P2501030000046' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443283' WHERE ordernumber = 'P2501030000047' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '93879' WHERE ordernumber = 'P2501030000048' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443283' WHERE ordernumber = 'P2501030000049' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '244301' WHERE ordernumber = 'P2501030000051' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443286' WHERE ordernumber = 'P2501030000052' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443288' WHERE ordernumber = 'P2501030000056' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '435318' WHERE ordernumber = 'P2501030000060' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '239204' WHERE ordernumber = 'P2501030000062' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443294' WHERE ordernumber = 'P2501030000066' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '441534' WHERE ordernumber = 'P2501030000067' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443299' WHERE ordernumber = 'P2501030000076' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443300' WHERE ordernumber = 'P2501030000078' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '87093' WHERE ordernumber = 'P2501030000079' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443300' WHERE ordernumber = 'P2501030000080' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '335240' WHERE ordernumber = 'P2501030000083' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '431336' WHERE ordernumber = 'P2501030000086' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443303' WHERE ordernumber = 'P2501030000087' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443304' WHERE ordernumber = 'P2501030000089' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443305' WHERE ordernumber = 'P2501030000090' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443306' WHERE ordernumber = 'P2501030000091' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '283956' WHERE ordernumber = 'P2501030000093' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '389182' WHERE ordernumber = 'P2501030000094' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '274916' WHERE ordernumber = 'P2501030000095' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '389182' WHERE ordernumber = 'P2501030000097' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '389182' WHERE ordernumber = 'P2501030000098' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443310' WHERE ordernumber = 'P2501030000100' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443312' WHERE ordernumber = 'P2501030000102' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443314' WHERE ordernumber = 'P2501030000105' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443316' WHERE ordernumber = 'P2501030000107' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '366385' WHERE ordernumber = 'P2501030000109' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '366385' WHERE ordernumber = 'P2501030000110' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '162735' WHERE ordernumber = 'P2501030000113' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '282613' WHERE ordernumber = 'P2501030000116' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '249733' WHERE ordernumber = 'P2501030000120' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443324' WHERE ordernumber = 'P2501030000123' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '241711' WHERE ordernumber = 'P2501030000124' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '437207' WHERE ordernumber = 'P2501030000125' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '437207' WHERE ordernumber = 'P2501030000126' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '370980' WHERE ordernumber = 'P2501030000127' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '437207' WHERE ordernumber = 'P2501030000128' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '275266' WHERE ordernumber = 'P2501030000129' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443325' WHERE ordernumber = 'P2501030000136' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '163199' WHERE ordernumber = 'P2501030000137' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443326' WHERE ordernumber = 'P2501030000140' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '433537' WHERE ordernumber = 'P2501030000142' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '442981' WHERE ordernumber = 'P2501030000143' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '287312' WHERE ordernumber = 'P2501030000145' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '439234' WHERE ordernumber = 'P2501030000146' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443329' WHERE ordernumber = 'P2501030000148' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '380454' WHERE ordernumber = 'P2501030000149' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '436816' WHERE ordernumber = 'P2501030000151' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '443332' WHERE ordernumber = 'P2501030000153' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '43782' WHERE ordernumber = 'P2501030000154' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '216444' WHERE ordernumber = 'P2501030000155' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '340921' WHERE ordernumber = 'P2501030000156' 2025-01-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '99632' WHERE ordernumber = 'P2501030000158' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '252840' WHERE ordernumber = 'P2501030000159' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '433108' WHERE ordernumber = 'P2501030000164' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '433108' WHERE ordernumber = 'P2501030000165' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '398173' WHERE ordernumber = 'P2501030000166' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443341' WHERE ordernumber = 'P2501030000167' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443342' WHERE ordernumber = 'P2501030000168' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '442645' WHERE ordernumber = 'P2501030000171' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '418691' WHERE ordernumber = 'P2501030000175' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '301109' WHERE ordernumber = 'P2501030000178' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '335527' WHERE ordernumber = 'P2501030000180' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '106989' WHERE ordernumber = 'P2501030000181' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '313319' WHERE ordernumber = 'P2501030000182' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '313319' WHERE ordernumber = 'P2501030000183' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '442044' WHERE ordernumber = 'P2501030000186' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443354' WHERE ordernumber = 'P2501030000195' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '352577' WHERE ordernumber = 'P2501030000196' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '263538' WHERE ordernumber = 'P2501030000197' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443356' WHERE ordernumber = 'P2501030000199' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '202673' WHERE ordernumber = 'P2501030000200' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '350007' WHERE ordernumber = 'P2501030000216' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443369' WHERE ordernumber = 'P2501030000219' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '85369' WHERE ordernumber = 'P2501030000222' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '143126' WHERE ordernumber = 'P2501030000225' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '268618' WHERE ordernumber = 'P2501030000227' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '371741' WHERE ordernumber = 'P2501030000229' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '213784' WHERE ordernumber = 'P2501030000235' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '291133' WHERE ordernumber = 'P2501030000236' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '168014' WHERE ordernumber = 'P2501030000238' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '337262' WHERE ordernumber = 'P2501030000239' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443386' WHERE ordernumber = 'P2501030000241' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443389' WHERE ordernumber = 'P2501030000243' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '365072' WHERE ordernumber = 'P2501030000245' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '388263' WHERE ordernumber = 'P2501030000246' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '426291' WHERE ordernumber = 'P2501030000248' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443395' WHERE ordernumber = 'P2501030000249' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '420658' WHERE ordernumber = 'P2501030000251' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '442726' WHERE ordernumber = 'P2501030000253' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443398' WHERE ordernumber = 'P2501030000254' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443404' WHERE ordernumber = 'P2501030000256' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443397' WHERE ordernumber = 'P2501030000259' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443397' WHERE ordernumber = 'P2501030000261' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '408578' WHERE ordernumber = 'P2501030000262' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443405' WHERE ordernumber = 'P2501030000268' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '390880' WHERE ordernumber = 'P2501030000270' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '389004' WHERE ordernumber = 'P2501030000274' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '348186' WHERE ordernumber = 'P2501030000276' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '390880' WHERE ordernumber = 'P2501030000278' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '390880' WHERE ordernumber = 'P2501030000279' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '392303' WHERE ordernumber = 'P2501030000281' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '90879' WHERE ordernumber = 'P2501030000282' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443410' WHERE ordernumber = 'P2501030000285' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443413' WHERE ordernumber = 'P2501030000287' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443412' WHERE ordernumber = 'P2501030000288' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443415' WHERE ordernumber = 'P2501030000296' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '297429' WHERE ordernumber = 'P2501030000301' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443416' WHERE ordernumber = 'P2501030000302' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443417' WHERE ordernumber = 'P2501030000305' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '279525' WHERE ordernumber = 'P2501030000310' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443419' WHERE ordernumber = 'P2501030000314' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443418' WHERE ordernumber = 'P2501030000313' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443422' WHERE ordernumber = 'P2501030000317' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '289319' WHERE ordernumber = 'P2501030000318' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '300104' WHERE ordernumber = 'P2501030000319' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '102102' WHERE ordernumber = 'P2501030000321' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '399828' WHERE ordernumber = 'P2501030000323' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443424' WHERE ordernumber = 'P2501030000324' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443428' WHERE ordernumber = 'P2501030000329' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '270643' WHERE ordernumber = 'P2501030000331' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '334332' WHERE ordernumber = 'P2501030000334' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443430' WHERE ordernumber = 'P2501030000338' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '397203' WHERE ordernumber = 'P2501030000343' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443432' WHERE ordernumber = 'P2501030000344' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '429422' WHERE ordernumber = 'P2501030000350' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443433' WHERE ordernumber = 'P2501030000354' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '295512' WHERE ordernumber = 'P2501030000357' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '221817' WHERE ordernumber = 'P2501030000363' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '261374' WHERE ordernumber = 'P2501030000368' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443439' WHERE ordernumber = 'P2501030000370' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443443' WHERE ordernumber = 'P2501030000371' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443446' WHERE ordernumber = 'P2501030000378' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '309445' WHERE ordernumber = 'P2501030000380' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '439163' WHERE ordernumber = 'P2501030000381' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '440944' WHERE ordernumber = 'P2501030000385' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '148120' WHERE ordernumber = 'P2501030000387' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '287483' WHERE ordernumber = 'P2501030000390' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '442990' WHERE ordernumber = 'P2501030000392' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '343703' WHERE ordernumber = 'P2501030000394' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443451' WHERE ordernumber = 'P2501030000399' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '407516' WHERE ordernumber = 'P2501030000400' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '265263' WHERE ordernumber = 'P2501030000402' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '161047' WHERE ordernumber = 'P2501030000406' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '160798' WHERE ordernumber = 'P2501030000407' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443453' WHERE ordernumber = 'P2501030000408' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443456' WHERE ordernumber = 'P2501030000412' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443457' WHERE ordernumber = 'P2501030000415' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '140488' WHERE ordernumber = 'P2501030000417' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443459' WHERE ordernumber = 'P2501030000418' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443460' WHERE ordernumber = 'P2501030000419' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443265' WHERE ordernumber = 'P2501030000422' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443464' WHERE ordernumber = 'P2501030000425' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443466' WHERE ordernumber = 'P2501030000426' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443469' WHERE ordernumber = 'P2501030000428' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '279433' WHERE ordernumber = 'P2501030000430' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443471' WHERE ordernumber = 'P2501030000431' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '282325' WHERE ordernumber = 'P2501030000433' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443472' WHERE ordernumber = 'P2501030000438' 2025-01-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '443473' WHERE ordernumber = 'P2501030000439' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '284344' WHERE ordernumber = 'P2501030000442' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443476' WHERE ordernumber = 'P2501030000448' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '430708' WHERE ordernumber = 'P2501030000452' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443479' WHERE ordernumber = 'P2501030000453' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '248339' WHERE ordernumber = 'P2501030000458' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '241589' WHERE ordernumber = 'P2501030000462' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '309518' WHERE ordernumber = 'P2501030000464' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '235879' WHERE ordernumber = 'P2501030000466' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443482' WHERE ordernumber = 'P2501030000468' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '373915' WHERE ordernumber = 'P2501030000469' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '413099' WHERE ordernumber = 'P2501030000472' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '281285' WHERE ordernumber = 'P2501030000476' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '432175' WHERE ordernumber = 'P2501030000478' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '430662' WHERE ordernumber = 'P2501030000482' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '385549' WHERE ordernumber = 'P2501030000485' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443492' WHERE ordernumber = 'P2501030000486' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '439298' WHERE ordernumber = 'P2501030000489' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '392084' WHERE ordernumber = 'P2501030000491' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '345369' WHERE ordernumber = 'P2501030000492' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443497' WHERE ordernumber = 'P2501030000497' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '346343' WHERE ordernumber = 'P2501030000502' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '284526' WHERE ordernumber = 'P2501030000504' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '397239' WHERE ordernumber = 'P2501030000507' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '232264' WHERE ordernumber = 'P2501030000512' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443501' WHERE ordernumber = 'P2501030000517' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '439462' WHERE ordernumber = 'P2501030000523' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443502' WHERE ordernumber = 'P2501030000526' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443504' WHERE ordernumber = 'P2501030000527' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '437351' WHERE ordernumber = 'P2501030000529' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443506' WHERE ordernumber = 'P2501030000535' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '284526' WHERE ordernumber = 'P2501030000537' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443512' WHERE ordernumber = 'P2501030000541' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443513' WHERE ordernumber = 'P2501030000545' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '356068' WHERE ordernumber = 'P2501030000548' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443516' WHERE ordernumber = 'P2501030000550' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '297426' WHERE ordernumber = 'P2501030000553' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '261147' WHERE ordernumber = 'P2501030000554' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443519' WHERE ordernumber = 'P2501030000556' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443521' WHERE ordernumber = 'P2501030000557' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '434245' WHERE ordernumber = 'P2501030000558' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443523' WHERE ordernumber = 'P2501030000559' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443525' WHERE ordernumber = 'P2501030000560' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443526' WHERE ordernumber = 'P2501030000561' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '395576' WHERE ordernumber = 'P2501030000563' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '283570' WHERE ordernumber = 'P2501030000564' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '404120' WHERE ordernumber = 'P2501030000565' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '271493' WHERE ordernumber = 'P2501030000567' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '34187' WHERE ordernumber = 'P2501030000569' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443531' WHERE ordernumber = 'P2501030000570' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443528' WHERE ordernumber = 'P2501030000571' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443536' WHERE ordernumber = 'P2501030000577' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '392460' WHERE ordernumber = 'P2501030000578' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '358764' WHERE ordernumber = 'P2501030000580' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '270866' WHERE ordernumber = 'P2501030000582' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443540' WHERE ordernumber = 'P2501030000585' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '270866' WHERE ordernumber = 'P2501030000588' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443542' WHERE ordernumber = 'P2501030000589' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443545' WHERE ordernumber = 'P2501030000591' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443537' WHERE ordernumber = 'P2501030000592' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '428489' WHERE ordernumber = 'P2501030000595' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443548' WHERE ordernumber = 'P2501030000597' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '441740' WHERE ordernumber = 'P2501030000598' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '342467' WHERE ordernumber = 'P2501030000599' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '322793' WHERE ordernumber = 'P2501030000602' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443551' WHERE ordernumber = 'P2501030000604' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443553' WHERE ordernumber = 'P2501030000606' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443555' WHERE ordernumber = 'P2501030000608' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '230567' WHERE ordernumber = 'P2501030000611' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443556' WHERE ordernumber = 'P2501030000613' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443557' WHERE ordernumber = 'P2501030000616' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '334547' WHERE ordernumber = 'P2501030000617' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '194702' WHERE ordernumber = 'P2501030000620' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '361271' WHERE ordernumber = 'P2501030000621' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '261962' WHERE ordernumber = 'P2501030000623' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443561' WHERE ordernumber = 'P2501030000625' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '429558' WHERE ordernumber = 'P2501030000626' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443562' WHERE ordernumber = 'P2501030000627' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '211521' WHERE ordernumber = 'P2501030000628' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '91230' WHERE ordernumber = 'P2501030000631' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '353814' WHERE ordernumber = 'P2501030000633' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443564' WHERE ordernumber = 'P2501030000635' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '299353' WHERE ordernumber = 'P2501030000636' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443567' WHERE ordernumber = 'P2501030000642' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443569' WHERE ordernumber = 'P2501030000645' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '52478' WHERE ordernumber = 'P2501030000649' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '286928' WHERE ordernumber = 'P2501030000650' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443571' WHERE ordernumber = 'P2501030000652' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443572' WHERE ordernumber = 'P2501030000654' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443573' WHERE ordernumber = 'P2501030000656' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443575' WHERE ordernumber = 'P2501030000658' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '433516' WHERE ordernumber = 'P2501030000659' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '433516' WHERE ordernumber = 'P2501030000660' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '322944' WHERE ordernumber = 'P2501030000661' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443576' WHERE ordernumber = 'P2501030000662' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '305448' WHERE ordernumber = 'P2501030000665' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '386162' WHERE ordernumber = 'P2501030000670' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '301568' WHERE ordernumber = 'P2501030000673' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443578' WHERE ordernumber = 'P2501030000675' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443579' WHERE ordernumber = 'P2501030000676' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '128489' WHERE ordernumber = 'P2501030000678' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443581' WHERE ordernumber = 'P2501030000680' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '289391' WHERE ordernumber = 'P2501030000681' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443582' WHERE ordernumber = 'P2501030000682' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '97938' WHERE ordernumber = 'P2501030000684' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '443585' WHERE ordernumber = 'P2501030000692' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '441724' WHERE ordernumber = 'P2501030000694' 2025-01-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '212509' WHERE ordernumber = 'P2501030000695' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365226' WHERE ordernumber = 'P2501030000698' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443587' WHERE ordernumber = 'P2501030000701' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443588' WHERE ordernumber = 'P2501030000703' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443589' WHERE ordernumber = 'P2501030000704' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443590' WHERE ordernumber = 'P2501030000705' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '442198' WHERE ordernumber = 'P2501030000707' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443592' WHERE ordernumber = 'P2501030000710' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443593' WHERE ordernumber = 'P2501030000711' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443586' WHERE ordernumber = 'P2501030000713' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443597' WHERE ordernumber = 'P2501030000716' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443598' WHERE ordernumber = 'P2501030000717' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '135621' WHERE ordernumber = 'P2501030000723' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443603' WHERE ordernumber = 'P2501030000725' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443604' WHERE ordernumber = 'P2501030000728' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '206638' WHERE ordernumber = 'P2501030000729' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443599' WHERE ordernumber = 'P2501030000730' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443605' WHERE ordernumber = 'P2501030000732' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443606' WHERE ordernumber = 'P2501030000736' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443607' WHERE ordernumber = 'P2501030000737' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '422341' WHERE ordernumber = 'P2501030000745' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443611' WHERE ordernumber = 'P2501030000746' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '380156' WHERE ordernumber = 'P2501030000748' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443612' WHERE ordernumber = 'P2501030000749' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443615' WHERE ordernumber = 'P2501030000753' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '255656' WHERE ordernumber = 'P2501030000754' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '136646' WHERE ordernumber = 'P2501030000755' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '317939' WHERE ordernumber = 'P2501030000758' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443619' WHERE ordernumber = 'P2501030000761' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443616' WHERE ordernumber = 'P2501030000763' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443622' WHERE ordernumber = 'P2501030000766' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '431607' WHERE ordernumber = 'P2501030000768' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443623' WHERE ordernumber = 'P2501030000769' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443625' WHERE ordernumber = 'P2501030000771' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443627' WHERE ordernumber = 'P2501030000772' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '225202' WHERE ordernumber = 'P2501030000774' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '366299' WHERE ordernumber = 'P2501030000781' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443629' WHERE ordernumber = 'P2501030000783' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443630' WHERE ordernumber = 'P2501030000784' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443631' WHERE ordernumber = 'P2501030000786' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443632' WHERE ordernumber = 'P2501030000787' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '81119' WHERE ordernumber = 'P2501030000788' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '443609' WHERE ordernumber = 'P2501030000791' 2025-01-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '391255' WHERE ordernumber = 'P2501030000793'