0

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Q&A for network engineers

SELECT *
FROM posts
WHERE ParentId IN 
( SELECT Top 1000 Id FROM posts 
  WHERE Tags like '%java%' and Tags not like '%javascript%' 
  ORDER BY Id desc
  )
  AND CreationDate > '2013-05-01' 
  AND CreationDate > '2013-06-01' 
  AND PostTypeId > 1

fork query

edited jul 30 13 anonymous

created feb 27 11 sysadmin1138