回答編集履歴
1
補足追加
test
CHANGED
|
@@ -56,11 +56,13 @@
|
|
|
56
56
|
|
|
57
57
|
, T1.time
|
|
58
58
|
|
|
59
|
-
-- , T3.maxtime 必要に応じて
|
|
59
|
+
-- , T3.maxtime 必要に応じて追加
|
|
60
60
|
|
|
61
|
-
FROM tbl T1
|
|
61
|
+
FROM tbl T1 -- ソート対象となるtblデータ
|
|
62
62
|
|
|
63
63
|
INNER JOIN
|
|
64
|
+
|
|
65
|
+
-- T1に対して、ソート用の項目をJOINするべく、tel毎のソート項目を抽出する
|
|
64
66
|
|
|
65
67
|
(
|
|
66
68
|
|
|
@@ -70,13 +72,9 @@
|
|
|
70
72
|
|
|
71
73
|
, MAX(T2.time) AS maxtime
|
|
72
74
|
|
|
73
|
-
FROM
|
|
75
|
+
FROM tbl T2
|
|
74
76
|
|
|
75
|
-
tbl T2
|
|
76
|
-
|
|
77
|
-
GROUP BY
|
|
77
|
+
GROUP BY T2.tel -- T1とT3が1:1となるように、TELで集約
|
|
78
|
-
|
|
79
|
-
T2.tel
|
|
80
78
|
|
|
81
79
|
) T3 ON(
|
|
82
80
|
|
|
@@ -84,16 +82,18 @@
|
|
|
84
82
|
|
|
85
83
|
)
|
|
86
84
|
|
|
87
|
-
-- WHERE T1.time >= DATE_FORMAT(( NOW() - INTERVAL 1 MONTH ), '%Y-%m-%d' ) 必要に応じて
|
|
85
|
+
-- WHERE T1.time >= DATE_FORMAT(( NOW() - INTERVAL 1 MONTH ), '%Y-%m-%d' ) 必要に応じて追加
|
|
88
86
|
|
|
89
87
|
ORDER BY T3.maxtime DESC
|
|
90
88
|
|
|
91
89
|
, T3.telsort
|
|
92
90
|
|
|
93
|
-
|
|
91
|
+
, T1.time DESC
|
|
94
92
|
|
|
95
|
-
|
|
93
|
+
, T1.id
|
|
96
94
|
|
|
97
95
|
;
|
|
98
96
|
|
|
99
97
|
```
|
|
98
|
+
|
|
99
|
+
|