create table getvalidaffiliates
(
id serial,
affid varchar(200),
paymentmethod varchar(500),
isvalidrules boolean,
managername varchar(300),
afftype varchar(200),
checkat timestamp,
firstunpaid date,
affname varchar(1000),
amount varchar(50),
pbalance varchar(50),
event_date date
);
INSERT INTO getvalidaffiliates (id, affid, paymentmethod, isvalidrules, managername, afftype, checkat, firstunpaid, affname, amount, pbalance, event_date) VALUES (493, '6de758c2', 'Bank Wire Transfer', 0, 'Ostapenko Evgenii MB', 'directdeals', '2022-05-16 10:38:19', '2021-02-03', 'Ihor ApproachX', '59561.89', '59561.89', '2022-05-16');
INSERT INTO getvalidaffiliates (id, affid, paymentmethod, isvalidrules, managername, afftype, checkat, firstunpaid, affname, amount, pbalance, event_date) VALUES (494, 'e6ae8183', 'Paxum', 0, 'Ostapenko Evgenii MB', 'directdeals', '2022-05-16 10:38:19', '2020-05-18', 'Davide Grisoni', '40959.65', '41090.05', '2022-05-16');
INSERT INTO getvalidaffiliates (id, affid, paymentmethod, isvalidrules, managername, afftype, checkat, firstunpaid, affname, amount, pbalance, event_date) VALUES (495, '7dc013ef', 'Bank Wire Transfer', 0, 'Svetlana Ostroglyad MB', 'directdeals', '2022-05-16 10:38:19', '2020-06-22', 'Nils Becker', '21233.50', '21942.00', '2022-05-16');
INSERT INTO getvalidaffiliates (id, affid, paymentmethod, isvalidrules, managername, afftype, checkat, firstunpaid, affname, amount, pbalance, event_date) VALUES (496, '59d11b6a', 'Paxum', 0, 'Svetlana Ostroglyad MB', 'other', '2022-05-16 10:38:24', '2020-05-18', 'jonah trenton', '109098.90', '109921.60', '2022-05-16');
SELECT count(distinct affid) countId FROM getvalidaffiliates WHERE `event_date` = current_date;
SELECT * FROM getvalidaffiliates WHERE `event_date` = current_date;