SELECT TOP 100 Id, Title, CreationDate, Tags, ClosedDate ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT TOP 100 Id, Title, CreationDate, Tags, ClosedDate
FROM Posts 
WHERE AnswerCount = 0
AND
CreationDate < '2013-12-26 02:00:00'
AND
(
Tags Like '%php%' OR
Tags = '%javascript%' OR
Tags = '%css%' OR
Tags = '%xml%' OR
Tags = '%html%'
)
AND
ClosedDate IS NULL
ORDER BY CreationDate DESC

Enter Parameters

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