Hello all. I've been trying to add an entry count to the blog's Archive Widget, but without any success. I've tried adding COUNT in the SQL statement and moving the DISTINCT clause in to parens, but this clobbers the AS \"Month\" and AS \"Year\" needed for the actual widget. I'm just looking for a simple count of entries per each result which I can render in my sidebar:
April 2012 (3)
March 2012 (12)
February 2012 (17)
etc.
Thanks in advance for any thoughts or pointers.
Patrick