回答編集履歴
2
目視でぬけてるのがきづいた・・・
test
CHANGED
@@ -29,6 +29,8 @@
|
|
29
29
|
wp.wp_slim_stats
|
30
30
|
|
31
31
|
)
|
32
|
+
|
33
|
+
GROUP BY CDT
|
32
34
|
|
33
35
|
ORDER BY CDT
|
34
36
|
|
1
カラムのかぶりをなくす
test
CHANGED
@@ -14,15 +14,15 @@
|
|
14
14
|
|
15
15
|
SELECT
|
16
16
|
|
17
|
-
DT,
|
17
|
+
CDT,
|
18
18
|
|
19
|
-
COUNT(DT) AS PV
|
19
|
+
COUNT(CDT) AS PV
|
20
20
|
|
21
21
|
FROM (
|
22
22
|
|
23
23
|
SELECT
|
24
24
|
|
25
|
-
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as DT
|
25
|
+
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as CDT
|
26
26
|
|
27
27
|
FROM
|
28
28
|
|
@@ -30,7 +30,7 @@
|
|
30
30
|
|
31
31
|
)
|
32
32
|
|
33
|
-
ORDER BY DT
|
33
|
+
ORDER BY CDT
|
34
34
|
|
35
35
|
```
|
36
36
|
|
@@ -48,7 +48,7 @@
|
|
48
48
|
|
49
49
|
SELECT
|
50
50
|
|
51
|
-
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as DT,
|
51
|
+
DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') as CDT,
|
52
52
|
|
53
53
|
COUNT(id) AS PV
|
54
54
|
|
@@ -56,9 +56,9 @@
|
|
56
56
|
|
57
57
|
wp.wp_slim_stats
|
58
58
|
|
59
|
-
GROUP BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // DT できたかもしれんが...
|
59
|
+
GROUP BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // CDT できたかもしれんが...
|
60
60
|
|
61
|
-
ORDER BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // DT できたかもしれんが...
|
61
|
+
ORDER BY DAT_FORMAT(from_unixtime(dt),'%Y-%m-%d') // CDT できたかもしれんが...
|
62
62
|
|
63
63
|
|
64
64
|
|