WP_Query return highest number only

If I get this right each of your posts have one value of Exercise and one Value of Tempo?

I would do the following probably:

  1. Build a list of exercises.
  2. For each exercise query query: 1 posts, ordered by Tempo, descending.

This is probably as good as it gets staying within realm of WP API. Might not be practical for high counts of Exercises, it’s all custom SQL from there.

Related Posts:

  1. Include images from pages in wp search.php results in default wp search
  2. List events by month
  3. How to append element after thumbnail
  4. GravityForm: Populate Dropdown with custom post type [closed]
  5. Can’t get order_by meta_value_num to work properly
  6. If post has custom field then display css-class
  7. Replace text in post from cvs
  8. Make a custom_post translatable
  9. How To Post WordPress Custom Post Types to Twitter via IFTTT
  10. Pagination hitting 404 page on /page/4
  11. Filter content in shortcode
  12. Validate Custom Post Type fields
  13. Accessing a protected property of a post
  14. Accessing download link from the loop with WP Download Manager Pro
  15. Set a template on a custom post in the plugin
  16. Filter Custom Post Type Posts by Taxonomy
  17. Include images from pages in wp search.php results in default wp search
  18. How to display all custom fields associated with a post type – IN THE ADMIN AREA?
  19. Show custom taxonomy not in submenu
  20. Loop carousel slider in wordpress
  21. How to Fix WordPress 500 Internal server error due to custom post type
  22. How to hide home title on pages and posts?
  23. Inconsistent temporary 404s on whole install | PHP error with post-template.php
  24. Search that will look in custom field, post title and post content
  25. Load custom posts with same tag as page
  26. Date archives for custom post type
  27. If featured image doesn’t exist, show post content
  28. How can I add dropdown widget/box to admin post page?
  29. Meta Query “IN” doesn’t work with ACF checkbox filter
  30. How to get only one category of custom post type?
  31. Error after deleting Custom Post Type with a function (no trash used)
  32. Append taxonomy terms as class names in markup?
  33. Change message given when deleting post from custom post type
  34. Using WPAlchemy metabox values in another metabox
  35. Display custom field of specific post where post title matches variable
  36. Custom Post Type | Fatal Error on register_post_type()
  37. How to output wordpress custom tags separated by comma?
  38. Show Different Header on a Specific Post ID
  39. Admin notice not displaying
  40. WooCommerce product search titles only
  41. Dynamic page outside WordPress
  42. Custom query to filter posts that have current post as a taxonomy [closed]
  43. Accessing post’s meta data based on user’s click of a post
  44. Changing number of posts per page on CPT-archive.php, have tried 20-30 code chunks so far
  45. Custom Post Type Loop throws 500 error when used in widget
  46. custom post type not showing in menu
  47. Received nothing after executing AJAX post function
  48. How can I make a custom post type sticky?
  49. limit value taxonomy based on previous taxonomy value wordpress
  50. How to change wp prefix for custom post type only?
  51. Metabox not show in categories custom post type cmb2
  52. Categorize custom post type
  53. Hide a widget inside a div on specific type of post
  54. How to import a custom MySQL DB table into a WordPress custom post type
  55. Function causing the loop display posting more (empty)
  56. Foreach inside shortcode not working as planned
  57. Custom fields for custom post type
  58. Set featured image to archive.php
  59. Get term name without a foreach loop
  60. Using wp_query to modify the loop in index.php for a CPT
  61. Create metaboxes based on custom post type
  62. Get custom post type categories to show up in menus
  63. How exclude or skip post type with get_next_post_link
  64. Create short URL with auto 301 redirect
  65. Is it possible to use array_walk() to append terms to an array of posts?
  66. get_post_types() can’t get some of my post type
  67. CMB2 metabox create select with list of post from CPT
  68. Custom post types, disable fields
  69. Different column width in 2 rows with bootstrap and custom post types-different classes needed
  70. Menu’s breaking, now showing all page links on site
  71. Page that lists publications by classifying them by taxonomy
  72. count & sum the value of custom field of the author post in dynamic posts
  73. Title and URL Error in Breadcrumb Navigation for Custom Post Types
  74. Assigning categories to custom post types via a front-end form; only works for native post type
  75. How to limit the number of custom posts certain users can publish in WordPress using php script?
  76. Custom sorting in post columns by ACF Pro Select Field
  77. Visualize info in just custom post_type in theme
  78. cpt not display inside nav menu
  79. wp_post_delete is deleting all offices
  80. How to show link to product in custom fields?
  81. current-post-parent for custom post type
  82. Having issue on Loading Meta Data From CSV to CPT
  83. CPT UI: Connect a custom post type to a custom post type
  84. The most recent post of custom taxonomy
  85. I broke it! Custom post type archive gets redirected to home
  86. Can’t save custom post type fields
  87. How to Create movie schedule by custom post type query
  88. Adding CPT changes entire layout of my site except for the archive of that CPT
  89. Create 2-layered dropdown menus for custom taxonomy and custom post type
  90. Get month and day from a Date Picker custom field
  91. Show Custom Post Type taxonomy term that matches custom field
  92. Select Menu for Custom post Type does not save
  93. is_singular won’t call my functions?
  94. How to add post type in masonry posts elementory widget
  95. Remove plugin’s custom post type archive page and single pages [closed]
  96. Inserting two categories
  97. How to delete unnecessary custom post types in the UI
  98. add_filter > posts_where works partially
  99. Send email on creation of custom post type and use get_post_meta()
  100. Just the First Metabox what saves the data!
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduseduseduedueduedusedusedu