title: SQL, set limit for a column?
body: <p>I have a problem with this SQL-Query</p>
  
  <pre><code>SELECT * 
  FROM page p 
  LEFT JOIN categorylinks c ON p.page_id = c.cl_from 
  WHERE c.cl_to IN
  (
    'Art-Rock-Band',
    'Echo-Pop-Preisträger',
    'Englische_Band',
    'Genesis_(Band)',
    'Grammy-Preisträger',
    'Peter_Gabriel',
    'Phil_Collins',
    'Popband',
    'Progressive-Rock-Band',
    'Rock_and_Roll_Hall_of_Fame'
  )
  </code></pre>
  
  <p>It works and I get a very big result of every page where <code>p.page_id = c.cl_from</code></p>
  
  <p>Now I want to set a limit for every single category because the query takes too long.</p>
  
  <p>I want just 5 results for '<code>Art-Rock-Band</code>', just 5 results for '<code>Echo-Pop-Preisträger</code>' etc...</p>