0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for passionate videogamers on all platforms

select top 10
a.Id
,a. Title
,c.TagsCount
,a. Title
,CHECKSUM(NEWID())
from posts a
inner join PostTypes b on a.posttypeid=b.id and b.name='Question'
inner join (Select PostId
                  ,count(TagId) as TagsCount
                  From PostTags
                  Group by PostId) c on a.id=c.postid and c.TagsCount>='5'
order by Checksum(newID()) desc

fork query

edited jan 17 18

created jan 17 18 anonymous