Changes between Version 5 and Version 6 of AdvancedReports

Timestamp:

12/28/21 13:00:37 (3 years ago)

Author:

193113

Comment:

--

AdvancedReports

@@ -48 +48 @@
 == Предложување на филмови на корисник врз база на корисниците со кои стапил во интеракција
 {{{
-
- select distinct m.title 
- from replies r 
- join discussions d on r.discussion_id = d.discussion_id
- join replies r2 on r2.discussion_id  = d.discussion_id  and r2.user_id  != 1
- join users u  on u.user_id  = r2.user_id 
- join movie_likes ml on ml.user_id = u.user_id 
- join movies m  on m.movie_id = ml.movie_id
- where  r.user_id = 1;
+select title from(
+         select  m.title, sum(mv.stars_rated) as total
+         from replies r 
+         join discussions d on r.discussion_id = d.discussion_id
+         join replies r2 on r2.discussion_id  = d.discussion_id  and r2.user_id  != 1
+         join users u  on u.user_id  = r2.user_id 
+         join movie_rates mv on mv.user_id = u.user_id 
+         join movies m on m.movie_id  = mv.movie_id
+         where  r.user_id = 1
+         group by m.title
+         order by sum(mv.stars_rated) desc 
+         limit 10
+ ) as tabela;
 }}}