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)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

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 > '2016-12-12 00:00:01' and 
a.CreationDate < '2017-10-12 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