SELECT DISTINCT(CONCAT(`utc_date`,`aff_id`,`tid1`,`tid2`,`tid3`,`tid4`)) AS cc,`utc_date`,`aff_id`,`tid1`,`tid2`,`tid3`,`tid4`,count(*) as tot_click FROM k9ti_affiliate_click_data WHERE id > 266040 GROUP BY (cc),`utc_date`,`aff_id`,`tid1`,`tid2`,`tid3`,`tid4`
SELECT * FROM k9ti_affiliate_reports WHERE `utc_date`='2025-04-28' AND aff_id='' AND (tid1='' OR tid1 is null) AND (tid2='' OR tid2 is null) AND (tid3='' OR tid3 is null) AND (tid4='' OR tid4 is null)SELECT * FROM k9ti_affiliate_reports WHERE `utc_date`='2025-05-04' AND aff_id='' AND (tid1='' OR tid1 is null) AND (tid2='' OR tid2 is null) AND (tid3='' OR tid3 is null) AND (tid4='' OR tid4 is null)Click Data - Done
SELECT DISTINCT(CONCAT(aff_id)) as aff,`utc_date`, count(*) as tot_leads FROM `k9ti_subscribers` WHERE aff_id!='' AND utm_source='referrer' AND subid > 9167 GROUP BY aff_id,`utc_date`

Leads Data - Done
max_id_sales --------1558

Sales Data - Records Not Available For Report