1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

select top 250
    'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link], 
    Posts.Title,
    Posts.CreationDate,
    Posts.AnswerCount,
    Posts.CommentCount,
    Posts.FavoriteCount,
    Posts.ViewCount,
    Posts.Tags [Tags]
FROM Tags    
    JOIN PostTags ON PostTags.TagId = Tags.Id
    JOIN Posts ON Posts.Id = PostTags.PostId 
WHERE    
Posts.PostTypeId=1
and Posts.CreationDate > '2014-01-01'
and Posts.Score > 30
and (Tags.TagName = 'css')
--and Posts.Title like '%SelectMany%'

Group By Posts.Id, Posts.Title, Posts.Body, Posts.CreationDate, Posts.Score, Posts.AnswerCount, Posts.CommentCount, Posts.FavoriteCount, Posts.ViewCount, Posts.AcceptedAnswerId, Posts.tags

Order By [ViewCount] Desc

fork query

edited may 1 18 Brendan.Enrick

created nov 28 16 anonymous