/* Selected fields */ SELECT q.Id, q.PostTypeId, q.Accept...

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

/* 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.CreationDate  >= Convert(datetime, '2010-08-19') AND
(
	q.Tags like '%bigdata%' OR 
	q.Tags like '%analytics' OR 
	q.Tags like '%hdfs' OR 
	q.Tags like '%mapreduce' OR 
	q.Tags like '%apache-kafka' OR 
	q.Tags like '%apache-spark' OR 
	q.Tags like '%apache-flink' OR 
	q.Tags like '%tensorflow' OR 
	q.Tags like '%hadoop' 
)
;

Enter Parameters

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