W3cubDocs

/WordPress

apply_filters_ref_array( ‘posts_groupby’, string $groupby, WP_Query $query )

Filters the GROUP BY clause of the query.

Parameters

$groupbystring
The GROUP BY clause of the query.
$queryWP_Query
The WP_Query instance (passed by reference).

More Information

  • If you come with MySQL knowledge, the GROUP BY clause is pretty useless without the ability to modify the SELECT statement.
  • There is no SELECT filter since the query is supposed to return only the post data. The GROUP BY clause is set only when there are Custom Field Parameters for querying by post meta or Taxonomy Parameters for querying by taxonomy.
  • The default posts_groupby is set to {$wpdb->posts}.ID, which means that even if there are multiple results because of multiple meta and taxonomy, they are grouped together by the post id.

Source

$groupby = apply_filters_ref_array( 'posts_groupby', array( $groupby, &$this ) );

Changelog

Version Description
2.0.0 Introduced.

© 2003–2024 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/hooks/posts_groupby