title: SQL error say column from COUNT does not exisit
body: <pre><code>SELECT c.review, m.category, u.username, i.item, i.item_id, m.cat_id, COUNT(rv.review_id) totalCount
  FROM reviews AS c
  LEFT JOIN review_vote as rv
     ON c.review_id = rv.review_id
  LEFT JOIN users AS u
     ON u.user_id = c.user_id 
  LEFT JOIN items AS i
     ON i.item_id = c.item_id
  LEFT JOIN master_cat AS m
     ON m.cat_id = i.cat_id
  WHERE LENGTH(c.review) &gt; 50 AND m.category = 'Movies' AND totalCount &gt; 2
  GROUP BY rv.review_id
  ORDER BY RAND()
  LIMIT 1
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>#1054 - Unknown column 'totalCount' in 'where clause' 
  </code></pre>
  
  <p>I am selecting this column right away, how come it doesn't exist?</p>
  
  <p>I am trying to random select a review  that is listed (or voted on 2 or more times) in in table <code>rv</code>.    Also I am not sure if I am using <code>GROUP BY</code> correctly?</p>