title: Mysql subquery limit or use multiple queries
body: <p>Is it possible to select just 2 questions per status. I know mysql doesn't support limits for subqueries but I've seen workarounds which I can't figure out how to use for this query. Is this a one query problem or do I have to use extra queries? I'm trying to select 2 rows for each status.</p>
  
  <p>Without <code>LIMIT 2</code> the following query will work, but it has too many results hence the need to limit it.</p>
  
  <pre><code>SELECT id FROM questions WHERE status_id = c.status_id LIMIT 2
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>  ...
      FROM questions q, users u, users lu, tags t, question_tags tt, connection c
     WHERE q.user_id = u.id
       AND tt.tag_id = t.id
       AND tt.question_id = q.id
       AND c.user_id = 100
       AND q.last_user = lu.id
       AND q.id IN (SELECT id FROM questions WHERE status_id = c.status_id LIMIT 2)
  GROUP BY q.id
  ORDER BY q.date DESC
  </code></pre>