title: How to do a count on a union query
body: <p>I have the following query:</p>
  
  <pre><code>select distinct profile_id from userprofile_...
  
  union
  
  select distinct profile_id from productions_...
  </code></pre>
  
  <p>How would I get the count of the total number of results?</p>