Test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- nemeklēt slēgtos

SELECT TOP 10 Id, Title, Tags, CreationDate
FROM Posts
WHERE
(
  AnswerCount = 0
  AND CreationDate > '2013-10-01'
  AND CreationDate < '2013-12-31'
  --AND ClosedDate = 0
)
AND
(
  Tags LIKE '%php%' OR
  Tags LIKE '%javascript%' OR
  Tags LIKE '%css%' OR
  Tags LIKE '%html%'
)
ORDER BY CreationDate DESC

Enter Parameters

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