title: SQL Query to Select Everything Except the Max Value
body: <p>I have this rather complex query that grabs data from three tables, and now I want it to be even more complicated (Oh dear)!</p>
  
  <p>I'd like the last posted feature to be displayed in it's own section of the page, and that's pretty easy by selecting the last entry in the table. However, for the complex query (the main page of the site), I'd like to be able to NOT have this feature displayed.</p>
  
  <p>I'd like to <code>union</code> the following query to my previous query, but it isn't returning the correct results:</p>
  
  <pre><code>SELECT
      features.featureTitle AS title, 
      features.featureSummary AS body, 
      features.postedOn AS dummy, 
      DATE_FORMAT( features.postedOn,  '%M %d, %Y' ) AS posted, 
      NULL, 
      NULL, 
      staff.staffName, 
      features.featureID 
  FROM 
      features 
      LEFT JOIN staff ON 
          features.staffID = staff.staffID 
  WHERE features.postedOn != MAX(features.postedOn)
  ORDER BY dummy DESC LIMIT 0,15
  </code></pre>
  
  <p>This query returns the following error: </p>
  
  <blockquote>
    <p>MySQL error: #1111 - Invalid use of group function</p>
  </blockquote>
  
  <p>Is there any way around this?</p>