Tips answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

SELECT
  Q.Id,
  Q.Title,
  A.Id,
  A.Score
FROM Posts A
  INNER JOIN Posts Q ON Q.Id = A.ParentId
WHERE 
  A.Score >= 0
  AND EXISTS (SELECT * FROM PostTags WHERE TagId = 18 AND PostId = Q.Id)
  AND A.CreationDate >= '2015-01-01 00:00:00'
  AND A.CreationDate <= '2015-12-31 23:59:59'
  AND Q.Title LIKE '%Tips%'
ORDER BY A.Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results