The answer is… I’m an idiot! (sort of)
My query is fine. It’s not pulling the post I expected it to because I had a LIMIT of 7 and when organized by date my expected post was further than 7 down the line. I was getting confused because the end result of this is a search page with posts organized with matching tags counting for more relevance than matching words in post content, but that organization only happens after the SQL query.
Special thanks @dechler for jogging my brainand making me realize that his attempt would work because he had less posts to be searching through.
Related Posts:
- Speed up search query that searches in post meta?
- How to make MySQL search queries with quotes
- How to display SQL query that ran in query?
- what are the numbers between curly brackets in search query
- How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
- wpdb get posts by taxonomy SQL
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Search Terms – Querying on either description__like OR name__like in the same Term Query?
- WordPress creating excessive joins on meta_query with search
- search through post-type attachments titles
- cron job to auto delete posts of a specific post type older than x days
- Are database queries created using WordPress filters protected from SQL injection?
- Get posts by category with pure SQL query
- Custom query to get terms from post ids
- Get the timout value of a saved transient?
- Change searched term
- What’s wrong with my $wpdb prepare?
- Search query -> Show all pages except certain template
- Temporarily storing main search result
- Editing the default wordpress search
- How do I see the mysql query generated by get_posts( $args )?
- sql select query in wordpress ‘page’ [closed]
- Query based on title, with ‘compare’ => ‘IN’
- is_search called incorreclty
- problem with sql query in wordpress plugin
- Searching With Apostrophe
- wpdb query problem to access previous 3 days posts
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Custom Query – Based on user input
- How to reset usual $query on search page to push custom $wpdb query there?
- how to insert missing tags into the posts through mySQL?
- Ideas how to search & replace post_content when string contains a newline?
- How to insert Collate into WordPress search query?
- Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
- $wpdb->prepare affecting the query?
- WordPress SQL search, how to handle SQL Injection?
- exclude pingbacks from wordpress SQL query
- How to interfere to default search to make it search in custom fields?
- prepare function sql safe method
- WordPress SQL query to tag all posts containing a specific word on title
- How to manage a particular “order by” for get_search_query()?
- Select column name dynamically mySQL Query
- How do I query for posts by custom meta and those that have been stickied?
- Change pure SQL database query to WordPress post query?
- Build A Custom SQL Query for WordPress Search
- WordPress search in modified post title
- Filter orders by modify date
- How to add url parameter to every search query in SearchWp?
- Cannot get sql request from Query object?
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Customising the default wordpress search functionality
- Display data from phpMyAdmin with WordPress
- Add rewrite rule for archive search
- SQL to Query the db and return all posts and it’s metas
- Restrict WordPress search to a single ACF field
- SQL query to delete users with multiple meta keys and comments
- Nested select statements not working
- Modify behaviour of “s” parameter in wp_query
- Sort by postmeta on when searching
- searching by keywords in post’s metas or pagination links problem
- Pagination adds search query (again)
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Fastest and most efficient SQL query to check if UID exists
- $query->set( ‘post_type’, ‘post’ ); not working
- How i make a custom sql query for Woocommerce
- $wpdb query for price in custom field value
- Run an update query in a function
- How to display a specific category using a custom Query in WordPress?
- search.php is not generating the right results
- Slow query when joining wp_posts with a lookup-table?
- Run search query again without pagination gives no results?
- Wpdb generates too many queries
- learn to run wpdb class
- SQL Query : how copy all tags of post into their post content in wordpress by sql query
- Where can I find the SQL to get the most used information by wordpress database?
- Custom Query for wp_posts using wp_postmeta
- 3 queries to update WordPress
- Reversing the order of posts AFTER the query is performed
- add_query_arg() XSS Vulnerability
- Custom Query to search through categories
- How to go about combining dropdowns / filter queries?
- Modify users.php query with multiple taxonomies
- MySql Query very slow
- Making a query to the DB using same parameters of loop
- Problem when try to add ++1 for user meta
- Query where ANDing slug values not working
- how do i register global query in template
- Sort query_terms_list for post_tags alphabetically
- Target a page with query
- How do I get specific readable results from this query and array results
- Query reversed when I use “category__not_in”
- Display Upload Author & Get Uploaded Post ID
- Display list of most recent grandchild (third tier) pages
- Update vs Insert logic but the last key is always inserted?
- Custom Query for searching through custom fields
- WP Query outputs three items within a div
- Query comments with non-empty ‘author_url’ value on Admin Comments Screen
- Advanced Search – Is this possible?
- How to show sticky posts on all pages of the pagination, not just the first page?