Orderby custom field meta value ASC and then by date DESC

Assuming the rest works, why not order the normal way:

function sort_posts_orderby( $orderby ) {
    $orderby = 'wp_postmeta.meta_value ASC, wp_posts.post_date DESC';
    return $orderby;
}