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 top 100 * from VoteTypes;
select top 100 * 
from Votes 
where PostId = 356123;
select cont(v.Id), v.PostId, vt.Name
from Votes v,
     VoteType vt
where v.VoteTypeId = vt.Id
and vt.Name in ('UpMode','DownMode')

select top 10 v.PostId, vt.Name
    from Votes v,
         VoteTypes vt
    where v.VoteTypeId = vt.Id
    and vt.Name = 'UpMode'

with rankedupvotes as (
    select top 10 count(v.Id) VoteCount, v.PostId
    from Votes v
    where v.VoteTypeId = 2
    group by v.PostId
    order by count(v.Id) desc

),
rankeddownvotes as (
    select top 10 count(v.Id) VoteCount, v.PostId
    from Votes v
    where v.VoteTypeId = 3
    group by v.PostId
    order by count(v.Id) desc

)
select PostId, VoteCount
from rankedupvotes
union all
select PostId, VoteCount
from rankeddownvotes;
select top 100 * from PostHistoryTypes;*/

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;

Enter Parameters

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