Advertisement
Guest User

Untitled

a guest
May 16th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ALLTABLE.Viewer_ID " +
  2.                    "FROM (SELECT A.Viewer_ID, A.Movie_ID, B.myID, B.myMovies " +
  3.                        "FROM Watched A LEFT JOIN (SELECT Viewer_ID AS myID, Movie_ID AS myMovies FROM Watched WHERE Viewer_ID = ?) B " +
  4.                        "ON (Viewer_ID != myID AND Movie_ID = myMovies) " +
  5.                        "GROUP BY A.Viewer_ID, A.Movie_ID, B.myID, B.myMovies " +
  6.                        "ORDER BY Viewer_ID ASC" +
  7.                    ") AS ALLTABLE " +
  8.                    "GROUP BY ALLTABLE.Viewer_ID " +
  9.                    "HAVING COUNT(ALLTABLE.Viewer_ID) > (SELECT Movie_ID FROM Watched WHERE Viewer_ID = ?)*(3/4)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement