0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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 < '2015-01-01'
    and (d.tags like '%<allocation>%' or  d.tags like '%<crash-dumps>%' or  d.tags like '%<dump>%' or  d.tags like '%<garbage>%' or  d.tags like '%<garbage-collection>%' or  d.tags like '%<handle-leak>%' or  d.tags like '%<heap-memory>%' or  d.tags like '%<memory>%' or  d.tags like '%<memory-address>%' or  d.tags like '%<memory-consumption>%' or  d.tags like '%<memory-corruption>%' or  d.tags like '%<memory-dump>%' or  d.tags like '%<memory-efficient>%' or  d.tags like '%<memory-leak-detector>%' or  d.tags like '%<memory-leaks>%' or  d.tags like '%<memory-limit>%' or  d.tags like '%<memory-management>%' or  d.tags like '%<memory-model>%' or  d.tags like '%<memory-optimization>%' or  d.tags like '%<memory-profiling>%' or  d.tags like '%<memorycache>%' or  d.tags like '%<memorystream>%' or  d.tags like '%<out-of-memory>%' or  d.tags like '%<readprocessmemory>%' or  d.tags like '%<shared-memory>%')
order by d.CreationDate

fork query

edited nov 26

created jun 29 21 anonymous