Display old posts if no future posts exist

example:

<?php
            query_posts('posts_per_page=5&order=ASC&post_status=future');
            if ( !have_posts() ) 
            query_posts('posts_per_page=5&order=DESC&post_status=publish');
            if( have_posts() ) : while ( have_posts() ) : the_post();
?>

Related Posts:

  1. How to Optimize WP site for millions of posts
  2. Get Terms by IDs with IDs order
  3. wpdb get posts by taxonomy SQL
  4. How to List Events by Year and Month Using Advanced Custom Fields?
  5. How many WordPress SQL Queries per page?
  6. Slow wp_enqueue_media()
  7. Advanced Custom Fields – Query Efficiency
  8. How to display lastest post date in the homepage?
  9. Get a user’s most recent post title
  10. Different Main Navigation per category
  11. How to tell if $query_var isset?
  12. Show All Posts Insert Edit Link
  13. Get posts by category with pure SQL query
  14. can’t get query to order posts by acf datepicker
  15. Sorting Grids with Essential Grid and Events Manger
  16. The use of including upgrade.php when building custom queries
  17. Get the timout value of a saved transient?
  18. Help with wordpress custom query and advanced custom fields plugin
  19. Does meta_query work within get_posts array?
  20. Mysql / WordPress killing my server with 80k users [closed]
  21. Query all posts and not repeat the same tag
  22. Slow meta_query with about 4 milion record on wp_postmeta
  23. How to show more than 5 posts?
  24. Deleting data from a custom table in WordPress
  25. WordPress Find Duplicate Post By Content
  26. WP Query Sort by meta value (date)
  27. mySQL query. ORDER BY meta_key
  28. how to query multiple categories in wordpress?
  29. Disable the MySQL query in the main query
  30. Strange string in console from wpdb query
  31. Update slug (URL) of pending posts via phpMyAdmin
  32. How can I get the query that would be run for the archive page?
  33. Query metas (and not : query posts by metas)
  34. Select query for a login
  35. What’s wrong with my $wpdb prepare?
  36. where should I reset query after using get_results?
  37. Missing posts in a query
  38. Alter a specific query on WordPress
  39. Exclude featured image and custom field from this get_attachment query
  40. Protect sequence of pages with same password for each of two groups of users
  41. How is it possible to get top comment from all children?
  42. wpdb print all post meta
  43. Form and custom query problem
  44. Export Specific User data without plugin
  45. How to write: $wpdb->update having WHERE NOT value pair in the array
  46. Exclude all sticky posts front page twenty twelve
  47. All in One Calendar Plugin Custom Post Type Query [closed]
  48. Get Posts from Last 24 hours and Sort them via GD Star Rating
  49. wpdb COALESCE won’t work
  50. get csv of users with user_meta
  51. Custom SQL Query passing array to WHERE p.id
  52. Query does not return content
  53. Query posts dynamic date range
  54. Parse query filter in wordpress and relation
  55. get posts by tag to showing in a widget
  56. Mysql query not working on WordPress 4.2.2
  57. get_post_meta with WP_query
  58. Taxonomy filter under Polylang
  59. How to create an overview of posts with the same tag?
  60. List WordPress Post and Related Attachments outside of a post page
  61. How properly create a blog template for wordpress?
  62. Is there a way to add a link directly into this media query?
  63. create a link to a random post within the current category
  64. Problem on displaying the results on my query
  65. Improve performance of slow query
  66. JetEngine Query Builder – order by value from repeater
  67. Change pure SQL database query to WordPress post query?
  68. WordPress search in modified post title
  69. meta_query not working
  70. Cannot get sql request from Query object?
  71. WordPress query: merge meta key (number) values and sort
  72. Heavy meta query causing SQL crash
  73. Question about of query
  74. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  75. Modify behaviour of “s” parameter in wp_query
  76. Sort by postmeta on when searching
  77. Pulling an ACF into a query
  78. Speed up search query that searches in post meta?
  79. How to make MySQL search queries with quotes
  80. Limiting a filtered query
  81. Using cron for multiple queries
  82. Archive query not working correctly
  83. Custom MySQL Query for Post and Post Meta
  84. very slow wordpress query with default query
  85. Displaying popular posts
  86. Custom Query problem access the values
  87. Set posts per page for parent category and it’s all children
  88. How to have more post in a page than in your home page
  89. Find all posts via SQL beginning with A of type B
  90. learn to run wpdb class
  91. list or get meta_key where meta_value is ‘something’
  92. If more than 1 image show post link?
  93. WP_Query with checkbox meta_query – WordPress [duplicate]
  94. Rewrite Query_Var URL Parameter with Slug
  95. How to query different categories on index?
  96. How to specify what kind of is_single post?
  97. Can’t See Media Queries with Inspect Tool [closed]
  98. Print data from wordpress sql query
  99. Can I create my own query in wordpress with traditional methods?
  100. How to show sticky posts on all pages of the pagination, not just the first page?