Total number of posts in last year

All you need to do is modify the SQL query. Using the code you linked as a base:

$numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status="publish" AND year(post_date) = 2010");
if (0 < $numposts) $numposts = number_format($numposts);

The ‘AND’ I added basically gives you all the posts of 2010. Change the year accordingly

Related Posts:

  1. Simple way to calculate median with MySQL
  2. Blog statistics
  3. Possibility to Display Most used Words?
  4. Counting number of visits to my website
  5. Looking for references to WordPress Popularity Statistics
  6. Check which user saw which page
  7. Looking for simple and lightweight plugin for post reading stats
  8. Remove views in single post [closed]
  9. How to move my stats to a self-hosted website?
  10. Still using WP Stats without Jetpack
  11. Delete old JetPack Site Stats? encrypted_search_terms in top search terms [closed]
  12. Plugin to show how far users are reading? [closed]
  13. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. What’s the best way to search for a UPC code in a Database?
  15. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  16. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  17. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  18. What is the difference between UNION and UNION ALL?
  19. Selecting COUNT(*) with DISTINCT
  20. Case in Select Statement
  21. What is a stored procedure?
  22. ORA-00904: invalid identifier
  23. SQL WITH clause example [duplicate]
  24. What is an index in SQL?
  25. Inserting multiple rows in a single SQL query? [duplicate]
  26. What exactly does numpy.exp() do? [closed]
  27. Unknown column in ‘field list’ error on MySQL Update query
  28. Unknown column in ‘field list’ error on MySQL Update query
  29. SQL Inner-join with 3 tables?
  30. The wait operation timed out. ASP
  31. What is SELF JOIN and when would you use it? [duplicate]
  32. The wait operation timed out. ASP
  33. Conversion failed when converting date and/or time from character string while inserting datetime
  34. Self Join to get employee manager name
  35. How do I UPDATE from a SELECT in SQL Server?
  36. SQL error “ORA-01722: invalid number”
  37. how to fix oracle ORA-01722 invalid number error
  38. f-statistics and p value suggest different results
  39. In R, how to find the standard error of the mean?
  40. SQL query to select dates between two dates
  41. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  42. In R, how to find the standard error of the mean?
  43. MySQL – Operand should contain 1 column(s)
  44. SQL SELECT WHERE field contains words
  45. Conversion failed when converting date and/or time from character string while inserting datetime
  46. When should I use CROSS APPLY over INNER JOIN?
  47. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  48. Insert Data Into Temp Table with Query
  49. QL Error: ORA-00933: SQL command not properly ended
  50. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  51. SQL query to get the employee name and their manager name from the same table
  52. MySQL create table if not exists and insert record only if table was created
  53. error, string or binary data would be truncated when trying to insert
  54. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  55. NOT IN vs NOT EXISTS
  56. SQL SELECT WHERE field contains words
  57. Online SQL Query Syntax Checker
  58. How can I do an UPDATE statement with JOIN in SQL Server?
  59. Must declare the scalar variable
  60. How to normalize a NumPy array to a unit vector?
  61. ORA-00979 not a group by expression
  62. T-SQL split string
  63. ORA-00907: missing right parenthesis
  64. How do I use properly CASE..WHEN in MySQL
  65. Must declare the scalar variable
  66. What is “Advanced” SQL?
  67. Rename column SQL Server 2008
  68. How to plot ROC curve in Python
  69. Why do we need “Relationships” between tables at all?
  70. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  71. Using group by on multiple columns
  72. Efficiently convert rows to columns in sql server
  73. How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
  74. How to delete duplicate rows in SQL Server?
  75. The SQL OVER() clause – when and why is it useful?
  76. Update multiple columns in SQL
  77. How can I do a FULL OUTER JOIN in MySQL?
  78. Nested select statement in SQL Server
  79. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  80. Using group by on multiple columns
  81. SQL SELECT WHERE field contains words
  82. SQL Query with NOT LIKE IN
  83. MySQL query String contains
  84. How do I escape a single quote in SQL Server?
  85. What’s the difference between VARCHAR and CHAR?
  86. Cannot delete or update a parent row: a foreign key constraint fails
  87. Cannot delete or update a parent row: a foreign key constraint fails
  88. SQL Server IF EXISTS THEN 1 ELSE 2
  89. Case statement in MySQL
  90. How to update multiple columns in single update statement in DB2
  91. Rename a column in MySQL
  92. T-SQL split string based on delimiter
  93. How to declare a variable in MySQL?
  94. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  95. Finding duplicate values in a SQL table
  96. ORA-01843 not a valid month- Comparing Dates
  97. Cannot delete or update a parent row: a foreign key constraint fails
  98. SQL Query with SUM with Group By
  99. MySQL Cannot Add Foreign Key Constraint
  100. How to normalize a NumPy array to a unit vector?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)