Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'06-02-2017' and '07-01-2017' /* SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE ParentId IN ( SELECT Id FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'05-02-2017' and '06-01-2017')