Ist es mit wp_query möglich, nach Taxonomie zu bestellen?

Nein,esistnichtmöglich,nach Taxonomie zubestellen,da dies unterbestimmten Gesichtspunkteneigentlichnicht viel Sinnmacht.

Taxonomien sind Möglichkeiten,Dinge zugruppieren. Der Sinneiner Taxonomiefür Postsbesteht also darin,Begriffein dieser Taxonomie zu haben,die zwischen Postsgeteilt werden. Wenneine Taxonomie Begriffe hätte,diejeweilsnurfüreinen Beitrag verwendet würden,wäre die Taxonomieirgendwie sinnlos. Und wenn die Begriffe sogeteilt würden,wie sie sein sollten,würdeeine Bestellungnach diesennichtsbesonders Nützlichesergeben.

Ineiner solchen Situation sollten Sie das Post-Meta verwenden. Sie könnennach Post-Metabestellen undesistfürjeden Posteinzigartig.

Bearbeiten: Das heißt,Sie könnennach Taxonomie ordnen,indem Sieeine benutzerdefinierte SQL-Abfragemithilfeeines Filterserstellen. Sie können dieseinfachnicht übereine unveränderte WP_Querytun: http://scribu.net/wordpress/sortable-taxonomy-columns.html

Wenn Siejedoch auf solche Dinge zurückgreifenmüssen,ist Ihre Datenentwurfsstrukturin erster Liniefalsch. "Begriffe"in der Taxonomie sind keinetatsächlichen "Daten". Die Begriffe selbst haben keineinhärente Bedeutung,sie sindnur Bezeichnungenfür diebestimmte Gruppierung,die siebeschreiben. Wenn Sie sie als aussagekräftige Datenbehandeln,liegt Ihnenein Konstruktionsfehler zugrunde.

Taxonomiengruppieren Dinge,indem sieihnen Begriffe zuweisen. Diese Gruppierungist der springende Punktbei Taxonomien. Die Begriffe sindnur hübsche Gesichterin der Gruppierung. Wenn Sie aussagekräftige Metadaten haben,die Sieeinem Beitrag zuweisen können,sollten Sie stattdessen das Beitrags-Meta dafür verwenden. Und dass Sie nach bestellen können,da Post-Meta sowohl Schlüssel als auch Werte zum Speichern von Informationen verwendet. Miteiner Taxonomie speichern Sie wirklichnur Schlüssel,deren Werte die Beiträge sind,dienach diesem Begriff zusammengefasst sind.

Auf lange Sicht sind die Dingeeinfacher,wenn Sie den richtigen Ansatz dafür verwenden. Ich sage zwarnicht,dass Siemit Taxonomienichts Seltsames anfangen können,aber Siemachenes sich auf lange Sichtnur schwerer,indem Sieesfalsch verwenden.

No, it is not possible to order by taxonomy, because from a certain type of standpoint, that doesn't actually make much sense.

Taxonomies are ways to group things together. So the point of having a taxonomy on posts would really be to have terms in that taxonomy that are shared between posts. If a taxonomy had terms that were only used on one post each, then that would make the taxonomy kind of pointless. And if the terms were shared like they should be, then ordering by it wouldn't produce anything particularly useful.

What you should be using in such a situation is the post meta. You can order by post meta, and it's unique to each post.

Edit: That said, you can order by taxonomy by making a custom SQL query using a filter, you just can't do it from a unmodified WP_Query: http://scribu.net/wordpress/sortable-taxonomy-columns.html

However, if you're having to resort to doing this sort of thing, then your data design structure is wrong in the first place. "Terms" in the taxonomy are not actual "data". The terms themselves have no inherent meaning, they're just labels for the particular grouping that they're describing. If you're treating them as meaningful data, then you have an underlying design flaw.

Taxonomies group things by assigning terms to them. That grouping is the whole point of taxonomies, the terms are just pretty faces on the grouping. If you have meaningful metadata to assign to a post, then you should be using the post meta for it instead. And that you can order by, because post meta uses both keys and values to store information. With a taxonomy, you're really only storing keys, with their values being the posts grouped together by that term.

Things are easier in the long run if you use the correct approach for it. While I'm not saying that you can't do something strange with taxonomy, you're just making things harder for yourself in the long run by using it wrong.

Die akzeptierte Antwort auf diese Frageistnicht akzeptabel. Esist unlogisch anzunehmen,dasseine Bestellungnach Steuern "keinen Sinnergibt". Die Antwort,dieergab,macht keinen Sinn.

Erwägen Sieeinen Menüposttyp. Dann haben Sieeine benutzerdefinierte Steuer von "FoodCategories". Die FoodCategories-Steuerenthält die Begriffe "Frühstück","Mittagessen" und "Abendessen". Wenn Sieeine Abfragemit dem Parametertax_query senden,haben Siejetzteine Ergebnismengemit allen Begriffen,diejedochnach Postdatum sortiert sind.

Um aus diesen die richtige Reihenfolgein Bezug aufihre Begriffe zuerhalten und sie dannim Frontend angemessen anzuzeigen,indem die Beiträgein ihre verschiedenen Kategorien unterteilt werden,müssen Sie die Ergebnismenge durchlaufen und dannjedeeinzelne abfragen Posten Sieinnerhalb der Ergebnismenge,um die Begriffe zufinden undmit dem aktuellen Begriff zu vergleichen,filtern Siein ein Array undfahren Sie durchgehendfort. Dannmüssen Sie dasneue Arrayerneut durchlaufen,umes anzuzeigen. Diesistnichtproduktiv.

Es wäre schön,wenn WPeine Orderby-Option "tax__in" hätte,wieeine Option "post__in",aber da diesnicht der Fallist,müssen Sieentweder den obengenannten lächerlichen Prozess ausführen. Passen Sie die Abfrage selbst über die Filter 'posts_orderby' und 'posts_join' an,um die orderby-Methode anzupassen und den Begriff zur Ergebnismenge hinzuzufügen. oder Siemüssenfürjeden Begriff,nach dem Siein den HTML-Abschnitten relativ zu diesen Begriffenfiltern,eine neue Abfrage durchführen.

Ameffizientesten wärees,die Abfragezeichenfolgemithilfe von Filtern zu ändern. Ameinfachsten wärees,drei separate Abfragen durchzuführen. Die WP-API sollte die Bestellungnach Steuern oder restriktiven Abfrageparametern verarbeiten. Wenn Sieeine Abfragebasierend aufbestimmten Bedingungeneinschränken,bestehteine hohe Wahrscheinlichkeit,dass vielenach denselben Bedingungenbestellenmüssen.

The accepted answer for this question is unacceptable. It is illogical to assume that ordering by tax "doesn't make sense". The answer he gave doesn't make sense.

Consider having a menu post type. Then you have a custom tax of "FoodCategories". The FoodCategories tax has "Breakfast", "Lunch" and "Dinner" terms. If you submit a query utilizing the tax_query param, you now have a result set with all of the terms, however they are ordered by post date.

In order to get the correct order out of these, relative to their terms, and then to display on the front end appropriately by separating the posts into their various categories, you have to loop through the result set, then query each individual post within the result set to find it's terms and compare to the current term, filter into an array and continue throughout. Then you have to again loop through the new array for display. This is not productive.

It would be nice if WP had a "tax__in" orderby option as it does a "post__in" one, but since it does not, you either have to do the above ridiculous process; customize the query yourself by way of 'posts_orderby' filter and 'posts_join' filter in order to adjust the orderby method and add the term to the result set, respectively; or you have to make a new query for each term you are filtering for within the html sections relative to those terms.

The most efficient would be to change the query string by way of filters. The easiest would be to do three separate queries. The WP API should be handling ordering by tax, or any restrictive query parameters. If you are restricting a query based on certain conditions, there is a high probability that many will have need to order by those same conditions.

Ja,aberesist ziemlich kompliziert ...

Fügen Siein Ihrem Thema zufunctions.php hinzu:

 function orderby_tax_clauses( $clauses, $wp_query ) {
    global $wpdb;
    $taxonomies = get_taxonomies();
    foreach ($taxonomies as $taxonomy) {
        if ( isset( $wp_query->query['orderby'] ) && $taxonomy == $wp_query->query['orderby'] ) {
            $clauses['join'] .=<<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
            $clauses['where'] .= " AND (taxonomy = '{$taxonomy}' OR taxonomy IS NULL)";
            $clauses['groupby'] = "object_id";
            $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.name ORDER BY name ASC) ";
            $clauses['orderby'] .= ( 'ASC' == strtoupper( $wp_query->get('order') ) ) ? 'ASC' : 'DESC';
        }
    }
    return $clauses;
}

    add_filter('posts_clauses', 'orderby_tax_clauses', 10, 2 );
 

Diesistfrankensteined voneinigen gefundenen Sachen undeinigen Sachen,dieich selbstgemacht habe. Das Erklärenist ziemlich schwierig,aber unter dem Strich können Sie? Orderby=(Taxonomie-Abfrage var) & order=ASC (oder DESC)eingeben und sie wird sofort loslegen!

Yes, but it is pretty involved...

Add to functions.php in your theme:

function orderby_tax_clauses( $clauses, $wp_query ) {
    global $wpdb;
    $taxonomies = get_taxonomies();
    foreach ($taxonomies as $taxonomy) {
        if ( isset( $wp_query->query['orderby'] ) && $taxonomy == $wp_query->query['orderby'] ) {
            $clauses['join'] .=<<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
            $clauses['where'] .= " AND (taxonomy = '{$taxonomy}' OR taxonomy IS NULL)";
            $clauses['groupby'] = "object_id";
            $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.name ORDER BY name ASC) ";
            $clauses['orderby'] .= ( 'ASC' == strtoupper( $wp_query->get('order') ) ) ? 'ASC' : 'DESC';
        }
    }
    return $clauses;
}

    add_filter('posts_clauses', 'orderby_tax_clauses', 10, 2 );

This is frankensteined from some found stuff and some stuff I did myself. Explaining is pretty tough, but the bottom line is with this running, you may put ?orderby=(taxonomy query var)&order=ASC (or DESC) and she'll take right off!

Ich komme hier zu spät zum Spiel,aberesgibt eineeinfachere WordPressy-Methode,um dies zutun.

Erstellen Sie Ihre Steuerabfrage wiegewohnt.

 $tax_query = array();
$tax_query['relation']="OR";
$tax_query[] = array(
    'taxonomy' => 'product_cat',
    'field'    => 'slug',
    'terms'    => $cat_terms,
);
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
 

Richten Sie Ihre Argumentefür query_posts oder WP_Query

 $args = array(
    'post_type'=>'post',
    'posts_per_page'=>12,
    'paged'=>$paged,
    'tax_query' => $tax_query,
);
 

Bevor Sie Ihren Aufruf von query_posts/WP_Query ausführen,schließen Sie den orderby-Filter an und überschreiben Sieihn

 add_filter('posts_orderby', 'edit_posts_orderby');
function edit_posts_orderby($orderby_statement) {
    $orderby_statement = " term_taxonomy_id ASC ";
    return $orderby_statement;
}
query_posts($args);
remove_filter('posts_orderby', 'edit_posts_orderby');
 

Vergessen Sienicht,den Filter anschließend zuentfernen ...

diesfunktioniertb/c dietax_queryerstellt die Joins usw.für Sie,Siemüssennurnacheinem der Felder aus dem Joinbestellen.

I'm coming late to the game here, but there is a simpler more WordPressy way of doing this.

Build out your tax query like normal.

$tax_query = array();
$tax_query['relation']="OR";
$tax_query[] = array(
    'taxonomy' => 'product_cat',
    'field'    => 'slug',
    'terms'    => $cat_terms,
);
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

Set up your args for query_posts or WP_Query

$args = array(
    'post_type'=>'post',
    'posts_per_page'=>12,
    'paged'=>$paged,
    'tax_query' => $tax_query,
);

Before you make your query_posts / WP_Query call, hook into the orderby filter and override it

add_filter('posts_orderby', 'edit_posts_orderby');
function edit_posts_orderby($orderby_statement) {
    $orderby_statement = " term_taxonomy_id ASC ";
    return $orderby_statement;
}
query_posts($args);
remove_filter('posts_orderby', 'edit_posts_orderby');

don't forget to remove filter afterwards...

this works b/c the tax_query creates the joins etc for you, you just need to order by one of the fields from the join.

Ichbin mirnicht sicher,warum alle Lösungen hier so ziemlich übertrieben sind.OK,esistein halbes Jahrzehnt her,aberichführegerade denfolgenden Code aus undesfunktioniert:

    <?php // Default
    $wheels_args = array(
        'post_type' => 'wheels',
        'posts_per_page' => '96',
        'orderby' => 'taxonomy, name', // Just enter 2 parameters here, seprated by comma
        'order'=>'ASC'
    );
    $loop = new WP_Query($wheels_args);
    ?>
 

Hiermit werden die Taxonomien Ihres CPT zuerstnach seiner Taxonomiein alphabetischer Reihenfolge undinnerhalb dieser Taxonomiegruppen auchnach alphabetischer Reihenfolge sortiert.

I'm not sure why all solutions here are pretty much overkilling it. OK, it's half a decade ago, but I'm just running the following code currently and it works:

   <?php // Default
    $wheels_args = array(
        'post_type' => 'wheels',
        'posts_per_page' => '96',
        'orderby' => 'taxonomy, name', // Just enter 2 parameters here, seprated by comma
        'order'=>'ASC'
    );
    $loop = new WP_Query($wheels_args);
    ?>

This will sort the taxonomies of your CPT first by it's taxonomy in alphabetical order and within these taxonomy groups als by alphabetical order.

Nun,ichmöchtemeine Erfahrungbeim Sortierenbenutzerdefinierter Beitragstypennach Kategorie/Taxonomie offenlegen.

DAS WEB

1. Eine Reisebüro-Website unter WordPress
2. Hauptinhalt desbenutzerdefinierten Beitragstyps "Ruta"
3. Taxonomiemit dieser Struktur Reisetyp> Kontinent> Land

DER FALL

Auf Seitenmit Archivkategorielisten wollte der Kunde,dass die Beiträgenach

1. Der Kontinent,geordnetnach Anzahl der Routen aufjeder.
2. Das Land,alphabetisch sortiert.

DIE SCHRITTE

Zuerst erhalteich die Anfrage von der unveränderten Archivseitenabfrage,die zufällig so aussah:

 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts 
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) )
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_date DESC LIMIT 0, 20
 

Zweitens habeich den SQL-Codein Sequel Pro anhand der Datenbankbearbeitet,ummeinen Anforderungen zuentsprechen. Ich komme damit heraus (ja,wahrscheinlich kannes verbessert werden:meine Kenntnisse über MySQL sindnicht herausragend):

 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id =  tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    ) AS Total
FROM  wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )
WHERE 1=1  
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) ) 
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY
total DESC,
wp_terms.name  
 

Drittens habeich die Abfragein die Dateifunctions.phpmit drei Filterneingebunden:posts_fields,posts_join undposts_orderby

Der Codein functions.php:

 function xc_query_fields( $fields ) {

   $fields = "wp_posts.ID, wp_posts.post_title, wp_terms.name, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id = tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    )
    AS Total";
     return $fields;
}


function xc_query_joins( $join ) {
$join .= "INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
   INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
   INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )";
 return $join;
}


function xc_query_orderby( $join ) {
    $join = "total DESC, wp_terms.name ";
    return $join;
 }
 

Schließlich habeich die Filter aus dempre_get_post-Hook unterbestimmten Bedingungen ausgelöst

 function filtra_queries( $query )
{

  if (  is_archive()  && $query->is_main_query() && !is_admin()  ) {

$rutes = array('viajes-privados', 'asia', 'africa', 'oceania', 'america', 'oriente-proximo');

if  ( in_array( $query->get('category_name'), $rutes ) ) 
  {
  add_filter( 'posts_fields', 'xc_query_fields' );
  add_filter( 'posts_join', 'xc_query_joins' );
  add_filter( 'posts_orderby', 'xc_query_orderby' );
}// end if in_array

  }// end if is_archive

}
 add_filter('pre_get_posts', 'filtra_queries');
 

Hoffe,das kannjemandem helfen

Well, I’d like to expose my experience in sorting custom post types by category/taxonomy.

THE WEB

1. A travel agency web site running on WordPress
2. Main content on custom post type called ‘ruta’
3. Taxonomy with this structure Type-of-travel > continent >country

THE CASE

In archive category list pages, the client wanted the posts to be sorted by

1. The continent, ordered by number of routes on each one.
2. The country, ordered alphabetically.

THE STEPS

First, I catch the request from the unmodified archive page query which happened to be like this:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts 
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) )
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_date DESC LIMIT 0, 20

Second, I edited the sql code in Sequel Pro against the database to conform my needs. I come out with this (yes, probably it can be improved: my knowledge on MySQL is not outstanding):

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id =  tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    ) AS Total
FROM  wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )
WHERE 1=1  
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) ) 
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY
total DESC,
wp_terms.name  

Third, I hooked the query on the functions.php file with three filters: posts_fields, posts_join and posts_orderby

The code in functions.php:

function xc_query_fields( $fields ) {

   $fields = "wp_posts.ID, wp_posts.post_title, wp_terms.name, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id = tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    )
    AS Total";
     return $fields;
}


function xc_query_joins( $join ) {
$join .= "INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
   INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
   INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )";
 return $join;
}


function xc_query_orderby( $join ) {
    $join = "total DESC, wp_terms.name ";
    return $join;
 }

Finally I triggered the filters from the pre_get_post hook according to some conditions

function filtra_queries( $query )
{

  if (  is_archive()  && $query->is_main_query() && !is_admin()  ) {

$rutes = array('viajes-privados', 'asia', 'africa', 'oceania', 'america', 'oriente-proximo');

if  ( in_array( $query->get('category_name'), $rutes ) ) 
  {
  add_filter( 'posts_fields', 'xc_query_fields' );
  add_filter( 'posts_join', 'xc_query_joins' );
  add_filter( 'posts_orderby', 'xc_query_orderby' );
}// end if in_array

  }// end if is_archive

}
 add_filter('pre_get_posts', 'filtra_queries');

Hope this can help somebody

Ich hatteein sehr ähnliches Problem,mit demichmichbefasst habe: Ichmöchteein benutzerdefiniertes Post-Type-Archiv (Zeitschriftenartikel)nacheinerbenutzerdefinierten Taxonomie (Ausgaben)bestellen. Ichmacheniemals direkte SQL-Abfragen aufmeiner Website - undnormalerweisemüssen Sie Ihren Ansatz überdenken,wenn Sie diesen anderen Antworten ähnlich sind.

PROBLEME:

1) Mit Wordpress können Sie Taxonomiennicht aufintelligente Weisebestellen.

2) Wordpresserlaubteinfachnicht,dass orderby Taxonomienfür WP_Query vom Post-Typ verwendet (wie von Ottoformuliert).

LÖSUNGEN:

1) Das Sortieren von Taxonomienerfolgt ambesten über Pluginfürbenutzerdefinierte Taxonomie-Bestellung NE im Moment. Sie können die Taxonomie über WYSIWYGin wp-adminbestellen. Das würdeichnichttun,aberich habenichts Besseresgefunden.

Wenn Sie das Plugineinrichten,erhalten Sieetwas Ähnliches wie hier. Beachten Sie die Option Auto-sort Queries of this Taxonomy - setzen Sie diese auf Custom Order as Defined Above; Dadurcherhalten Sie die Bestellung,die Siebenötigen. Screenshot:

2) Miteiner sortierten Taxonomie können Siejetzteine Reihe von WP_Query-Aufrufenerstellen,diejeden Begriff durchlaufen,und soeffektivein nach Taxonomiegeordnetes Archiverstellen. Verwenden Sie get_terms(),umein Array aller Steuerbegriffe zuerstellen,undführen Sie dannfürjeden Begriffeinen foreach aus. Dadurch wirdfürjedes Begriffselementein WP_Queryerstellt,der alle Beiträgefüreinen bestimmten Begriff zurückgibt,wodurcheffektivein nach Taxonomiebegriffgeordnetes Archiverstellt wird. Code,um dies zuermöglichen:

   // Get your terms and put them into an array
  $issue_terms = get_terms([
    'taxonomy' => 'issues',
    'hide_empty' => false,
  ]);

  // Run foreach over each term to setup query and display for posts
  foreach ($issue_terms as $issue_term) {
    $the_query = new WP_Query( array(
      'post_type' => 'post',
      'tax_query' => array(
        array(
          'taxonomy' => 'issues',
          'field' => 'slug',
          'terms' => array( $issue_term->slug ),
          'operator' => 'IN'
        )
      )
    ) );

    // Run loop over each query
    while($the_query->have_posts()) :
      $the_query->the_post();

      // YOUR TEMPLATE OUTPUT FOR EACH POST

    endwhile;
  }
 

Verwandte Lektüre auf dieser Site: Alle Beiträgein anzeigen Einbenutzerdefinierter Beitragstyp,gruppiertnacheinerbenutzerdefinierten Taxonomie

I had a very similar problem that I dealt with: I want to order a custom post-type archive (magazine articles) by a custom taxonomy (issues). I never do direct SQL queries on my site - and usually if you are like these other answers - you need to rethink your approach.

PROBLEMS:

1) Wordpress doesn't allow you to order taxonomies in any intelligent way.

2) Wordpress just doesn't allow orderby to be use taxonomies on post-type WP_Query (as spelled out by Otto).

SOLUTIONS:

1) Sorting taxonomies is best accomplished by the Custom Taxonomy Order NE plugin at the moment. It allows you to order the taxonomy via WYSIWYG in wp-admin which isn't how I would do it but I haven't found anything better.

When you setup the plugin, you'll get something similar to what I've done here. Make note of the option Auto-sort Queries of this Taxonomy - set this to Custom Order as Defined Above; this gets you the ordering you need. Screenshot:

2) With a sorted taxonomy in place, you can now create a series of WP_Query calls that run through each term, effectively creating an archive ordered by the taxonomy. Use get_terms() to create an array of all tax terms, then run a foreach over each term. This creates a WP_Query for each term item that will return all posts for a given term, effectively creating an archive ordered by taxonomy term. Code to make this happen:

  // Get your terms and put them into an array
  $issue_terms = get_terms([
    'taxonomy' => 'issues',
    'hide_empty' => false,
  ]);

  // Run foreach over each term to setup query and display for posts
  foreach ($issue_terms as $issue_term) {
    $the_query = new WP_Query( array(
      'post_type' => 'post',
      'tax_query' => array(
        array(
          'taxonomy' => 'issues',
          'field' => 'slug',
          'terms' => array( $issue_term->slug ),
          'operator' => 'IN'
        )
      )
    ) );

    // Run loop over each query
    while($the_query->have_posts()) :
      $the_query->the_post();

      // YOUR TEMPLATE OUTPUT FOR EACH POST

    endwhile;
  }

Related reading on this site: Display all posts in a custom post type, grouped by a custom taxonomy

Hierist die Lösung,dieichfür dieses spezielle Problem verwendet habe. Diese Lösungistfürextreme Fällegedacht,in denenesnichtmöglichist,einen pre_get_posts -Filter zu verwenden,undin der Abfrageeine Paginierung vorhandenist (z. B. WooCommerce):

 global $wpdb;

$taxonomies = array('my-tax-1', 'my-tax-2', 'my-tax-3');

$orderby = "'".implode("', '", array_keys($taxonomies))."'";
$id_sql = $GLOBALS['wp_query']->request;

$id_sql = preg_replace('/LIMIT\s+\d+\s?,?\s\d*/', '', $id_sql);
$id_sql = str_replace('SQL_CALC_FOUND_ROWS', '', $id_sql);

$term_sql = "SELECT
  tt.taxonomy AS `taxonomy`,
  t.name AS `term_name`,
  t.slug AS `term_slug`,
  count(*) AS `term_count`
FROM ({$id_sql}) p 
JOIN wp_term_relationships tr
  ON p.ID = tr.object_id
JOIN wp_term_taxonomy tt
  ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms t
  ON tt.term_id = t.term_id
WHERE tt.taxonomy IN ({$orderby})
GROUP BY t.slug
ORDER BY
  FIELD(tt.taxonomy, {$orderby})"; // Add further specific ordering here

$results = $wpdb->get_results($term_sql, ARRAY_A);
 

Ich habe dies verwendet,umein Navigationsmenü zuerstellen,dasnach Taxonomie,Begriff und Anzahl der Beiträgepro Begriffgeordnetist.

Wenn Sienur die Beiträgemöchten,ändern Sie die Abfragein SELECT p.* und GROUP BY p.ID

Here's the solution I've used for this particular problem. This solution is for extreme cases where it is both not possible to use a pre_get_posts filter and there is existing pagination on the query (ie: WooCommerce):

global $wpdb;

$taxonomies = array('my-tax-1', 'my-tax-2', 'my-tax-3');

$orderby = "'".implode("', '", array_keys($taxonomies))."'";
$id_sql = $GLOBALS['wp_query']->request;

$id_sql = preg_replace('/LIMIT\s+\d+\s?,?\s\d*/', '', $id_sql);
$id_sql = str_replace('SQL_CALC_FOUND_ROWS', '', $id_sql);

$term_sql = "SELECT
  tt.taxonomy AS `taxonomy`,
  t.name AS `term_name`,
  t.slug AS `term_slug`,
  count(*) AS `term_count`
FROM ({$id_sql}) p 
JOIN wp_term_relationships tr
  ON p.ID = tr.object_id
JOIN wp_term_taxonomy tt
  ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms t
  ON tt.term_id = t.term_id
WHERE tt.taxonomy IN ({$orderby})
GROUP BY t.slug
ORDER BY
  FIELD(tt.taxonomy, {$orderby})"; // Add further specific ordering here

$results = $wpdb->get_results($term_sql, ARRAY_A);

I've used this to create a nav menu ordered by taxonomy, term, and count of posts-per-term.

If you simply want the posts then change the query to SELECT p.* and GROUP BY p.ID

Esist wieeine Abfrage vor der Abfrage,aberes stört Sienicht,wenn wirnicht zu viele Beiträge abfragen ... Die Ideeist,die Hauptabfrage so zu ändern,dass wirnichteinmal zu Vorlagengehen und siegenerierenmüssenneue Abfragen und Schleifen ...

 function grouped_by_taxonomy_main_query( $query ) {

    if ( $query->is_home() && $query->is_main_query() ) { // Run only on the homepage

        $post_ids = array();

        $terms = get_terms('my_custom_taxonomy');

        foreach ( $terms as $term ) {
            $post_ids = array_merge( $post_ids, get_posts( array( 
                'posts_per_page' => 4, // as you wish...
                'post_type' => 'my_custom_post_type', // If needed... Default is posts
                'fields' => 'ids', // we only want the ids to use later in 'post__in'
                'tax_query' => array( array( 'taxonomy' => $term->taxonomy, 'field' => 'term_id', 'terms' => $term->term_id, )))) // getting posts in the current term
            );
        }

        $query->query_vars['post_type'] = 'my_custom_post_type'; // Again, if needed... Default is posts
        $query->query_vars['posts_per_page'] = 16; // If needed...
        $query->query_vars['post__in'] = $post_ids; // Filtering with the post ids we've obtained above
        $query->query_vars['orderby'] = 'post__in'; // Here we keep the order we generated in the terms loop
        $query->query_vars['ignore_sticky_posts'] = 1; // If you dont want your sticky posts to change the order

    }
}

// Hook my above function to the pre_get_posts action
add_action( 'pre_get_posts', 'grouped_by_taxonomy_main_query' );
 

It's like a query before the query, but won't bother if we're not not querying too many posts... The idea is to modify the main query so we don't even need to go to templates and generate new queries and loops...

function grouped_by_taxonomy_main_query( $query ) {

    if ( $query->is_home() && $query->is_main_query() ) { // Run only on the homepage

        $post_ids = array();

        $terms = get_terms('my_custom_taxonomy');

        foreach ( $terms as $term ) {
            $post_ids = array_merge( $post_ids, get_posts( array( 
                'posts_per_page' => 4, // as you wish...
                'post_type' => 'my_custom_post_type', // If needed... Default is posts
                'fields' => 'ids', // we only want the ids to use later in 'post__in'
                'tax_query' => array( array( 'taxonomy' => $term->taxonomy, 'field' => 'term_id', 'terms' => $term->term_id, )))) // getting posts in the current term
            );
        }

        $query->query_vars['post_type'] = 'my_custom_post_type'; // Again, if needed... Default is posts
        $query->query_vars['posts_per_page'] = 16; // If needed...
        $query->query_vars['post__in'] = $post_ids; // Filtering with the post ids we've obtained above
        $query->query_vars['orderby'] = 'post__in'; // Here we keep the order we generated in the terms loop
        $query->query_vars['ignore_sticky_posts'] = 1; // If you dont want your sticky posts to change the order

    }
}

// Hook my above function to the pre_get_posts action
add_action( 'pre_get_posts', 'grouped_by_taxonomy_main_query' );

Ichmöchtemeine Begriffemanuell sortieren,daher verwendeich dazuein Plugin. undichbin ein Fan des Filters pre_get_posts,also habeich das richtige Arbeitsbeispiel von Drew Gourleygenommen undes damit zum Laufengebracht. Dasist alsoein Sonderfall,aberichposteestrotzdem,fallsesjemandem hilft. Derfolgende Codegehtin functions.php oderein benutzerdefiniertes Plugin.

Beginnen wir zuerstmit dem Filter. Wirbestellen denbenutzerdefinierten Beitragstyp musicnachbenutzerdefinierter Taxonomie style

 function so14306_pre_get_posts($query)
{
    if (is_admin()) :
        return;
    endif;

    if ($query->is_main_query()) :
        if (is_post_type_archive('music')) :
            $query->set('orderby', 'style');

        endif;
    endif;
}

add_action('pre_get_posts', 'so14306_pre_get_posts');
 

dann rufen wir den Filterpost_clauses auf:

 function so14306_posts_clauses($clauses, $wp_query)
{
    global $wpdb;

    if (isset($wp_query->query_vars['orderby']) && $wp_query->query_vars['orderby'] === 'style') {
        $orderby = $wp_query->query_vars['orderby'];
        $clauses['join'] .= <<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
        $clauses['where'] .= " AND (taxonomy = '{$orderby}' OR taxonomy IS NULL)";
        $clauses['groupby'] = "object_id";
        $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.term_order ORDER BY {$wpdb->terms}.term_order ASC) ASC";
        $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC";
    }

    return $clauses;
}

add_filter('posts_clauses', 'so14306_posts_clauses', 10, 2);
 

Jetztmüssen Sienurnoch Ihre Taxonomienmit demfolgenden Plugin sortieren: Einfachebenutzerdefinierte Nachbestellung . Dieses Pluginistfür diese Lösung obligatorisch ,daes der Datenbank die Spalte term_order hinzufügt!

und diese Zeile hier: $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC" ordnet die Postsnach Titel,daher lautet die vollständige Sortierung der obigen Lösung:taxonomyterm=> Post-Titel.

i like to sort my terms manually, so i use a plugin to do so. and i'm a fan of the pre_get_posts filter, so i took the proper working example of Drew Gourley and made it work with that. so this is some kinda special case, but i'm posting this anyhow, in case it helps someone. following code goes into functions.php or a custom plugin.

first lets start of with the filter. we order the custom post type music by custom taxonomy style

function so14306_pre_get_posts($query)
{
    if (is_admin()) :
        return;
    endif;

    if ($query->is_main_query()) :
        if (is_post_type_archive('music')) :
            $query->set('orderby', 'style');

        endif;
    endif;
}

add_action('pre_get_posts', 'so14306_pre_get_posts');

then we call the post_clauses filter:

function so14306_posts_clauses($clauses, $wp_query)
{
    global $wpdb;

    if (isset($wp_query->query_vars['orderby']) && $wp_query->query_vars['orderby'] === 'style') {
        $orderby = $wp_query->query_vars['orderby'];
        $clauses['join'] .= <<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
        $clauses['where'] .= " AND (taxonomy = '{$orderby}' OR taxonomy IS NULL)";
        $clauses['groupby'] = "object_id";
        $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.term_order ORDER BY {$wpdb->terms}.term_order ASC) ASC";
        $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC";
    }

    return $clauses;
}

add_filter('posts_clauses', 'so14306_posts_clauses', 10, 2);

now all you need to do, is sort your taxonomies with the following plugin: Simple Custom Post Order. This plugin is mandatory for this solution, since it adds the column term_order to the database!

and this line here: $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC" orders the posts by title, so the full sorting of the above solution is: taxonomy term => post title.