title

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

/*
SELECT TOP 19609
Id,Body,Tags,ViewCount,CreationDate
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'01-01-2013' and '01-01-2014'

ORDER BY [ViewCount] Desc
*/




SELECT
ParentId,Id,Body

FROM Posts

WHERE ParentId IN
(
SELECT TOP 19609
    Id
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'01-01-2013' and '01-01-2014'

ORDER BY [ViewCount] Desc)

Enter Parameters

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