Q&A for committed Christians, experts in Christianity and those interested in learning more
/* SELECT count FROM Posts Where PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'01-01-2013' and '01-01-2014' /* SELECT TOP 14983 Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'01-01-2017' and '01-01-2018' ORDER BY [ViewCount] Desc */ SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate 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-2017' and '01-01-2018' ORDER BY [ViewCount] Desc)