Changes between Version 11 and Version 12 of AdvancedReports

Timestamp:

12/28/21 14:37:51 (3 years ago)

Author:

193113

Comment:

--

AdvancedReports

@@ -53 +53 @@
          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 users u  on u.user_id  = r2.user_id and 
+         
+                        (
+                                select count(r3.reply_id)
+                                from replies r3 
+                                group by u.user_id 
+                        ) >= 
+                        (
+                                
+                                select count(*) / (select count(*) from users)
+                                from replies 
+                        )
+                        
      join movie_rates mv on mv.user_id = u.user_id 
      join movies m on m.movie_id  = mv.movie_id