The biggest problem here is syncing between two dissimilar sets of data. This looks like a good use-case for @scribu ‘s Posts2Posts plugin.
Once you’ve installed that, you can create a direct correlation between the different post-types and query that connection.
Related Posts:
- Multiple Rows in a using wp_query
- Some doubts about how the main query and the custom query works in this custom theme?
- Using a custom WP_Query with get_template_part loop
- Loop within a loop?
- How to list some posts first in the loop based on post id
- Display posts the match taxonomy term linked from wp_list_categoies?
- WordPress Custom Query to show posts from last x years
- How to order posts tag by tag?
- Loop through all tags & output posts in alphabetical list
- Pagination with 5 posts per page
- Merging a complex query with post_rewind and splitting posts into two columns
- Pagination Not working on Home Page with 2 Query
- meta_query not working properly
- Pagination not working Search posts
- How to display 3 different loops in 3 columns on homepage
- Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
- WP_Query to get posts in a specific category and post format
- Can’t get drafts with WP_Query using post_status parameter
- WP_Query doesn’t get sticky post at the top, when used in a page template
- WP_Query loop within WP_Query loop
- Prevent duplicate post from dynamic multiple loops
- if/else on custom query gives 200 OK when condition not met?
- Multiple Loops Inside a Function
- How to pass many ids in post__in?
- Sticky posts are not showing at the top of category posts
- Storing query variable and then using wp_reset_query
- Sub-loop / nested loops Best Practices
- Any number in meta key (wp query)
- Can I set my WP_Query to be a Main Query?
- How do I run through a WordPress loop called from a filter function?
- How do I get the title of a category in a custom loop?
- Group and list posts by custom taxonomy
- Show scheduled posts in main loop but not in WP_Query?
- Change query based on post type while staying in loop
- Get a list of posts with associated meta_value
- $WP_Query: How to display excerpt on first post only
- Check if loop has any categories?
- WordPress query with items from more than one selfdefined taxonomy as `term` argument
- Show all data in database table and make it into an interactive table
- How to make search for posts using get method?
- How to get list of posts from permalinks?
- Get all fields inlcuding “ACF” (Advanced Custom Fields) columns in wp_query
- How to access custom WordPress database tables
- get_template_part causes 500 error
- Assign custom parameter to each post in query
- how to use pre_gets_posts to exclude one queried ID from homepage loop
- WP_Query – Adding “offset” posts to the end of the loop
- Conditional operator OR not working with custom fields
- Get posts that do not have the same tags as current
- wp_query is showing posts from other categories
- Should I reset $wp_query?
- Exclude a Woocommerce product from WP_Query
- WP_QUERY wrong ammount of posts
- How to add sort order to incremented and paginated category loop
- How does WP generate the default $query in WP_Query based on the URL?
- How to remove only the latest sticky post from the loop
- Expecting statement error from php loop using ACF plugin
- How I can repeat 2 HTML templates in a WordPress Query?
- How do I sort this custom list of sticky posts
- Query only displays one page_id
- Get posts with no tags?
- wp-query, pull children of parent page
- I am officially missing something about transient posts
- Offset WP_Query by negative 1
- WP_Query orderby random do not repeat infinite scroll – one loop
- How do I get the content of a custom instance of WP_Query?
- $post in wp_query?
- How to pass the current content of $wp_query to a new page?
- How can I have sticky posts while ALSO showing posts from a specific category using one WP_Query?
- ACF: How can I publish values of ACF fields in a loop while using wp_query?
- Can I alter the main loop to ‘orderby’ a custom callback?
- Show a message if there are no active posts in category
- WooCommerce | AJAX | Product Pagination | Help me implement Ajax Pagination
- Problem with my loops
- Regarding a custom loop and output HTML tags
- display the children of the post using the current page as the main parent
- Display 3 levels of categories on page
- Paging works correctly on local version, but not live?
- Custom post type loop error: Trying to get property of non-object
- Second WP_Query loop shows data from main query
- How to add in WP_Query to every 3 posts displayed? [duplicate]
- Display three sequential posts on each page load, without repeating previous
- display post multiple times based on array of dates
- How to make a wordpress loop file that displays posts based on certain conditions
- Custom loop – Isolating post meta output depending on current query taxonomy terms
- Issue in If else condition [closed]
- Pagination not working with WP_QUERY
- Sorting is not working in WordPress WP_Query
- Add custom WP_Query after the first 3 posts
- How do I display posts with specific value in a custom field into my loop?
- Search Query that Includes Custom Table
- Order by multiple meta keys on wordpress
- wp_query pagination links producing 404
- Display First posts without the default featured image
- Pagination problem with multiple loops on the same page
- Can’t seem to get an else statement correct? [closed]
- Output ACF field dynamicaly within a taxonomy loop [closed]
- How do I split a large query with a semi-expensive function included into multiple smaller queries
- Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
- Custom WordPress loop, articles not in same order as Array