title: MySQL join two tables to find all rows EXCEPT the row with the max value
body: <p>I'm trying to write a query that will find all rows in a group EXCEPT the row with the max value.  I have a query so far that finds the row with the max value, but now I need to find all the rest of the rows.  Here is a SQLFiddle with the two databases and sample data.  I also have the query that finds the max rows.
  <a href="http://sqlfiddle.com/#!2/514d2/33" rel="nofollow">http://sqlfiddle.com/#!2/514d2/33</a></p>
  
  <p>For those that don't want to use SQLFiddle...
  Tablename: listings
  Tablename: bids</p>
  
  <pre><code>SELECT listings.end_date, listings.user_id, listings.title, 
    listings.auc_fp, listings.id, listings.auc_image1
  FROM listings 
  JOIN bids b1 
  ON b1.listing_id=listings.id 
  LEFT JOIN bids b2 
  ON b2.listing_id=listings.id AND b1.bid &lt; b2.bid
  WHERE b1.user_id = 1
  AND b2.bid IS NULL
  AND listings.end_date &gt; NOW()
  ORDER BY listings.list_ts DESC
  </code></pre>
  
  <p>Above is the query that find the max rows.  I'm trying to join the listings table with the bids table on listings.id=bids.listing_id.  Then I need to find all the rows where a user ($user or user "1") has bid on that listing.  Then I need to exclude the listings where the user is has the max bid (which is what the query above does).</p>
  
  <p>I originally thought I could use the query above as a subquery to exclude the listings where the user is the max bidder.  But I'm not sure if that's the best way to do it and I'm not that good with subqueries.</p>