Current AMC Customers

This report shows all active AMC customers referred from your website. You currently have 365 customers making total monthly payments of $18,496.35.

[6.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.0187s] select count(*), sum(amcpolicy.Cost) as Income from amcpolicy 
							inner join amccustomer on amccustomer.CustomerId=amcpolicy.CustomerId
						where amccustomer.ReferringAffiliateId=36651 and EndDate is null

[4.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[3.0E-5s] select AffiliateId from affiliate where IsDemo=2

[5.0E-5s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.01355s] select SQL_CALC_FOUND_ROWS amcplan.*, amcpolicy.* from amcpolicy 
							inner join amcplan on amcplan.PlanId=amcpolicy.PlanId
							inner join amccustomer on amccustomer.CustomerId=amcpolicy.CustomerId
						where amccustomer.ReferringAffiliateId=36651
						and (amcpolicy.EndDate is null or amcpolicy.EndDate > '2010-09-08 12:57:36')
						order by StartDate desc limit 0, 25

[0.00018s] select FOUND_ROWS()