title: How to stop some records displaying multiple times in SQL Query
body: <p>Here is the <a href="http://rextester.com/MTIFT55374" rel="nofollow noreferrer">Complete SQL Fiddle</a></p>
  
  <p>As you can see, the records from <code>recommendations</code> table are displaying multiple times. But If i remove this line <code>LEFT JOIN cast ON cast.cast_tmdb_id=tmdb_movies.tmdb_id
  </code> then, they do not display multiple times. So this line is the main problem. </p>
  
  <p>I did not use cast table in my SQL Query, just for the sake of simplicity. But I need it. </p>
  
  <p>And yes, I need <code>group_concat</code> to display the records together in my <code>PHP code</code></p>
  
  <p>That's all the information needed, i guess. Please let me know, if you need more information or want me to explain again.</p>
  
  <p>Edit: Dear @Shadow, who marked this suggestion as duplicate. If I use <code>DISTINCT</code> then, not all records will display. Because it is possible that 2 movies have an average rating of <code>7.5</code></p>