title: MySQL LIMIT only parent JOIN
body: <p>I have a mysql table with 20 parent rows and 38 child rows.  Child rows have the column <code>parent_id</code> which is the <code>id</code> of the parent row.</p>
  
  <p>Here is the query</p>
  
  <pre><code>  SELECT child.*,parent.title as ptitle FROM mytable parent
    LEFT JOIN mytable child on child.`parent_id`=parent.id
    ORDER by parent.id ASC
  </code></pre>
  
  <p>Now i'm trying to do pagination.  I only want 10 parent rows per page.  How do i LIMIT the results in a way it only fetches 10 parent rows but still fetches the child rows?  </p>
  
  <p>Also how do i LIMIT the child rows.. like only show 5 child rows per parent row?</p>