SELECT kind, count( * ) FROM ( SELECT kind, kind.item, activity.o FROM kind INNER JOIN activity ON kind.item = activity.item WHERE (activity.o BETWEEN '2013-01-01' AND '2014-01-01') AND kind.kind IN ('acbk', 'jcbk', 'accd', 'jcdvd', 'bcbk', 'acmus', 'jckit', 'ucfold', 'jccd', 'acdvd')) AS mytable WHERE o BETWEEN '2013-03-01' and '2013-04-01' GROUP BY kind;
acbk,216796
accd,83124
acdvd,181145
acmus,1029
bcbk,630
jcbk,161623
jccd,9373
jcdvd,31230
jckit,1392
ucfold,1460
