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.
Odd behavior indeed, can't seem to replicate the issue. What if you set 1 as value?
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.
SELECT SQL_CALC_FOUND_ROWS QXO_posts.IDFROM QXO_postsINNER JOIN QXO_postmetaON ( QXO_posts.ID = QXO_postmeta.post_id )WHERE 1=1AND ( QXO_postmeta.meta_key = 'snews_overall_score' )AND QXO_posts.post_type = 'post'AND ((QXO_posts.post_status = 'publish'))GROUP BY QXO_posts.IDORDER BY QXO_postmeta.meta_value DESCLIMIT 0, 1
I am a junior developer, so you can talk to me "technically", if needed ;-)
Thank you for your support
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.
Well thank to yourself hehe nice catch
Glad it was sorted Enzo, let me know if you need further help.