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 5000 Id FROM posts 
  WHERE Tags like '%java%' 
  AND Tags not like '%javascript%' 
  AND CreationDate BETWEEN '2013-06-01' AND '2013-06-15'
  ORDER BY Id desc
  )
 
  AND PostTypeId > 1

fork query

edited jul 30 13 anonymous

created feb 27 11 sysadmin1138