title: Using SQL_CALC_FOUND_ROWS in a subquery
body: <p>I find that MySQL returns a</p>
  
  <pre><code>Incorrect usage/placement of 'SQL_CALC_FOUND_ROWS'
  </code></pre>
  
  <p>error if I put SQL_CALC_FOUND_ROWS in a subquery</p>
  
  <pre><code>SELECT
    *
  FROM
    (
       SELECT SQL_CALC_FOUND_ROWS * FROM test_table
    ) as T1
  </code></pre>
  
  <p>Is there a workaround for this? or am I just implementing it incorrectly?</p>
  
  <p>EDIT: There is a reason why I need to make T1 a subquery in case anyone is wondering.</p>