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.ID 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 ;-)
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.
Hello.
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
Ezio
Hi there,
Odd behavior indeed, can't seem to replicate the issue. What if you set 1 as value?
Regards
djwd
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.ID
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
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!
Well thank to yourself hehe nice catch
Glad it was sorted Enzo, let me know if you need further help.
Regards
djwd