Title: SQL Query Help
Last modified: August 18, 2016

---

# SQL Query Help

 *  [trmtnbike](https://wordpress.org/support/users/trmtnbike/)
 * (@trmtnbike)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/sql-query-help-1/)
 * I originally posted this to the Themes and Templates forum, but thought I may
   get more help here.
 * Is anyone aware of a way to query for the date and time a category last had a
   post added to it?
 * Please note: I cannot rely on the timestamp of the most recent post in the category,
   as they do not necessarily reflect the date in which a post was added to a category.
   For instance, if a post was made on August 1, 2005, and was then added to a category
   on July 20, 2006, I would want a way to display that the category was last updated
   on July 20, 2006.
 * I added a timestamp to the post2cat table a long while ago to give myself this
   functionality, but was hoping that someone – with more knowledge of the WordPress
   DB schema than I – would know of a way around doing so.
 * The ultimate aim is to make my photoblog theme more easily distributable.

The topic ‘SQL Query Help’ is closed to new replies.

## Tags

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

 * 0 replies
 * 1 participant
 * Last reply from: [trmtnbike](https://wordpress.org/support/users/trmtnbike/)
 * Last activity: [19 years, 11 months ago](https://wordpress.org/support/topic/sql-query-help-1/)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics