Click Data - Records Not Available For Report
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 > 9023 GROUP BY aff_id,`utc_date`

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

SELECT tbl1.`record`,code,username,`tid1`,`tid2`,`tid3`,`tid4`,tbl1.`id`,payment,tracking FROM idevaff_sales_test as tbl1 left JOIN idevaff_affiliates on tbl1.`id`=idevaff_affiliates.`id` WHERE record >10180 order by tbl1.record asc

Sales Data - Done