Query Help

[brianlange]

I have an online forum and have an issue where replies have a earlier `created` date than the first post in the thread. I need to query for all thread posts that have a reply with an earlier `created` date. I want to write a query like this

"SELECT id, thread_id, created from posts where  thread_id in (Sub query for replies order by created desc limit one and created is greater

than the created value in the first post) Am I making sense?

 

I know I could loop through all the records with php and check for this type of thing, but I was hoping to do it with a single query.

 

Thanks.

 

 

   

[fenway]

Try thinking about this from the inside-out, then piece the query back together.