Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
DECLARE @tag nvarchar(35) = ##tag:string## SELECT TOP 10 Id, Tags, ViewCount FROM Posts WHERE PostTypeId = 1 AND Tags LIKE '%'+lower(@tag)+'%' ORDER BY ViewCount desc