How to tell WP_Query to order by 2 columns. I have 1 orderby statement now:
'meta_key' => 'date_time',
'orderby' => 'meta_value',
'meta_type' => 'DATETIME',
'order' => 'ASC',
This is fine if meta_value is different. But if it's same then results getting randomized. I need to add 1 more column to ORDER BY, for example add another
'meta_key' => 'post_id',
'orderby' => 'meta_value',
'meta_type' => 'numeric',
'order' => 'ASC',
Note that I need to CAST values.
First orderby generates SQL like this:
ORDER BY CAST(wp_postmeta.meta_value AS DATETIME) ASC
I need it to be like this:
ORDER BY CAST(wp_postmeta.meta_value AS DATETIME), wp_posts.ID ASC
I need to add some unique value in case first identical orderby column.