0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select top ##num##
  cast(
    round(cast(u.reputation as real)/1000,1) 
    as varchar)+'K' as [Rep],
  p.owneruserid as [User Link],
  case when p.posttypeid = 1 then 'Q' else 'A' end 
    as [Q/A],
  p.score as [Votes],
  p.id as [Post Link],
  p.lasteditdate as [Modified]
from posts p
join users u on u.id = p.owneruserid
where
  u.id in ##ListofUserIDs##
order by [Modified] desc

fork query

edited apr 5 13 Kaveh

created apr 5 13 anonymous