Ordene por valor meta, primero pro, luego gratis

Antes de disparar,solo unanota, NUNCA (mi énfasis) haga uso de query_posts para crear consultaspersonalizadas

Nota: estafunciónnoestá destinada a ser utilizadapor complementos otemas. Como seexplicamás adelante,existen opcionesmejores ymáseficacesparamodificar la consultaprincipal. query_posts ()es unaforma demasiado simplista yproblemática demodificar la consultaprincipal de unapágina reemplazándola con unanuevainstancia de la consulta. Esineficiente (vuelve aejecutar consultas SQL) yfallará rotundamenteen algunas circunstancias (especialmente cuando setrata de lapaginación depublicaciones).

En su lugar,utilice WP_Query o get_posts para crear consultaspersonalizadas,pero SOLO sino sepuedemodificar la consultaprincipal con pre_get_posts . Para obtenermásinformación,consulte estapublicación

Suponiendo que solo hay dos valorespara su meta_key ( TENGA EN CUENTA: Parafines deprueba,he usadomi propiameta clave,debe reemplazarla con la suyapropia ),es decir,pro y free,puede recuperarpublicaciones quetenganesta meta_keyespecífica. Su consulta se verá así:

 $args = [
    'meta_key'          => 'packages',
    'orderby'           => 'rand',
    'posts_per_page'    => 5,
];

$the_query = new WP_Query( $args );
 

Sinembargo,sitiene más valores queestos dos,entonces deberá ajustar su consultaparaincluirel meta_value y luego hacer uso delparámetro meta_compare. Su consulta ajustada se convertiráen:

 $args = [
    'meta_key'          => 'packages',
    'meta_value'        => 'free, pro',
    'orderby'           => 'rand',
    'meta_compare'      => 'IN',
    'posts_per_page'    => 5,
];
 

( PD! Antes de continuar,debeteneren cuenta queelparámetro orderby ha cambiadoen la versión 4.0,peroestonofuncionaráen estainstancia.

Genial,ahoratendrás 5publicaciones que se recuperaron aleatoriamente y quetienen un meta_value de pro o free

Ahoratenemos que ordenarlos. Lamejor soluciónposiblees usar usort para ordenar lamatriz depublicaciones devueltaen $the_query->posts de acuerdo conel valor de laspublicaciones meta_value. Luego deberá desarmar $the_query->posts y luego restablecerlo con lamatriz depublicaciones reordenada.

Aquíestáel código completo:

 <?php
$args = [
    'meta_key'          => 'packages',
    'meta_value'        => 'free, pro',
    'orderby'           => 'rand',
    'meta_compare'      => 'IN',
    'posts_per_page'    => 5,
];

$the_query = new WP_Query( $args );
$post_metas = $the_query->posts;

usort( $post_metas, function( $a, $b ){
    $a = get_post_meta( $a->ID , 'packages', true ) ;
    $b = get_post_meta( $b->ID, 'packages', true ) ;

    if ( $a == $b ) {
        return 0;
    }
        return ( $a > $b ) ? -1 : 1;
    }
);

unset($the_query->posts);
$the_query->posts = $post_metas;

if ( $the_query->have_posts() ) {
    echo '<ul>';
    while ( $the_query->have_posts() ) {
        $the_query->the_post();

        echo '<li>' . get_post_meta( get_the_ID(), 'packages', true ). '</br>' . get_the_title() . '</li>';

    }
    echo '</ul>';
} 
wp_reset_postdata();
?>
 

Solonecesitará ajustar las variables de consultapara que se adapten a susnecesidades ytambién ajustarel cicloparamostrar lo que senecesita

Sinembargo,estanoes la únicaforma de lograrlo,tambiénpuedemover sufunción de clasificación a sufunctions.php y apuntarespecíficamente aesta consultapersonalizada

Before I fire away, just one note, NEVER (my emphasis) make use of query_posts to create custom queries

Note: This function isn't meant to be used by plugins or themes. As explained later, there are better, more performant options to alter the main query. query_posts() is overly simplistic and problematic way to modify main query of a page by replacing it with new instance of the query. It is inefficient (re-runs SQL queries) and will outright fail in some circumstances (especially often when dealing with posts pagination).

Rather make use of WP_Query or get_posts to create custom queries, but ONLY if you can't modify the main query with pre_get_posts. For more info, check out this post

Assuming that there are only two values for your meta_key (PLEASE NOTE: For testing purposes, I have used my own meta key, you should replace this with your own), namely pro and free, you can just retrieve posts that has this specific meta_key. Your query will then look something like this:

$args = [
    'meta_key'          => 'packages',
    'orderby'           => 'rand',
    'posts_per_page'    => 5,
];

$the_query = new WP_Query( $args );

If you however have more values than just these two, then you will need to adjust your query to include the meta_value and then make use of the meta_compare parameter. Your adjusted query will then become:

$args = [
    'meta_key'          => 'packages',
    'meta_value'        => 'free, pro',
    'orderby'           => 'rand',
    'meta_compare'      => 'IN',
    'posts_per_page'    => 5,
];

(PS! Before I go on, you should note that the orderby parameter has changed in version 4.0, but this will not work in this instance.

Great, you will now have 5 posts that was retrieved randomly which has either a meta_value of pro or free

Now we need to sort them. The best possible solution is to make use of usort to sort the returned array of posts in $the_query->posts according to the value of the posts meta_value. You will then need to unset $the_query->posts and then reset it with the reordered post array.

Here is the complete code:

<?php
$args = [
    'meta_key'          => 'packages',
    'meta_value'        => 'free, pro',
    'orderby'           => 'rand',
    'meta_compare'      => 'IN',
    'posts_per_page'    => 5,
];

$the_query = new WP_Query( $args );
$post_metas = $the_query->posts;

usort( $post_metas, function( $a, $b ){
    $a = get_post_meta( $a->ID , 'packages', true ) ;
    $b = get_post_meta( $b->ID, 'packages', true ) ;

    if ( $a == $b ) {
        return 0;
    }
        return ( $a > $b ) ? -1 : 1;
    }
);

unset($the_query->posts);
$the_query->posts = $post_metas;

if ( $the_query->have_posts() ) {
    echo '<ul>';
    while ( $the_query->have_posts() ) {
        $the_query->the_post();

        echo '<li>' . get_post_meta( get_the_ID(), 'packages', true ). '</br>' . get_the_title() . '</li>';

    }
    echo '</ul>';
} 
wp_reset_postdata();
?>

You will just need to adjust the query variables to suit your needs and also adjust the loop to display what is needed

This is not the only way to achieve it though, you can also move your sorting function to your functions.php and specifically target this custom query

Debe consultarpor meta_keyen lugar de meta_value:

  $query_string . '&meta_key=name_of_key_that_stores_free_or_pro&orderby=meta_value_num'
 

You need to query by the meta_key instead of meta_value:

 $query_string . '&meta_key=name_of_key_that_stores_free_or_pro&orderby=meta_value_num'