title: SQL: how to select result of joined tables with limit based on main table rows quantity?
body: <p>I have a table, movies.</p>
  <pre><code>+----+------+
  | id | name |
  +----+------+
  </code></pre>
  <p>And I have another table, genres.</p>
  <pre><code>+----+------+----------+
  | id | name | movie_id |
  +----+------+----------+
  </code></pre>
  <p>Guess, that every movie record have 3 genre records binded by movie_id.
  I need to get 10 movie records with ALL genre records joined.</p>
  <p>My query is:</p>
  <pre><code>select *
  from movies
  left join genres on movies.id = genres.movie_id
  limit 10;
  </code></pre>
  <p>Result is 10 rows, but I want to get 10 movie rows with ALL genre rows joined = 30 rows.</p>
  <p>What query should be?</p>