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. Keep featured content post in homepage with original order
  4. How to show related posts by category
  5. Display all posts from specific categories on a page
  6. How to exclude latest x posts from a paginated query?
  7. Search & Remove Specific Shortcode From All Posts
  8. Display content from a specific category
  9. Using $wpdb to query posts with meta value containing current post_id
  10. WP_Query to work with custom view
  11. Number of posts per page setting is not working?
  12. WordPress Posts Out Of Order after 3.1 Update
  13. Order post by year DESC and month ASC
  14. WordPress get posts by date without query_posts
  15. Replace Main Query With Custom Query
  16. Featured Posts for Category Pages
  17. Cannot Update A Post, 404 Error
  18. Function to show random posts from a category
  19. Hiding posts in a list from specified categories
  20. Manually removing revision post types
  21. Improving WP_Query for performance when random posts are ordered
  22. Create dropdown list post
  23. I would like to give special promotion for the first 100 posts in my blog? Can anyone tell me how to do that?
  24. Tags to Post-ID mysql query. Tag Search
  25. Inserting custom data to the_post() during loop
  26. How To Get Posts With A Specific Word
  27. Why WP_Query(‘showposts=5’) shows only 1 post?
  28. Display all posts that were published before full post on single.php
  29. Two loops, one AJAX loop, exclude posts in first loop from second loop, loops are in different files
  30. Get user categories with most posts in it
  31. Random ajax load only works with posts_per_page set to -1
  32. MySql query to get posts with all meta and terms
  33. Custom order for Mysql array
  34. posts_per_page option limits the number of Gallery items
  35. List authors with the last post title and order by last post date
  36. How to Mysql select a list of posts with meta_values AND all relevant categories?
  37. What do these phpMyAdmin errors mean on my WordPress databaes?
  38. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  39. Nested WP_Query breaking loop
  40. WordPress query_posts by tag doesn’t work anymore(?)
  41. do more action after I publish a post
  42. Retrieve only posts from a specific user in wp-admin/edit.php
  43. Why Query is returning empty array?
  44. meta_value timestamp older than now
  45. $wpdb returns duplicate posts
  46. Displaying post excerpt using wpdb query
  47. Display Posts with template on a Page
  48. Query for first 3 posts to change the look and feel
  49. Shortcode with ‘year’ parameter
  50. On what hook can I get the queried object’s final state?
  51. How to give classname to post if post has no content?
  52. How to use mysql LIKE with wpdb?
  53. Get the most recently modified post date of most recently modified post
  54. Queries take 120+ seconds on my large WordPress site
  55. Database hacked – random posts are modified
  56. WordPress post filter menu
  57. Restore woocommerce orders
  58. How do post IDs work in WordPress?
  59. WordPress query portfolio posts
  60. How to get posts ordered by using their categories?
  61. WP_Query articles order by offset in collumns
  62. Display 3 posts with different HTML markup using a loop
  63. Getting posts from some categories plus some individual posts
  64. How to assign a post to a post parrent?
  65. get parent fields title, content excerpt etc
  66. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  67. AWS usage queries
  68. Move position in post list for a custom checkbox column
  69. How to merge the content of posts that have the same title?
  70. Query to fetch custom taxonomy along with post title
  71. How to fetch courses in all languages in WordPress?
  72. Mysql update menu_order problem
  73. Bulk find & replace on WordPress posts/pages (minus image paths)
  74. How can I use query_posts to loop through posts and construct my own content?
  75. ‘posts’ table should not store the absolute image path
  76. Assign a day of the week to post, e.g: Assign Monday to post and have it only appear when the day is Monday
  77. load post data into mysql
  78. Show 5 posts and than 3 posts offset with pagination
  79. wp_query args with relation
  80. Querying posts from current category, using a variable as array argument
  81. Use special template for the first post in the loop
  82. Need help writing loop to display posts by categories in separate divs
  83. Modify WordPress loop after it has been run
  84. Query post category & remove any post id
  85. show latest authors blog post
  86. Converting Posts to Pages
  87. How to get only current images of a post
  88. Ordering posts alphabetically by meta keys and title
  89. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  90. How to change the publishing date of each posts?
  91. Remove duplicated posts in the loop if post has more than one category
  92. How to limit the number of results for all query_posts on mysite
  93. wp_query select if have comments
  94. How to limit post query to only return a total count of items with certain post statuses?
  95. Not displaying any articles on a custom made file
  96. If meta_key exists then don’t select this post?
  97. Sort Posts Alphabetically Based on Specific Category (Divi)
  98. WP_Query post_tilte search in posts table
  99. How to manually delete post from database without causing conflicts?
  100. Why does ‘get_the_ID’ work outside of the loop?