Custom WordPress SQL Query 4 posts per custom taxonomy

This is possible, but there’s not a “neat” way to do it. There’s a great write-up here:

Display the Most Recent Post in Each Category

but as the author points out, it’s a separate query to get the most recent posts for each term. To his great credit, he does deal with caching them, which will help tremendously with the load this would place on your database / server.

Related Posts:

  1. WordPress Paginate $wpdb->get_results
  2. $wpdb->replace: WHERE?
  3. Custom select query two tables by a meta key
  4. Fastest and most efficient SQL query to check if UID exists
  5. What SQL Query to do a simple find and replace
  6. Custom Search Query
  7. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  8. wpdb get posts by taxonomy SQL
  9. Multipart/formatted MySQL query problem
  10. How to make an activities stream mixing posts and comments?
  11. Can I use $wpdb for my custom tables in the WordPress database?
  12. Create subpage /user/ or /my-profile/ like /author/ with additional query like /user/user123
  13. Retrieve and display data from custom db table in admin area?
  14. How to find if a post with custom_field == X exists?
  15. Custom search page and search by title, content and tag
  16. Modifying loop on a custom page, strange behaviour
  17. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  18. What’s the proper way to use a custom table? [closed]
  19. Why would switch_to_blog stop working?
  20. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  21. How to correctly pass values to wpdb->prepare()?
  22. What’s wrong with my $wpdb prepare?
  23. Get stock by custom meta field on all Woocommerce variable products
  24. How I display post of the post type group by year of post?
  25. Load more posts with multiple queries
  26. Hi, I wanted to make custom search with multiple fields
  27. The function can not create a table on MariaDB server
  28. wp_query get post custom taxonomy in search.php
  29. Q: How to pull data from custom table to populate zustomizer setting/control select options
  30. Include data from custom table in WP_Query
  31. $wpdb->insert running multiple times?
  32. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  33. wpdb custom tables without plugin
  34. Order posts with a custom field but also without
  35. wpdb query problem to access previous 3 days posts
  36. WordPress Custom post query sorting does not work
  37. Save title as custom field on custom post type
  38. I can’t figure out what’s wrong with this statement. $wpdb->query update
  39. Add content in between of foreach
  40. Custom Loop Query For Search Page
  41. Custom Query – Based on user input
  42. Custom SELECT Query With Multiple Meta Values (Ordering Problem)
  43. PHP -> SQL Query with Summing
  44. Query for specific custom field
  45. $wpdb->prepare affecting the query?
  46. prepare function sql safe method
  47. Display posts by combining multiple meta key
  48. Why my query does not run with prepare
  49. Custom Same Page Search
  50. Fatal error Call to a member function insert() on a non-object [closed]
  51. custom user meta query
  52. How do I query for posts by custom meta and those that have been stickied?
  53. SQL query to get posts from multiple categories but not in a category
  54. Recent activity query WordPress
  55. How to query term_id of a Custom Taxonomy by name
  56. Troubles about insering a POST with a SQL query, post_status
  57. WP Search Form Query: Add Author’s posts into search query
  58. query variables for custom taxonomies
  59. display text generated via custom get query string
  60. Customising the default wordpress search functionality
  61. What is my error trying to create a new table in the database?
  62. Any way to use FETCH_KEY_PAIR with $wpdb?
  63. Delete oldest wordpress post (SQL query)
  64. Custom query pagination with php parameter as arg problem
  65. How to have differents sites share the same tables of DB?
  66. How to automatically pull an information from a form field onto an other page?
  67. Query Posts to display all posts with category “custom field value”
  68. Add commentmeta custom field to every published comment with SQL
  69. Query 1 custom post type, each day, alphabetically
  70. $wpdb query for price in custom field value
  71. Run an update query in a function
  72. Pre_Get_Posts order DESC not registering
  73. Multiple Taxonomies Using Custom SQL Query
  74. Wpdb generates too many queries
  75. get_var result empty for query of custom table in plugin admin
  76. Search a meta field for a value in all posts
  77. Special Query: Title, Terms, Content – %LIKE%
  78. Custom MySQL query to list post
  79. Custom Query Arguments
  80. pull custom fields values from wp-database in a nested foreach loop
  81. Custom Query for Taxonomy
  82. Include plugin´s table in custom query
  83. User Query Multiple Orderby Clause
  84. Has the table name in SQL for WordPress changed from WP_posts to WPCS_post?
  85. wp_trim_words() does not trim the_content() in WordPress
  86. Gallery Shortcode: using link attribute to link to a specific image size
  87. Limit comments displayed on basis of user_id
  88. Are database queries created using WordPress filters protected from SQL injection?
  89. How to display post title & excerpt when mouse hovers on an image?
  90. Can’t receive $args[ ] to my custom widget
  91. Customizing Users in Admin Area
  92. CREATE TABLE with dbDelta does not create table
  93. get_delete_post_link( $post->ID ) is blank when logged in as “subscriber”
  94. insert post fails after multiple postings
  95. A delete/trash all function?
  96. Creates only one table and not the other
  97. Unable to show messages using ‘admin_notices’
  98. How can I add a Description column to the media library browser screen?
  99. Changes in comments.php in the child theme does not show up on the site
  100. how to modify request to get_template_part()?