rendered paste bodymysql> select * from events where event_key like "l.nfl.com-2007%" and event_status != "post-event" and start_date_time < "2007-12-05";
+------+-----------------------+---------------------+--------------+---------------------+
| id | event_key | start_date_time | event_status | last_update |
+------+-----------------------+---------------------+--------------+---------------------+
| 6240 | l.nfl.com-2007-e.2283 | 2007-11-30 01:15:00 | pre-event | 2007-11-29 19:56:00 |
| 6220 | l.nfl.com-2007-e.2286 | 2007-12-02 18:00:00 | pre-event | 2007-11-29 19:56:00 |
| 6035 | l.nfl.com-2007-e.2289 | 2007-12-02 18:00:00 | pre-event | 2007-11-29 19:56:00 |
| 6157 | l.nfl.com-2007-e.2291 | 2007-12-02 18:00:00 | pre-event | 2007-11-29 19:56:00 |
| 6250 | l.nfl.com-2007-e.2294 | 2007-12-02 18:00:00 | pre-event | 2007-11-29 19:56:00 |
| 6268 | l.nfl.com-2007-e.2297 | 2007-12-02 18:00:00 | pre-event | 2007-11-29 19:56:00 |
| 6116 | l.nfl.com-2007-e.2303 | 2007-12-02 21:05:00 | pre-event | 2007-11-29 19:56:00 |
| 6128 | l.nfl.com-2007-e.2304 | 2007-12-02 21:05:00 | pre-event | 2007-11-29 19:56:00 |
| 6231 | l.nfl.com-2007-e.2305 | 2007-12-02 21:15:00 | pre-event | 2007-11-29 19:56:00 |
| 6104 | l.nfl.com-2007-e.2308 | 2007-12-03 01:15:00 | pre-event | 2007-11-29 19:56:00 |
| 6078 | l.nfl.com-2007-e.2312 | 2007-12-04 01:30:00 | pre-event | 2007-11-29 19:56:00 |
+------+-----------------------+---------------------+--------------+---------------------+
11 rows in set (0.00 sec)