Guest User

Untitled

a guest
Feb 21st, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT user_id
  2. FROM user_movies
  3. GROUP BY user_id
  4. ORDER BY COUNT(
  5. movie_id IN (SELECT movie_id FROM user_movies WHERE user_id = 305344)
  6. ) DESC
  7. LIMIT 50
  8.  
  9. SELECT inst1.user_id
  10. FROM user_movies inst1, user_movies inst2
  11. WHERE inst1.user_id != inst2.user_id
  12. AND inst1.movie_id = inst2.movie_id
Add Comment
Please, Sign In to add comment