"Best" posts prior to 2010

0

Please login or register to vote for this query.

(click on this box to dismiss)

All questions that start with the word "Best" and were asked before 2010. "Best way" is excluded from the resulsts.

Stack Overflow

Q&A for programmers

-- "Best" posts prior to 2010
-- All questions that start with the word "Best" and were asked before 2010.
-- "Best way" is excluded from the resulsts.

select
  CreationDate, Id as [Post Link], Body, Score from Posts
where
  upper(Title) like 'BEST%' and
  upper(Title) not like 'BEST WAY%' and
  ClosedDate is null and
  cast(CreationDate as DATE) < cast('2010-01-01 00:00:00.000' as DATE)
order by Score desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached