Q&A about the site for professional robotic engineers, hobbyists, researchers and students
/* SELECT Id,ParentId,Body,Tags,ViewCount,CreationDate FROM Posts WHERE PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') AND CreationDate BETWEEN'08-02-2017' and '09-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'08-02-2017' and '09-01-2017')