Count of comments containing WHYT.com

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

SELECT 'http://http://stackoverflow.com/questions/' +  CONVERT(varchar,P.id) FROM Posts P
INNER JOIN Comments C ON P.Id = C.PostId
WHERE 
P.CreationDate >= convert(datetime, '01/01/2012', 103)  AND P.CreationDate <= convert(datetime, '01/02/2012', 103) 
AND LOWER(C.Text) LIKE '%http://meta.stackoverflow.com/questions/128548/what-stack-overflow-is-not%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results