Order by meta values

You can do this by just looking for release_date_db:

function plugin_name_get_posts() {
    global $wpdb;
$the_posts = $wpdb->get_results( "SELECT * FROM $wpdb->posts, $wpdb->postmeta WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id AND meta_key = 'release_date_db' AND meta_value >= 20120000 AND meta_value <= 20121231 ORDER BY meta_value ASC;", ARRAY_A );
 }

Related Posts:

  1. Ordering by meta_value AND date NOT WORKING with wp_query
  2. How to orderby multiple meta fields if some fields are empty
  3. Order posts by more than one variable (meta_key and publish date AND time)
  4. How to only display posts whose meta_value field is not empty?
  5. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  6. WP_Query orderby post__in remains ineffective in the Loop [closed]
  7. WP_Query orderby date not working
  8. Order by optional meta key?
  9. Sorting: custom query with orderby meta_value_num THEN by title
  10. Order by DESC, ASC in custom WP_Query
  11. WP_Query order by multiple meta keys & fields
  12. Secondary Sort (fallback) for WP_Query
  13. Query Posts in a Predefined Order
  14. How to get order of posts?
  15. Sort Order for a Custom Query in a Post Type Archive Not Working
  16. Order posts by ID in the given order
  17. Is it possible to orderby multiple meta_keys when using meta_value_num?
  18. Custom WP_Query order by post_meta and (author) user_meta
  19. Sorting posts by custom date fields (non standard date format)
  20. How to order posts tag by tag?
  21. How do I order pages and categories by ID or name in the same query?
  22. WP_Query with meta_value LIKE ‘something%’
  23. WP_Query ordered by custom field that is a date string?
  24. WP_Query sort by comment meta data
  25. Order posts by tags count?
  26. Merge 2 args in one WP_Query and order it by date
  27. Orderby = none not working [duplicate]
  28. WP_query ‘orderby=none’ Problem
  29. Order posts by date and then by custom field
  30. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  31. Revolution Slider Orderby Two Custom Fields
  32. Sorting meta_value as integer doesn’t work
  33. Order posts ascending with number in title
  34. List taxonomy terms plus their latest post ordered by post date
  35. Order by the results of a function with WP_query
  36. How to order posts in wp_query by a meta_value of the corresponding author
  37. Order by menu structure
  38. Add a default meta_value to new posts
  39. WP_Query order by date in meta_value
  40. How to use order RAND() on WordPress?
  41. Show all parents and children in custom post type in right order
  42. WP_Query orderby breaks when using AJAX?
  43. Order WP Query posts by custom order calculated from post meta values
  44. Custom Post order for homepage
  45. How to use Meta Value Compare in WP_Query For Max and Min numbers
  46. Custom WP Query from meta_value stored as serialised array
  47. Meta query with order by another custom field
  48. Change default ordering of taxonomy terms – pre_get_terms
  49. meta_query works locally but not on live server
  50. Ordering Posts Type A by Custom Fields of related Post Type B
  51. WordPress WP_Query orderby being overwritten
  52. WP_Query Order by Specific Post ID First
  53. Order Posts by meta value AND published date
  54. How can I pick a single post from the latest 3?
  55. Wp query orderby ‘title’ doesn’t work
  56. How can I order Wp_Query hierarchically?
  57. How do I sort posts with multiple pages
  58. Sorting posts DESC based on the number of comments using WP_Query
  59. Order WP_Query by multiple fields, subtracting them from one another
  60. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  61. pre_get_posts order by not working
  62. Custom query for sidebar isn’t returning results
  63. Need wp_query to return all children and grandchildren
  64. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  65. Orderby ASC changes to DESC in WP_Query
  66. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  67. Order By table field comment_status in WordPress > 4.0
  68. new WP_Query to get max price meta value not working
  69. Complex WP_Query order request: DESC by day, but then ASC by time
  70. How to set multiple `orderby` in query argument?
  71. WP_Query order result by date AND meta_value
  72. Query multiple meta values
  73. Order by title without taking into account ‘the’
  74. Why isn’t my `meta_query` array functioning properly?
  75. WP_Query orderby author__in
  76. Sort wordpress custom posts based on meta value
  77. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  78. Weird orderby => post__in issue
  79. Meta_query on same meta key, with diffrenct values
  80. Order by summing multiple values
  81. Understanding the orderby in WP_Query?
  82. Order by empty custom field
  83. How to extract specific post
  84. How to order posts by title after they have already been sorted by category
  85. Advanced ordering of query_posts
  86. Help ordering Post loop by two meta values
  87. Order ascending is ignored in meta query?
  88. meta_value_num not ordering all items
  89. Meta Query relation “AND” then set array accordingly
  90. How to filter a query by multiple meta keys and order by other meta keys
  91. Multiple Orderby’s using random order WP_Query
  92. Debugging wp_query orderby for taxonomy
  93. WP Query – order posts by meta field first and then order the rest
  94. Ordering posts by an array
  95. How to Create a Random List of Child Pages
  96. Advanced WP_Query with meta_query, orderby?
  97. Does meta_value (array) work with ‘orderby’?
  98. Specify strict ‘order by’ in WordPress query
  99. How to Order a list of taxonomies? orderby?
  100. WP Query Meta Value – How To Identify Specific, Unique Values?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)