2022

0

Please login or register to vote for this query.

(click on this box to dismiss)

SELECT C.CreationDate, C.Text, P.Id as [Post Link] FROM Comments C INNER JOIN Posts P ON C.PostId = P.Id WHERE C.UserId = ##UserIdX## AND P.OwnerUserId = ##UserIDY## ORDER BY C.CreationDate ASC

Stack Overflow

Q&A for professional and enthusiast programmers

select c.postid as [Post Link], c.text, c.creationdate
from comments c
where c.userid = 22222
and c.text like '%python%'
order by c.creationdate asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results