SELECT P.Id AS [Post Link], C.text FROM Comments C INNER ...

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 P.Id AS [Post Link], 
       --concat('site://','questions/', P.Id, '|', P.Title) [Question],
       C.text
FROM Comments C
INNER JOIN Posts P
ON P.Id = C.PostId
WHERE P.PostTypeId = 1 AND C.text LIKE N'%спасибо%'

Enter Parameters

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