回答編集履歴

1

修正

2017/11/13 06:53

投稿

yambejp
yambejp

スコア114581

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
  ```