Downloads / Gas

	            SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'resources' AND post_parent = 0 AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC LIMIT 100	        

	            Array
(
    [0] => stdClass Object
        (
            [year] => 2021
            [month] => 1
            [posts] => 1
        )

    [1] => stdClass Object
        (
            [year] => 2020
            [month] => 11
            [posts] => 3
        )

    [2] => stdClass Object
        (
            [year] => 2020
            [month] => 7
            [posts] => 1
        )

    [3] => stdClass Object
        (
            [year] => 2020
            [month] => 6
            [posts] => 1
        )

    [4] => stdClass Object
        (
            [year] => 2020
            [month] => 5
            [posts] => 2
        )

    [5] => stdClass Object
        (
            [year] => 2020
            [month] => 2
            [posts] => 1
        )

    [6] => stdClass Object
        (
            [year] => 2019
            [month] => 11
            [posts] => 2
        )

    [7] => stdClass Object
        (
            [year] => 2019
            [month] => 10
            [posts] => 4
        )

    [8] => stdClass Object
        (
            [year] => 2019
            [month] => 9
            [posts] => 10
        )

    [9] => stdClass Object
        (
            [year] => 2019
            [month] => 6
            [posts] => 1
        )

    [10] => stdClass Object
        (
            [year] => 2019
            [month] => 5
            [posts] => 1
        )

    [11] => stdClass Object
        (
            [year] => 2019
            [month] => 4
            [posts] => 1
        )

    [12] => stdClass Object
        (
            [year] => 2019
            [month] => 2
            [posts] => 2
        )

    [13] => stdClass Object
        (
            [year] => 2019
            [month] => 1
            [posts] => 1
        )

    [14] => stdClass Object
        (
            [year] => 2018
            [month] => 11
            [posts] => 1
        )

    [15] => stdClass Object
        (
            [year] => 2018
            [month] => 10
            [posts] => 4
        )

    [16] => stdClass Object
        (
            [year] => 2018
            [month] => 9
            [posts] => 53
        )

    [17] => stdClass Object
        (
            [year] => 2018
            [month] => 6
            [posts] => 1
        )

    [18] => stdClass Object
        (
            [year] => 2018
            [month] => 4
            [posts] => 1
        )

    [19] => stdClass Object
        (
            [year] => 2018
            [month] => 2
            [posts] => 1
        )

    [20] => stdClass Object
        (
            [year] => 2017
            [month] => 10
            [posts] => 5
        )

    [21] => stdClass Object
        (
            [year] => 2017
            [month] => 9
            [posts] => 7
        )

    [22] => stdClass Object
        (
            [year] => 2017
            [month] => 6
            [posts] => 1
        )

    [23] => stdClass Object
        (
            [year] => 2017
            [month] => 4
            [posts] => 2
        )

    [24] => stdClass Object
        (
            [year] => 2017
            [month] => 3
            [posts] => 2
        )

    [25] => stdClass Object
        (
            [year] => 2017
            [month] => 2
            [posts] => 1
        )

    [26] => stdClass Object
        (
            [year] => 2016
            [month] => 11
            [posts] => 5
        )

    [27] => stdClass Object
        (
            [year] => 2016
            [month] => 10
            [posts] => 5
        )

    [28] => stdClass Object
        (
            [year] => 2016
            [month] => 9
            [posts] => 51
        )

    [29] => stdClass Object
        (
            [year] => 2016
            [month] => 7
            [posts] => 1
        )

    [30] => stdClass Object
        (
            [year] => 2016
            [month] => 6
            [posts] => 1
        )

    [31] => stdClass Object
        (
            [year] => 2016
            [month] => 5
            [posts] => 1
        )

    [32] => stdClass Object
        (
            [year] => 2016
            [month] => 4
            [posts] => 1
        )

    [33] => stdClass Object
        (
            [year] => 2016
            [month] => 2
            [posts] => 2
        )

    [34] => stdClass Object
        (
            [year] => 2015
            [month] => 11
            [posts] => 3
        )

    [35] => stdClass Object
        (
            [year] => 2015
            [month] => 10
            [posts] => 5
        )

    [36] => stdClass Object
        (
            [year] => 2015
            [month] => 9
            [posts] => 8
        )

    [37] => stdClass Object
        (
            [year] => 2015
            [month] => 6
            [posts] => 3
        )

    [38] => stdClass Object
        (
            [year] => 2015
            [month] => 5
            [posts] => 1
        )

    [39] => stdClass Object
        (
            [year] => 2015
            [month] => 4
            [posts] => 1
        )

    [40] => stdClass Object
        (
            [year] => 2015
            [month] => 3
            [posts] => 1
        )

    [41] => stdClass Object
        (
            [year] => 2015
            [month] => 2
            [posts] => 3
        )

    [42] => stdClass Object
        (
            [year] => 2014
            [month] => 11
            [posts] => 1
        )

    [43] => stdClass Object
        (
            [year] => 2014
            [month] => 10
            [posts] => 6
        )

    [44] => stdClass Object
        (
            [year] => 2014
            [month] => 9
            [posts] => 51
        )

    [45] => stdClass Object
        (
            [year] => 2014
            [month] => 6
            [posts] => 3
        )

    [46] => stdClass Object
        (
            [year] => 2014
            [month] => 5
            [posts] => 2
        )

    [47] => stdClass Object
        (
            [year] => 2014
            [month] => 4
            [posts] => 1
        )

    [48] => stdClass Object
        (
            [year] => 2014
            [month] => 3
            [posts] => 2
        )

    [49] => stdClass Object
        (
            [year] => 2014
            [month] => 2
            [posts] => 1
        )

    [50] => stdClass Object
        (
            [year] => 2014
            [month] => 1
            [posts] => 2
        )

    [51] => stdClass Object
        (
            [year] => 2013
            [month] => 11
            [posts] => 3
        )

    [52] => stdClass Object
        (
            [year] => 2013
            [month] => 10
            [posts] => 9
        )

    [53] => stdClass Object
        (
            [year] => 2013
            [month] => 9
            [posts] => 12
        )

    [54] => stdClass Object
        (
            [year] => 2013
            [month] => 7
            [posts] => 5
        )

    [55] => stdClass Object
        (
            [year] => 2013
            [month] => 6
            [posts] => 5
        )

    [56] => stdClass Object
        (
            [year] => 2013
            [month] => 5
            [posts] => 2
        )

    [57] => stdClass Object
        (
            [year] => 2013
            [month] => 4
            [posts] => 3
        )

    [58] => stdClass Object
        (
            [year] => 2013
            [month] => 3
            [posts] => 2
        )

    [59] => stdClass Object
        (
            [year] => 2013
            [month] => 2
            [posts] => 2
        )

    [60] => stdClass Object
        (
            [year] => 2012
            [month] => 10
            [posts] => 6
        )

    [61] => stdClass Object
        (
            [year] => 2012
            [month] => 9
            [posts] => 57
        )

    [62] => stdClass Object
        (
            [year] => 2012
            [month] => 6
            [posts] => 1
        )

    [63] => stdClass Object
        (
            [year] => 2012
            [month] => 4
            [posts] => 1
        )

    [64] => stdClass Object
        (
            [year] => 2012
            [month] => 3
            [posts] => 4
        )

    [65] => stdClass Object
        (
            [year] => 2012
            [month] => 1
            [posts] => 4
        )

    [66] => stdClass Object
        (
            [year] => 2011
            [month] => 11
            [posts] => 1
        )

    [67] => stdClass Object
        (
            [year] => 2011
            [month] => 10
            [posts] => 3
        )

    [68] => stdClass Object
        (
            [year] => 2011
            [month] => 9
            [posts] => 10
        )

    [69] => stdClass Object
        (
            [year] => 2011
            [month] => 4
            [posts] => 2
        )

    [70] => stdClass Object
        (
            [year] => 2011
            [month] => 2
            [posts] => 2
        )

    [71] => stdClass Object
        (
            [year] => 2011
            [month] => 1
            [posts] => 2
        )

    [72] => stdClass Object
        (
            [year] => 2010
            [month] => 10
            [posts] => 4
        )

    [73] => stdClass Object
        (
            [year] => 2010
            [month] => 9
            [posts] => 49
        )

    [74] => stdClass Object
        (
            [year] => 2010
            [month] => 3
            [posts] => 1
        )

    [75] => stdClass Object
        (
            [year] => 2010
            [month] => 1
            [posts] => 2
        )

    [76] => stdClass Object
        (
            [year] => 2009
            [month] => 11
            [posts] => 3
        )

    [77] => stdClass Object
        (
            [year] => 2009
            [month] => 10
            [posts] => 2
        )

    [78] => stdClass Object
        (
            [year] => 2009
            [month] => 9
            [posts] => 13
        )

    [79] => stdClass Object
        (
            [year] => 2009
            [month] => 3
            [posts] => 1
        )

    [80] => stdClass Object
        (
            [year] => 2009
            [month] => 2
            [posts] => 5
        )

    [81] => stdClass Object
        (
            [year] => 2009
            [month] => 1
            [posts] => 1
        )

    [82] => stdClass Object
        (
            [year] => 2008
            [month] => 11
            [posts] => 2
        )

    [83] => stdClass Object
        (
            [year] => 2008
            [month] => 10
            [posts] => 3
        )

    [84] => stdClass Object
        (
            [year] => 2008
            [month] => 9
            [posts] => 24
        )

    [85] => stdClass Object
        (
            [year] => 2008
            [month] => 4
            [posts] => 1
        )

    [86] => stdClass Object
        (
            [year] => 2008
            [month] => 1
            [posts] => 2
        )

    [87] => stdClass Object
        (
            [year] => 2007
            [month] => 12
            [posts] => 1
        )

    [88] => stdClass Object
        (
            [year] => 2007
            [month] => 11
            [posts] => 1
        )

    [89] => stdClass Object
        (
            [year] => 2007
            [month] => 10
            [posts] => 1
        )

    [90] => stdClass Object
        (
            [year] => 2007
            [month] => 9
            [posts] => 10
        )

    [91] => stdClass Object
        (
            [year] => 2007
            [month] => 6
            [posts] => 2
        )

    [92] => stdClass Object
        (
            [year] => 2007
            [month] => 5
            [posts] => 1
        )

    [93] => stdClass Object
        (
            [year] => 2007
            [month] => 4
            [posts] => 1
        )

    [94] => stdClass Object
        (
            [year] => 2006
            [month] => 11
            [posts] => 1
        )

    [95] => stdClass Object
        (
            [year] => 2006
            [month] => 9
            [posts] => 31
        )

    [96] => stdClass Object
        (
            [year] => 2006
            [month] => 3
            [posts] => 1
        )

    [97] => stdClass Object
        (
            [year] => 2006
            [month] => 1
            [posts] => 1
        )

    [98] => stdClass Object
        (
            [year] => 2004
            [month] => 4
            [posts] => 1
        )

)