Query Run
SELECT subdomain, count(*) ct FROM ( SELECT SUBSTRING_INDEX( ... 1 month ago
SELECT subdomain, count(*) ct FROM ( SELECT SUBSTRING_INDEX( ... 1 year ago