Title: Date Queries
Last modified: August 19, 2016

---

# Date Queries

 *  [Dennis Whiteman](https://wordpress.org/support/users/fastpipe/)
 * (@fastpipe)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/date-queries/)
 * We are getting crushed this morning with some unusual queries based on post date
   that seem to be taking a long time:
 * `# Time: 101018 13:04:15
    # Query_time: 40 Lock_time: 0 Rows_sent: 1 Rows_examined:
   15792 SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2006-09-12 00:00:00'
   AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC
   LIMIT 1;
 * Does anyone know what might be searching for a range of dates without an upper
   limit?
 * Thanks,
 * Dennis

The topic ‘Date Queries’ is closed to new replies.

## Tags

 * [date](https://wordpress.org/support/topic-tag/date/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [query](https://wordpress.org/support/topic-tag/query/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [Dennis Whiteman](https://wordpress.org/support/users/fastpipe/)
 * Last activity: [15 years, 7 months ago](https://wordpress.org/support/topic/date-queries/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics