[wp-trac] [WordPress Trac] #11398: new sort method for query_posts (order by last comment date)
WordPress Trac
noreply at wordpress.org
Fri Aug 23 17:40:31 UTC 2013
#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
More information about the wp-trac
mailing list