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 '%<application-monitoring>%' or d.tags like '%<azure-monitoring>%' or d.tags like '%<code-profiling>%' or d.tags like '%<debug-diagnostic-tool>%' or d.tags like '%<diagnostic-tools>%' or d.tags like '%<diagnostics>%' or d.tags like '%<freeze>%' or d.tags like '%<health-monitoring>%' or d.tags like '%<monitoring>%' or d.tags like '%<optimization>%' or d.tags like '%<process-monitoring>%' or d.tags like '%<profiler>%' or d.tags like '%<profiling>%' or d.tags like '%<server-monitoring>%' or d.tags like '%<system-monitoring>%') order by d.CreationDate