Duplicate Search Result
-
Relevanssi Version 4.24.3
Bricks 1.12.2
WordPress 6.7.2A duplicate search result appears at the end when searching for “Kiwanda”
Parameters Relevanssi is getting:
array(71) { ["s"]=> string(7) "kiwanda" ["error"]=> string(0) "" ["m"]=> string(0) "" ["p"]=> int(0) ["post_parent"]=> string(0) "" ["subpost"]=> string(0) "" ["subpost_id"]=> string(0) "" ["attachment"]=> string(0) "" ["attachment_id"]=> int(0) ["name"]=> string(0) "" ["pagename"]=> string(0) "" ["page_id"]=> int(0) ["second"]=> string(0) "" ["minute"]=> string(0) "" ["hour"]=> string(0) "" ["day"]=> int(0) ["monthnum"]=> int(0) ["year"]=> int(0) ["w"]=> int(0) ["category_name"]=> string(0) "" ["tag"]=> string(0) "" ["cat"]=> string(0) "" ["tag_id"]=> string(0) "" ["author"]=> string(0) "" ["author_name"]=> string(0) "" ["feed"]=> string(0) "" ["tb"]=> string(0) "" ["paged"]=> int(1) ["meta_key"]=> string(0) "" ["meta_value"]=> string(0) "" ["preview"]=> string(0) "" ["sentence"]=> string(0) "" ["title"]=> string(0) "" ["fields"]=> string(0) "" ["menu_order"]=> string(0) "" ["embed"]=> string(0) "" ["category__in"]=> array(0) { } ["category__not_in"]=> array(0) { } ["category__and"]=> array(0) { } ["post__in"]=> array(0) { } ["post__not_in"]=> array(0) { } ["post_name__in"]=> array(0) { } ["tag__in"]=> array(0) { } ["tag__not_in"]=> array(0) { } ["tag__and"]=> array(0) { } ["tag_slug__in"]=> array(0) { } ["tag_slug__and"]=> array(0) { } ["post_parent__in"]=> array(0) { } ["post_parent__not_in"]=> array(0) { } ["author__in"]=> array(0) { } ["author__not_in"]=> array(0) { } ["search_columns"]=> array(0) { } ["brx_main_query"]=> bool(true) ["posts_per_page"]=> int(10) ["order"]=> string(3) "ASC" ["orderby"]=> string(4) "date" ["post_status"]=> string(7) "publish" ["ignore_sticky_posts"]=> bool(false) ["suppress_filters"]=> bool(false) ["cache_results"]=> bool(true) ["update_post_term_cache"]=> bool(true) ["update_menu_item_cache"]=> bool(false) ["lazy_load_term_meta"]=> bool(true) ["update_post_meta_cache"]=> bool(true) ["post_type"]=> string(3) "any" ["nopaging"]=> bool(false) ["comments_per_page"]=> string(2) "50" ["no_found_rows"]=> bool(false) ["search_terms_count"]=> int(1) ["search_terms"]=> array(1) { [0]=> string(7) "kiwanda" } ["search_orderby_title"]=> array(1) { [0]=> string(167) "tap_posts.post_title LIKE '{0cead9276bfed5ad52b2cff391ac38b7d8a0936702662e40d0d4309e4a2348a5}kiwanda{0cead9276bfed5ad52b2cff391ac38b7d8a0936702662e40d0d4309e4a2348a5}'" } }
MySQL Query
string(672) "SELECT DISTINCT(relevanssi.doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 1 + relevanssi.comment * 0.75 + relevanssi.tag * 1 + relevanssi.link * 0 + relevanssi.author + relevanssi.category * 1 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.customfield + relevanssi.mysqlcolumn AS tf FROM tap_relevanssi AS relevanssi WHERE (relevanssi.term LIKE 'kiwanda%' OR relevanssi.term_reverse LIKE CONCAT(REVERSE('kiwanda'), '%')) AND relevanssi.doc NOT IN (199,201,1309,1761,1763) AND ((relevanssi.doc IN (SELECT DISTINCT(posts.ID) FROM tap_posts AS posts WHERE posts.post_status IN ('publish'))) OR (doc = -1)) ORDER BY tf DESC LIMIT 500"
Results
array(4) { [2]=> float(4.49287892112568698621544172056019306182861328125) [130]=> float(4.49287892112568698621544172056019306182861328125) [133]=> float(1.4976263070418955880569455985096283257007598876953125) [1787]=> float(1.4976263070418955880569455985096283257007598876953125) }
How can I eliminate the duplicate search result?
Thank You!
The page I need help with: [log in to see the link]
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- You must be logged in to reply to this topic.