title: Using limit and offset in subquery in Zend framework 2
body: <p>I have two tables: users and usermeta. The table usermetahas 4 columns: id, user_id, meta_key and meta_value. A user can have many meta data.
  I want to get the groups of the first 10 users. So I create a SQL query in Zend framework 2:</p>
  
  <pre><code>$coreSelect = $sql-&gt;select()
                          -&gt;from('users')
                          -&gt;limit(10)
                          -&gt;offset(0);
  $select = $sql-&gt;select()
  -&gt;from(array('u'   =&gt; $coreSelect))
  -&gt;join('usermeta', 
                          'u.user_id = usermeta.user_id',
                          array(
                              'meta_key'      =&gt; 'meta_key',
                              'meta_value'    =&gt; 'meta_value',
                          ),
                          Select::JOIN_LEFT
  );
  </code></pre>
  
  <p>When execute this query, it show up a SQL syntax error. The SQL query string manipulated by Zend framework is like this:</p>
  
  <pre><code>    SELECT u.*
      FROM (
      SELECT * FROM users LIMIT '10' OFFSET '0') AS u
      ...
  </code></pre>
  
  <p>It means that Zend framework has added quotes into offset and limit value and it makes the syntax error.
  Can anyone please help me to resolve this problem?</p>