Title: WP_Date_Query::get_sql_for_subquery
Published: April 25, 2014
Last modified: February 24, 2026

---

# WP_Date_Query::get_sql_for_subquery( array $query ): array

## In this article

 * [Description](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#description)
 * [Parameters](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#parameters)
 * [Return](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#return)
 * [Source](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#source)
 * [Related](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#related)
 * [Changelog](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#changelog)

[ Back to top](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#wp--skip-link--target)

Turns a single date clause into pieces for a WHERE clause.

## 󠀁[Description](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#description)󠁿

A wrapper for get_sql_for_clause(), included here for backward compatibility while
retaining the naming convention across Query classes.

## 󠀁[Parameters](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#parameters)󠁿

 `$query`arrayrequired

Date query arguments.

## 󠀁[Return](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#return)󠁿

 array Array containing JOIN and WHERE SQL clauses to append to the main query.

 * `join` string[]
 * Array of SQL fragments to append to the main JOIN clause.
 * `where` string[]
 * Array of SQL fragments to append to the main WHERE clause.

## 󠀁[Source](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#source)󠁿

    ```php
    protected function get_sql_for_subquery( $query ) {
    	return $this->get_sql_for_clause( $query, '' );
    }
    ```

[View all references](https://developer.wordpress.org/reference/files/wp-includes/class-wp-date-query.php/)
[View on Trac](https://core.trac.wordpress.org/browser/tags/6.9.4/src/wp-includes/class-wp-date-query.php#L706)
[View on GitHub](https://github.com/WordPress/wordpress-develop/blob/6.9.4/src/wp-includes/class-wp-date-query.php#L706-L708)

## 󠀁[Related](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#related)󠁿

| Uses | Description | 
| [WP_Date_Query::get_sql_for_clause()](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_clause/)`wp-includes/class-wp-date-query.php` |

Turns a first-order date query into SQL for a WHERE clause.

  |

## 󠀁[Changelog](https://developer.wordpress.org/reference/classes/wp_date_query/get_sql_for_subquery/?output_format=md#changelog)󠁿

| Version | Description | 
| [3.7.0](https://developer.wordpress.org/reference/since/3.7.0/) | Introduced. |

## User Contributed Notes

You must [log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fdeveloper.wordpress.org%2Freference%2Fclasses%2Fwp_date_query%2Fget_sql_for_subquery%2F)
before being able to contribute a note or feedback.