How do I modify this wpdb query to include posts that have a post_status of publish and draft?

You can use AND and OR statements in MySQL. Try this:

$count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts $where AND (post_status="publish" OR post_status="draft")" );

Related Posts:

  1. How to Modify this $wpdb query to accept an array of post statuses
  2. $wpdb->get_row() only returns a single row?
  3. How to parse row results from $wpdb -> get_results
  4. what is the way to see the currently executing query in wordpress?
  5. Fetch array with $wpdb
  6. $wpdb->last_error doesn’t show the query on error
  7. Theoretical Multi-Server WordPress Setup with Shared Users
  8. Delete/replace img tags in post content for auto published posts [closed]
  9. Speed optimization of $wpdb->get_results
  10. What does wp_update_post() do that the $wpdb class does not?
  11. $wpdb is get_results escaped
  12. wpdb-> not adding prefix to custom table
  13. WordPress insert NOW() in TIMESTAMP column returns all zeros
  14. $wpdb prepare issue with mysql DATE_FORMAT
  15. How-To: wpdb Insert Record With Date
  16. How to pass NULL in where array for $wpdb->update
  17. Get random row from custom table
  18. store custom WP table names in a global variable
  19. wpdb prepare: passing varible number of fields as second argument
  20. I am not understandinhg $wpdb->prepare correctly
  21. How to save html and text in the database?
  22. XOR functionality for meta_query
  23. Using WPDB class
  24. WPDB Update using Conditional Arrays
  25. How can I migrate mysql_fetch_array to $wbpdb?
  26. What is _transient_random_seed for?
  27. wpdb get_results() and prepare when to use prepare?
  28. Foreach loop using $wpdb not results from rows
  29. Return XML of Post Metadata
  30. How to Instantiate wpdb Object in New File
  31. How do you build a wpdb query dynamically?
  32. What’s the proper way to add users to my site in order to test things?
  33. External DB Connection [closed]
  34. Problem in inserting row to custom database table
  35. sanitize_text_field and apostrophe problem
  36. Codex: Database Description: meaning of Cardinality
  37. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  38. Code only works every other time its run
  39. wpdb updating record in wordpress with json adds extra array elements
  40. How to display a specific category using a custom Query?
  41. Can’t pass variable in wordpress wpdb->get_results
  42. AWS Bitnami WordPress – SELECT command denied to user
  43. WPDB Placeholders and second argument for prepared statements
  44. PHP Fatal Error – $wpdb a non-object?
  45. WordPress db prepare
  46. How do I count columns on a custom WPDB query?
  47. how to get db values without using an loop with wpdb->get_results()
  48. Custom SQL query ORDER BY term_order
  49. Trouble inserting string containing quotations marks with wpdb in save_post hook
  50. How to run wp_insert_post() & wpdb on the background?
  51. $wpdb->prepare was called incorrectly when inserting multiple records
  52. How to protect a script execution on WordPress?
  53. how to connect to another database in wordpress
  54. $wpdb->insert() doesnt work anymore
  55. wpdb query not working
  56. Where can I see MySQL hostname and port for wp-config.php
  57. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  58. Perform a function when a user clicks register button
  59. $wpdb->get_results not returning an array
  60. WPDB Query Question with Category Only
  61. wpdb result arrray inside an array
  62. $wpdb->num_rows doesn’t work
  63. $wpdb->get_var next var?
  64. How can I change my meta_query to SQL wpdb query?
  65. How capturate wpdb exceptions?
  66. how to list all post that are in the custom taxonomy using $wpdb
  67. Limit left join
  68. “This message was added in version X” showing a later version than current one
  69. Get records from Formidable Table using $wpdb->get_col
  70. Prepare WPDB with meta key and meta value
  71. How to get row value from wpdb
  72. I am using wpdb but it not working perfectly.but if I dont use form data its work
  73. Escaping a WPDB Object in One Shot
  74. wont add form details to database or send me mail
  75. Missing argument 2 for wpdb::prepare() [duplicate]
  76. wpdb->update update the entire table instead of one row
  77. WPDP related functions look to work but they don’t
  78. Save customizer default values to DB on theme activation
  79. Plugin with connection to database – Single function
  80. Alter the main search query to search posts by coauthor user name
  81. Update all fields of table with ON DUPLICATE KEY UPDATE command
  82. WordPress – wpdb query does not list same result as sql query
  83. Protect custom form from SQL injection
  84. why nl2br() is adding an extra ?
  85. What is the best practice to initialise $wpdb by loading wp-load.php?
  86. $wpdb->get_results in not an array
  87. How to add more custom fields in user meta table simultaneously
  88. wpdb->update error
  89. get unserialized array without using get_option()
  90. Custom Query for searching through custom fields
  91. SQL Query to select post title & post ID from a particular category
  92. Create Table Failed Column Date DateType
  93. Using $wpdb to update current post
  94. Checking if meta_value exists for any user
  95. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  96. DBDelta: “table doesn’t exist” for a table that was just created
  97. query using wpdb in wordpress gets me no result
  98. query_vars doesn’t return query string (trying to get data from $wpdb)
  99. Table wont load into WPDB
  100. $wpdb->prepare UPDATE process not work in functions.php