Unfortunately there’s not really an easy way to achieve what you’re looking for because you’re using ACF to manage the relationships. ACF stores its data as serialized arrays in wp_postmeta, so you can’t use SQL. A more performant way to manage the relationships between posts and FAQs would be to use a taxonomy.
Related Posts:
- Using OR conditions in meta_query for query_posts argument
- How To Fix WP Query Returns Results But Shouldn’t?
- Editing the default wordpress search
- wordpress ajax relationship query
- Slow Query On Search
- Excluding posts from search results page with meta query not working
- Slow wp_posts and wp_postmeta query using Advance Custom Fields
- Limit default Search query to post_title
- How can I modify standard search query to include also ACF custom fields values?
- WP_Query with “post_title LIKE ‘something%'”?
- Can I force WP_Query to return no results?
- Post_count only shows the number of results per page
- Pagination with custom SQL query
- WP Query where title begins with a specific letter
- Display List Of Posts Containing a Relationship Field Value [ACF]
- Whats the difference between post_limits and pre_get_posts?
- Search custom taxonomy term by name
- ACF Relationship Field Search Filtering [closed]
- Is it possible to wrap Geo Location search around WP_Query?
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Is it possible to select against a post’s parent’s fields with WP_Query?
- Tracing the life of a query
- Want to redirect if search query match exact title of any post
- Extending WP_Query — Optimise SQL query
- ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
- How to filter sql only for a specific post type
- How to make an activities stream mixing posts and comments?
- Pagination not working for Custom search form & custom result template
- How to support multiple search terms query within one process?
- SQL Statement generated by WP_Query not producing expected results
- WordPress meta_query and order by custom field
- What is an efficient way to query based on post_meta?
- Pagination broken when merging search results with additional WP_Query
- SQL query equivalent to WP User Query
- Custom search form with empty parameters
- How to search by title or tags exclusively?
- WordPress search exact match
- Pagination wont work with search results template [duplicate]
- Revolution Slider Orderby Two Custom Fields
- Recommended way to drop a pending query (in pre_get_posts)?
- How do I search WordPress by different fields without a plugin?
- Multiple keyword search
- how to retrieve specific product attribute value in an sql query?
- Using next/previous_posts_link with customised search
- meta_query with array as value
- WordPress custom search form with pre_get_posts not work
- Search – Ajax – Alter Query Parameters with Pagination
- query posts in functions.php and update a field
- Add custom search results to main WP search [duplicate]
- Multiple search queries on one page
- tax_query shows no results if nothing is selected
- Filter WordPress posts by between parameter
- SQL User Query by Multiple Roles using PHP
- Advanced WP Query hogs the SQL server
- SELECT * FROM $wpdb->posts WHERE ID > 160
- Searching through different categories on different pages code is not working
- Minimising number of queries on a page when using Advanced Custom Fields
- WP Query search for attachments and their exact title
- Query Posts depends on custom field inside repeater field using acf
- WP_Query’s “request” SQL Query
- Including only current user’s posts in search
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- ACF Relationship + WP Template Parts
- Query post with meta_query where date is not in future
- is_search was called incorrectly
- Minimising Database Queries when using Advanced Custom Fields
- How do I search inside specific taxonomies in WordPress
- Modifying the Search Results
- ACF – Get lowest & highest value from field
- WP User Query get all authors with last name starting with specific letter
- Custom category search box for WordPress
- Select from wp_post and multiple meta_value from wp_postmeta
- Refine search results using WP_Query
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- If two first numbers exist in wp_meta_query value
- WP_Query meta_query >= date
- Search Posts with Custom Fields as query
- How to correctly pass values to wpdb->prepare()?
- Complex date range with WP_Query and BETWEEN
- Creating a custom search for a specific post type
- Sort users by “birthday” using WP_User_Query
- $wpdb select date range of posts
- Custom Search Result Page displaying only 1 result.
- ACF Date Based wp_query
- How to loop for every result found in the_content() when using the search query?
- Multiple taxonomy And acf filter group by
- List of the years with posts presented
- Assigning a meta_query value based on regexp to wp_query fails
- Custom query based on meta key – Reduce three states to two in results?
- Include custom field in Ajax search WordPress
- What is the random string I am seeing when I use get_query_var?
- showing all search result in one template
- Querying on multiple taxonomies pulled from $_GET checkbox array not working?
- Is there any advantage of using default WordPress Search instead of creating a custom one?
- SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
- Slow WP_Query for custom post type
- WP_Query Not Recognizing Taxonomy Parameter in Custom Search
- Search pages that are a child of the current page
- Include tags in WP_Query
- Search for multiple tags?