title: Wrong results on JOIN with three tables MYSQL
body: <p>I have three tables: Publisher, Imprint and Magazine.
  A Magazine belongs to an Imprint, and only one Imprint.
  An Imprint belongs to a Publisher and only one Publisher.
  A Publisher has many Imprints.</p>
  <p>I'm trying to query all Imprints, fetching data from its publisher and counting all its magazines.</p>
  <p>My current attempt is:</p>
  <pre><code>SELECT i.id, i.name, p.name as publisher, count(m.id) as magazines
  FROM imprint AS i
      JOIN publisher as p ON p.id = i.publisher 
      LEFT INNER JOIN magazine as m  ON m.imprint = i.id
  ORDER BY publisher ASC, i.name ASC
  </code></pre>
  <p>But I'm only getting one row as a result, not all the imprints with its Publisher name and magazine count.
  Where am I wrong?</p>