cjdavey

I’ve found the queries that are adding the events, and I’m now fairly confident they’re part of the theme/site build rather than the plugin – so I’ll mark this one resolved.

Thanks for your help in getting this far!

Thanks!

Yes, selecting just post doesn’t affect it.

Here are the Better Search queries:

SELECT option_value
FROM wp_options
WHERE option_name = '_transient_timeout_bs_voiceforlife'
LIMIT 1

SELECT option_value
FROM wp_options
WHERE option_name = '_transient_bs_voiceforlife'
LIMIT 1

SELECT DISTINCT ID, (MATCH(post_title) AGAINST ('voice for life' IN BOOLEAN MODE ) * 10 ) + (MATCH(post_content) AGAINST ('voice for life' IN BOOLEAN MODE ) * 1 ) AS score
FROM wp_posts
WHERE 1=1
AND MATCH (post_title,post_content) AGAINST ('voice for life' IN BOOLEAN MODE )
AND (post_status = 'publish'
OR post_status = 'inherit')
AND wp_posts.post_type IN ('post', 'page', 'areas', 'area_page')
ORDER BY score DESC

SELECT DISTINCT ID, (MATCH(post_title) AGAINST ('voice for life' IN BOOLEAN MODE ) * 10 ) + (MATCH(post_content) AGAINST ('voice for life' IN BOOLEAN MODE ) * 1 ) AS score
FROM wp_posts
WHERE 1=1
AND MATCH (post_title,post_content) AGAINST ('voice for life' IN BOOLEAN MODE )
AND (post_status = 'publish'
OR post_status = 'inherit')
AND wp_posts.post_type IN ('post', 'page', 'areas', 'area_page')
ORDER BY score DESC

SELECT DISTINCT wp1.searchvar, wp2.sumCount
FROM wp_bsearch_daily wp1, (SELECT searchvar, SUM(cntaccess) as sumCount
FROM wp_bsearch_daily
WHERE dp_date >= '2016-01-27'
GROUP BY searchvar
ORDER BY sumCount DESC
LIMIT 30) wp2
WHERE wp1.searchvar = wp2.searchvar
ORDER by wp1.searchvar ASC

Thanks! Here you go!.