Hello all, i have strange behavior after updating to v4, ihave 2custom fields one is a date field and the other is list field containning numbers (for order position ex: 01,02,03...50) like that:
custom query :
$join .= " LEFT JOIN $wpdb->postmeta AS pm1 ON ($wpdb->posts.ID = pm1.post_id AND pm1.meta_key = 'post_date')
LEFT JOIN $wpdb->postmeta AS pm2 ON ($wpdb->posts.ID = pm2.post_id AND pm2.meta_key = 'post_order')"
note here that the custom fields are : post_date and post_order
and here is the order query:
$orderby = " pm1.meta_value DESC, pm2.meta_value ASC, DATE($wpdb->posts.post_date) DESC";
in latest v3 of the plugin all was working fine, but after updating to v4 the order is not working as expected