title: How to LEFT JOIN on mysql rows that don't exist past a certain year?
body: <p>I have two tables, I'll list table names and relevant fields:</p>
  
  <pre><code>PLAYERS:
  playerid
  
  STATS:
  statsid
  playerid
  year
  </code></pre>
  
  <p>Every time a player accumulated stats in a game, it put a row in the <code>stats</code> table and recorded the year.</p>
  
  <p>Now, I would like get a list of all players in the <code>players</code> table who have NOT recorded any stats in 2016 and up.</p>
  
  <p>I tried LEFT JOIN but don't really understand what I'm doing and couldn't get it to work.  This is one of the things I tried, don't laugh</p>
  
  <pre><code>SELECT * FROM `players` LEFT JOIN `stats` ON players.playerid = stats.playerid where count(*) = 0 and stats.year &gt;= 2016
  </code></pre>