Public Ticket #2334460
Ordering post reviews


  • ioemargherita started the conversation


    The "Side Posts" widget has a very strange behavior. 

    I have in "Posts number" the value "3" but I see 6 posts in my homepage. 

    And I can't order by meta value (the score) DESC. 

    It seems it's duplicating the resultset (4+2), but I can't understand why, look at the screenshot.

    Thank you


  •  93
    djwd replied

    Hi there,

    Odd behavior indeed, can't seem to replicate the issue. What if you set 1 as value?


  • ioemargherita replied

    Hello, thank you for your reply. 

    When I set "1" as value I get FIVE posts (and they are not ordered by score, look at the screenshot). 

    The query appears to be OK, so I can't really understand. 

    FROM QXO_posts
    INNER JOIN QXO_postmeta
    ON ( QXO_posts.ID = QXO_postmeta.post_id )
    WHERE 1=1
    AND ( QXO_postmeta.meta_key = 'snews_overall_score' )
    AND QXO_posts.post_type = 'post'
    AND ((QXO_posts.post_status = 'publish'))
    GROUP BY QXO_posts.ID
    ORDER BY QXO_postmeta.meta_value DESC
    LIMIT 0, 1

    Any ideas?

    I am a junior developer, so you can talk to me "technically", if needed ;-)

    Thank you for your support

  • ioemargherita replied

    dwjd, good news... I got it! :) 

    I had five articles flagged as "featured" (the Wordpress native option). I was using this flag instead the recommended "Feature this Post on the Homepage Slider?" in the Single Post Options. 

    Now I've removed the "featured" flag and the posts are disappeared from the snews_overall_score query.

    Thank you! 

  •  93
    djwd replied

    Well thank to yourself hehe nice catchsmile.png

    Glad it was sorted Enzo, let me know if you need further help.