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://whathaveyoutried.com%'

Enter Parameters

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