Jarkko Karhunen

Yes! This works like a charm! Thank you so much!

Done & sent

Oh yes, I did install the beta version of the plugin first

Yes, I have access to phpmyadmin.

Here’s the log content of some searches:

2023-09-05 13:48:47 : SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta AS a ON ( a.post_id = wp_posts.ID ) LEFT JOIN wp_postmeta AS b ON ( (( b.post_id = a.post_id )) AND (( b.meta_key LIKE CONCAT( ‘_’, a.meta_key ) )) ) LEFT JOIN wp_posts AS c ON ( ( c.post_name = b.meta_value ) AND ( c.post_type = ‘acf-field’ ) AND (( c.post_content LIKE ‘%:”text”%’ ) OR ( c.post_content LIKE ‘%:”textarea”%’ ) OR ( c.post_content LIKE ‘%:”wysiwyg”%’ ) OR ( c.post_content LIKE ‘%:”select”%’ ) OR ( c.post_content LIKE ‘%:”checkbox”%’ ) OR ( c.post_content LIKE ‘%:”radio”%’ )) ) WHERE 1=1 AND wp_posts.ID NOT IN (1464) AND ( wp_term_relationships.term_taxonomy_id IN (67) ) AND ( ( ( b.meta_id IS NOT NULL ) AND ( c.ID IS NOT NULL ) AND ( a.meta_value LIKE ‘%jamaica%’ ) ) OR ( ( wp_posts.post_title LIKE ‘%jamaica%’ ) OR ( wp_posts.post_content LIKE ‘%jamaica%’ ) OR ( wp_posts.post_excerpt LIKE ‘%jamaica%’ ) ) ) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘alkoholi’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘drinkki’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘valineet’ 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_posts.post_title LIKE ‘{332308f4c0dbaed97fd267487e343edd859a2380bfd95baacf7ad67d9da0f29a}jamaica{332308f4c0dbaed97fd267487e343edd859a2380bfd95baacf7ad67d9da0f29a}’ DESC, wp_posts.post_date DESC LIMIT 0, 50
2023-09-05 13:48:59 : SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta AS a ON ( a.post_id = wp_posts.ID ) LEFT JOIN wp_postmeta AS b ON ( (( b.post_id = a.post_id )) AND (( b.meta_key LIKE CONCAT( ‘_’, a.meta_key ) )) ) LEFT JOIN wp_posts AS c ON ( ( c.post_name = b.meta_value ) AND ( c.post_type = ‘acf-field’ ) AND (( c.post_content LIKE ‘%:”text”%’ ) OR ( c.post_content LIKE ‘%:”textarea”%’ ) OR ( c.post_content LIKE ‘%:”wysiwyg”%’ ) OR ( c.post_content LIKE ‘%:”select”%’ ) OR ( c.post_content LIKE ‘%:”checkbox”%’ ) OR ( c.post_content LIKE ‘%:”radio”%’ )) ) WHERE 1=1 AND wp_posts.ID NOT IN (1464) AND ( wp_term_relationships.term_taxonomy_id IN (67) ) AND ( ( ( b.meta_id IS NOT NULL ) AND ( c.ID IS NOT NULL ) AND ( a.meta_value LIKE ‘%plantation%’ ) ) OR ( ( wp_posts.post_title LIKE ‘%plantation%’ ) OR ( wp_posts.post_content LIKE ‘%plantation%’ ) OR ( wp_posts.post_excerpt LIKE ‘%plantation%’ ) ) ) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘alkoholi’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘drinkki’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘valineet’ 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_posts.post_title LIKE ‘{c05b72c5543863fd91545c98ab6ea129c5be692966993383746cb37bdf19ec97}plantation{c05b72c5543863fd91545c98ab6ea129c5be692966993383746cb37bdf19ec97}’ DESC, wp_posts.post_date DESC LIMIT 0, 50
2023-09-05 13:49:06 : SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta AS a ON ( a.post_id = wp_posts.ID ) LEFT JOIN wp_postmeta AS b ON ( (( b.post_id = a.post_id )) AND (( b.meta_key LIKE CONCAT( ‘_’, a.meta_key ) )) ) LEFT JOIN wp_posts AS c ON ( ( c.post_name = b.meta_value ) AND ( c.post_type = ‘acf-field’ ) AND (( c.post_content LIKE ‘%:”text”%’ ) OR ( c.post_content LIKE ‘%:”textarea”%’ ) OR ( c.post_content LIKE ‘%:”wysiwyg”%’ ) OR ( c.post_content LIKE ‘%:”select”%’ ) OR ( c.post_content LIKE ‘%:”checkbox”%’ ) OR ( c.post_content LIKE ‘%:”radio”%’ )) ) WHERE 1=1 AND wp_posts.ID NOT IN (1464) AND ( wp_term_relationships.term_taxonomy_id IN (67) ) AND ( ( ( b.meta_id IS NOT NULL ) AND ( c.ID IS NOT NULL ) AND ( a.meta_value LIKE ‘%scofflaw%’ ) ) OR ( ( wp_posts.post_title LIKE ‘%scofflaw%’ ) OR ( wp_posts.post_content LIKE ‘%scofflaw%’ ) OR ( wp_posts.post_excerpt LIKE ‘%scofflaw%’ ) ) ) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘alkoholi’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘drinkki’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘valineet’ 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_posts.post_title LIKE ‘{0bdc5a20dc7d8110622f8132d71f88411e41db654a6ca6dd950fbdc0c6fac699}scofflaw{0bdc5a20dc7d8110622f8132d71f88411e41db654a6ca6dd950fbdc0c6fac699}’ DESC, wp_posts.post_date DESC LIMIT 0, 50
2023-09-05 13:49:13 : SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta AS a ON ( a.post_id = wp_posts.ID ) LEFT JOIN wp_postmeta AS b ON ( (( b.post_id = a.post_id )) AND (( b.meta_key LIKE CONCAT( ‘_’, a.meta_key ) )) ) LEFT JOIN wp_posts AS c ON ( ( c.post_name = b.meta_value ) AND ( c.post_type = ‘acf-field’ ) AND (( c.post_content LIKE ‘%:”text”%’ ) OR ( c.post_content LIKE ‘%:”textarea”%’ ) OR ( c.post_content LIKE ‘%:”wysiwyg”%’ ) OR ( c.post_content LIKE ‘%:”select”%’ ) OR ( c.post_content LIKE ‘%:”checkbox”%’ ) OR ( c.post_content LIKE ‘%:”radio”%’ )) ) WHERE 1=1 AND wp_posts.ID NOT IN (1464) AND ( wp_term_relationships.term_taxonomy_id IN (67) ) AND ( ( ( b.meta_id IS NOT NULL ) AND ( c.ID IS NOT NULL ) AND ( a.meta_value LIKE ‘%mai%’ ) AND ( a.meta_value LIKE ‘%tai%’ ) ) OR ( ( ( wp_posts.post_title LIKE ‘%mai%’ ) OR ( wp_posts.post_content LIKE ‘%mai%’ ) OR ( wp_posts.post_excerpt LIKE ‘%mai%’ ) ) AND ( ( wp_posts.post_title LIKE ‘%tai%’ ) OR ( wp_posts.post_content LIKE ‘%tai%’ ) OR ( wp_posts.post_excerpt LIKE ‘%tai%’ ) ) ) ) AND ((wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘page’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘attachment’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘alkoholi’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘drinkki’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘private’)) OR (wp_posts.post_type = ‘valineet’ 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 (CASE WHEN wp_posts.post_title LIKE ‘{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}mai tai{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}’ THEN 1 WHEN wp_posts.post_title LIKE ‘{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}mai{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}’ THEN 2 WHEN wp_posts.post_excerpt LIKE ‘{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}mai tai{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}’ THEN 4 WHEN wp_posts.post_content LIKE ‘{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}mai tai{1d42e411925e83847698c379dc8958b05f72f90eb7d39b7296fe1eb01f8b01a9}’ THEN 5 ELSE 6 END), wp_posts.post_date DESC LIMIT 0, 50

Quoting Lionel Richie: “Hello?”

Thanks, but indeed I got it fixed.

Not totally sure if I understand what you mean but here’s a try: https://paste.pics/4c8ae498017646af47c99bb3aaea8640

Excellent, thanks!

Topic shoud say TeXt Icon…

Email sent!

Sure. Let me know when.

Ok, thanks.

Excellent! Tack!

Yes, this did the trick. Thank you!