Wordpress Post Loop Based On Selecting 10 Post Id's from DB?

Question

I've spent most of today looking for info on how I can get 10 post ID's (which dynamically change every day) from table name wp_recently_popular row post_id and create a loop that uses those id's to call the post info so I can have those 10 posts on my homepage.

All day long and everyone is showing the same tutorial over and over again.

Here's the thing I'm not even sure it's possible?

I've even looked at WP's own docs for custom select query and it's pretty crap too. I'm in serious need of help. I'll even pay if you need me to.

Thanks

Answer 1

You'll need to post the DB Schema for this wp_recently_popular table to get an accurate answer.