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. WordPress Post Query Using Custom native MySQL like St_Distance_Sphere
  4. Keep featured content post in homepage with original order
  5. How to get posts published between a date and today?
  6. How to show related posts by category
  7. the_author() returns empty string
  8. MySQL Query to Retrieve Category from wp_posts
  9. Display all posts from specific categories on a page
  10. SQL Query for getting all posts in their latest revised state
  11. How to exclude latest x posts from a paginated query?
  12. post__in for get_posts with a dynamic array
  13. Search & Remove Specific Shortcode From All Posts
  14. Display content from a specific category
  15. Manually delete post from database
  16. How to display posts by current user/author in a custom page template?
  17. Using $wpdb to query posts with meta value containing current post_id
  18. post_name empty after wp_insert_post
  19. Query posts distinct authors
  20. WP_Query to work with custom view
  21. How to get previous 10 days post from a specific date – WP Query
  22. Number of posts per page setting is not working?
  23. WordPress Posts Out Of Order after 3.1 Update
  24. How to force update all posts after import
  25. Query only Posts from Both of Two Category?
  26. Insert custom div between posts
  27. Can’t show comments count per post outside loop
  28. Only display posts with comments
  29. Order post by year DESC and month ASC
  30. WordPress get posts by date without query_posts
  31. How to Display Post View Count
  32. Replace Main Query With Custom Query
  33. Different amount of posts on homepage than paged pages
  34. Query All users that has post
  35. Featured Posts for Category Pages
  36. get posts and postmetas in assoc array
  37. Can’t publish new posts
  38. Cannot Update A Post, 404 Error
  39. Function to show random posts from a category
  40. Hiding posts in a list from specified categories
  41. How do I batch create revisions of all posts?
  42. How would I get 1 latest post from a query for 5 posts?
  43. Filter Posts By Tag
  44. Manually removing revision post types
  45. Can I set and show “important” post in my blog?
  46. Exclude posts with empty post_content in wp_query
  47. Reset/Reorder posts ID in the MySQL wp_posts table
  48. How do I find which articles are missing a featured image in The WordPress database?
  49. Improving WP_Query for performance when random posts are ordered
  50. Create dropdown list post
  51. I would like to give special promotion for the first 100 posts in my blog? Can anyone tell me how to do that?
  52. previewing my posts on static page?
  53. Exclude newest post from category X but show rest
  54. Tags to Post-ID mysql query. Tag Search
  55. Reset Popular post query?
  56. Can’t get wp_insert_post to work
  57. Inserting custom data to the_post() during loop
  58. How To Get Posts With A Specific Word
  59. Why WP_Query(‘showposts=5’) shows only 1 post?
  60. is there a way to show the the post title after the image?
  61. Display posts with tag that matches current post title
  62. Why is querying posts messing up my pages?
  63. wp_insert_post – duration
  64. Display all posts that were published before full post on single.php
  65. Category Foreach keeps looping?
  66. Blog post per page setting conflicting with custom WP_Query?
  67. How to exclude latest x posts from a paginated query?
  68. Two loops, one AJAX loop, exclude posts in first loop from second loop, loops are in different files
  69. How to do set post permalinks using 6 digit random unique function?
  70. Get user categories with most posts in it
  71. Random ajax load only works with posts_per_page set to -1
  72. MySql query to get posts with all meta and terms
  73. Using $wpdb to fetch posts with meta data
  74. Display an author’s posts on his own author page
  75. Creating a post from data returned from HTML form
  76. Multi row post list
  77. Custom order for Mysql array
  78. posts_per_page option limits the number of Gallery items
  79. List authors with the last post title and order by last post date
  80. How to make multiple sections in home pulling posts category wise?
  81. Query Posts by Custom Field
  82. How to Mysql select a list of posts with meta_values AND all relevant categories?
  83. Remove a shortcode from all WordPress posts
  84. How to order posts in an arbitrary order?
  85. What do these phpMyAdmin errors mean on my WordPress databaes?
  86. Display Posts on Custom Page
  87. How to get posts from a current post’s month?
  88. Wrong post title displayed from loop
  89. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  90. Nested WP_Query breaking loop
  91. WordPress query_posts by tag doesn’t work anymore(?)
  92. While loop articles – if statement order
  93. do more action after I publish a post
  94. Retrieve only posts from a specific user in wp-admin/edit.php
  95. Conditionals if tags exist?
  96. Why Query is returning empty array?
  97. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  98. WordPress website loads more posts than expected
  99. Get the amount of posts on a current page
  100. Posts – display all posts except a post by an ID
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)