SELECT q.Id, q.PostTypeId, q.AcceptedAnswerId, q.Creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT q.Id, q.PostTypeId, q.AcceptedAnswerId, q.CreationDate, q.Score,
q.ViewCount, q.Body, q.LastEditDate, q.LastActivityDate, q.Title, q.Tags, 
q.AnswerCount, q.ClosedDate, 
a.Id, a.PostTypeId, a.ParentId, a.CreationDate, a.Score, a.ViewCount,
a.Body, a.LastEditDate, a.LastActivityDate, a.Title, a.CommentCount

/* Question posts */
FROM Posts q 
/* Answers */
INNER JOIN Posts a 
ON a.ParentId = q.Id 

WHERE 
q.PostTypeId = 1 AND 
a.PostTypeId = 2 AND
q.CreationDate  >= Convert(datetime, '2010-08-19') AND
(
	q.Tags like '%security%' OR 
	q.Tags like '%analyst' OR 
	q.Tags like '%analysis' OR 
	q.Tags like '%risk management' OR 
	q.Tags like '%CREST' OR 
	q.Tags like '%CISSP' OR 
	q.Tags like '%CISM'
)
;

Enter Parameters

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