A lexical search method
Q&A about the site for gardeners and landscapers
SELECT * FROM posts WHERE ParentId IN ( SELECT Top 1000000 Id FROM posts WHERE Tags like '%java%' and Tags not like '%javascript%' ORDER BY Id desc ) AND CreationDate BETWEEN '2013-05-31' and '2013-07-01' AND ParentId = 2