0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

/* Selected fields */
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.Score >= ##MinScore:int## AND
q.CreationDate  >= Convert(datetime, '2017-06-21') AND
(
	q.Tags like '%security%' OR 
	q.Tags like '%information-security' OR 
	q.Tags like '%information-systems' OR 
	q.Tags like '%security-operations' OR 
	q.Tags like '%information-assurance' OR 
	q.Tags like '%network-security' OR 
	q.Tags like '%project-management' OR 
	q.Tags like '%vulnerability-assessment' OR 
	q.Tags like '%Linux' OR
	q.Tags like '%NIST' 
)
;

view current version

edited jun 30

created jun 30 jon.doe39204