title: Select row with max child rows
body: <p>I have a table post and another table views, a post has many views while a view belongs to only one post. Now how do I select a post which has the most views, i.e. the post with max views when compared to the other post using mysql?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>More complicated scenario, a topic table that has many posts, and the posts can have many topics too, now how do i fetch for each topic, pick the most viewed post using mysql?</p>