Convert a WP Query into a simpler SQL query to fetch only COUNT of posts

You can also try below code to retrieve count of rows.

$myquery = $wpdb->get_results( "SELECT * FROM  tablename WHERE ID='some-value'" );
echo  $wpdb->num_rows;

Let me know if you have any problem.

cheers

Related Posts:

  1. Pagination with custom SQL query
  2. How to make an activities stream mixing posts and comments?
  3. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  4. Select from wp_post and multiple meta_value from wp_postmeta
  5. How to correctly pass values to wpdb->prepare()?
  6. $wpdb select date range of posts
  7. How to pass orderby params to $wpdb->prepare()?
  8. Make a SQL query with wpdb in WordPress
  9. List of ways to access WordPress database?
  10. Passing a SQL query to the WP Query
  11. Any way to use FETCH_KEY_PAIR with $wpdb?
  12. What argument does my function need to echo get_results() query results
  13. Include post_status check within $wpdb query
  14. wpdb LIKE request shows all database data
  15. WP_Query with “post_title LIKE ‘something%'”?
  16. How to print the excuted sql right after its execution
  17. Return only Count from a wp_query request?
  18. Whats the difference between post_limits and pre_get_posts?
  19. Using OR conditions in meta_query for query_posts argument
  20. how does $wpdb differ to WP_Query?
  21. Is it possible to wrap Geo Location search around WP_Query?
  22. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  23. Is it possible to select against a post’s parent’s fields with WP_Query?
  24. Query causing load because of SQL_CALC_FOUND_ROWS post counting?
  25. Extending WP_Query — Optimise SQL query
  26. Use WP_Query with a custom SQL query
  27. How to filter sql only for a specific post type
  28. SQL Statement generated by WP_Query not producing expected results
  29. What is an efficient way to query based on post_meta?
  30. How can I connect to another WP database and use WP_Query?
  31. SQL query equivalent to WP User Query
  32. Recommended way to drop a pending query (in pre_get_posts)?
  33. how to retrieve specific product attribute value in an sql query?
  34. Get number of comments after modifying comment query
  35. How to change a custom query into a standard loop?
  36. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  37. Should close $wpdb via $wpdb->close()
  38. Filter WordPress posts by between parameter
  39. SQL User Query by Multiple Roles using PHP
  40. Advanced WP Query hogs the SQL server
  41. SELECT * FROM $wpdb->posts WHERE ID > 160
  42. $wpdb->insert inserting two rows in database
  43. Get the Plugin Which Triggered a MySql Query in WordPress?
  44. Detect featured image among the attached images
  45. Query post with meta_query where date is not in future
  46. How would I format a query that depends on post parent taxonomy
  47. Mysql query LIKE not working
  48. WP User Query get all authors with last name starting with specific letter
  49. Order by custom table and multiplication
  50. Sort users by “birthday” using WP_User_Query
  51. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  52. WPDB query – decrypting DB data
  53. How To Fix WP Query Returns Results But Shouldn’t?
  54. List of the years with posts presented
  55. How to delete taxonomy term when a wordpress user is removed?
  56. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  57. Slow WP_Query for custom post type
  58. Complex WP SQL Query
  59. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  60. Optional Meta Query
  61. Custom Query num_rows returns wrong amount
  62. Sorting events by descending date, and ascending time if multiple events on a date
  63. Getting post revision and printing them on the post content site
  64. Editing the default wordpress search
  65. Filtering posts from different categories into different section by doing WP_Query only once
  66. Iterating through $wpdb query without using get_results for large query results
  67. WP Query related posts by tags
  68. Order by summing multiple values
  69. How to extract specific post
  70. Woocommerce – Changing the order of the upsell products [closed]
  71. Query with search and subscribers only output
  72. Changing sort order for presentation by Jetpack infinite scroll
  73. wp_Qwery works to slow
  74. Include data from custom table in WP_Query
  75. How to query custom post types with mixed AND & OR statements for custom fields
  76. wordpress ajax relationship query
  77. Query most popular terms by taxonomy over 2 week period
  78. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  79. Custom query: Get all posts that are from a certain category?
  80. How to access custom WordPress database tables
  81. Ajax future single post query doesn’t work when NOT logged in
  82. Conditional sorting with variable using WP Query
  83. Is it safe to access the underlying mysqli object from \wpdb for custom queries?
  84. Debugging wp_query orderby for taxonomy
  85. Is it possible to query from external database? [duplicate]
  86. Include post content of linked posts in search
  87. Getting additional columns from sql
  88. WordPress query posts with multiple post_meta data
  89. Specify strict ‘order by’ in WordPress query
  90. Getting rid of unwanted nonSQL syntax characters when debugging a query
  91. How I can change the condition or compare operator for WP_Query in pre_get_posts
  92. Does WordPress have something like Drupal’s DB API?
  93. get_post() is not returning correct value
  94. Query where ANDing slug values not working
  95. Slow Query On Search
  96. WP_Query: apply an SQL function to meta fileld value
  97. How to avoid filling up an array each time I run a WP_query?
  98. How to SQL query posts IDs by categories AND authors?
  99. Randomly select one of last 3 posts
  100. WordPress SQL JOIN query