0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

select top 50
    '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 > DATEADD(DAY, -7, GETDATE())
and Tags.TagName = 'android'

Order By [ViewCount] Desc

fork query

edited jun 6 20

created nov 28 16 anonymous