Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select P.ID as [Post Link], p.Score, P.Title, P.OwnerDisplayName, P.ViewCount, pt.Name from Posts as P inner join PostTypes as Pt on P.posttypeid = pt.Id where p.Score > ##score## order by P.Score desc