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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100 Id,Title,CreationDate,Tags,ClosedDate,ViewCount, Score, FavoriteCount
FROM Posts 
WHERE PostTypeId = 1 
AND Tags LIKE '%java%'
AND Tags NOT LIKE '%javascript%'
AND 
(Tags LIKE '%##Tag1##%' 
OR Tags LIKE '%##Tag2##%' 
OR Tags LIKE '%##Tag3##%'
OR Tags LIKE '%##Tag5##%'
OR Tags LIKE '%##Tag6##%')
ORDER BY ViewCount DESC, Score DESC, FavoriteCount DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results