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