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 to Get All Posts with any post status?
  2. posts_per_page no limit
  3. How can i get count from query post
  4. query_post by title?
  5. Why query_posts() isn’t marked as deprecated?
  6. Alternative to query_posts for main loop? [duplicate]
  7. how to query posts by category and tag?
  8. Using WP_Query to Query Multiple Categories with Limited Posts Per Category?
  9. Order by meta value or date?
  10. How do I query by post format in WordPress 3.1
  11. Display posts of the last 7 days
  12. Is there a way to exclude the content from the post variable to save on RAM usage?
  13. Filtering posts by post meta data
  14. How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
  15. Query posts by custom taxonomy ID
  16. Display/query post formats
  17. How to query post by user role?
  18. How to return results of a get_posts() in explicitly defined order
  19. Help to condense/optimize some working code
  20. How to set posts per page using WP_Query()
  21. query_posts exclude a meta key
  22. How do I create a random post that will last for a day
  23. Ensuring sticky posts are retrieved first (without using two queries)?
  24. Determine if more posts are available than was asked for in `query_posts()`?
  25. Modify main WordPress loop with a parse_query filter
  26. query_posts() in function makes global $wp_query out of sync?
  27. Limiting query_posts to 1, regardless of sticky post?
  28. How to make “sticky” pages (and query by them)
  29. Query posts: how to exclude results if post is in multiple categories
  30. query_posts ->using meta_compare / where meta value is smaller or greater or equals
  31. Problem with ‘post__not_in’
  32. How to order posts by descending comment count on taxonomy page?
  33. Sort posts alphabetically by custom field value, insert divider between different letters
  34. Is it better practice to use query_posts, WP_Query, or get_posts to create various custom loops within a Page?
  35. WP 5.8 “Query Loop” block: where to place custom query?
  36. Sort X categories by last update and show image
  37. Custom Post Type “Event”: chronological list of recurring events
  38. using post__in allow duplicate post id
  39. Pagination on archive.php page
  40. WordPress Custom Query
  41. Best way to load page content in Fancybox popup?
  42. How should I intercept the main query and inject custom join / order by / group by criteria
  43. advice on creating a ‘related posts’ query like the one used on stackexchange
  44. order post my meta value m/d/y format with year as included value
  45. Order by meta value, pro first, then free
  46. Having trouble generating pagination links on custom query
  47. How to create an attachments archive with working pagination?
  48. _wp_page_template to dynamically use template
  49. Using dynamic conditions in ‘posts_where’ filter
  50. Help altering a query to exclude all but standard post format
  51. List users with the most total posts view
  52. Schedule Sticky Posts
  53. Use union/intersection query_posts variables in uri request parameter form?
  54. query_posts doesn’t order by title
  55. How to limit search to first letter of title?
  56. query_posts and pagination, still stuck after much research
  57. Query posts by taxonomy term name
  58. Sorting problem with ‘query_posts’ funcion in wordpress. Sort by custom field not working
  59. Total Count of Posts NOT in Selected Categories?
  60. Custom query with query_posts doesn’t show post without certain meta_key
  61. how could I get the pagination as I want to when query posts using get_posts function
  62. Counter code for paginated category pages in wordpress
  63. Post Title displaying but not in the wrapped HTML I need
  64. Author List page: Exclude based on last post date
  65. WordPress Search Filter Only for Page with Child of Child of Child of Child of Child
  66. Replace query_posts with pre_get_posts
  67. How to sort by meta value?
  68. query_posts sort in multiple directions
  69. Filter query_posts by tag slug on “Tag Archive” page (when tag is 2 or more words)
  70. pagination in author.php template returns 404 error
  71. get_post_meta causes database queries
  72. Problem with single-page for my custom post
  73. How to ensure that is_search() return false after query_posts
  74. Warning: urlencode() expects parameter 1 to be string, array given in and not getting the preffered output
  75. How to modify the query to exclude posts by slug?
  76. query recent posts from several categories
  77. Inserting Post Using wp_insert_post. How to Fill Yoast Plugin SEO Fields
  78. Show Posts From Same Category OR Same Tag
  79. Post count per (day/month/year) since blog began
  80. Example Query Posts Showing the Latest Post with the Featured Image
  81. Dynamically excluding current page id
  82. Why is that gdsr_sort=thumbs (GD start rating plugin) only works with query_posts and not with WP_Query?
  83. How do i paginate query_posts with numeric pagination?
  84. Query_posts $query_string
  85. How to make the list of post and load on same page with sub-pages [closed]
  86. Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
  87. exclude ids through post__not_in
  88. How to order posts by slug using query_posts/ Wp_query
  89. How to get 4 Posts after the 5 most recent ones
  90. Query 1 taxonomy term, exclude another
  91. Order by meta_key with two meta_queries
  92. How to order results by date and meta key?
  93. Pagination on custom query
  94. Search stores (custom postcode field) within 5, 10, 15 miles of user inputted postcode.. Code modification
  95. Ordering terms before displaying posts
  96. What is the difference between “manage_{$post_type}_posts_columns” and “manage_edit-{$post_type}_columns”?
  97. Sort Posts by Multiple Meta Values [duplicate]
  98. Querying posts with meta value that begins with a certain pattern
  99. How to show only today’s post?
  100. Different number of posts on the front page
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)