2025-01-11 01:00:02 -- 將會員中心id寫入data-lake 2025-01-11 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-10%'; 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '438822' WHERE ordernumber = 'P2501100000021' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '357006' WHERE ordernumber = 'P2501100000022' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '276041' WHERE ordernumber = 'P2501100000025' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447170' WHERE ordernumber = 'P2501100000028' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '439782' WHERE ordernumber = 'P2501100000029' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '428599' WHERE ordernumber = 'P2501100000031' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '218549' WHERE ordernumber = 'P2501100000032' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447171' WHERE ordernumber = 'P2501100000034' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '446657' WHERE ordernumber = 'P2501100000039' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '291015' WHERE ordernumber = 'P2501100000041' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '429723' WHERE ordernumber = 'P2501100000042' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447175' WHERE ordernumber = 'P2501100000043' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '432054' WHERE ordernumber = 'P2501100000044' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447175' WHERE ordernumber = 'P2501100000046' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447178' WHERE ordernumber = 'P2501100000048' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447179' WHERE ordernumber = 'P2501100000049' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '431154' WHERE ordernumber = 'P2501100000053' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '441547' WHERE ordernumber = 'P2501100000054' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447185' WHERE ordernumber = 'P2501100000058' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '283039' WHERE ordernumber = 'P2501100000062' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447182' WHERE ordernumber = 'P2501100000065' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '105856' WHERE ordernumber = 'P2501100000066' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '446648' WHERE ordernumber = 'P2501100000068' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '274684' WHERE ordernumber = 'P2501100000070' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '80892' WHERE ordernumber = 'P2501100000072' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '442898' WHERE ordernumber = 'P2501100000073' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447177' WHERE ordernumber = 'P2501100000075' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447152' WHERE ordernumber = 'P2501100000077' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '398047' WHERE ordernumber = 'P2501100000079' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '93731' WHERE ordernumber = 'P2501100000081' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '378584' WHERE ordernumber = 'P2501100000082' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '270705' WHERE ordernumber = 'P2501100000085' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P2501100000086' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '334056' WHERE ordernumber = 'P2501100000087' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '334056' WHERE ordernumber = 'P2501100000089' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '266795' WHERE ordernumber = 'P2501100000090' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '251911' WHERE ordernumber = 'P2501100000091' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447196' WHERE ordernumber = 'P2501100000093' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447193' WHERE ordernumber = 'P2501100000094' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '373748' WHERE ordernumber = 'P2501100000095' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '250986' WHERE ordernumber = 'P2501100000096' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '74135' WHERE ordernumber = 'P2501100000097' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '432453' WHERE ordernumber = 'P2501100000099' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '386641' WHERE ordernumber = 'P2501100000102' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447201' WHERE ordernumber = 'P2501100000103' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '95916' WHERE ordernumber = 'P2501100000105' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447207' WHERE ordernumber = 'P2501100000110' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '436238' WHERE ordernumber = 'P2501100000111' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '348545' WHERE ordernumber = 'P2501100000113' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '451' WHERE ordernumber = 'P2501100000114' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '317718' WHERE ordernumber = 'P2501100000115' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '99139' WHERE ordernumber = 'P2501100000119' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '383213' WHERE ordernumber = 'P2501100000121' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '440081' WHERE ordernumber = 'P2501100000128' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '273139' WHERE ordernumber = 'P2501100000132' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '134860' WHERE ordernumber = 'P2501100000133' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '136519' WHERE ordernumber = 'P2501100000135' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '125988' WHERE ordernumber = 'P2501100000136' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '276976' WHERE ordernumber = 'P2501100000139' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447213' WHERE ordernumber = 'P2501100000140' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447218' WHERE ordernumber = 'P2501100000142' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '353854' WHERE ordernumber = 'P2501100000143' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '129005' WHERE ordernumber = 'P2501100000144' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '104585' WHERE ordernumber = 'P2501100000148' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '284900' WHERE ordernumber = 'P2501100000150' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447220' WHERE ordernumber = 'P2501100000151' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447223' WHERE ordernumber = 'P2501100000155' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '217505' WHERE ordernumber = 'P2501100000161' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447221' WHERE ordernumber = 'P2501100000162' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447225' WHERE ordernumber = 'P2501100000166' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '52833' WHERE ordernumber = 'P2501100000167' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '164500' WHERE ordernumber = 'P2501100000169' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '442981' WHERE ordernumber = 'P2501100000170' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '215802' WHERE ordernumber = 'P2501100000173' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '434922' WHERE ordernumber = 'P2501100000176' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '52368' WHERE ordernumber = 'P2501100000177' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447226' WHERE ordernumber = 'P2501100000180' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '392863' WHERE ordernumber = 'P2501100000184' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447230' WHERE ordernumber = 'P2501100000188' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447230' WHERE ordernumber = 'P2501100000189' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447232' WHERE ordernumber = 'P2501100000190' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '326967' WHERE ordernumber = 'P2501100000191' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447235' WHERE ordernumber = 'P2501100000194' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '431322' WHERE ordernumber = 'P2501100000201' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '17684' WHERE ordernumber = 'P2501100000202' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '329313' WHERE ordernumber = 'P2501100000204' 2025-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '447240' WHERE ordernumber = 'P2501100000206' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '446754' WHERE ordernumber = 'P2501100000210' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447244' WHERE ordernumber = 'P2501100000216' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '397258' WHERE ordernumber = 'P2501100000218' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '93826' WHERE ordernumber = 'P2501100000220' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '224842' WHERE ordernumber = 'P2501100000221' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '401548' WHERE ordernumber = 'P2501100000222' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '390626' WHERE ordernumber = 'P2501100000223' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '263084' WHERE ordernumber = 'P2501100000227' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '138191' WHERE ordernumber = 'P2501100000230' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '263084' WHERE ordernumber = 'P2501100000236' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '391342' WHERE ordernumber = 'P2501100000237' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '391342' WHERE ordernumber = 'P2501100000241' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '110093' WHERE ordernumber = 'P2501100000249' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '428572' WHERE ordernumber = 'P2501100000253' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '277858' WHERE ordernumber = 'P2501100000257' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '104945' WHERE ordernumber = 'P2501100000258' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '207841' WHERE ordernumber = 'P2501100000259' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '319172' WHERE ordernumber = 'P2501100000261' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '96156' WHERE ordernumber = 'P2501100000266' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '364081' WHERE ordernumber = 'P2501100000268' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447254' WHERE ordernumber = 'P2501100000271' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '162674' WHERE ordernumber = 'P2501100000274' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '272707' WHERE ordernumber = 'P2501100000277' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '352793' WHERE ordernumber = 'P2501100000278' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '272707' WHERE ordernumber = 'P2501100000280' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '162674' WHERE ordernumber = 'P2501100000281' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '400728' WHERE ordernumber = 'P2501100000283' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '216864' WHERE ordernumber = 'P2501100000287' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447263' WHERE ordernumber = 'P2501100000295' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '236881' WHERE ordernumber = 'P2501100000303' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '400901' WHERE ordernumber = 'P2501100000304' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P2501100000313' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '207841' WHERE ordernumber = 'P2501100000314' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '207841' WHERE ordernumber = 'P2501100000316' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447266' WHERE ordernumber = 'P2501100000318' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '433074' WHERE ordernumber = 'P2501100000324' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '277145' WHERE ordernumber = 'P2501100000325' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '240414' WHERE ordernumber = 'P2501100000329' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '412640' WHERE ordernumber = 'P2501100000331' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '433594' WHERE ordernumber = 'P2501100000332' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '437499' WHERE ordernumber = 'P2501100000335' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447276' WHERE ordernumber = 'P2501100000344' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '263282' WHERE ordernumber = 'P2501100000345' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '374458' WHERE ordernumber = 'P2501100000346' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447274' WHERE ordernumber = 'P2501100000348' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '87780' WHERE ordernumber = 'P2501100000350' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '258439' WHERE ordernumber = 'P2501100000352' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '296858' WHERE ordernumber = 'P2501100000354' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '296858' WHERE ordernumber = 'P2501100000359' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '94814' WHERE ordernumber = 'P2501100000360' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '435118' WHERE ordernumber = 'P2501100000365' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '443756' WHERE ordernumber = 'P2501100000367' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '351190' WHERE ordernumber = 'P2501100000375' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '284529' WHERE ordernumber = 'P2501100000377' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '316660' WHERE ordernumber = 'P2501100000382' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447170' WHERE ordernumber = 'P2501100000385' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '391150' WHERE ordernumber = 'P2501100000390' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '334987' WHERE ordernumber = 'P2501100000392' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '261804' WHERE ordernumber = 'P2501100000400' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447279' WHERE ordernumber = 'P2501100000402' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447286' WHERE ordernumber = 'P2501100000407' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '164139' WHERE ordernumber = 'P2501100000409' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '164139' WHERE ordernumber = 'P2501100000411' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '257042' WHERE ordernumber = 'P2501100000420' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '228412' WHERE ordernumber = 'P2501100000421' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '427237' WHERE ordernumber = 'P2501100000423' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447288' WHERE ordernumber = 'P2501100000425' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447287' WHERE ordernumber = 'P2501100000424' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447290' WHERE ordernumber = 'P2501100000428' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447291' WHERE ordernumber = 'P2501100000429' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389962' WHERE ordernumber = 'P2501100000435' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '101403' WHERE ordernumber = 'P2501100000437' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '97769' WHERE ordernumber = 'P2501100000447' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447299' WHERE ordernumber = 'P2501100000452' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447300' WHERE ordernumber = 'P2501100000456' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '117509' WHERE ordernumber = 'P2501100000460' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447301' WHERE ordernumber = 'P2501100000463' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '445106' WHERE ordernumber = 'P2501100000464' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '119729' WHERE ordernumber = 'P2501100000475' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '89765' WHERE ordernumber = 'P2501100000476' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '228204' WHERE ordernumber = 'P2501100000477' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447000' WHERE ordernumber = 'P2501100000479' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '144274' WHERE ordernumber = 'P2501100000484' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447305' WHERE ordernumber = 'P2501100000489' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '425890' WHERE ordernumber = 'P2501100000490' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '314562' WHERE ordernumber = 'P2501100000491' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447308' WHERE ordernumber = 'P2501100000493' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '316477' WHERE ordernumber = 'P2501100000494' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447309' WHERE ordernumber = 'P2501100000495' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447311' WHERE ordernumber = 'P2501100000496' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '436733' WHERE ordernumber = 'P2501100000497' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447312' WHERE ordernumber = 'P2501100000499' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '303679' WHERE ordernumber = 'P2501100000501' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '338682' WHERE ordernumber = 'P2501100000504' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447316' WHERE ordernumber = 'P2501100000506' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '398511' WHERE ordernumber = 'P2501100000508' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '313052' WHERE ordernumber = 'P2501100000515' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '394172' WHERE ordernumber = 'P2501100000516' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '437355' WHERE ordernumber = 'P2501100000518' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '292568' WHERE ordernumber = 'P2501100000519' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447320' WHERE ordernumber = 'P2501100000521' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '405596' WHERE ordernumber = 'P2501100000522' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447323' WHERE ordernumber = 'P2501100000528' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '447324' WHERE ordernumber = 'P2501100000529' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '419908' WHERE ordernumber = 'P2501100000533' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '438589' WHERE ordernumber = 'P2501100000535' 2025-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '436129' WHERE ordernumber = 'P2501100000536' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '228029' WHERE ordernumber = 'P2501100000537' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '441923' WHERE ordernumber = 'P2501100000538' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447328' WHERE ordernumber = 'P2501100000541' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447317' WHERE ordernumber = 'P2501100000543' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447329' WHERE ordernumber = 'P2501100000546' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '342840' WHERE ordernumber = 'P2501100000547' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '66331' WHERE ordernumber = 'P2501100000550' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447330' WHERE ordernumber = 'P2501100000553' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '436129' WHERE ordernumber = 'P2501100000561' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '87297' WHERE ordernumber = 'P2501100000563' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447334' WHERE ordernumber = 'P2501100000564' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447335' WHERE ordernumber = 'P2501100000569' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '93655' WHERE ordernumber = 'P2501100000576' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '394714' WHERE ordernumber = 'P2501100000578' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447337' WHERE ordernumber = 'P2501100000580' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '380735' WHERE ordernumber = 'P2501100000581' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447337' WHERE ordernumber = 'P2501100000582' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '375325' WHERE ordernumber = 'P2501100000583' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '269583' WHERE ordernumber = 'P2501100000588' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '232968' WHERE ordernumber = 'P2501100000593' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '371641' WHERE ordernumber = 'P2501100000597' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '443304' WHERE ordernumber = 'P2501100000600' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '267465' WHERE ordernumber = 'P2501100000602' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447343' WHERE ordernumber = 'P2501100000603' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447341' WHERE ordernumber = 'P2501100000607' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447347' WHERE ordernumber = 'P2501100000608' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '271168' WHERE ordernumber = 'P2501100000611' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447350' WHERE ordernumber = 'P2501100000613' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '123673' WHERE ordernumber = 'P2501100000618' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '446287' WHERE ordernumber = 'P2501100000620' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '258483' WHERE ordernumber = 'P2501100000631' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '446314' WHERE ordernumber = 'P2501100000634' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '234948' WHERE ordernumber = 'P2501100000635' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '114727' WHERE ordernumber = 'P2501100000641' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447354' WHERE ordernumber = 'P2501100000647' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447343' WHERE ordernumber = 'P2501100000650' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '423032' WHERE ordernumber = 'P2501100000652' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447355' WHERE ordernumber = 'P2501100000653' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447357' WHERE ordernumber = 'P2501100000662' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447359' WHERE ordernumber = 'P2501100000664' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '263180' WHERE ordernumber = 'P2501100000666' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '442146' WHERE ordernumber = 'P2501100000670' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447362' WHERE ordernumber = 'P2501100000672' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '99900' WHERE ordernumber = 'P2501100000675' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '305444' WHERE ordernumber = 'P2501100000686' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447363' WHERE ordernumber = 'P2501100000688' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '305444' WHERE ordernumber = 'P2501100000690' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '268233' WHERE ordernumber = 'P2501100000693' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '339970' WHERE ordernumber = 'P2501100000694' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447365' WHERE ordernumber = 'P2501100000697' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '305549' WHERE ordernumber = 'P2501100000698' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '228529' WHERE ordernumber = 'P2501100000700' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447372' WHERE ordernumber = 'P2501100000702' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '356476' WHERE ordernumber = 'P2501100000705' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '314886' WHERE ordernumber = 'P2501100000708' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '428160' WHERE ordernumber = 'P2501100000709' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447375' WHERE ordernumber = 'P2501100000714' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447374' WHERE ordernumber = 'P2501100000713' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '428475' WHERE ordernumber = 'P2501100000715' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447374' WHERE ordernumber = 'P2501100000718' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '231296' WHERE ordernumber = 'P2501100000721' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447369' WHERE ordernumber = 'P2501100000723' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447377' WHERE ordernumber = 'P2501100000724' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447369' WHERE ordernumber = 'P2501100000725' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '303400' WHERE ordernumber = 'P2501100000728' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '321471' WHERE ordernumber = 'P2501100000729' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447377' WHERE ordernumber = 'P2501100000731' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '414906' WHERE ordernumber = 'P2501100000733' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447380' WHERE ordernumber = 'P2501100000732' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447381' WHERE ordernumber = 'P2501100000735' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '408880' WHERE ordernumber = 'P2501100000737' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '307113' WHERE ordernumber = 'P2501100000744' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447386' WHERE ordernumber = 'P2501100000753' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '339374' WHERE ordernumber = 'P2501100000754' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '403634' WHERE ordernumber = 'P2501100000770' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447391' WHERE ordernumber = 'P2501100000776' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447395' WHERE ordernumber = 'P2501100000784' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447396' WHERE ordernumber = 'P2501100000785' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '394735' WHERE ordernumber = 'P2501100000790' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '400936' WHERE ordernumber = 'P2501100000794' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '169960' WHERE ordernumber = 'P2501100000795' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '201629' WHERE ordernumber = 'P2501100000799' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '79320' WHERE ordernumber = 'P2501100000800' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '209803' WHERE ordernumber = 'P2501100000802' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '446227' WHERE ordernumber = 'P2501100000806' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447399' WHERE ordernumber = 'P2501100000816' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '430433' WHERE ordernumber = 'P2501100000820' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '342003' WHERE ordernumber = 'P2501100000821' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '318130' WHERE ordernumber = 'P2501100000822' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447160' WHERE ordernumber = 'P2501100000833' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '215448' WHERE ordernumber = 'P2501100000835' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447307' WHERE ordernumber = 'P2501100000836' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447307' WHERE ordernumber = 'P2501100000837' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '359049' WHERE ordernumber = 'P2501100000839' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '437032' WHERE ordernumber = 'P2501100000844' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '437032' WHERE ordernumber = 'P2501100000845' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '447405' WHERE ordernumber = 'P2501100000848' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '444751' WHERE ordernumber = 'P2501100000851' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '444751' WHERE ordernumber = 'P2501100000852' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '444751' WHERE ordernumber = 'P2501100000855' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '445267' WHERE ordernumber = 'P2501100000857' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '273391' WHERE ordernumber = 'P2501100000858' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '397034' WHERE ordernumber = 'P2501100000860' 2025-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '40950' WHERE ordernumber = 'P2501100000862' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '125080' WHERE ordernumber = 'P2501100000863' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '347929' WHERE ordernumber = 'P2501100000866' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '397034' WHERE ordernumber = 'P2501100000870' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '340479' WHERE ordernumber = 'P2501100000874' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '135457' WHERE ordernumber = 'P2501100000880' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '313600' WHERE ordernumber = 'P2501100000882' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '412052' WHERE ordernumber = 'P2501100000884' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447417' WHERE ordernumber = 'P2501100000886' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '232128' WHERE ordernumber = 'P2501100000888' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447417' WHERE ordernumber = 'P2501100000889' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '423057' WHERE ordernumber = 'P2501100000891' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447419' WHERE ordernumber = 'P2501100000892' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447420' WHERE ordernumber = 'P2501100000894' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '238186' WHERE ordernumber = 'P2501100000895' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '372611' WHERE ordernumber = 'P2501100000898' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '241840' WHERE ordernumber = 'P2501100000911' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '433002' WHERE ordernumber = 'P2501100000912' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '387534' WHERE ordernumber = 'P2501100000914' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447422' WHERE ordernumber = 'P2501100000917' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447423' WHERE ordernumber = 'P2501100000918' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '67537' WHERE ordernumber = 'P2501100000925' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '235429' WHERE ordernumber = 'P2501100000929' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '95757' WHERE ordernumber = 'P2501100000931' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '95757' WHERE ordernumber = 'P2501100000933' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '412215' WHERE ordernumber = 'P2501100000939' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '412215' WHERE ordernumber = 'P2501100000945' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '315404' WHERE ordernumber = 'P2501100000946' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '339687' WHERE ordernumber = 'P2501100000950' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '402235' WHERE ordernumber = 'P2501100000952' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '234266' WHERE ordernumber = 'P2501100000955' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '288124' WHERE ordernumber = 'P2501100000956' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447433' WHERE ordernumber = 'P2501100000964' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447432' WHERE ordernumber = 'P2501100000965' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '404126' WHERE ordernumber = 'P2501100000974' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447438' WHERE ordernumber = 'P2501100000979' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '55006' WHERE ordernumber = 'P2501100000982' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447444' WHERE ordernumber = 'P2501100000989' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '391827' WHERE ordernumber = 'P2501100000994' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447446' WHERE ordernumber = 'P2501100000996' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '24' WHERE ordernumber = 'P2501100000998' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '447438' WHERE ordernumber = 'P2501100000999' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '98721' WHERE ordernumber = 'P2501100001000' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '442557' WHERE ordernumber = 'P2501100001003' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '437583' WHERE ordernumber = 'P2501100001004' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '436107' WHERE ordernumber = 'P2501100001007' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '384434' WHERE ordernumber = 'P2501100001008' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '374455' WHERE ordernumber = 'P2501100001009' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '129909' WHERE ordernumber = 'P2501100001010' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '266880' WHERE ordernumber = 'P2501100001012' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '346006' WHERE ordernumber = 'P2501100001016' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '27925' WHERE ordernumber = 'P2501100001018' 2025-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '284936' WHERE ordernumber = 'P2501100001019'