回答編集履歴
3
見直し
answer
CHANGED
|
@@ -17,5 +17,7 @@
|
|
|
17
17
|
AND sub_ar.updated_at <= {指定の日付(Y-m-d)}
|
|
18
18
|
AND sub_ar.deleted_at IS null
|
|
19
19
|
GROUP BY sub_ar.user_id
|
|
20
|
-
)
|
|
20
|
+
)
|
|
21
|
+
ORDER BY ar.user_id;
|
|
21
|
-
```
|
|
22
|
+
```
|
|
23
|
+
ORDER BY句が必要な気がするけど、とくに条件が指定されていないので、user_id順にしてみた。
|
2
見直し
answer
CHANGED
|
@@ -6,7 +6,9 @@
|
|
|
6
6
|
SELECT
|
|
7
7
|
ar.article_id,
|
|
8
8
|
ar.user_id,
|
|
9
|
+
ar.type,
|
|
9
|
-
ar.updated_at
|
|
10
|
+
ar.updated_at,
|
|
11
|
+
ar.deleted_at
|
|
10
12
|
FROM articles AS ar
|
|
11
13
|
WHERE (ar.user_id, ar.updated_at) IN (
|
|
12
14
|
SELECT sub_ar.user_id, MAX(sub_ar.updated_at) as updated_at
|
1
見直し
answer
CHANGED
|
@@ -13,7 +13,7 @@
|
|
|
13
13
|
FROM articles AS sub_ar
|
|
14
14
|
WHERE sub_ar.type = 'B'
|
|
15
15
|
AND sub_ar.updated_at <= {指定の日付(Y-m-d)}
|
|
16
|
-
AND deleted_at IS null
|
|
16
|
+
AND sub_ar.deleted_at IS null
|
|
17
17
|
GROUP BY sub_ar.user_id
|
|
18
18
|
);
|
|
19
19
|
```
|