The stats query for MPA2
select site,
ROUND(sum(partner_uniques)*partner_paid),fm from mpa2.stats where date>='2004-06-15' and date<='2004-06-15' and webmaster='xxxxxx' group by site,date,referrer,uniques_paid,uniques_p,signup_p aid,partner_paid,date,webmaster,fm order by site
To me the part that I put in bold is sketchy.
Lets say partner_uniques sums up to 1000 and partner_paid = 0.8
ROUND(1000*0.8) = 800
Now there's 800 uniques instead of 1000.
I could be wrong that it's used like that, but it sure seems possible
