Most popular questions from last week

0

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

select top 250
    'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link], 
    Posts.Title,
    Posts.AnswerCount + Posts.CommentCount + Posts.FavoriteCount as score,
    Posts.ViewCount,
    Posts.Tags [Tags],
    Posts.CreationDate
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 in('java')

Order By [ViewCount] Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results