0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited dec 30 13 _

created dec 21 13 anonymous