SELECT user_request.media_type_id AS user_request_media_type_id, count(1) AS count_1
FROM user_request
WHERE user_request.date <= '2009-10-27' AND user_request.date >= '2009-09-27' AND user_\
request.project_id = 90 GROUP BY user_request.media_type_id

media_type_id count_1
1       4047
4       2607
6       2687
7       2816
8       18778
9       3

select sum(count_1) FROM(
SELECT user_request.media_type_id AS user_request_media_type_id, count(1) AS count_1
FROM user_request
WHERE user_request.date <= '2009-10-27' AND user_request.date >= '2009-09-27' AND user_\
request.project_id = 90 GROUP BY user_request.media_type_id
AS anon_1

30938