How to return count of custom post type posts with a specific custom field value via $wpdb?

While custom SQL is sometimes what it takes, note that to address your concern for WP_Query it supports 'fields' => 'ids' argument to limit data returned to IDs (which can be easily used for count).

In many cases that is reasonably efficient while more robust and future-proof in WP environment.

Related Posts:

  1. Multipart/formatted MySQL query problem
  2. wpdb COALESCE won’t work
  3. Get posts from category with custom query
  4. Valid SQL query return empty
  5. mysql query – how to escape apostrophe?
  6. Updating with $qpdb->query() always returns 0 rows affected
  7. WordPress Mysql query and Duplicate
  8. Help with Related Posts Function
  9. Mysql query and odd results
  10. simple sql query on wp_postmeta very slow
  11. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  12. How many WordPress SQL Queries per page?
  13. Custom $wpdb Query for Custom Post Type by Category
  14. Can’t pass table to $wpdb->prepare
  15. $wpdb->get_var not returning a result
  16. Are database queries created using WordPress filters protected from SQL injection?
  17. Most effective use of DB querys
  18. Grouping related postmeta data via SQL query
  19. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  20. Slow meta_query with about 4 milion record on wp_postmeta
  21. wpdb::prepare() isn’t working
  22. Select User by Joining Multiple Meta Value Results
  23. mySQL query. ORDER BY meta_key
  24. $wpdb doesn’t appear to work on page inside of a plugin
  25. Using $wpdb->update but confused on the WHERE in and SET
  26. My SQL function to change user_name
  27. You have an error in your SQL syntax – Help with query
  28. What’s wrong with my $wpdb prepare?
  29. Make one query for adding entries to database
  30. Why is variable not working on custom sql query using wpdb?
  31. MySQL variable in query
  32. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  33. Advanced SELECT query with condtional statements
  34. how would I create a custom query to get all users, and a related post based on a postmeta field?
  35. Help with MySQL to $WPDB query
  36. How do I see the mysql query generated by get_posts( $args )?
  37. Alter query with posts_clauses to retrieve NULL values last
  38. wpdb->term_taxonomy count posts from both published and private posts?
  39. wpdb print all post meta
  40. Plugin will sort users by usermeta
  41. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  42. MySql Query very slow
  43. Searching With Apostrophe
  44. wpdb query problem to access previous 3 days posts
  45. WordPress Query wp-terms SLOW
  46. How to write: $wpdb->update having WHERE NOT value pair in the array
  47. I can’t figure out what’s wrong with this statement. $wpdb->query update
  48. Use mysql_query instead of $wpdb query
  49. Custom Query – Based on user input
  50. Custom WordPress Table wpdb
  51. Best practice to limit results in get_row()?
  52. Placing a widget with $wpdb query
  53. Custom Query returns array, but I can’t see it’s elements
  54. how to insert missing tags into the posts through mySQL?
  55. Ideas how to search & replace post_content when string contains a newline?
  56. Query Column of Specific ID from Database Table
  57. Query the WordPress database to get data together with replaced information
  58. $wpdb->prepare affecting the query?
  59. Optimize slow SQL query for multiple meta values
  60. prepare function sql safe method
  61. WordPress Insert not working with ajax
  62. How do I query for posts by custom meta and those that have been stickied?
  63. wpdb update multiple row?
  64. Formatting a date/time returned from a custom $wpdb query
  65. Improve performance of slow query
  66. How to delete all images from code in all post_content
  67. How do I get specific readable results from this query and array results
  68. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  69. Delete oldest wordpress post (SQL query)
  70. Displaying data from custom table
  71. Get 2 meta values from meta key column
  72. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  73. SQL query to delete users with multiple meta keys and comments
  74. WordPress Database Query works in phpMyAdmin but not in the code
  75. OR condition not working
  76. Trouble migrating custom post types from non-wordpress cms
  77. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  78. Exclude Posts from a Widget
  79. Fastest and most efficient SQL query to check if UID exists
  80. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  81. How to make MySQL search queries with quotes
  82. Use $wpdb->get_results with filter based on array
  83. $wpdb query for price in custom field value
  84. Display result from custom post meta query
  85. Wpdb empty result only if language is Russian
  86. Run an update query in a function
  87. How to fix this insert? Don’t work for me!
  88. Function returning queried meta value based on current post ID
  89. Update vs Insert logic but the last key is always inserted?
  90. Custom MySQL Query for Post and Post Meta
  91. There is way to improve this query? wordpress get post data and some meta data
  92. Wpdb generates too many queries
  93. Custom Query for searching through custom fields
  94. sql for querying post and their category
  95. Access Tables with number prefix
  96. How to reference same column name but different table in custom db query
  97. Retrieving custom field array value through db query
  98. How to get one result using wpdb class?
  99. Delete query won’t run
  100. update $wpdb one query