SELECT q.Id as question_id,q.CreationDate as question_cr...


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT  q.Id as question_id,q.CreationDate as question_creationDate,
q.acceptedAnswerId as question_acceptedAnswerId,
q.Body as question_text, q.Title as question_title,
q.Tags as question_tags,
a.Id as answer_id,a.CreationDate as answer_creationDate,
a.score as answer_score,a.Body as answer_text,
a.Title as answer_title,a.Tags as answer_tags
FROM Posts q
inner join
Posts a on q.AcceptedAnswerId = a.Id
a.PostTypeId = 2
and  a.CreationDate > '2016-01-01 00:00:01' and 
a.CreationDate < '2017-01-01 00:00:00' and a.Body like '' and 
q.Body not like ''

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results