回答編集履歴
1
修正
test
CHANGED
@@ -8,8 +8,8 @@
|
|
8
8
|
|
9
9
|
from tweets as t1
|
10
10
|
|
11
|
-
inner join (select distinct twi_created,id from tweets where twuser_id = 500 order by twi_created desc limit 5) as t2
|
11
|
+
inner join (select distinct twi_created,twuser_id from tweets where twuser_id = 500 order by twi_created desc limit 5) as t2
|
12
12
|
|
13
|
-
on t1.twi_created=t2.twi_created and t1.id=t2.id
|
13
|
+
on t1.twi_created=t2.twi_created and t1.twuser_id=t2.twuser_id
|
14
14
|
|
15
15
|
```
|