title: Paginated chunk of bigger resultset *and* total resultset count in one query?
body: <p>My personal holy grail of SQL (specifically MySQL) query building is this:</p>
  
  <p>I wonder if / how it is possible to - in the same query - to get a paginated chunk of a bigger resultset (ie. page 2, with 20 per page, of 13000 total results) <em>and</em> the count of total results (in this example 13000).</p>
  
  <p>I'm not saying that this is the best or most efficient way to get the two results (page of results and total result count) but I like a challenge and can never seem to do this in one query.</p>
  
  <p>So, what do you say?</p>