erikj (owner)

Revisions

gist: 219884 Download_button fork
public
Public Clone URL: git://gist.github.com/219884.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

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