My comments my keyword

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select parent.score, comments.score, postid as [Post Link], comments.creationdate, text from comments
join posts parent on (comments.postid = parent.id)
where userid = ##userid## and text like '%##pat##%'
order by comments.score desc, creationdate desc

Enter Parameters

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