title: Column 'user' in group statement is ambiguous
body: <p>I need to get USER from cadastro.user (username) and user from posts.user (user id) but both tables has the same name = USER.
  How can I make this select work with this duplicate USER?</p>
  
  <pre><code>SELECT posts.id, posts.user, cadastro.user, cadastro.nome, cadastro.id 
  FROM posts join cadastro 
  where posts.user = cadastro.id and posts.user &lt;&gt; '1' 
  group by user order by rand()
  limit 10
  </code></pre>