summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema.sql b/schema.sql
index 516fe28..650b379 100644
--- a/schema.sql
+++ b/schema.sql
@@ -192,7 +192,7 @@ create view rating_view as
title_id, name, rating, count, last
from
ratings
- join users using(title_id, user_id)
+ join users using(user_id)
order by
title_id,
rating desc