回答編集履歴
4
訂正
answer
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
where group_id=grp.ID and user_id=$user_id
|
|
7
7
|
and created_at > $time
|
|
8
8
|
) as 特定時間後加入
|
|
9
|
-
, exists(
|
|
9
|
+
, not exists(
|
|
10
10
|
select 1 from group_users
|
|
11
11
|
where group_id=grp.ID and user_id=$user_id
|
|
12
12
|
) as 未加入
|
3
推敲
answer
CHANGED
|
@@ -3,14 +3,12 @@
|
|
|
3
3
|
select *
|
|
4
4
|
, exists(
|
|
5
5
|
select 1 from group_users
|
|
6
|
-
where group_id=grp.ID
|
|
6
|
+
where group_id=grp.ID and user_id=$user_id
|
|
7
|
-
and user_id=$user_id
|
|
8
7
|
and created_at > $time
|
|
9
8
|
) as 特定時間後加入
|
|
10
9
|
, exists(
|
|
11
10
|
select 1 from group_users
|
|
12
|
-
where group_id=grp.ID
|
|
11
|
+
where group_id=grp.ID and user_id=$user_id
|
|
13
|
-
and user_id=$user_id
|
|
14
12
|
) as 未加入
|
|
15
13
|
from groups grp
|
|
16
14
|
```
|
2
訂正
answer
CHANGED
|
@@ -3,12 +3,14 @@
|
|
|
3
3
|
select *
|
|
4
4
|
, exists(
|
|
5
5
|
select 1 from group_users
|
|
6
|
+
where group_id=grp.ID
|
|
6
|
-
|
|
7
|
+
and user_id=$user_id
|
|
7
8
|
and created_at > $time
|
|
8
9
|
) as 特定時間後加入
|
|
9
|
-
,
|
|
10
|
+
, exists(
|
|
10
11
|
select 1 from group_users
|
|
12
|
+
where group_id=grp.ID
|
|
11
|
-
|
|
13
|
+
and user_id=$user_id
|
|
12
14
|
) as 未加入
|
|
13
|
-
from groups
|
|
15
|
+
from groups grp
|
|
14
16
|
```
|
1
追記
answer
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
where user_id=$user_id
|
|
7
7
|
and created_at > $time
|
|
8
8
|
) as 特定時間後加入
|
|
9
|
-
, exists(
|
|
9
|
+
, not exists(
|
|
10
10
|
select 1 from group_users
|
|
11
11
|
where user_id=$user_id
|
|
12
12
|
) as 未加入
|