title: MySQL join query - Not unique table/alias
body: <p>What could be wrong with this one? I am getting Error #1066 - Not unique table/alias: 'v'</p>
  
  <pre><code>SELECT v.newsid AS identifier, j.createdate AS DATE, j.newstext AS TEXT, j.uuid AS user, j.flags AS fcount, j.votes AS vcount, j.authornick AS nick 
  FROM votes v 
  INNER JOIN news v ON j.newsid = v.newsid GROUP BY v.newsid ORDER BY COUNT( v.newsid )   
  LIMIT 20
  </code></pre>