0

Please login or register to vote for this query.

(click on this box to dismiss)

potential game criteria?

Q&A for amateur radio enthusiasts

select
  tags,
  id,
  viewcount,
  answercount,
  cast(creationdate as date) as asked,
  title
into #temp
from posts
where 
  ( tags like '%excel%' or tags like '%vba>%' )
  and answercount<3
  and posttypeid=1
  and viewcount>1000
  and tags not like '%php%'
  and tags not like '%java%'
  and tags not like '%python%'

select 
  'https://stackoverflow.com/q/' + CAST(Id AS nvarchar) + '|' + title AS [Link],
  *
from #temp
where viewcount>1000
order by  --year(asked) desc, month(asked)/4 desc, 
  viewcount desc

view current version

edited jul 23 18

created jun 15 18 ashleedawg