Thanks karpstrucking,
This was a simple case of me needing to understand the Query better. Once I fully understood that wp_query returns a string for the sql query, it was a simply case of doing what I needed to do to correction the event_date value, concatenating on the additional title or meta_num_value and returning that.
Then I would just have to add_filter the orderby.
Related Posts:
- How to order posts tag by tag?
- Order by title without taking into account ‘the’
- Filtering by multiple conditions in the loop
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Use REGEXP in WP_Query meta_query key
- WP_Query orderby post__in remains ineffective in the Loop [closed]
- WP_Query orderby date not working
- Order by optional meta key?
- Sorting: custom query with orderby meta_value_num THEN by title
- Order by DESC, ASC in custom WP_Query
- WP_Query order by multiple meta keys & fields
- How to list some posts first in the loop based on post id
- Whats the difference between post_limits and pre_get_posts?
- How to add taxonomy filter on the query fly?
- Secondary Sort (fallback) for WP_Query
- Query Posts in a Predefined Order
- WP_Query – filter or directly?
- How to get order of posts?
- Order posts by ID in the given order
- What is the most efficient way of querying posts based on visits and date for current day?
- Custom WP_Query order by post_meta and (author) user_meta
- Sorting posts by custom date fields (non standard date format)
- Changing Posts Per Page and offset with pre_get_posts
- ajax category filter
- Overriding The Loop with filter or hook
- How do I order pages and categories by ID or name in the same query?
- Custom query incorrectly returning everything [closed]
- WP Rest API v2 return posts with specific tag
- How to filter sql only for a specific post type
- WP_Query ordered by custom field that is a date string?
- Ignore a filter on the media library
- WP_Query sort by comment meta data
- How to support multiple search terms query within one process?
- Order posts by tags count?
- Merge 2 args in one WP_Query and order it by date
- Orderby = none not working [duplicate]
- WP_query ‘orderby=none’ Problem
- Order posts by date and then by custom field
- How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
- Revolution Slider Orderby Two Custom Fields
- How to get any tag ID
- Order posts ascending with number in title
- List taxonomy terms plus their latest post ordered by post date
- Order by the results of a function with WP_query
- How to order posts in wp_query by a meta_value of the corresponding author
- Order by menu structure
- Which filter/action hook gets triggered after a query has been performed?
- WP_Query order by date in meta_value
- Remove ellipsis from the excerpt retrieved using get_the_excerpt()
- How to use order RAND() on WordPress?
- Show all parents and children in custom post type in right order
- Removing posts from the returned wp_query. Cannot use object of type WP_Query as array
- Ordering by meta_value AND date NOT WORKING with wp_query
- WP_Query orderby breaks when using AJAX?
- Order WP Query posts by custom order calculated from post meta values
- Custom Post order for homepage
- How to implement time filter to show random post 1 month for one category and 3 months for other categories
- What’s the point of the query_vars filter?
- Meta query with order by another custom field
- Change default ordering of taxonomy terms – pre_get_terms
- WordPress WP_Query orderby being overwritten
- WP_Query Order by Specific Post ID First
- Order Posts by meta value AND published date
- Refine/Filter WP_Query Posts with jQuery or Ajax
- Use ‘parse_query’ filter to show posts that from multiple criteria
- How can I pick a single post from the latest 3?
- Wp query orderby ‘title’ doesn’t work
- How to apply filter inside a single wp_query?
- What is considered a default query for the request filter?
- Using apply_filters(‘the_content’, $custom_query->post_content) alters output
- How can I order Wp_Query hierarchically?
- Modifying the Search Results
- When to add_filter() to Custom Query
- How do I sort posts with multiple pages
- Sorting posts DESC based on the number of comments using WP_Query
- Order by custom table and multiplication
- Query total number of posts
- Order WP_Query by multiple fields, subtracting them from one another
- Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
- pre_get_posts order by not working
- How to add post_distinct filter to WP_Comment_Query?
- Using Ajax to load more posts | Help me change the wording on my button to notify the user
- How to use filter hook “the_posts” with a function that refers to $this?
- (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
- How to create a WordPress Post Filter that users can use to filter posts by year?
- Orderby ASC changes to DESC in WP_Query
- add_filter() depending on search term
- SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
- Order By table field comment_status in WordPress > 4.0
- query_vars filter not working even though query string parameter is present
- Complex WP_Query order request: DESC by day, but then ASC by time
- How to set multiple `orderby` in query argument?
- WP_Query order result by date AND meta_value
- How do I run through a WordPress loop called from a filter function?
- How can I filter by slug depending on language selection
- WP_Query orderby author__in
- wp_query ‘s’, search filter with pagination is not working
- How to orderby multiple meta fields if some fields are empty
- Sort wordpress custom posts based on meta value
- How to filter, restrict and return posts based on custom user meta information