query for filtering published posts?

You can add this to the WHERE clause, just after your filter by post_date:

AND post_status = "publish"

Related Posts:

  1. wp_posts table: safely remove unused columns to save database storage
  2. Order posts alphabetically: how to set order=asc in mysql query?
  3. How to get posts published between a date and today?
  4. the_author() returns empty string
  5. MySQL Query to Retrieve Category from wp_posts
  6. SQL Query for getting all posts in their latest revised state
  7. post__in for get_posts with a dynamic array
  8. How to display posts by current user/author in a custom page template?
  9. post_name empty after wp_insert_post
  10. How to force update all posts after import
  11. Query only Posts from Both of Two Category?
  12. Insert custom div between posts
  13. Only display posts with comments
  14. How to Display Post View Count
  15. Different amount of posts on homepage than paged pages
  16. Query All users that has post
  17. get posts and postmetas in assoc array
  18. Can’t publish new posts
  19. How do I batch create revisions of all posts?
  20. How would I get 1 latest post from a query for 5 posts?
  21. Can I set and show “important” post in my blog?
  22. Exclude posts with empty post_content in wp_query
  23. How do I find which articles are missing a featured image in The WordPress database?
  24. previewing my posts on static page?
  25. Reset Popular post query?
  26. Can’t get wp_insert_post to work
  27. is there a way to show the the post title after the image?
  28. Display posts with tag that matches current post title
  29. wp_insert_post – duration
  30. Category Foreach keeps looping?
  31. Blog post per page setting conflicting with custom WP_Query?
  32. How to exclude latest x posts from a paginated query?
  33. Using $wpdb to fetch posts with meta data
  34. Display an author’s posts on his own author page
  35. Creating a post from data returned from HTML form
  36. How to make multiple sections in home pulling posts category wise?
  37. Query Posts by Custom Field
  38. Remove a shortcode from all WordPress posts
  39. How to get posts from a current post’s month?
  40. Wrong post title displayed from loop
  41. While loop articles – if statement order
  42. Conditionals if tags exist?
  43. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  44. Get the amount of posts on a current page
  45. Posts – display all posts except a post by an ID
  46. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  47. update image path with words starting uppercase to lowercase chars
  48. why the same code got different results when using query_posts in functions.php and index.php
  49. Archive template combined with post slider and regular posts
  50. How to get posts published on the latest date?
  51. How to only publish posts with image in it
  52. Post Filtering by GET URL parameters
  53. WP_Query: Show 10 posts in date order, first three random
  54. Get post by tag
  55. Random posts that always include a particular post?
  56. Need to change all links in page content but not in post content
  57. Can’t update WordPress Page if post_content is Empty
  58. Bootsrap carousel for post
  59. How to select particular month post from table and update the post status using MySQL?
  60. Retrieving posts by their date and category
  61. Echo the number of posts being displayed
  62. Exclude a category of posts in author template
  63. WordPress displays post on subcategory only
  64. Trying to query all posts in category 4
  65. Get posts from current category?
  66. get last post’s link with SQL query
  67. Change content off every sixth element
  68. How to save template data into wp_post table (post_content column)
  69. WP query taxonomy optimization
  70. get posts, run a custom query, and join the results
  71. Show posts from two specific category in WP_Query
  72. How to create loop of posts except post ID defined via ACF field
  73. Displaying all posts from other sites on the network on one site
  74. Multisite how to display merged posts from two sites and sort by latest date?
  75. How to show post views shortcode data for each post on Posts List Page?
  76. WordPress MySQL Search and replace with wildcard?
  77. How to display particular categorie’s post which associated to specific user?
  78. Add postmeta to all blog posts
  79. wp_insert_post not inserting post
  80. Dev and prod on the same database- dev version active for IOS
  81. Manipulate query to show specific post
  82. How to correctly escape data
  83. Blog posts not displaying on blog posts page
  84. Sort Events by Venue Title – Sort Post set by related post ids
  85. Get posts by category or author
  86. Sort / Filter Queries
  87. get “read more” with custom DB query like you would with WP Query
  88. Save/retrieve form data best practises for theme development
  89. How do I control the fallback query after the original query returned cero posts?
  90. SQL query to remove first image in all posts
  91. How to pass multiple checkbox values to wordpress query?
  92. Delete junk text from all the post using my sql command
  93. How to get all post titles starting with numbers and symbols?
  94. How to inject a post within a loop
  95. How to get alphabetic listing x other posts, based on first letter post?
  96. How to create a post based on data in a table?
  97. wp trim function not working
  98. Change from all posts to specific categories post on main page?
  99. query_posts different amount of posts per page [duplicate]
  100. Do I need to create a multisite for querying posts from multiple WordPress sites?