kinkersnick

Thanks James, I hadn’t heard of Health Check before, that thing is genius for debugging without touching your frontend!

So after lots of switching plugins on and off and testing, I’ve found that both Stackable Blocks and Kadence Blocks cause the same issue in combination with Yoast.

We need all three of these plugins, so not sure how to go about fixing it other than writing to the makers of all three plugins for help. Any other suggestions, or thoughts as to why these particular combinations could cause an issue like this?

Solved this one myself:

In case anyone is interested, this is the full query that enables me to search two sets of taxonomies, each with an internal OR condition (via ‘IN’) but combined via an AND condition:

SELECT * FROM wp_posts
LEFT JOIN wp_term_relationships AS cuisine ON (wp_posts.ID = cuisine.object_id)
LEFT JOIN wp_term_relationships AS goodfor ON (wp_posts.ID = goodfor.object_id) WHERE wp_posts.post_type = 'listings'
AND wp_posts.post_status = 'publish'
AND cuisine.term_taxonomy_id IN (41, 42, 45)
AND goodfor.term_taxonomy_id IN (55, 57)

X