title: How to get view for each article?
body: <p>I have 4 tables</p>
  
  <pre><code>articles
  category
  article_category
  view
  </code></pre>
  
  <p>I need to find view count for each article
  Below is my sql query</p>
  
  <pre><code>SELECT a.id,
  (SELECT SUM(view) FROM view v ON v.aid=a.id) as view 
  FROM articles a JOIN article_category ac ON a.id 
  ON ac.aid JOIN category c ON c.id=ac.cid 
  LEFT JOIN view cv ON v.aid=a.id GROUP BY a.id
  </code></pre>
  
  <p>My guestion is if there are another ways without using extra SELECT query?</p>