MySQL can do math but can’t pass it through query_posts like that, or any WordPress’ post query functions, which depend upon WP_Query. They will literally look for a table/column named, in your case, “meta_value_num / date”. To do it in SQL I believe– aka., this is untested– you’d have to do something like this:
SELECT (meta_value_num / DATE()) as ddiv
FROM <some-table>
ORDER BY ddiv
And that isn’t going to be a very efficient query anyway.
Why can’t you do the division after the query? I believe the sort order will be the same either way.
Related Posts:
- Using $wpdb to query posts with meta value containing current post_id
- Query posts from current year
- How to show posts rank based on custom field value
- How do I create Comma Separated list of attached image ids?
- How to add posts to wp_query result?
- Order post by year DESC and month ASC
- Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
- How can I display a specific user’s first published post?
- wp_enqueue_media() slows down my WP site
- How can I get all posts data from within a paginated search result?
- Sorting posts alphabetical that have single digits
- Query posts from different categories in multisite
- posts_per_page doesnt work
- Sorting posts according to view counts not working
- Only display posts after current date
- Improving WP_Query for performance when random posts are ordered
- Get posts by name and taxonomy term
- WP_Query Authors OR Categories
- Get Posts that are in the current month or later
- do_shortcode within post query
- Get Meta Key Value While Saving Post
- Most liked page not displaying posts
- Query get post,how to add comment box
- get query() without post content?
- How can I setup a relationship using categories in WordPress?
- posts_per_page option limits the number of Gallery items
- How i can limit period of post publication?
- How to setup a query to output posts by groups of five?
- Exclude current custom post on single post
- Dynamically switch template on click
- Get all custom post types excepted some…
- Get all comments of author’s posts
- First x post with another template then the others
- Why Query is returning empty array?
- Delete all drafts?
- Wrap every month posts in div
- meta_value timestamp older than now
- Counter is skipping post when I still want it visible [closed]
- Do not show children of a category
- post__in not working with pre_get_posts, but post__not_in does work
- How to get all post_parents of a post?
- Query for first 3 posts to change the look and feel
- Why posts array is empty?
- Query posts and filter at query time by value of custom meta
- Run query_posts if SESSION is empty?
- Very complex post query
- Delete post revisions only for a single post
- How to give classname to post if post has no content?
- Display post by click on the link
- Queries take 120+ seconds on my large WordPress site
- How to retrieve certain number of images from a wordpress post?
- How to convert query sql to shortcode in wordpress?
- WordPress loop not working on static front page
- Some doubts about how the loop work (trying debugging it)
- How to display only one category in a custom post type?
- Adjust the order for returned posts
- Trim posts from WP-Query?
- Anyone know a php snippet for showing the first 200 characters of the most recent post?
- Get current taxonomy and display query accordingly
- Trying to exclude custom posts based on date, while sorting by custom field
- How Can I Always Display A Particular Post First Using WP_Query?
- how to add tags to post in the Loop?
- Merge get_comments & get_posts into a single query
- How to optimize posts query in wordpress
- Check if almost 10 year old – working code is up to date
- Query to fetch custom taxonomy along with post title
- How to fetch courses in all languages in WordPress?
- Query custom post type custom meta key
- How to search through “post title” and “tags” using WP_Query?
- Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
- I have two post types in the same query, how can I use CSS to select only one post type?
- filter posts based on menu_order
- Bulk Post update_post_meta
- Show 5 posts and than 3 posts offset with pagination
- I need some explanation on global $post [duplicate]
- How to delete all posts with dead image urls?
- Numbering author posts in posts query
- How to run select query of post with category and tags?
- Querying posts from current category, using a variable as array argument
- Query posts from newest category
- wp query custom orderby not custom field
- Custom Select Query pagination not working properly
- Query post by meta key of another table
- Sort / Filter Queries
- Query post category & remove any post id
- Display the latest post from some selected authors
- Ordering posts alphabetically by meta keys and title
- Why I have this strange behavior when I try to exlude the featured post from posts visualization?
- Grab next post title in archive page
- Continuous listing from a custom field
- Displaying Results From Custom Taxonomy Query
- How to store post rating system data post independent?
- Get first comment link on the post itself
- How to limit post query to only return a total count of items with certain post statuses?
- The page that displays Posts on homepage
- query_post or single-[cpt].php?
- Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields
- Display posts with id equal to relationship value
- Sort Posts Alphabetically Based on Specific Category (Divi)
- Change permalinks in posts via SQL