Getting Year & Date inside wpdb [duplicate]

You mention the Codex page for WP_Query but you are not using WP_Query. You are using wpdb.

WP_Query is a very complicated class for querying the WordPress tables for post (CPT) data. wpdb is a lightweight wrapper around PHP SQL functions. With WP_Query you can pass arguments like monthnum because the WP_Query class converts the argument into proper SQL.

With wpdb you have to write the SQL. $wpdb->get_results essentially passes your SQL through to the database engine. If you look at the database descriptions, there is no column named monthnum. You are asking MySQL to pull data from a column that does not exist. That is why you get an error.

You need to write valid SQL– look at the date manipulation functions— or use WP_Query whose Codex page you are already investigating. The latter is the better choice.

Related Posts:

  1. WP_Comment_Query pagination, delving into the unknown
  2. Sort posts by category name and title
  3. Getting all user metadata from user
  4. ajax category filter
  5. Display posts the match taxonomy term linked from wp_list_categoies?
  6. WordPress 4.9.5 PHP intermittent warning trim() expects parameter 1 to be string, array given
  7. Limit WP_Query to only X results (total, not per page)
  8. How to disable main query?
  9. Use post__in and post__not_in together?
  10. WP_Query on different site in a multisite setup
  11. Best practice for multiple queries on page
  12. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  13. How to user WP_Query to lower the number of queries
  14. Exclude post on loop by multiple meta key value
  15. how do i combine keyword search and taxonomy in a WP_query $args array Worpresss [closed]
  16. How to find out what “Blog pages show at most” is set to [duplicate]
  17. difference between $wp_the_query and $wp_query? & getting the values properly [duplicate]
  18. Ignore/Skip default value on orderby menu_order?
  19. WP_Query order by date in meta_value
  20. WP_Query pagination not working in admin area
  21. Sanitizing search data for use with WP_Query
  22. How to search by a post and a category name on wordpress at the same time?
  23. What’s the point of the query_vars filter?
  24. Meta query with order by another custom field
  25. How to retrieve current page WP_Query arguments?
  26. How can I get an array of all IDs from the current queried object?
  27. Get Category Archive Template Name Dynamically
  28. How to limit WP_Query to one result on the loop?
  29. WP User Query get all authors with last name starting with specific letter
  30. Query post from all category with same tag on 1 pages
  31. How to correctly pass values to wpdb->prepare()?
  32. How to use filter hook “the_posts” with a function that refers to $this?
  33. Is there a way to include a post multiple times in the same query result?
  34. WP_Query, pre_get_posts and offset
  35. add_actions called from functions.php not returning good values
  36. Multiple Search Terms WP_Query
  37. Filtering posts from different categories into different section by doing WP_Query only once
  38. Show posts from a custom taxonomy on a page
  39. Suggestions on making this query/code more performant
  40. Where to put meta Keys
  41. WP Query Args – Title or Taxonomy Value
  42. Should wp_query automatic meta and term cache priming be used in an enviroment with an object caching
  43. wp_query with custom post type only returning last posted
  44. Display custom tags on pages that have a specific page parent
  45. Slow WP_Query with ‘OR’ on meta_query
  46. How to filter a query by multiple meta keys and order by other meta keys
  47. Multiple Orderby’s using random order WP_Query
  48. using pre_get_posts for search results not found
  49. How can I override one post and make it display content for another post?
  50. Exclude parent with child pages from WP_Query
  51. Co-authors list of all posts
  52. Get multiple users with meta value in one query and populate WP_User class
  53. get_posts always returning the same number of posts = 5
  54. WP_Query calls all posts?
  55. WP_Query: apply an SQL function to meta fileld value
  56. The best way to store variable across different widgets
  57. WPQuery calling specific posts problem
  58. Overriding $wp_query on a template
  59. How to use ‘WP_Query’ or ‘query_posts’ to display content in a descending order
  60. How to display specific ids of posts using wp_query?
  61. Filtering by multiple conditions in the loop
  62. Limit loop to future events
  63. Display count number of posts with the same specific meta_key meta_value
  64. Echo User Name from User with most comments of today?
  65. Tax_Query using WP_Query not working
  66. How to stack name list in non-alphabetical order?
  67. Magazine style frontpage with multiple categories/loops and no duplicate posts
  68. orderby ignored by wp_query
  69. $wp_query->found_posts not returning correct value
  70. How to make a post with certain taxonomy term display first before other post with only one query?
  71. Exception for excluding previously displayed posts in queries
  72. How do I compare the value of two taxonomies in a wp_query
  73. Apply a custom WP_Query to the whole multisite network
  74. display ACF repater field in archive page
  75. Custom Taxonomy Archive Page to display either ALL listings or only from URL
  76. Meta query ignores multiple values of the key
  77. Any way to use FETCH_KEY_PAIR with $wpdb?
  78. Query by meta key and order by another meta key value
  79. Filter admin ajax data by url query
  80. Display hierarchical structure of Custom post type in UL LI
  81. Using a variable within the blog posts array query – posts_per_page as variable
  82. Complex Meta Query
  83. Order search results by multiple post_types
  84. Single query for multiple categories
  85. Best way to query posts and order by relevancy to query
  86. Woocommerce WP_Query post__not_in problem
  87. how to show more than 1 post into three columns query
  88. How to combine nested tax_query logic with other nested query logic?
  89. complex query question
  90. tax_query not working for taxonomy slug
  91. custom query – offset to pagination
  92. Order Custom Field by Price
  93. How to Insert data with wp cron
  94. When should you use WP_Query vs query_posts() vs get_posts()?
  95. Stop link being removed in menu/list when viewing that post
  96. WP_Query breaks pagination
  97. wpdb LIKE request shows all database data
  98. Can’t seem to get an else statement correct? [closed]
  99. query_vars category_name only display one catgory out of multiple categories
  100. Incorrect posts displayed on category page
error code: 523