SELECT DATE_FORMAT(FROM_UNIXTIME(created),'%Y-%m') AS monthno,COUNT(*) AS nodenum FROM {node} n WHERE n.created>0 AND (n.status=1) AND n.type IN ('blog') GROUP BY monthno LIMIT 101