title: MySQL query was working before, now it isn't?
body: <p>I'm having an odd problem, and I don't have the slightest idea of why it isn't working.
  I have the following query that I constructed:</p>
  
  <pre><code>SELECT servers.id, servers.name, servers.address, servers.port, servers.up, servers.down, servers.genre, servers.score, servers.version, servers.country, ROUND( AVG( reviews.average ) , 0 ) AS review
  FROM servers
  INNER JOIN reviews ON servers.id = reviews.server
  ORDER BY servers.score DESC 
  </code></pre>
  
  <p>This query was working fine a few weeks ago. It is meant to get many fields from the "servers" table, and the average field from the "reviews" table where the server in the "reviews" table is the same as the id in the "servers" table.</p>
  
  <p>Like I said, this query was working fine before. Yesterday I noticed that a vital part of my site wasn't working, and I figured out that this query is failing.</p>
  
  <p>I've confirmed that is returning exactly 1 row (when, at the moment, it should be returning 4, because there are 4 entries in the "servers" table.)
  This is what phpMyAdmin gives me when I execute that query:</p>
  
  <pre><code>id    name  address  port   up    down  genre   score   version  country   review
  NULL  NULL  NULL     NULL   NULL  NULL  NULL    NULL    NULL    NULL       NULL
  </code></pre>
  
  <p>Could anybody enlighten me? I've come here as a last resort, because I am stuck.</p>