List all unique custom field values?

From what I understand I think you can try something like:

SELECT meta_value, COUNT(post_id) as count FROM $wpdb->postmeta WHERE meta_key = 'authors' GROUP BY meta_value HAVING count >= 20 ORDER BY meta_value;

Let me know if this works for you!

Related Posts:

  1. How to add a custom field in the advanced menu properties?
  2. Sortable Custom Columns in User Panel (users.php)?
  3. Importing data for advanced custom fields plugin?
  4. Gutenberg add a custom metabox to default blocks
  5. How to rename a custom field?
  6. Filter post listing by meta value which is a date
  7. Extra profile field as select box?
  8. Matching Serialized Arrays with meta_query
  9. Adding Custom Field to Taxonomy Input :Panel
  10. How to activate “custom fields” section in WP3
  11. How to filter or search the posts using postmeta tables custom meta fields with wordpress REST API
  12. Add meta data to the menu
  13. Custom bulk action for media gallery items
  14. Copy SEO Meta Desc “Custom Field” to Excerpt field?
  15. Custom fields won’t display on my blog page
  16. How to customize default wordpress editor?
  17. Order Custom post type loop by custom field (datepicker)
  18. Localized Date Format for Custom Field
  19. Add an advert every nth Paragraph
  20. Check if the value of a field has changed on save_post
  21. How to edit multiple post with Custom fields
  22. Undefined index error when saving content on metabox
  23. Saving custom image meta fields
  24. How to update custom user meta field in wp?
  25. Complex WP_User_Query call fails on production server
  26. Query post order by post and desc not working
  27. If category then echo a custom fields
  28. How can I show custom fields in the loop only to specific user roles?
  29. Add conditional custom option to ‘Display name publicly as’ dropdown
  30. Custom fields not getting saved in the databse when added to the add new user profile page
  31. Show 1 post and after a specific date show the next one
  32. How to Create Dynamic Fields in a Meta Box?
  33. How to show Small Box Inside Content Area, which holds (text, images, links)?
  34. Sort custom field by post
  35. How to order posts by one custom field and filter them by another one?
  36. Can we create a WordPress read-only virtual field derived from three other fields?
  37. How to create a gallery custom field for WordPress post?
  38. How to display image inside container of custom made widget
  39. Can I create a template or doctype for my blog site?
  40. List users by sum of all their posts’ custom field values
  41. Custom Metabox additional item
  42. How to combine custom fields to make one order-able value
  43. Duplicate (or more) custom fields on many posts. Is there an easy way to clean them up?
  44. How to add new field to the account address?
  45. Split the_title
  46. Sort WP_Query with numeric custom field
  47. Display Multiple Values of Same Key
  48. How to Wrote Simple Calculations by Using Custom Fields in Loop?
  49. Custom Query based on custom field of a single post
  50. Iterate through users and display users meta info at front-page
  51. How to remove custom fields from the selector?
  52. What is the proper way to add a required field to a post type? [duplicate]
  53. Adding custom field and querying from post table
  54. How can I combine this php statement to get the results of multiple variable inputs?
  55. Access ACF fields within custom preview function?
  56. Looping inside block return
  57. Scripts and tags will not save or output from my custom meta box
  58. Sortable Custom Columns not sorting correct
  59. Using WP Color Picker in Repeatable Fields
  60. Running wp_postmeta update query does not show the custom fields data in admin section
  61. How do I save Multiple fields in a meta box?
  62. How to load script conditionally on custom field in wp_postmeta?
  63. Can I access Posts of custom-fields via URL?
  64. Output custom field value
  65. Custom field image to Featured Image
  66. Best way to achieve multiple links in a post title
  67. Show array of meta_value in Edit Post Coloum
  68. plugin-list-category-post custom fields
  69. How to display data from custom fields I created?
  70. Get array of posts based on custom field values
  71. Working with multiple values and metaboxes
  72. Unable to select image with custom field
  73. How to automatically change a posts status to draft based on custom field
  74. How to show ACF fields in Gridbuilder custom block
  75. WordPress Rest API custom field not updating till i manually update the post
  76. search based on custom field
  77. Why isn’t update_post_meta saving?
  78. Custom fields multiple commas separated values
  79. Display taxonomy loop using custom field data
  80. Adding more fields to the registration form
  81. Add custom field information to source meta data
  82. use mysql to replace one custom field value with another custom field value
  83. Change blog post title on main blog page
  84. Spit out list of distinct instances of custom field?
  85. Delete custom meta
  86. Filter and display a specific custom field value [closed]
  87. Is it possible in WordPress
  88. Related post thumbnail not showing up
  89. Edit different parts of a page seperately
  90. Get multiple posts with some custom fields efficient
  91. I want my post to republish again after adding a custom field
  92. Custom fields: dropdown values depending on other custom field value
  93. Custom fields / meta box output
  94. Creating an If/Else statement using WPAlchemy MetaBox radio boxs
  95. How to retrive Custom Fields as Values for a Form field
  96. Get single image from custom fields made with WCK custom fields creator
  97. Media Custom Fields – get a value with PHP
  98. How to add google map to custom field
  99. jaredatch metaboxes on video post formats
  100. Truncating characters in Advanced Custom Fields works some places but not others?
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduedusedueduseduseduseduedusedu