Title: Expected post not showing
Last modified: November 1, 2021

---

# Expected post not showing

 *  [spost](https://wordpress.org/support/users/spost/)
 * (@spost)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/expected-post-not-showing/)
 * Hello,
    I expected this post: [https://mealcomparison.com/green-chef-vs-hello-fresh/](https://mealcomparison.com/green-chef-vs-hello-fresh/)
   To show up on this page: [https://mealcomparison.com/how-long-does-hellofresh-last/](https://mealcomparison.com/how-long-does-hellofresh-last/)
 * I’m having 2 taxonomies used for filtering: category, brand
    I’ve checked and
   both posts have overlapping taxonomy terms in both taxonomies. I imagine there’s
   something I’m not understanding about this.
 * Here’s a Query Monitor output:
 *     ```
       SELECT wp_posts.*, MATCH (wp_posts.post_title) AGAINST ('How long does HelloFresh last?') as score
       FROM wp_posts
       LEFT JOIN wp_term_relationships
       ON (wp_posts.ID = wp_term_relationships.object_id)
       WHERE 1=1
       AND ( wp_posts.post_date <= '2021-11-01 07:10:06' )
       AND wp_posts.ID NOT IN (438)
       AND ( wp_term_relationships.term_taxonomy_id IN (10,35) )
       AND wp_posts.post_type = 'post'
       AND ((wp_posts.post_status = 'publish'
       OR wp_posts.post_status = 'inherit'))
       AND MATCH (wp_posts.post_title) AGAINST ('How long does HelloFresh last?')
       GROUP BY wp_posts.ID
       ORDER BY score DESC
       LIMIT 0, 5
       ```
   
 * Could you let me know what else you might need from me?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexpected-post-not-showing%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/expected-post-not-showing/#post-15028499)
 * The query seems to be fine. What is query monitor showing you in terms of number
   of results found. Also, are you in a position to run this in phpMyAdmin in your
   server to see what it throws up?
 * Assume both these are posts – i.e. not pages or another post type?
 * You say you have a brand custom taxonomy? Does the second post fall into either
   10 or 35 in terms of category number?
 *  Thread Starter [spost](https://wordpress.org/support/users/spost/)
 * (@spost)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/expected-post-not-showing/#post-15031148)
 * # of results found: Is that the # under the “rows” column? if yes, it’s displaying“
   1”
 * I think I did phpMyAdmin correctly – it seems to display the same post as is 
   being displayed on the front end.
 * Yes these are posts.
    Yes the post falls in both 10 and 35 category terms.
 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/expected-post-not-showing/#post-15036981)
 * Thanks. This appears to be that MySQL FULLTEXT can’t figure out that HelloFresh
   as a term is available – issue is that it isn’t really a word.
 * Does it help if you also turning on matching for content in the settings page.
 * Another way would be to use the manual posts option in the meta box at the bottom
   of the edit post screen and include the post ID explicitly.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Expected post not showing’ is closed to new replies.

 * ![](https://ps.w.org/contextual-related-posts/assets/icon-256x256.png?rev=2985705)
 * [Contextual Related Posts](https://wordpress.org/plugins/contextual-related-posts/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contextual-related-posts/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contextual-related-posts/)
 * [Active Topics](https://wordpress.org/support/plugin/contextual-related-posts/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contextual-related-posts/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contextual-related-posts/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Ajay](https://wordpress.org/support/users/ajay/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/expected-post-not-showing/#post-15036981)
 * Status: not resolved