0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 
  p.Id AS [Post Link],
  p.Title,
  p.Score,
  p.ViewCount,
  p.CreationDate,
  p.Tags,
  CASE p.PostTypeId 
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END AS PostType,
  LEFT(p.Body, 200) + '...' AS BodyPreview
FROM 
  Posts p
WHERE 
  (p.Title LIKE '%architect%' 
   OR p.Body LIKE '%architect%')
  AND p.PostTypeId IN (1, 2)  -- Only questions and answers
  AND p.CreationDate >= DATEADD(MONTH, -1, GETDATE())  -- Last 6 months only
  AND p.Score >= 0  -- Include all non-negative scored posts
ORDER BY 
  p.Score DESC,
  p.CreationDate DESC

fork query

edited nov 17

created nov 17 anonymous