2025-03-04 01:00:02 -- 將會員中心id寫入data-lake 2025-03-04 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-03-03%'; 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '429024' WHERE ordernumber = 'P2503030000013' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '200771' WHERE ordernumber = 'P2503030000015' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '456594' WHERE ordernumber = 'P2503030000017' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '312940' WHERE ordernumber = 'P2503030000021' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459232' WHERE ordernumber = 'P2503030000023' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459234' WHERE ordernumber = 'P2503030000027' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '432184' WHERE ordernumber = 'P2503030000028' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '252761' WHERE ordernumber = 'P2503030000030' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459236' WHERE ordernumber = 'P2503030000033' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '154682' WHERE ordernumber = 'P2503030000034' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459237' WHERE ordernumber = 'P2503030000037' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '44684' WHERE ordernumber = 'P2503030000038' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459240' WHERE ordernumber = 'P2503030000039' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '410427' WHERE ordernumber = 'P2503030000040' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '308188' WHERE ordernumber = 'P2503030000045' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '241889' WHERE ordernumber = 'P2503030000046' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '458514' WHERE ordernumber = 'P2503030000047' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '428217' WHERE ordernumber = 'P2503030000048' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '277492' WHERE ordernumber = 'P2503030000049' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '395776' WHERE ordernumber = 'P2503030000051' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '271209' WHERE ordernumber = 'P2503030000052' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '353308' WHERE ordernumber = 'P2503030000055' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459242' WHERE ordernumber = 'P2503030000056' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '149838' WHERE ordernumber = 'P2503030000057' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '149838' WHERE ordernumber = 'P2503030000060' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459242' WHERE ordernumber = 'P2503030000062' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459247' WHERE ordernumber = 'P2503030000073' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '404116' WHERE ordernumber = 'P2503030000074' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459249' WHERE ordernumber = 'P2503030000075' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459247' WHERE ordernumber = 'P2503030000079' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459246' WHERE ordernumber = 'P2503030000080' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '380354' WHERE ordernumber = 'P2503030000082' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459250' WHERE ordernumber = 'P2503030000085' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459251' WHERE ordernumber = 'P2503030000086' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459252' WHERE ordernumber = 'P2503030000088' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '395581' WHERE ordernumber = 'P2503030000089' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459253' WHERE ordernumber = 'P2503030000095' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '395581' WHERE ordernumber = 'P2503030000096' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '421888' WHERE ordernumber = 'P2503030000097' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '440495' WHERE ordernumber = 'P2503030000098' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459254' WHERE ordernumber = 'P2503030000100' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459255' WHERE ordernumber = 'P2503030000102' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459256' WHERE ordernumber = 'P2503030000103' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459257' WHERE ordernumber = 'P2503030000105' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '303823' WHERE ordernumber = 'P2503030000111' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '293891' WHERE ordernumber = 'P2503030000112' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '224684' WHERE ordernumber = 'P2503030000115' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '376234' WHERE ordernumber = 'P2503030000122' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '392137' WHERE ordernumber = 'P2503030000123' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '380031' WHERE ordernumber = 'P2503030000127' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '459263' WHERE ordernumber = 'P2503030000131' 2025-03-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '305444' WHERE ordernumber = 'P2503030000134' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459265' WHERE ordernumber = 'P2503030000138' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459267' WHERE ordernumber = 'P2503030000140' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459268' WHERE ordernumber = 'P2503030000142' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459269' WHERE ordernumber = 'P2503030000143' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '397393' WHERE ordernumber = 'P2503030000144' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459270' WHERE ordernumber = 'P2503030000147' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '86200' WHERE ordernumber = 'P2503030000148' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459271' WHERE ordernumber = 'P2503030000149' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '103972' WHERE ordernumber = 'P2503030000152' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '287841' WHERE ordernumber = 'P2503030000153' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '120333' WHERE ordernumber = 'P2503030000155' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459273' WHERE ordernumber = 'P2503030000156' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '458275' WHERE ordernumber = 'P2503030000157' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459272' WHERE ordernumber = 'P2503030000160' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '95398' WHERE ordernumber = 'P2503030000163' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459274' WHERE ordernumber = 'P2503030000164' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '404532' WHERE ordernumber = 'P2503030000165' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459277' WHERE ordernumber = 'P2503030000168' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459278' WHERE ordernumber = 'P2503030000169' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '285362' WHERE ordernumber = 'P2503030000172' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '239455' WHERE ordernumber = 'P2503030000180' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459279' WHERE ordernumber = 'P2503030000181' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '238136' WHERE ordernumber = 'P2503030000182' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '139381' WHERE ordernumber = 'P2503030000187' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459280' WHERE ordernumber = 'P2503030000190' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '457346' WHERE ordernumber = 'P2503030000193' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '245332' WHERE ordernumber = 'P2503030000197' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459281' WHERE ordernumber = 'P2503030000198' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '458459' WHERE ordernumber = 'P2503030000200' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '298291' WHERE ordernumber = 'P2503030000202' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459282' WHERE ordernumber = 'P2503030000203' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459283' WHERE ordernumber = 'P2503030000204' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459284' WHERE ordernumber = 'P2503030000206' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '400947' WHERE ordernumber = 'P2503030000208' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459285' WHERE ordernumber = 'P2503030000211' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459286' WHERE ordernumber = 'P2503030000213' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459287' WHERE ordernumber = 'P2503030000217' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459288' WHERE ordernumber = 'P2503030000218' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459289' WHERE ordernumber = 'P2503030000221' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459287' WHERE ordernumber = 'P2503030000222' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '429562' WHERE ordernumber = 'P2503030000223' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459291' WHERE ordernumber = 'P2503030000225' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459290' WHERE ordernumber = 'P2503030000227' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '72734' WHERE ordernumber = 'P2503030000229' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '451384' WHERE ordernumber = 'P2503030000231' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459293' WHERE ordernumber = 'P2503030000234' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '394376' WHERE ordernumber = 'P2503030000236' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '349998' WHERE ordernumber = 'P2503030000238' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '349998' WHERE ordernumber = 'P2503030000242' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '406506' WHERE ordernumber = 'P2503030000243' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459295' WHERE ordernumber = 'P2503030000245' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '224596' WHERE ordernumber = 'P2503030000246' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459296' WHERE ordernumber = 'P2503030000249' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '437537' WHERE ordernumber = 'P2503030000254' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459297' WHERE ordernumber = 'P2503030000260' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '289933' WHERE ordernumber = 'P2503030000261' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459299' WHERE ordernumber = 'P2503030000268' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '121245' WHERE ordernumber = 'P2503030000273' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '360796' WHERE ordernumber = 'P2503030000276' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '264478' WHERE ordernumber = 'P2503030000279' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459300' WHERE ordernumber = 'P2503030000282' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459301' WHERE ordernumber = 'P2503030000286' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459303' WHERE ordernumber = 'P2503030000289' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '95584' WHERE ordernumber = 'P2503030000291' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '454467' WHERE ordernumber = 'P2503030000292' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459307' WHERE ordernumber = 'P2503030000294' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '317906' WHERE ordernumber = 'P2503030000295' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '345636' WHERE ordernumber = 'P2503030000297' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '108803' WHERE ordernumber = 'P2503030000299' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459308' WHERE ordernumber = 'P2503030000301' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459308' WHERE ordernumber = 'P2503030000302' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '266798' WHERE ordernumber = 'P2503030000304' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '89653' WHERE ordernumber = 'P2503030000308' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '252036' WHERE ordernumber = 'P2503030000309' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459310' WHERE ordernumber = 'P2503030000319' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '347710' WHERE ordernumber = 'P2503030000320' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '251842' WHERE ordernumber = 'P2503030000321' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459311' WHERE ordernumber = 'P2503030000322' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '392465' WHERE ordernumber = 'P2503030000324' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459313' WHERE ordernumber = 'P2503030000325' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459314' WHERE ordernumber = 'P2503030000328' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459315' WHERE ordernumber = 'P2503030000331' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '392009' WHERE ordernumber = 'P2503030000334' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '281809' WHERE ordernumber = 'P2503030000335' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459316' WHERE ordernumber = 'P2503030000337' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '356393' WHERE ordernumber = 'P2503030000340' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '456851' WHERE ordernumber = 'P2503030000343' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459317' WHERE ordernumber = 'P2503030000344' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459318' WHERE ordernumber = 'P2503030000345' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459320' WHERE ordernumber = 'P2503030000349' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '299342' WHERE ordernumber = 'P2503030000351' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459321' WHERE ordernumber = 'P2503030000353' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '457412' WHERE ordernumber = 'P2503030000354' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '291082' WHERE ordernumber = 'P2503030000357' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '291082' WHERE ordernumber = 'P2503030000359' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459324' WHERE ordernumber = 'P2503030000362' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '358329' WHERE ordernumber = 'P2503030000365' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '397485' WHERE ordernumber = 'P2503030000368' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459327' WHERE ordernumber = 'P2503030000371' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '96806' WHERE ordernumber = 'P2503030000372' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459326' WHERE ordernumber = 'P2503030000374' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459328' WHERE ordernumber = 'P2503030000375' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459330' WHERE ordernumber = 'P2503030000382' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '457337' WHERE ordernumber = 'P2503030000384' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459332' WHERE ordernumber = 'P2503030000385' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459333' WHERE ordernumber = 'P2503030000386' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '284074' WHERE ordernumber = 'P2503030000389' 2025-03-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '459334' WHERE ordernumber = 'P2503030000393' 2025-03-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '378296' WHERE ordernumber = 'P2503030000396'