[wp-trac] [WordPress Trac] #17065: Independent ASC/DESC in multiple ORDER BY statement.

[WordPress Trac]

#17065: Independent ASC/DESC in multiple ORDER BY statement.
----------------------------+-----------------------
 Reporter:  ericmann        |       Owner:  ericmann
     Type:  task (blessed)  |      Status:  closed
 Priority:  normal          |   Milestone:  4.0
Component:  Query           |     Version:  3.1
 Severity:  normal          |  Resolution:  fixed
 Keywords:  has-patch       |     Focuses:
----------------------------+-----------------------

Comment (by RossCurrie):

 I'm not sure that this is a meaningful contribution, or even the right
 thread for it, but I think it's worth pointing out somewhere that ordering
 by multiple attributes doesn't really work well when date/post_date is
 used, as it's sorted as a datetime value. Even posts on the same date are
 still ordered by the time they were created.

 So if I want to sort by date,meta or date,title it just doesn't work.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/17065#comment:70>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform