title: How to do this query? Many different categories of products, need a limit on number of products per category
body: <p>I have a query which selects products from a table:</p>
  
  <pre><code>Select * FROM products WHERE category_id in (1,2,3,4,5) LIMIT 100
  </code></pre>
  
  <p>I would like to impose a limit on the number of entries returned for each category rather than the sum of all categories.</p>
  
  <p>The way I have it sometimes it could return 100 products for just one category then just stop before it gets to any of the others</p>