0

Please login or register to vote for this query.

(click on this box to dismiss)

This is a rough estimate

Q&A for professional and enthusiast programmers

SELECT Id as [Post Link], Score, CreationDate, ViewCount, Tags 
FROM Posts 
WHERE Id NOT IN
(
     SELECT ParentId
     FROM Posts
     WHERE PostTypeId = 2
     AND Score >= 1 AND ClosedDate IS NULL
)
AND (
  Tags LIKE '%10.%' 
  OR Tags Like '%9.%' 
  OR Tags LIKE '%8.%' 
  OR Tags LIKE '%11.04%'
  OR Tags LIKE '%7.%'
  OR Tags LIKE '%6.%'
)
AND ClosedDate IS NULL
AND AcceptedAnswerId IS NULL
ORDER BY ViewCount DESC

fork query

edited dec 27 12

created dec 27 12 Marco Ceppi