回答編集履歴
4
訂正
test
CHANGED
@@ -14,7 +14,7 @@
|
|
14
14
|
|
15
15
|
) as 特定時間後加入
|
16
16
|
|
17
|
-
, exists(
|
17
|
+
, not exists(
|
18
18
|
|
19
19
|
select 1 from group_users
|
20
20
|
|
3
推敲
test
CHANGED
@@ -8,9 +8,7 @@
|
|
8
8
|
|
9
9
|
select 1 from group_users
|
10
10
|
|
11
|
-
where group_id=grp.ID
|
11
|
+
where group_id=grp.ID and user_id=$user_id
|
12
|
-
|
13
|
-
and user_id=$user_id
|
14
12
|
|
15
13
|
and created_at > $time
|
16
14
|
|
@@ -20,9 +18,7 @@
|
|
20
18
|
|
21
19
|
select 1 from group_users
|
22
20
|
|
23
|
-
where group_id=grp.ID
|
21
|
+
where group_id=grp.ID and user_id=$user_id
|
24
|
-
|
25
|
-
and user_id=$user_id
|
26
22
|
|
27
23
|
) as 未加入
|
28
24
|
|
2
訂正
test
CHANGED
@@ -8,20 +8,24 @@
|
|
8
8
|
|
9
9
|
select 1 from group_users
|
10
10
|
|
11
|
+
where group_id=grp.ID
|
12
|
+
|
11
|
-
|
13
|
+
and user_id=$user_id
|
12
14
|
|
13
15
|
and created_at > $time
|
14
16
|
|
15
17
|
) as 特定時間後加入
|
16
18
|
|
17
|
-
,
|
19
|
+
, exists(
|
18
20
|
|
19
21
|
select 1 from group_users
|
20
22
|
|
23
|
+
where group_id=grp.ID
|
24
|
+
|
21
|
-
|
25
|
+
and user_id=$user_id
|
22
26
|
|
23
27
|
) as 未加入
|
24
28
|
|
25
|
-
from groups
|
29
|
+
from groups grp
|
26
30
|
|
27
31
|
```
|
1
追記
test
CHANGED
@@ -14,7 +14,7 @@
|
|
14
14
|
|
15
15
|
) as 特定時間後加入
|
16
16
|
|
17
|
-
, exists(
|
17
|
+
, not exists(
|
18
18
|
|
19
19
|
select 1 from group_users
|
20
20
|
|