Query posts by custom fields

I managed to figure it out (finally) after about 12 hours of screwing around.

The answer here gave me 98% of the answer, and the rest was simply using the appropriate hooks to modify it for my use and to include the postmeta table.

Related Posts:

  1. Can I force WP_Query to return no results?
  2. Order Search Results Page by meta_value If no Value Return Remaining Results
  3. Tracing the life of a query
  4. Want to redirect if search query match exact title of any post
  5. How to support multiple search terms query within one process?
  6. Custom search form with empty parameters
  7. Pagination wont work with search results template [duplicate]
  8. Search – Ajax – Alter Query Parameters with Pagination
  9. Multiple search queries on one page
  10. tax_query shows no results if nothing is selected
  11. Searching through different categories on different pages code is not working
  12. WP Query search for attachments and their exact title
  13. WP_Query’s “request” SQL Query
  14. Including only current user’s posts in search
  15. is_search was called incorrectly
  16. How do I search inside specific taxonomies in WordPress
  17. Custom category search box for WordPress
  18. Refine search results using WP_Query
  19. Search Posts with Custom Fields as query
  20. Complex date range with WP_Query and BETWEEN
  21. Creating a custom search for a specific post type
  22. How to loop for every result found in the_content() when using the search query?
  23. Assigning a meta_query value based on regexp to wp_query fails
  24. showing all search result in one template
  25. Search for multiple tags?
  26. wp_query ‘s’, search filter with pagination is not working
  27. Multiple Search Terms WP_Query
  28. WP Query Args – Title or Taxonomy Value
  29. Display filtered results into custom page
  30. WordPress pagination not working on template search.php
  31. Cutom wp_query for geolocation search, pagination not working
  32. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  33. Search Query for multiple categories using ‘OR’ but having certain categories be ‘AND’
  34. query_vars overriding WP_Query args
  35. Query with search and subscribers only output
  36. how can I override The Events Calendar query modifications?
  37. How to make search for posts using get method?
  38. Categorising search results based on Custom Fields
  39. using pre_get_posts for search results not found
  40. Search posts missing a particular custom field
  41. How do I get my custom query to work with search results after the first page?
  42. Modify Search Query if original Query gave no results
  43. Include post content of linked posts in search
  44. Replacing search results with custom external query
  45. Prevent author bio page from showing in search results
  46. How do I amend wp_query before it is run/executed?
  47. Get a list of posts by specific category
  48. WordPress Custom Search Form Displaying Unexpected Results
  49. Redirect Search to Form When No Product Results Are Found
  50. How to properly use AND / OR in custom search
  51. Issues with search after added meta_query
  52. Slow Query On Search
  53. Sorting search results with custom dropdown
  54. How To Keep Search Title the same on paged Results
  55. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  56. How to restrict search on a certain page to only return results against custom taxonomies?
  57. Filter out a meta key in the Search results page with two CPT
  58. Query by key or author
  59. Can I make a search query which includes a space?
  60. How to filter a static post page with ajax and $wp_query
  61. Searching not only by post name but also category
  62. $wp_query->found_posts not returning correct value
  63. How to search by slug and old slug in single API
  64. My combination of ‘post_type’ and ‘tax_query’ not working?
  65. Block internal search queries with pre_get_posts and regex rules
  66. How to make the WP query search for the “s” arg in other places too
  67. Search Exact on WordPress – Relevannsi Solution Not Working
  68. Excluding posts from search results page with meta query not working
  69. Pagination repeating posts on search results
  70. I have problems with the search query using multiple post types
  71. WP_Query no result if keyword contains number
  72. Categories In English version showing not canonical URL, instead shows query search result
  73. Filter admin ajax data by url query
  74. How to extend WP_query to a specific table?
  75. Display Search Results by tag_ID in my search.php
  76. How to debug none working search query?
  77. getting posts by tags
  78. Add to search posts query array with post IDS which will appear first
  79. Custom Post Type WP_Query with filters and search
  80. Search has query that will return no results
  81. Get posts by similar names and categories
  82. Logging search queries for logged-in users
  83. How to show terms from another taxonomy
  84. Search Field that allows options of “Match any keyword” or “Match all keywords”
  85. A very strange problem with search query
  86. Search format not matching taxonomy query
  87. Search Functionality broken by the wp 4.2 update
  88. Custom search (wp query by custom fields)
  89. WordPress WP_Query Array Custom search via taxonomies
  90. Custom Search Query – include only custom fields and title
  91. $wp_query when new WP_Query
  92. Search Query that Includes Custom Table
  93. Manipulating a query
  94. Why does WP_Query not search for two ‘meta_query’ keys separated with OR?
  95. Filtering product search results using tags
  96. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  97. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  98. How does Show Posts based on a keyword search work in WP_Query
  99. Search results stuck on page 1
  100. Custom Taxonomy in custom REST API search