title: MySQL get title from parentid with two tables
body: <p>I will try to explain much as possible. here is my query..</p>
  
  <pre><code>SELECT * FROM mm_star_ratings s
  JOIN mm_posts p ON s.post_id = p.postid
  WHERE p.type='B'
  ORDER BY s.rating DESC LIMIT 5
  </code></pre>
  
  <p><code>type='B'</code> is the main post and <code>type='C'</code> is the reply on that post. There is a <code>parentid</code> column in <code>mm_posts</code> to set main post <code>(B)</code> id for <code>C</code>. Do I want to get the <code>title</code> from <code>mm_posts</code> if <code>type='C'</code> is there anyway?</p>
  
  <p>The challenge for me is to get it work with my rating table where <code>post_id</code> is set for both <code>B</code> and <code>C</code></p>