apply_filters_ref_array( 'posts_request', string $request, WP_Query $query )

Filters the completed SQL query before sending.

Parameters

$request

(string) The complete SQL query.

$query

(WP_Query) The WP_Query instance (passed by reference).

More Information

The input of this filter is the post request SQL, something like the following:

SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_posts AS p2 ON ( wp_posts.post_parent = p2.ID ) WHERE 1=1 AND wp_posts.ID IN ( 3, 632 ) AND wp_posts.post_type != 'revision' AND ( ( wp_posts.post_status = 'publish' ) OR ( wp_posts.post_status = 'inherit' AND ( p2.post_status = 'publish' ) ) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 20

Source

File: wp-includes/class-wp-query.php

View on Trac

Used By

Used By Description
wp-includes/class-wp-query.php: WP_Query::get_posts()

Retrieves an array of posts based on query variables.

Changelog

Version Description
2.0.0 Introduced.

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