Test

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT TOP 100
'http://stackoverflow.com/questions/' + CAST(Id AS nvarchar) + '|' + CAST(Id AS nvarchar) AS [ID],
Title,
CreationDate,
Tags
FROM Posts 
WHERE AnswerCount = 0
AND
CreationDate < '2014-01-10 00: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

/*
neatbildēti
php, js, css, xml vai html
nav slēgti
izveidoti pirms ... datuma
dinamisks URL
*/

Enter Parameters

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