title: MySql Query Limit based on Sub Query Value
body: <p>I am looking for a solution to use sub query in limit value.</p>
  
  <p>Ex:</p>
  
  <pre><code>SELECT *
  FROM `user`
  WHERE usertype='6' LIMIT
    (SELECT count(*) FROM allowed WHERE usertype='6')
  </code></pre>
  
  <p>Is there any other way to use a sub Query in LIMIT. I tried the above Query but Its not working.</p>