How to get tag search result list to order by last post date?

[B-runner]

Mega old thread bump.

What is suggested isn't exactly possible without more work, hence the error:

MySQL Error : Unknown column 'lastpost' in 'order clause'

The columns available in tagcontent are: tagid, contenttypeid, contentid, userid, dateline. There is no lastpost.

The dateline is the date the tag was added.
The userid is the user who added the tag (this could help track down a rouge tagger )
The contentid is an ID # based on when the content was created. This can allow you to sort based on when the thread was created, and not when the tag was applied. This is at least better for me since I can back-apply tags to old thread and it's not good to have those show up before new threads.

It looks like the contenttypeid determines if it is a forum post, blog or article.

For me, it looks like it puts posts before blog entries in results this list.


Note, as there is no "lastpost" in the tagcontent, and it won't make sense either since it only gets updated when a new tag is added. To get a lastpost one would have to take the contentid and then go to another table and query to get that based on the contentid, which would take hacking up the php a little more. I'm good with what I have for now.


(Adding info since this place is searched often and provides great info. Also, I don't get to contribute much elsewhere. )