Show Blogroll of another WordPress site

You have a couple of options here, but first let me advise you away from querying the database directly. If your sites are that closely related, then they should be in a Multisite network …

RSS

On Site B, fetch the RSS of Site A and display the posts and author attributions there. You can find any number of RSS plugins that do this for you or just get you started.

XML-RPC

Site B can also connect to Site A to fetch the latest posts using XML-RPC. You then have full access to data, including the most recent posts, as well as media, comments, etc.

Related Posts:

  1. How can i get count from query post
  2. Using WP_Query to Query Multiple Categories with Limited Posts Per Category?
  3. Is there a way to exclude the content from the post variable to save on RAM usage?
  4. Display/query post formats
  5. How to query post by user role?
  6. Ensuring sticky posts are retrieved first (without using two queries)?
  7. Determine if more posts are available than was asked for in `query_posts()`?
  8. query_posts() in function makes global $wp_query out of sync?
  9. Limiting query_posts to 1, regardless of sticky post?
  10. WordPress Custom Query
  11. How should I intercept the main query and inject custom join / order by / group by criteria
  12. advice on creating a ‘related posts’ query like the one used on stackexchange
  13. Using dynamic conditions in ‘posts_where’ filter
  14. Help altering a query to exclude all but standard post format
  15. List users with the most total posts view
  16. Schedule Sticky Posts
  17. How to limit search to first letter of title?
  18. Post Title displaying but not in the wrapped HTML I need
  19. get_post_meta causes database queries
  20. How to ensure that is_search() return false after query_posts
  21. Inserting Post Using wp_insert_post. How to Fill Yoast Plugin SEO Fields
  22. Why is that gdsr_sort=thumbs (GD start rating plugin) only works with query_posts and not with WP_Query?
  23. Query_posts $query_string
  24. How to order posts by slug using query_posts/ Wp_query
  25. How to get 4 Posts after the 5 most recent ones
  26. Query 1 taxonomy term, exclude another
  27. Order by meta_key with two meta_queries
  28. Pagination on custom query
  29. Search stores (custom postcode field) within 5, 10, 15 miles of user inputted postcode.. Code modification
  30. Ordering terms before displaying posts
  31. What is the difference between “manage_{$post_type}_posts_columns” and “manage_edit-{$post_type}_columns”?
  32. Sort Posts by Multiple Meta Values [duplicate]
  33. Querying posts with meta value that begins with a certain pattern
  34. How to show only today’s post?
  35. use query_posts to return a post OR a page by ID
  36. Adding Variables to post query
  37. Unable To Get Published posts using query_posts
  38. ACF Custom Field WP_Query, but need to get all posts, if field doesn’t exist
  39. Read More is not working in query posts
  40. query_posts for child pages
  41. How to reverse the order of WordPress blog posts?
  42. orderby:date not working
  43. Placing post data (title, date, and excerpt) nested in static content
  44. query_posts() ALWAYS displays something?
  45. Trouble with get_next_post() get_previous_post() returning null
  46. Single meta key with multiple meta value in like comparison
  47. Possible to display posts containing a short code ?
  48. How to run a SQL Query for character in Post Titles
  49. Authors List page : how to exclude posts from certain category
  50. list child page items (1 level with meta keys)
  51. Query a WordPress page by its title (which has a parent page)
  52. Sorting a query Field by date
  53. Trying to package posts for republishing by partner offsite
  54. Why this code causes infinite loop?
  55. Each post is showing twice in my custom query…?
  56. number of posts per page + random + exclude categories
  57. query_posts() – problem with “s” parameter
  58. How to Query Post
  59. query_post and wpdb returning different results
  60. Exclude current sticky post
  61. Page title in post query
  62. query_posts pagination will always show identical content
  63. Question about querying posts
  64. How to list most popular post
  65. WordPress Custom Query to get Most Commented Posts in the Past 7 Days
  66. Breadcrumbs stop working on a specific template file
  67. How can I query for all children posts regardless of parent
  68. INSERT in table row fatal error
  69. WordPress query reverse order
  70. How to reverse post navigation at bottom of post
  71. WP-API: get posts in multiple categories
  72. Restrict query_posts by Date?
  73. Different layout based on post amount?
  74. How to solve this without flushing the rewrite rules for each post query the visitor triggers?
  75. Sort post by custom field numeric value
  76. Notting but the latest post content keeps on being loaded
  77. query_posts doesnt show pages with given ID when post_type => page
  78. Keeping get_posts’ offset and is_paged() synchronized
  79. Having an issue doing a WP_Query with post_content and category__and
  80. How to put posts in pages using query posts
  81. Query add html after set amount of posts?
  82. Custom loop off by one post
  83. How to setup blog page to render blog posts minus afew categories
  84. Create a Loop with Posts Ordered by Most Recent Comments
  85. How to get max value of filtered query post
  86. Ordering of posts, 2020 Year showing as next event when should be last
  87. Pagination doesn’t work in query post in tag template
  88. Specifying image size used in template the_content
  89. How to display most popular post by views count in WordPress?
  90. Order posts by ACF checkbox
  91. How to optimize ‘select found_rows()’ query? Several ‘high load average’ alerts daily
  92. query multiple posts by id using a string parameter, not array()
  93. query_posts – slightly more advanced query
  94. Query posts in a category and include only one post per author?
  95. Query Posts Creates 404 Error
  96. How to go to tag archives using a form
  97. WordPress loop problem: Multiple loops, index.php and is_paged causing duplicate posts on next page
  98. Achieving pagination with `query_posts`
  99. query_posts works while get_posts doesn’t
  100. Sort posts with multiple meta_keys