.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
  id as [Post Link],
  owneruserid as [User Link],
  score as Score,
  viewcount as Views,
  commentcount as Comments,
  favoritecount as [Fav's],
  round(datediff(d,getdate(),creationdate),1) as YearsOld,
  Tags

from posts
where
  posttypeid=1
  and tags like '%vba>%'
  and answercount=0
  and closeddate is null
  and communityowneddate is null
order by
  score desc,
  viewcount desc

Enter Parameters

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