title: Using multiple joins and group_concat() in MySQL?
body: <p>I need to use Joins for a project but I have forgot how to use it. It's all just messing with my head now, I can't quite figure it out. </p>
  
  <p>I have five tables, all of which I need to join: </p>
  
  <pre><code>categories - id, name
  movies_categories - movie_id, category_id
  movies - id, title, description, release_date, cover_image
  users - id, username, password
  user_movies - user_id, movie_id, favorite, review, watch_date, rating
  </code></pre>
  
  <p>As you can see the project is movie related, and user_movies contains all the movies the user has watched. What I need to do is get all the movies a certain user has watched. So, I need all of the movie info for each movie, the username (that's pretty much all the info I need from the user), and some of the columns from user_movies (all of them except the first two). I also need to combine all of the categories for each movies into one "variable". I believe you can use GROUP_CONCAT() to do that, I've done it before. </p>
  
  <p>It's a tricky task, I really need to get my head around this. If anyone can help me out I'd appreciate it. </p>