24.9186s:
25 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
INNER JOIN wp_postmeta AS mt2
ON ( wp_posts.ID = mt2.post_id )
INNER JOIN wp_postmeta AS mt3
ON ( wp_posts.ID = mt3.post_id )
INNER JOIN wp_postmeta AS mt4
ON ( wp_posts.ID = mt4.post_id )
INNER JOIN wp_postmeta AS mt5
ON ( wp_posts.ID = mt5.post_id )
INNER JOIN wp_postmeta AS mt6
ON ( wp_posts.ID = mt6.post_id )
WHERE 1=1
AND ( wp_postmeta.meta_key = 'book_until'
AND ( ( ( mt1.meta_key = 'training_start'
AND mt1.meta_value > '20220416' )
AND ( mt2.meta_key = 'status'
AND mt2.meta_value IN ('gtr','booked') )
AND ( mt3.meta_key = 'status'
AND mt3.meta_value != 'canceled' ) )
OR ( ( mt4.meta_key = 'book_until'
AND mt4.meta_value > '20220416' )
AND ( mt5.meta_key = 'status'
AND mt5.meta_value IN ('reserved','gtr-plus') )
AND ( mt6.meta_key = 'status'
AND mt6.meta_value != 'canceled' ) ) ) )
AND ((wp_posts.post_type = 'post_event'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'acf-disabled'
OR wp_posts.post_status = 'private')))
GROUP BY wp_posts.ID
ORDER BY wp_postmeta.meta_value ASC
LIMIT 0, 6
WP_Query->get_posts()
Theme 1
Comments