Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description --select * from VoteTypes; --select * from PostTypes; select top 30 a. PostId as [Comment Link] , a.*, b.* from Votes a inner join Comments b on a.PostId = b.Id order by a.PostId desc;