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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

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
Where 
a.PostTypeId = 2
and  a.CreationDate > '2017-01-01 00:00:01' and 
a.CreationDate < '2018-01-01 00:00:00' and a.Body like '%medium.com%' and 
q.Body not like '%medium.com%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results