title: Query multiple dates NOT greater than the current date
body: <p>I have a one to many relationship in my database where one event could have multiple dates. I need to find all those events which don't have any events greater than the current dates (i.e. events which have expired).</p>
  
  <p>I am using the following to select all those events with dates in the future:</p>
  
  <pre><code>SELECT events.id AS id,events.picture,events.name,events.venue,events.city
  FROM events,event_dates
  WHERE event_dates.start_date &gt;= DATE(NOW())
  GROUP BY events.id ORDER BY events.id DESC
  </code></pre>
  
  <p>I'm not being very smart trying to reverse this, and get events where ALL dates are <code>&lt; DATE(NOW())</code> or <code>NOT event_dates.start_date &gt;= DATE(NOW())</code></p>
  
  <p>Which (or neither) is closer to the idea.</p>