Q&A for gardeners and landscapers
SELECT count(*) FROM Posts Where PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'01-01-2017' and '01-01-2018' /* SELECT TOP 14983 Id,Body,Tags,ViewCount,CreationDate FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'01-01-2012' and '01-01-2013' ORDER BY [ViewCount] Desc SELECT ParentId,Id,Body FROM Posts WHERE ParentId IN ( SELECT TOP 14983 Id FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'01-01-2012' and '01-01-2013' ORDER BY [ViewCount] Desc) */