Q&A for science fiction and fantasy enthusiasts
-- 'git' tag -- 'trunk' in title SELECT p.Id AS [Post Link], p.Score, a.Score AS [Accepted Score], p.Title, p.Tags, p.CreationDate AS [Date Posted], p.CommentCount, p.Body FROM Posts p JOIN Posts a ON p.AcceptedAnswerId = a.Id WHERE p.PostTypeId = 1 -- Question AND CHARINDEX('git', p.Tags) > 0 AND p.Score >= ##MinScore:int?4## --AND p.Score <= ##MaxScore:int?30000## AND (p.Title LIKE '%[Tt][Rr][Uu][Nn][Kk]%') ORDER BY p.CreationDate DESC;