To select top 10 reads per month in WordPress, you need to use the Plugin CountPerDay.
The following mysql snippet will do the rest.
SELECT COUNT(page), wp_posts.post_title, wp_posts.post_name from wp_cpd_counter join wp_posts ON wp_posts.id = wp_cpd_counter.page WHERE wp_posts.post_date between '2014-06-01' AND '2014-06-30' GROUP BY page ORDER BY 1 desc LIMIT 10
To calculate the number of days in a month in C# and VB.NET.
private static int DayCountPerMonth(DateTime date)
{
if (date == null) { throw new ArgumentNullException();}
var calendar = new System.Globalization.GregorianCalendar();
return calendar.GetDaysInMonth(date.Year, date.Month);
}
Private Shared Function DayCountPerMonth(date As DateTime) As Integer If date Is Nothing Then Throw New ArgumentNullException() End If Dim calendar = New System.Globalization.GregorianCalendar() Return calendar.GetDaysInMonth(date.Year, date.Month) End Function