Query Run
SELECT subdomain, count(*) ct FROM ( SELECT SUBSTRING_INDEX( ... 8 months ago
SELECT subdomain, count(*) ct FROM ( SELECT SUBSTRING_INDEX( ... 2 years ago