Current AMC Customers

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

[0.00012s] select AffiliateId from affiliate where IsDemo=2

[7E-05s] select AffiliateId from affiliate where IsDemo=2

[7E-05s] select AffiliateId from affiliate where IsDemo=2

[0.00014s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.00609s] 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

[7E-05s] select AffiliateId from affiliate where IsDemo=2

[0.00013s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[7E-05s] select AffiliateId from affiliate where IsDemo=2

[0.00013s] select affiliateclass.* from affiliateclass
							inner join affiliate on affiliate.AffiliateClassId=affiliateclass.AffiliateClassId
						where affiliate.AffiliateId = 36651

[0.01338s] 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 > '2008-12-03 19:05:06')
						order by StartDate desc limit 0, 25

[0.0001s] select FOUND_ROWS()