0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

SELECT
Id,Body,Tags,ViewCount,CreationDate

FROM Posts

WHERE ParentId IN
(
SELECT TOP 4650
    Id
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%c#%')
AND CreationDate
BETWEEN'01-01-2010' and '01-01-2011'
ORDER BY ViewCount Desc)

fork query

edited jul 7 19

created feb 4 19 anonymous