0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

/* 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
a.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-assurance' OR 
	q.Tags like '%security-operations' OR 
	q.Tags like '%cryptography' OR 
	q.Tags like '%risk-assessment' OR 
	q.Tags like '%risk-management' OR 
	q.Tags like '%threat-analysis' OR 
	q.Tags like '%authentication' OR
	q.Tags like '%network-security' OR 
	q.Tags like '%NIST-cybersecurity-framework' OR 
	q.Tags like '%internal-auditing' 
)
;

view current version

edited jun 30

created jun 30 jon.doe39204