Show one post per author and order by custom field

You use a AND statement after a GROUP BY statement. That wont work.

Try altering the WHERE statement (posts_where_paged filter) to add the AND pm.meta_key = 'KEY' line.

Additionally you can use the posts_orderby filter to alter the ORDER BY.

EDIT

You can find some additional information here.

Related Posts:

  1. How to override parent functions in child themes?
  2. Solution to render Shortcodes in Admin Editor
  3. Define page template in wp_insert_post
  4. Get a list of all available fields in the User Profile
  5. How do I use the WP image functions in a page template?
  6. How to remove Customize from admin menu bar after WP 4.3
  7. Child theme functions.php do I use php open and close tags?
  8. Modify Admin Bar Link
  9. why doesnt is_home() work in functions.php
  10. WP 4.4. responsive loads normal image after loading the responsive image
  11. Insert Ad Code in the Middle of a Post
  12. Enabling shortcodes for custom fields
  13. Passing variables to templates (alternatives to globalizing variables)
  14. Load post with a different template?
  15. Add options to featured image
  16. Programmatically Add Font-Awesome Icons to Category Widget
  17. Dynamically Register Sidebars For Each Top Level Page
  18. Two different menus for two different locations?
  19. Run Product Filter Javascript On Page Template
  20. Most efficient way to get custom database records from 20 buttons and 20 tables?
  21. How to add a column to the Trash page?
  22. Custom registration URL lost when user makes signup mistake
  23. Images uploaded using media uploader are appearing upside down
  24. Empty Date Returned on my function
  25. Woocommerce Attributes pulling in wrong data
  26. How to get the post_name when in preview?
  27. Can’t check if a post has thumbnail adding filter to get_post_metadata()
  28. How to hook into a function offered by a plugin?
  29. Echo tags used to describe the theme
  30. Change position of media in admin menu
  31. How to Display Frontend CSS for Administrator only
  32. How can I change a function in a parent theme via a child themes functions.php
  33. How can I remove the main description text box in a Woocommerce product editor page? I only use the “Product short description” text box [closed]
  34. Automatically assign video ‘poster’ value to ‘filename’ for archive listing
  35. How can I make a widget shortcode to control all the widgets?
  36. admin-ajax.php + load-scripts.php hanging for minutes
  37. Unique sequential reservation code
  38. new_excerpt_more link not working properly
  39. Where to add the permalink in this function?
  40. Show image exactly defined to a width
  41. Change CSS for logged in users
  42. Always the Latest google jQuery instead of default WordPress jQuery
  43. if statement for wordpress default featured image on single post
  44. Function to display post by specific author
  45. Override the WordPress core function wp_referer_field
  46. Is `is_sidebar_active()` deprecated, and showing error?
  47. How to return hook data when multiple parameters are present?
  48. Return category name with & Ampersand doesnt work
  49. Control the srcset much more (not all sizes in it each time)
  50. How to add_filter html template to middle of content
  51. Warning: join(): Invalid arguments passed in post-template.php
  52. javascript and css links not working on sever
  53. is_page() or is_single not working
  54. What are the meta fields for an attachment?
  55. Can’t locate custom image sizes defined by child theme
  56. How to map numbers utilizing array function
  57. how to change “posted by” words
  58. Add attribute only to first image of every post via functions.php
  59. 400 Bad Request – JavaScript App calling Custom wp-json endpoint
  60. Add loggedout class on body using a function or JS
  61. Difference between get_userdata() and get_currentuserinfo()
  62. Help with IF has focus then… statment
  63. How d0 i get the number of attachments in the post
  64. Default click “I have read and agree to the website terms and conditions”
  65. How to use wp_enqueue_script properly?
  66. Run function with schedule is not working correctly
  67. Enqueue script if not page template
  68. How do you insert code into the sidebar?
  69. Auto Resize embedded videos player
  70. Images with overlay
  71. Combine multiple menus using the filter wp_nav_menu_items
  72. Keep Admin Logged In For a Year
  73. Changing author links on homepage to buddypress profiles – without affecting ability to link to author archive throughout the site
  74. WordPress Ajaxifying not working properly
  75. Strange result of get_stylesheet_directory()
  76. Comment function for page
  77. Taxonomy On Index Page
  78. I see edit instead of read more
  79. How to add function to custom fields when page/post has a password?
  80. Zip all (original) images from media gallery
  81. How to exclude posts with empty and non-existent relational custom field with meta_query?
  82. How to replace words in my posts and saved new words
  83. Why might wptexturize have become re-enabled?
  84. List all post title in category using functions.php
  85. Quicktags external functions file
  86. Problem in shortcode outputting content
  87. Remove Captions from Custom Gallery function.php
  88. How to use different jquery function of idangero swiper dependant on page template?
  89. Optimizing multiple WP_querys into one call?
  90. Why does modifying my functions.php file always result in a server error
  91. Echo custom field value in shortcode function
  92. WordPress Comment functions
  93. wp_get_current_user->user login returns %20 for spaces
  94. Disable every rss feed except home feed
  95. If two tags in the middle i need comma
  96. reusing code in function and running it with loop
  97. Explode Array from Repeatable Custom Field
  98. Automatically delete posts that aren’t in an array
  99. Ads Only at one website inside multisite network – code error
  100. Setcookie not setting cookies anywhere except admin