hi @aurovrata ,

Yes, you are right, when only one post exists in the term then there is no ranking possible.

But in the filter where you adding the condition in the query’s “WHERE” section, the post can’t be retrieved with WP_Query because there is no saved information about the post and category in the wp_reorder_post_rel table. I hope you understand the problem I described.

Thanks,
Vahan

here is the args of WP_Query:

Array
(
    [post_type] => my-post-type
    [meta_key] => visibility
    [meta_value] => visible
    [tax_query] => Array
        (
            [0] => Array
                (
                    [taxonomy] => my-category
                    [field] => id
                    [terms] => 31
                )
        )
    [paged] => 1
    [posts_per_page] => 25
    [orderby] => menu_order
    [order] => ASC
)

here is the request:

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_reorder_post_rel ON wp_posts.ID = wp_reorder_post_rel.post_id and incl = 1
WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (31)
) AND ( 
  ( wp_postmeta.meta_key = 'visibility' AND wp_postmeta.meta_value = 'visible' )
) AND wp_posts.post_type = 'my-post-type' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')
AND wp_reorder_post_rel.category_id = '31'
GROUP BY wp_posts.ID
ORDER BY wp_reorder_post_rel.id ASC
LIMIT 0, 25

You can see here that added wp_reorder_post_rel.category_id = ’31’ this line and this term has only one post but in the wp_reorder_post_rel table there is no any information about the term.