[wp-trac] [WordPress Trac] #11398: new sort method for query_posts (order by last comment date)

[WordPress Trac]

#11398: new sort method for query_posts (order by last comment date)
------------------------------+-------------------
 Reporter:  erden.ozkan       |       Owner:  ryan
     Type:  enhancement       |      Status:  new
 Priority:  normal            |   Milestone:  3.7
Component:  Query             |     Version:  2.9
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |
------------------------------+-------------------

Comment (by nacin):

 Replying to [comment:4 wonderboymusic]:
 > The big issue is that it requires a `JOIN` of posts and comments which
 won't work if the tables are partitioned or something. This could be an
 option for the user, but maybe something that core never uses.

 WordPress assumes that all blog-level tables are in the same dataset can
 be joined, including posts, terms, comments, and the associated meta
 tables. Users is considered a global table, so it cannot be joined with
 comments, posts, etc. (and is not in core).

--
Ticket URL: <http://core.trac.wordpress.org/ticket/11398#comment:8>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software