title: Counting likes and comments between two different table of a specific topic
body: <p>I have two tables, <strong>likes</strong> and <strong>comments</strong> both of which refer to topic posts - like a topic of a forum for example.</p>
  
  <p>Both of them have a column that refers to a specific topic_id.</p>
  
  <p>Now here's the deal: i want to create a top 5 chart of most liked + commented, the total of both summed up i mean, topics.</p>
  
  <p>For example i did this query for selecting from the topics table the most liked, i want to make the same chart with the total of likes + comments. Here's my top 5 topics by total of likes only.</p>
  
  <pre><code>SELECT topics.* ,
  COUNT(q_id)
  AS post_count 
  FROM topics 
  LEFT JOIN likes 
  ON topics.id = likes.q_id 
  WHERE topics.to_user = 'someuser' 
  GROUP BY likes.q_id  
  ORDER BY post_count DESC 
  LIMIT 0, 5
  </code></pre>
  
  <p>Tnx in advance!</p>