Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
/* 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'06-02-2017' and '07-01-2017')