yiselsp

Hi!
I’ve been talking with our developers and we have been checking any possible answer for this issue. We came to the conclusion that it has to be the plugin.
The queries are not working as they should. They should be AND not OR.

I find it really weird, this change all of the sudden. Because a few weeks ago, it worked perfectly and we’ve check if it was something related to the cpts and taxonomies of the website they’re fine.

This is one of the pages using the the plugin: https://spacehuntr.com/venues/london/

Thanks in advance

I don’t really know what’s new.

You can see here the settings.
https://ibb.co/T0DTLJm
https://ibb.co/9VbPLDC
https://ibb.co/XVywjXF
https://ibb.co/2dT7JfS
https://ibb.co/ZcNSydN
https://ibb.co/KrcGTxG
https://ibb.co/MRtMG5H

I added the plugin through Elementor. And they only thing extra is apply some CSS.

For query monitor,

SELECT DISTINCT wpem_posts.ID, wpem_posts.post_date
FROM wpem_posts
INNER JOIN wpem_term_relationships AS crpt_tr
ON (wpem_posts.ID = crpt_tr.object_id)
INNER JOIN wpem_term_taxonomy AS crpt_tt
ON (crpt_tr.term_taxonomy_id = crpt_tt.term_taxonomy_id)
INNER JOIN wpem_terms AS crpt_t
ON (crpt_tt.term_id = crpt_t.term_id)
WHERE 1=1
AND MATCH (post_title) AGAINST (‘Book Your Event Venues in Amsterdam’)
AND wpem_posts.post_date < ‘2021-01-07 10:46:25’
AND wpem_posts.post_date >= ‘2018-01-08 10:46:25’
AND wpem_posts.post_status IN (‘publish’,’inherit’)
AND wpem_posts.ID != 53647
AND wpem_posts.post_type IN (‘job_listing’)
AND CONCAT(crpt_tt.taxonomy, ‘/’, crpt_tt.term_id) IN (‘job_listing_region/2705′,’job_listing_category/40638’)
GROUP BY wpem_posts.ID
HAVING ( COUNT(DISTINCT crpt_tt.taxonomy) = 2
AND COUNT(DISTINCT crpt_tt.term_id) >= 2 )
ORDER BY MATCH (post_title) AGAINST (‘Book Your Event Venues in Amsterdam’) DESC
LIMIT 0, 4

Thanks for the answer.