Q&A about the site for enthusiasts and scholars of mythology and folklore
select [Year], LastActivityDate, Title, id, Body, [link], ViewCount, Score from ( select CAST( cast(DATENAME(yyyy, CreationDate) as varchar) as varchar) [Year], LastActivityDate, Title, p.Id, Body, 'https://stackoverflow.com/questions/' + CAST(p.Id AS nvarchar) [link], ViewCount, Score from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where TagName LIKE '%wordpress%' group by p.id, Body, p.CreationDate, Title, ViewCount, Score, LastActivityDate ) as X order by [ViewCount] desc, [LastActivityDate]