Trier par DESC, ASC dans WP_Query personnalisé

Je doiseffectuer untri àplusieursniveaux dans une requête. Leproblèmeest de commander une valeur DESCet l'autre ASC comme dans SQL. Le SQL suivant sembleme donner ce queje veux quandje l'exécute dans leterminal:

 SELECT DISTINCT * FROM wp_posts 
INNER JOIN wp_postmeta 
ON wp_posts.ID = wp_postmeta.post_id 
WHERE wp_posts.post_type = 'post' 
AND wp_postmeta.meta_key = 'pb_issue_featured'
AND wp_posts.post_status = 'publish' 
ORDER BY wp_postmeta.meta_value DESC, wp_posts.menu_order ASC;
 

Le pb_issue_featuredest une valeurbooléenne. Le résultatfinal dontj'aibesoinest la requêtepour afficher lesmessages qui ont une valeurméta de 1pour ce champen haut,puistous les autres ci-dessous. Ensuite,le deuxièmeniveau de classementest le menu_order désigné (j'utilise leplugin de commande destypes depublication).

Leproblèmeest quema valeurbooléenne doit être ordonnée de hauten bas (1 à 0)mais lemenu_orderest le contraire. Ce quiest commandéen premier avec leplugin a un ordre demenu de 1. Donc,utiliser le 'orderby'intégré dans WP_Queryne fonctionnepas. Quelqu'un a des suggestions? J'ai regardé dans lefiltre 'posts_orderby'maisje n'aipaspu lefaireprendre. Jene savaispas vraiment oùil devait être appliquéni commentje pourrais le résoudre. Iln'atout simplementpas réorganisé lafaçon dontje l'avais.

Mercipour l'aide! Jepublierai la WP_Query réelle sielleestpertinente,maisje voulais que cela soit aussi court quepossible.

La requête args:

 $args = array(
        'post_type' => 'post',
        'meta_key' => 'pb_issue_featured',
        'orderby'   => 'meta_value',
        'order' => 'DESC',
        'post_status' => 'publish',
        'posts_per_page' => $posts,
        'paged' => $paged,
        'meta_query' => array(
            array(
                'key' => 'headline',
                'value' => 1,
                'compare' => '!=' 
                )
            )
        );
$q = new WP_Query($args);
 

I need to do multi-level ordering in a query. The issue is with ordering one value DESC and the other ASC as in SQL. The following SQL seems to give me what I want when I run it in terminal:

SELECT DISTINCT * FROM wp_posts 
INNER JOIN wp_postmeta 
ON wp_posts.ID = wp_postmeta.post_id 
WHERE wp_posts.post_type = 'post' 
AND wp_postmeta.meta_key = 'pb_issue_featured'
AND wp_posts.post_status = 'publish' 
ORDER BY wp_postmeta.meta_value DESC, wp_posts.menu_order ASC;

The pb_issue_featured is a boolean value. The end result I need is the query to display posts that have a meta value of 1 for this field at the top, then all the others bellow. Then the second tier ordering is the designated menu_order (I'm using the post types order plugin).

The issue is that my boolean value needs to be ordered high to low (1 to 0) but the menu_order is the opposite. What is ordered first with the plugin has a menu order of 1. So using the built in 'orderby' in WP_Query doesn't work. Anyone have suggestions? I looked into the 'posts_orderby' filter but couldn't get it to take. Wasn't really sure where it should be applied or how I could troubleshoot it. It just didn't re order the way I had it.

Thanks for the help! I will post the actual WP_Query if it's relevant but I wanted to keep this as short as possible.

The query args:

$args = array(
        'post_type' => 'post',
        'meta_key' => 'pb_issue_featured',
        'orderby'   => 'meta_value',
        'order' => 'DESC',
        'post_status' => 'publish',
        'posts_per_page' => $posts,
        'paged' => $paged,
        'meta_query' => array(
            array(
                'key' => 'headline',
                'value' => 1,
                'compare' => '!=' 
                )
            )
        );
$q = new WP_Query($args);