erikj (owner)

Revisions

gist: 198182 Download_button fork
public
Public Clone URL: git://gist.github.com/198182.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
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

[erikj@cerebus]: mysql -u root zeitbyte -e "select date, 
count(distinct(c_ip)) from user_request where media_id = 150 OR 
media_id=151 OR media_id=152 and client_id!=1 and project_id!=1 and 
project_id!=1 group by date;"
+------------+-----------------------+
| date       | count(distinct(c_ip)) |
+------------+-----------------------+
| 2009-04-23 |                     8 | 
| 2009-04-24 |                     8 | 
| 2009-04-27 |                     2 | 
| 2009-04-28 |                     7 | 
| 2009-04-29 |                     3 | 
| 2009-04-30 |                     6 | 
| 2009-05-01 |                     3 | 
| 2009-05-04 |                     3 | 
| 2009-05-05 |                     3 | 
| 2009-05-06 |                     1 | 
| 2009-05-16 |                     1 | 
| 2009-05-18 |                     1 | 
| 2009-05-19 |                     1 | 
| 2009-05-20 |                     1 | 
| 2009-05-21 |                     1 | 
| 2009-05-22 |                     1 | 
| 2009-06-02 |                     1 | 
| 2009-06-03 |                     1 | 
| 2009-06-10 |                     2 | 
| 2009-06-11 |                     1 | 
| 2009-06-12 |                     2 | 
| 2009-06-15 |                     1 | 
| 2009-06-19 |                     1 | 
| 2009-09-14 |                     2 | 
+------------+-----------------------+
 
[erikj@cerebus]: mysql -u root zeitbyte -e "select date, 
count(distinct(c_ip)) from user_request where media_id = 150 OR 
media_id=151 OR media_id=152 and client_id!=1 and project_id!=1 group by 
date;"
+------------+-----------------------+
| date       | count(distinct(c_ip)) |
+------------+-----------------------+
| 2009-04-23 |                     8 | 
| 2009-04-24 |                     8 | 
| 2009-04-27 |                     2 | 
| 2009-04-28 |                     7 | 
| 2009-04-29 |                     3 | 
| 2009-04-30 |                     6 | 
| 2009-05-01 |                     3 | 
| 2009-05-04 |                     3 | 
| 2009-05-05 |                     3 | 
| 2009-05-06 |                     1 | 
| 2009-05-16 |                     1 | 
| 2009-05-18 |                     1 | 
| 2009-05-19 |                     1 | 
| 2009-05-20 |                     1 | 
| 2009-05-21 |                     1 | 
| 2009-05-22 |                     1 | 
| 2009-06-02 |                     1 | 
| 2009-06-03 |                     1 | 
| 2009-06-10 |                     2 | 
| 2009-06-11 |                     1 | 
| 2009-06-12 |                     2 | 
| 2009-06-15 |                     1 | 
| 2009-06-19 |                     1 | 
| 2009-09-14 |                     2 |