Sum custom field values of particular taxonomy

You would have to JOIN a couple of tables.

SELECT meta_value FROM wp_postmeta as pm
INNER JOIN wp_term_relationships as tr ON (pm.post_id = tr.object_id) 
INNER JOIN wp_term_taxonomy as tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) 
WHERE 1
AND tt.taxonomy = 'laptop'
AND pm.meta_key = 'quantity'

I am fairly sure that is right. These things are complicated.

If your meta_value is a number– that is, no punctuation or other spaces– you should be able to use SUM(meta_value) and avoid the array_sum after the fact.

Related Posts:

  1. Custom field values to taxonomy terms
  2. Woocommerce Custom Meta Boxes- How to only display if they actually have content
  3. ACF – Can’t get custom post type by taxonomy
  4. I want to show image from custom field image on my custom page template
  5. How do I organize posts based on their taxonomy?
  6. Most efficient way to add javascript file to specific post and/or pages?
  7. Display all values of custom a field created with ACF on a page
  8. How to automatically apply woocommerce product title to all product images alt tags?
  9. If Custom Field is empty don’t display div
  10. How to make an meta_query optional?
  11. WP_Query | Help me create a search term with an ‘OR’ relation?
  12. Add custom field to attachments in a specific category
  13. How can update custom meta for all posts
  14. get_post_custom single array
  15. WP_Query use for a filter with multiple Taxonomies and Terms
  16. Make custom field meta not display if there is not data in it
  17. Display Post co-authored in Author Page
  18. how to increase custom post value by one most efficiently?
  19. get_the_terms – only top level
  20. Get Custom URL For Custom Taxonomy
  21. How can I create a list of page titles from custom meta values?
  22. Custom profile field with birthday. Troubles with
  23. Why my filterable portfolio page work not perfectly between slug button and slug output WORDRPESS?
  24. wordpress allow user to edit user profile with custom fields
  25. Store multiple custom field as post meta per post(css, js, html, 2 link) [closed]
  26. Grab posts by multiple categories
  27. How to VAR_DUMP a $variable during checkout process (Is my product meta callable?)
  28. How to use thumbnail size of image if I’m only using src to get image
  29. 3 Slashes appear after Apostrophe in custom fields after updating product-site
  30. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  31. Trying to retrieve post meta
  32. Pull Tags But Not as Links
  33. How to combine 2 php functions into one function with a custom field
  34. Advanced Custom Fields – display label and value only if value entered
  35. Is it possible to retrieve all posts with a certain value for metadata?
  36. Saving zero in meta box
  37. Why does this update_post_meta function not delete the custom field itself?
  38. Ajax filter button display all posts
  39. Hierarchical taxonomy list with modificated term links
  40. WordPress loop by meta key that is an array? and how loop multiple arrays
  41. if custom field doesn’t exist, use post thumbnail instead, as image background
  42. Exclude product attributes from taxonomy terms loop
  43. WP All Import / Update stock quantity from multiple XML files
  44. How to store multiple custom meta box
  45. How to insert wp_users ->user login name to wp_terms when a new user registering?
  46. Concatenate Custom Field Value & HTML Value
  47. `update_post_meta` not working anymore
  48. Storing content into a custom taxonomy
  49. Define category ID using get_post_meta
  50. Check in which custom taxonomy belongs and change the style
  51. Hide a div when a custom field is empty
  52. Adding custom url to readmore link using get_permalink()
  53. Filter unique custom field value based on custom taxonomy category or other custom field
  54. Display movies that apear this day next
  55. Add “alt” Attribute to GD Star Rating Tags
  56. How to break up php code to avoid echo
  57. Display background color or image with custom meta box?
  58. custom header text
  59. Can ‘Custom Field’ data be inserted into this Short Code?
  60. Query pulling a single post per month
  61. Add custom fields from different posts
  62. Hi need update in my terms for other taxonomy
  63. WordPress: Export/Import Yoast meta title & description to custom taxonomy
  64. Delete images from media library when user deletes an image from ACF Gallery
  65. Adding a custom meta field with default NULL value which is not selectable
  66. Order category posts by last word of custom field
  67. Display acf taxonomy attachment
  68. Get taxonomy terms that share a common object property
  69. Products listing check if meta checkbox is checked
  70. How to update custom fields when post is published?
  71. Block error message in foreach loop when looping through ACF field
  72. Hide a div if the fiels is empty
  73. Inserting a class on before_widget if checkbox is checked
  74. Categories does not show Block editor WordPress
  75. What is the correct way to search 3 custom fields only in WordPress?
  76. wp_get_nav_menu_items() with ACF
  77. Filtering custom posts by using checkboxes for taxonomy in an ajax loop always gives server 500 error
  78. How do I get the value of a current user’s custom field?
  79. How to separate the taxonomies list from the form so that editing taxonmies is the same as pages and posts?
  80. Add Custom Taxonomy into Script
  81. How to display custom field from a gallery thumbnail?
  82. Getting a value from a custom field from a page that shares a parent with the current page
  83. Custom fields changes the formatting of metabox input
  84. Display Content Based on Custom Field Value
  85. enumerating custom taxonomies?
  86. If custom field doesn’t exist, or exists and it’s true show title?
  87. Custom field in title
  88. How can I put a custom field as the link of a button shortcode?
  89. Outputting a custom field in PHP
  90. Custom fields randomly stop working
  91. Where can I find the code for the menu page meta boxes?
  92. Query specific posts per user selections from dropdown menus
  93. How to echo a different field if another field is empty?
  94. PHP Puzzle: Unique Styles with PHP loop
  95. I want Page titles and excerpts to show up on home.php in certain order
  96. Metadata on the WP_Post object
  97. Appending an ACF custom field to the page title
  98. How do I change the Go To Categories link in the term_updated_messages
  99. Convert custom field date format to “WordPress default”
  100. How to execute a shortcode within a custom field?