Trend of questions with [tag] that have the [tag] as title prefix

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

declare @tag nvarchar(35) = ##tag:string##
declare @numAnswers int = iif(
  lower(##answers:string?any##) = 'any', 
  -1,
  cast(##answers## as int)
)

declare @now date = getdate();
declare @cyear int = year(@now);
declare @cmonth int = month(@now);
declare @ldate date = cast( 
(select min(CreationDate) from Posts where PostTypeId = 1)
as date);

declare @months table (
name nvarchar(max),
questions bigint
)


/*select
  count(*)
from
  Posts
where
  charindex(@tag,Tags) > 0
  and
  lower(Title) like replace(@tag,'-',' ') + '%'
  and
  ClosedDate is null
  and
  AnswerCount = iif(@numAnswers = -1, AnswerCount, @numAnswers)
order by
  
desc*/

Enter Parameters

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