If you can formulate problematic part of your request as WP query you can run it and look at $wpdb->last_query to see generated SQL. This is usually easiest way to have a starting point and something to customize further.
Related Posts:
- Using a custom WP_Query with get_template_part loop
- WP_Query orderby post__in remains ineffective in the Loop [closed]
- How to make WP_Query ‘post__in’ accept an array?
- WP_QUERY Get posts by category and similar name (Like)
- Using get_posts vs. WP_Query
- Is it possible to orderby multiple meta_keys when using meta_value_num?
- Is it possible to wrap Geo Location search around WP_Query?
- Merging multiple wp_query objects
- Query causing load because of SQL_CALC_FOUND_ROWS post counting?
- Using custom meta_query with relation not working as expected
- How to Access Global $multipage or Global $numpages outside the loop?
- Only show first post to match certain criteria within WP_Query
- What is an efficient way to query based on post_meta?
- Pagination wont work with search results template [duplicate]
- Pagination Not working on Home Page with 2 Query
- WP_Query in a shortcode
- ‘posts_where’ filter not applying ‘WP_Query’ in `wp_ajax`
- Get all posts without tags
- Sort by meta key on archive page
- Get post ID’s from one query and exclude from another
- What are the differences between “Latest Posts” and “Static Page”?
- Retrieve or Query Pages by ID
- WordPress Query is taking more then 20 second and stuck on creating index
- Modifying raw $_POST data early in the lifecycle
- Searching through different categories on different pages code is not working
- Difficulty with rewrite rules
- how to get the id for a post from within a post and return post meta for it
- Show selected images on top in Media Manager
- How to make this WP_Query run faster on a WordPress website?
- Order taxonomy terms in alphabetical order
- How do I sort posts with multiple pages
- Complex date range with WP_Query and BETWEEN
- Attachment changing page’s permalink – $post not resetting?
- showing all search result in one template
- List custom taxonomy terms sharing posts with a term from a second custom taxonomy
- Make (post) query a clickable link
- How to set pagination to work with ‘/page/’?
- How to do meta_query for attachments?
- Most commented last 24h, week, month, year and all time – posts_where
- How can I filter by slug depending on language selection
- How to duplicate 5 posts out of WP_Query results?
- Ajax WP_Query reutrns no results on author.php
- WP_query sorting can’t sort danish letters (æ, ø, å)
- Dynamic User Id
- Large AND OR query timing out
- WP_query wp_posts_counts returns only count of admin and not users
- Categorising search results based on Custom Fields
- get_post_meta slowing down my page load (in a plugin)
- Custom taxonomy.php not working
- “tax_query” parameter is ignored when “p” parameter is set in WP_Query
- Conditional sorting with variable using WP Query
- How can i share WP_Query between multiple functions?
- Advanced WP_Query with meta_query, orderby?
- sort and display posts by custom field (wp-query and the loop))
- I need help using pre_get_comments to limit comments in the comments admin screen
- WP_query only displays one of my custom post type entries
- Issues with search after added meta_query
- How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
- How to create dynamic value in WP_Query meta_query
- Woocommerce: order posts by meta key
- Modify query posts
- WP_Query with multiple orderby NOT working with ASC and DESC, what’s wrong?
- query post by author gender
- How to access $wp_query object from array of posts given by get_posts?
- Display all attached image of every post of custom post type and link to original post
- How do I add an item to the WP admin menu?
- Multiple meta query from array
- Links in the_content not linked
- Related posts by current posts child category
- Trying to change category of wp_query
- Any quicker alternative for WP_Query “NOT IN”
- Block internal search queries with pre_get_posts and regex rules
- duplicated posts when using pagination
- Is it possible to give a classname to specific comments in the WordPress admin?
- How can I have sticky posts while ALSO showing posts from a specific category using one WP_Query?
- How to upload 3 attachments to current post?
- In a WordPress multisite configuration, how do I instruct WP_Query() to return posts from a sub-site?
- How to query for exact string in custom field?
- WP_Query for posts that have postmeta assigned to a taxonomy
- Paginated Author.php not using Author.php template
- Help displaying related categories
- A very strange problem with search query
- How to make a wordpress loop file that displays posts based on certain conditions
- Custom Theme Building & Permalinks
- Custom loop – Isolating post meta output depending on current query taxonomy terms
- wp_query – show pages that have parent defined
- previous_posts_link not working in WordPress pagination
- How do I display posts with specific value in a custom field into my loop?
- Orderby Meta Value and Query from Meta Query
- WP Query to order posts by multiple meta fields
- Order by multiple meta keys on wordpress
- Sort posts in dashboard using custom field; also include posts where field isn’t set
- Display First posts without the default featured image
- paginate_links() with Custom Taxonomy
- Parsing External Table Arguments
- Query posts by meta value and sort by another meta key
- Output ACF field dynamicaly within a taxonomy loop [closed]
- Why does WP_Query not search for two ‘meta_query’ keys separated with OR?
- How do I split a large query with a semi-expensive function included into multiple smaller queries
- WP Query returning all posts when Meta_query is null