Comments by one user on another user's posts


Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

declare @CommentatorId int = ##CommentatorId##
declare @PosterId int = ##PosterId##

select c.Text, c.PostId as [Post Link]
from Comments c join Posts p on (c.PostId = p.Id)
where c.UserId = @CommentatorId
  and p.OwnerUserId = @PosterId

Enter Parameters

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