confluence-comment by author

select a.creationdate,b.username from content a,user_mapping b where a.contenttype='COMMENT' and a.creator=b.user_key and a.creationdate between '2016/4/1' and '2016/4/20' order by creationdate desc