How do I extract the contents of a CPT’s custom field for all posts?

I managed to achieve what I wanted by piping wp-cli with xargs and grep, like this:

wp post list --post_type=CPTNAME --field=ID | xargs -n 1 wp post meta list --format=csv | grep -E "^[[:digit:]]*,(CUSTOMFIELD1|CUSTOMFIELD2|...|CUSTOMFIELDN)" >> file.csv

This is, however, extremely slow, taking more than 30 minutes for 10 thousand CPTs.

I think a direct SQL query would be much, much more efficient.

Related Posts:

  1. what is the correct way to compare dates in a WP query_posts meta_query
  2. Advanced search form with filters for custom taxonomies and custom fields
  3. Custom field values deleted when trashing custom post type
  4. How to get all custom fields of any post type
  5. Admin Area Custom Type Search By Meta Fields Without Title & Content
  6. How do I Paginate Search Results for Custom Post Types?
  7. How Can I save multiple records in same meta key?
  8. Detect meta value changes when post is updated (post_updated)
  9. Search everything (posts, pages, tags, cpt, meta)
  10. How to get source of custom meta image?
  11. Displaying Meta Box Image
  12. ACF Upload Image in repeater from front-end with custom form? – add_post_meta()
  13. Formatting custom meta box date from YYYY/MM/DD to a more readable alternative
  14. Create a random unique 6 digit number as custom field for custom post type
  15. how to interconnect custom post types?
  16. List all images from a single post meta value
  17. Populate Custom Fields in a Custom Post Type?
  18. Meta Key Value in current-user-only loop
  19. How to check if user meta field is empty in conditional else statement
  20. How to implement a Google map store locator
  21. Posting to a Custom Post Type from front end – user generated content
  22. Update Post Meta for a logged in user
  23. A better way to add a meta box to custom post types
  24. Two Custom Post Types Many to Many Relationship
  25. get_post_meta not working on publishing
  26. How do I set all of a particular post meta to a value within the custom post type I’m in?
  27. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  28. Importing Data from a Non-WordPress database, into WP
  29. Custom fields for custom post type
  30. Check if post with same meta value exists
  31. Submitting Custom Post Types with custom fields from Front-end form
  32. create custom meta box with default value
  33. delete_post_meta() for whole CPT / multiple posts?
  34. How to get specific post meta by title or id
  35. copy images from custom field to another custom field
  36. How to show custom field on specific custom post type posts only when filled
  37. Cannot obtain custom meta information
  38. How can I output WPAlchemy repeating fields meta values in my page template?
  39. How to call a post’s metadata in shortcode.php?
  40. delete duplicate meta_value with same post_id
  41. Search CPT Title AND Meta
  42. updating one custom meta field only
  43. Add a class to post_class if more than one post shares same meta_value_num
  44. Add a meta field to the list of results for a custom post type
  45. Empty meta-box returns publishdate if no value is set?
  46. Filter search posts by post meta?
  47. Custom fields for post or terms which don’t update on post update
  48. Custom Post Type meta data getting deleted on bulk editing taxonomies
  49. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  50. How to keep custom post type related information
  51. How can I add a meta[] to my custom post type and search by term with the Rest API?
  52. Show posts from WP Custom Post Type selected from a field in a metabox
  53. Creating an archive page or simple template to list all values of a custom field of specific post type listing
  54. Where is get_post_meta value located?
  55. Custom meta fields not showing up in WP_Response Object via custom endpoint
  56. How to Disable option of meta field if that option is selected for any other post in custom post type?
  57. Add more custom fields when creating a new custom post type
  58. Delete custom post type metadata without deleting the post in admin area
  59. How can I get the $key / $value pairs of custom fields that were added via 3rd party plugins or themes?
  60. How to add post reference field to a plugin?
  61. Advanced search form with filters for custom taxonomies and custom fields
  62. Querying meta values within an array
  63. Display a list of posts whose meta field values are equal to the ID of the post being viewed?
  64. Check for custom field value in different post type than current one and do something
  65. How do I set the default admin sort order for a custom post type to a custom column?
  66. Development of a WordPress Search Plugin – Best Practices
  67. How can I filter posts by post_parent in the admin?
  68. WP_Query orderby custom field then post_date in one query
  69. Using Custom Fields in Custom Post Type URL
  70. Adding meta values to permalink
  71. How to create a mini directory in WordPress?
  72. front end radio custom taxonomy with custom post type
  73. Can’t sort order of wp_query with 2 meta keys
  74. WordPress Create Post from front-end
  75. add custom field to custom post type
  76. Can we create a custom post template for a specific page template
  77. Settings API – save multiple tabs at once
  78. How to create multiple editor?
  79. Targeting categories in custom fields
  80. How to make a pulldown menu display custom meta terms in a theme?
  81. Meta box with front-end styling
  82. Display custom post front end filter by ACF equals current user
  83. Custom fields array to display it monthly
  84. Copy data from 2 different ACF custom post types with relation
  85. Orderby if between two meta fields
  86. How can I use a custom template to load custom post type posts based on a post_meta value
  87. How do I query with multiple custom fields orderby in same column?
  88. filter using custom fields
  89. Displaying Custom Fields from Custom Post Types [closed]
  90. CPT – Custom Text fields point to new url permalinks
  91. Custom Fields with add_post_meta()
  92. Fixed custom fields depending on posttype/category
  93. WordPress loop, show only one post per custom field
  94. Custom Post Type as invoice or order template
  95. Make each Value of custom field show related posts when clicked
  96. Filter CPT based on meta box value using Flexible Posts widget?
  97. why get_post_meta is returning 0?
  98. Filter Custom post type by another Custom post type
  99. Save post_parent in a custom post type
  100. Retrieve a post with its ACF repeater fields in wordpress
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedusedusedusedueduseduseduedus