title: adding count( ) column on each row
body: <p>I'm not sure if this is even a good question or not.</p>
  
  <p>I have a complex query with lot's of unions that searches multiple tables for a certain keyword (user input). All tables in which there is searched are related to the table <code>book</code>.</p>
  
  <p>There is paging on the resultset using LIMIT, so there's always a maximum of 10 results that get withdrawn. </p>
  
  <p>I want an extra column in the resultset displaying the total amount of results found however.  <strong>I do not want to do this using a separate query</strong>. Is it possible to add a count() column to the resultset that counts every result found?</p>
  
  <p>the output would look like this:</p>
  
  <pre><code>ID    Title    Author    Count(...)  
  1     book_1   auth_1      23  
  2     book_2   auth_2      23  
  4     book_4   auth_..     23  
  </code></pre>
  
  <p>...</p>
  
  <p>Thanks!      </p>