I have been stuck for a few hours on this problem and would love any suggestions on how to do this.
I have post meta field that is a checkbox with the name and value "featured".
I need to order posts that have been modified or created in the last 24 hours and also have the post meta field "featured" first followed by the rest of the posts.
I have tried using the pre_get_posts filter but with no luck.
Thanks in advance.