active starter customers query

gistfile1.sql

set @run_at = '2014-12-31 00:00:00';
select a.account_id, a.subdomain, aa2.num_active_agents_90_days
from accounts a 
inner join 
(select aa.account_id, count(*) num_active_agents_90_days, @run_at as run_at, 'all' as timespan
from active_agents aa 
where aa.run_at between subdate(@run_at, interval 90 day) and @run_at
and timespan = '1d'
group by aa.account_id
) aa2
using (account_id, run_at, timespan)
where a.run_at = @run_at and a.timespan = 'all' and a.plan_type = 1