Old posts matching given label

0

Please login or register to vote for this query.

(click on this box to dismiss)

Startups Meta

Q&A for entrepreneurs faced with delivering a new product or service under conditions of significant uncertainty

DECLARE @maxAskTime DATETIME = convert(DATETIME, '##maxAskTime?2014/10/01 00:00:00##')

SELECT TOP 100
Posts.id as [Post Link], 
Posts.CreationDate,
Posts.ViewCount,
Posts.Score as [Score], 
Posts.Tags as [Tagged With]
FROM Posts

WHERE 
Posts.PostTypeId=1
AND
Posts.Score >0
AND
Posts.CreationDate < @maxAskTime
AND
Posts.Tags like '%##tag?jquery##%' 
AND
(lower(Posts.Body) LIKE lower('%##keyword##%'))
ORDER BY Posts.CreationDate DESC, Posts.ViewCount DESC

Enter Parameters

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