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, '2017-06-20') AND
(
	q.Tags like '%security%' OR 
	q.Tags like '%information-systems' OR 
	q.Tags like '%penetration-testing' OR 
	q.Tags like '%linux' OR 
	q.Tags like '%software-development' OR 
	q.Tags like '%python' OR 
	q.Tags like '%information-security' OR 
	q.Tags like '%project-management' OR
    q.Tags like '%vulnerability-assessment' OR 
	q.Tags like '%java' OR 
	q.Tags like '%tester'
)
;

Enter Parameters

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