title: SQL Select only players that have played x amount of games in recent y days?
body: <p><strong>Q: How do I make MySQL only SELECT all users that have played => x amount of games <em>within</em> the y most recent days?</strong></p>
  
  <p>This is all used for a gaming ladder. I use two tables: weblPlayers has only the user info (username, email, password etc), and weblGames has the result of every reported game along with the date and time, properly formatted, of when it was reported.</p>
  
  <p>Here are the screenshots of them:</p>
  
  <p><a href="http://www.ubuntu-pics.de/bild/21059/screenshot_87_RTDZBb.png" rel="nofollow noreferrer">weblGames</a> </p>
  
  <p>WeblPlayers has the fields: player_id | name | email | etc | etc. The names found of a winner or loser in weblGames when a game is reported correspond to same names found in WeblPlayers.</p>