apply_filters_ref_array( ‘posts_clauses’, string[] $clauses, WP_Query $query )

Filters all query clauses at once, for convenience.

Description

Covers the WHERE, GROUP BY, JOIN, ORDER BY, DISTINCT, fields (SELECT), and LIMIT clauses.

Parameters

$clausesstring[]
Associative array of the clauses for the query.
  • where string
    The WHERE clause of the query.
  • groupby string
    The GROUP BY clause of the query.
  • join string
    The JOIN clause of the query.
  • orderby string
    The ORDER BY clause of the query.
  • distinct string
    The DISTINCT clause of the query.
  • fields string
    The SELECT clause of the query.
  • limits string
    The LIMIT clause of the query.
$queryWP_Query
The WP_Query instance (passed by reference).

More Information

The posts_clauses filter runs before the query gets executed and is essentially the sum of all filters that run immediately before it. So it should be used if you don’t intend to let another plugin override it, or if you need to alter several different parts of the query at once. If you’re only modifying a particular clause, you should probably use one of these clause-specific filters:

* posts_where_paged
* posts_groupby
* posts_join_paged
* posts_orderby
* posts_distinct
* post_limits
* posts_fields

Note: If you’re working on a caching plugin, use the posts_clauses_request filter instead. It’s basically the same filter, but it runs later (and after posts_selection), specifically so that “regular” plugins can execute their filters before your caching plugin does anything.

Source

$clauses = (array) apply_filters_ref_array( 'posts_clauses', array( compact( $pieces ), &$this ) );

Changelog

VersionDescription
3.1.0Introduced.

User Contributed Notes

  1. Skip to note 2 content

    Example migrated from Codex:

    In the following example, you can see how you can inspect the current query.

    <?php
    /**
     * Alter different parts of the query
     * 
     * @param array $pieces
     * 
     * @return array $pieces
     */
    function intercept_query_clauses( $pieces )
    {
    	echo '<style>#post-clauses-dump { display: block; background-color: #777; color: #fff; white-space: pre-line; }</style>';
    	// >>>> Inspect & Debug the Query 
    	// NEVER EVER show this to anyone other than an admin user - unless you're in your local installation
    	if ( current_user_can( 'manage_options' ) )
    	{
    		$dump = var_export( $pieces, true );
    		echo "< PRE id='post-clauses-dump'>{$dump}</ PRE >";
    	}
    
    	return $pieces;
    }
    add_filter( 'posts_clauses', 'intercept_query_clauses', 20, 1 );

    If you need to alter anything, simply set the $pieces['whatever_part'] string to what you need. Be sure to use appropriate $wpdb properties and methods (e.g. $wpdb->prefix, $wpdb->prepare()) in your SQL to prevent injection attacks, handle table prefix variations, and so forth.

    This would be the output on the Admin “All Posts” example.com/wp-admin/edit.php screen:

    array (
    	'where' => ' AND wp_posts.post_type = \'post\' AND (wp_posts.post_status = \'publish\' OR wp_posts.post_status = \'future\' OR wp_posts.post_status = \'draft\' OR wp_posts.post_status = \'pending\' OR wp_posts.post_status = \'private\')',
    	'groupby' => '',
    	'join' => '',
    	'orderby' => 'wp_posts.post_date DESC',
    	'distinct' => '',
    	'fields' => 'wp_posts.*',
    	'limits' => 'LIMIT 0, 20',
    )

You must log in before being able to contribute a note or feedback.