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