title: Spring Data JPA Query: MYSQL TO @QUERY
body: <p>Can someone please translate me the following mysql query to @Query?</p>
  <p>Mysql-query:</p>
  <pre><code>SELECT * 
  FROM game JOIN game_teams ON game.id = game_teams.game_id
      JOIN team_members ON game_teams.teams_id = team_members.team_id
  WHERE start_date IS NOT NULL AND end_date IS NOT NULL AND members_username = 'user2'
  </code></pre>
  <p>This query retrieves more columns than columns in game table. Maybe I have to select just the columns that are in the game table?</p>
  <p>I need something like this:</p>
  <pre><code>@Query(&quot;???&quot;)
  Collection&lt;Game&gt; findUserPlayedGames(User user);
  </code></pre>