Skip to content

Instantly share code, notes, and snippets.

@westonruter

westonruter/homepage-query-sans-customize-preview.sql

Last active January 17, 2018 14:39
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save westonruter/36563b2356a7a3c891f178176fc99b3a to your computer and use it in GitHub Desktop.
Save westonruter/36563b2356a7a3c891f178176fc99b3a to your computer and use it in GitHub Desktop.
Download ZIP
Various SQL queries generated by various WP_Query instances with and without customized post data from Customize Posts injected into a derived table via unions. The customized state includes 3 posts and 1 page. SQL below is generated by https://github.com/xwp/wp-customize-posts/pull/248
Raw
homepage-query-sans-customize-preview.sql
# post_type=post&s=test
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
homepage-query-with-customize-preview.sql
# post_type=post&s=test&wp_customize=on
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM ((
SELECT wp_posts.*
FROM wp_posts
WHERE 1 = 1
AND (wp_posts.ID NOT IN (7926, 7928, 7930, 7931))
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'))
UNION ALL (
SELECT
CAST('7926' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_date,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-1-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_modified,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7926' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7928' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_date,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-page-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_modified,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?page_id=7928' AS
CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('page' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7930' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_date,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-2-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_modified,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7930' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7931' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_date,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-3-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 15:57:13' AS DATETIME) AS post_modified,
CAST('2016-09-06 22:57:13' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7931' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS
UNSIGNED) AS comment_count)) AS wp_posts
WHERE 1 = 1
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
meta-query-with-value-search-sans-customize-prevew.sql
# post_type=post&meta_key=_thumbnail_id&meta_value=123
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND ( ( wp_postmeta.meta_key = '_thumbnail_id'
AND wp_postmeta.meta_value = '123' ) )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
meta-query-with-value-search-with-customize-prevew.sql
# post_type=post&meta_key=_thumbnail_id&meta_value=123&wp_customize=on
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM ((
SELECT wp_posts.*
FROM wp_posts
INNER JOIN ((
SELECT *
FROM wp_postmeta
WHERE (!(post_id = 7926
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7928
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7930
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7931
AND meta_key = '_thumbnail_id')))
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7926' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
CAST('5237' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7928' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
CAST('5229' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7930' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7931' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
CAST('5112' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_value)) AS wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1 = 1
AND (wp_posts.ID NOT IN (7926, 7928, 7930, 7931))
AND ((wp_postmeta.meta_key = '_thumbnail_id'
AND wp_postmeta.meta_value = '123'))
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID)
UNION ALL (
SELECT
CAST('7926' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_date,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-1-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7926' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7928' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_date,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-page-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?page_id=7928' AS
CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('page' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7930' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_date,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-2-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7930' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7931' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_date,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-3-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:08:30' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:08:30' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7931' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS
UNSIGNED) AS comment_count)) AS wp_posts
INNER JOIN ((
SELECT *
FROM wp_postmeta
WHERE (!(post_id = 7926
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7928
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7930
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7931
AND meta_key = '_thumbnail_id')))
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7926' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
CAST('5237' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7928' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
CAST('5229' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7930' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7931' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
CAST('5112' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_value)) AS wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1 = 1
AND ((wp_postmeta.meta_key = '_thumbnail_id'
AND wp_postmeta.meta_value = '123'))
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
meta-query-without-value-search-sans-customize-preview.sql
# post_type=post&meta_key=_thumbnail_id
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1
AND ( wp_postmeta.meta_key = '_thumbnail_id' )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
meta-query-without-value-search-with-customize-preview.sql
# post_type=post&meta_key=_thumbnail_id&wp_customize=on
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM ((
SELECT wp_posts.*
FROM wp_posts
INNER JOIN ((
SELECT *
FROM wp_postmeta
WHERE (!(post_id = 7926
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7928
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7930
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7931
AND meta_key = '_thumbnail_id')))
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7926' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7928' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7930' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7931' AS
UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE
utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)) AS wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1 = 1
AND (wp_posts.ID NOT IN (7926, 7928, 7930, 7931))
AND (wp_postmeta.meta_key = '_thumbnail_id')
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID)
UNION ALL (
SELECT
CAST('7926' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_date,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-1-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7926' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7928' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_date,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-page-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?page_id=7928' AS
CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('page' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7930' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_date,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-2-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7930' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7931' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_date,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_date_gmt,
NULL AS post_content,
NULL AS post_title,
NULL AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-3-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:04:56' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:04:56' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7931' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS
UNSIGNED) AS comment_count)) AS wp_posts
INNER JOIN ((
SELECT *
FROM wp_postmeta
WHERE (!(post_id = 7926
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7928
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7930
AND meta_key = '_thumbnail_id'))
AND (!(post_id = 7931
AND meta_key = '_thumbnail_id')))
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7926' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7928' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7930' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)
UNION ALL (
SELECT
NULL AS meta_id,
CAST('7931' AS UNSIGNED) AS post_id,
CAST('_thumbnail_id' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS meta_key,
NULL AS meta_value)) AS wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1 = 1
AND (wp_postmeta.meta_key = '_thumbnail_id')
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10
Raw
search-query-sans-customize-preview.sql
# post_type=post&s=test
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND (((wp_posts.post_title LIKE '%test%')
OR (wp_posts.post_excerpt LIKE '%test%')
OR (wp_posts.post_content LIKE '%test%')))
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'jetpack-portfolio', 'jetpack-testimonial')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 2
AND wp_posts.post_status = 'private')
ORDER BY wp_posts.post_title LIKE '%test%' DESC, wp_posts.post_date DESC
LIMIT 0, 10
Raw
search-query-with-customize-preview.sql
# post_type=post&s=test&wp_customize=on
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM ((
SELECT wp_posts.*
FROM wp_posts
WHERE 1 = 1
AND (wp_posts.ID NOT IN (7926, 7928, 7930, 7931))
AND (((wp_posts.post_title LIKE '%test%')
OR (wp_posts.post_excerpt LIKE '%test%')
OR (wp_posts.post_content LIKE '%test%')))
AND wp_posts.post_type IN
('post', 'page', 'attachment', 'jetpack-portfolio', 'jetpack-testimonial')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 2
AND wp_posts.post_status = 'private')
ORDER BY wp_posts.post_title LIKE '%test%' DESC,
wp_posts.post_date DESC)
UNION ALL (
SELECT
CAST('7926' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_date,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_date_gmt,
CAST('Test Post 1 Content 🙈' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_content,
CAST('Test Post 1 Title' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_title,
CAST('Test Post 1 Excerpt' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-1-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7926' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7928' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_date,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_date_gmt,
CAST('Test Page Content' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_content,
CAST('Test Page Title' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_title,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('closed' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-page-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?page_id=7928' AS
CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('page' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7930' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_date,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_date_gmt,
CAST('Test Post 2 Content 🙉' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_content,
CAST('Test Post 2 Title' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_title,
CAST('Test Post 2 Excerpt' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-2-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7930' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS UNSIGNED) AS comment_count)
UNION ALL (
SELECT
CAST('7931' AS UNSIGNED) AS ID,
CAST('2' AS UNSIGNED) AS post_author,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_date,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_date_gmt,
CAST('Test Post 3 Content 🙊' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_content,
CAST('Test Post 3 Title' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_title,
CAST('Test Post 3 Excerpt' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_excerpt,
CAST('publish' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS comment_status,
CAST('open' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS ping_status,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_password,
CAST('test-post-3-slug' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_name,
NULL AS to_ping,
NULL AS pinged,
CAST('2016-09-06 16:03:31' AS DATETIME) AS post_modified,
CAST('2016-09-06 23:03:31' AS DATETIME) AS post_modified_gmt,
NULL AS post_content_filtered,
CAST('0' AS UNSIGNED) AS post_parent,
CAST('http://src.wordpress-develop.dev/?p=7931' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS guid,
CAST('0' AS UNSIGNED) AS menu_order,
CAST('post' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_type,
CAST('' AS CHAR CHARACTER
SET utf8mb4) COLLATE utf8mb4_unicode_ci AS post_mime_type,
CAST('0' AS
UNSIGNED) AS comment_count)) AS wp_posts
WHERE 1 = 1
AND (((wp_posts.post_title LIKE '%test%')
OR (wp_posts.post_excerpt LIKE '%test%')
OR (wp_posts.post_content LIKE '%test%')))
AND wp_posts.post_type IN
('post', 'page', 'attachment', 'jetpack-portfolio', 'jetpack-testimonial')
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 2
AND wp_posts.post_status = 'private')
ORDER BY wp_posts.post_title LIKE '%test%' DESC, wp_posts.post_date DESC
LIMIT 0, 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment