Q&A about the site for Joomla! administrators, users, developers and designers
-- Enter Query Title -- Enter Query Description select count(*) from posts where owneruserID = 2869 and creationdate between dateadd(yy, -1, getdate()) and getdate()