1st task

0

Please login or register to vote for this query.

(click on this box to dismiss)

CiviCRM Meta

Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software

/*
select * from posts where Id = 356123;
select * from SuggestedEdits where PostId = 356123;
select * from ReviewTasks rt 
inner join ReviewTaskResults rtr 
on rt.Id = rtr.ReviewTaskId
where rt.PostId = 356123;

select * from PostHistory where PostId = 356123;

select top 10 PostId, Comment
from (select PostId, Comment,
             row_number() over (partition by PostId order by CreationDate desc) as rownum
             from PostHistory) ph
where rownum = 1;

with YearlyTagCounts as (
  select top 5
      t.TagName,
      count(p.Id) as TotalPosts
  from Posts p,
       PostTags pt,
       Tags t
  where p.Id = pt.PostId
  and pt.TagId = t.Id
  and year(p.CreationDate) = year(getdate())  -- Filter posts created this year
  group by t.TagName
  order by COUNT(p.Id) desc
),*/

select top 100 * from Tags

Enter Parameters

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