06-15-2004, 10:02 AM
|
|
|
Industry Pioneer
Industry Role:
Join Date: Oct 2002
Location: USA/EU/ASIA
Posts: 5,401
|
Quote:
Originally posted by swedguy
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 
|
You guys crack me up!!!
ROFLMAO!!!
 |
|
|