column_E_from_2018

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

SELECT --distinct
    (d.Id) as id,
    d.CreationDate,
    --FORMAT (d.CreationDate, 'yyyy-MM') as [date1],
    CONCAT('site://q/', d.Id, '|', d.Title) AS [PostLink],
    d.Title,
    d.Body,
    d.tags,
    Score,
    ViewCount,
    AcceptedAnswerId,
    AnswerCount,
    CommentCount,
    FavoriteCount,
    ClosedDate
  FROM Posts d
  WHERE
    d.PostTypeId = 1  -- 1=Question
    --and d.CreationDate >='2018-01-01'
    and (d.tags like '%<dotTrace>%' or  d.tags like '%<miniprofiler>%' or  d.tags like '%<mvc-mini-profiler>%' or  d.tags like '%<windows-performance-analyzer>%' or  d.tags like '%<xperf>%')
order by d.CreationDate

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results