Select u1.id AS QuestionUserId, u1.Reputation As Question...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

Select u1.id AS QuestionUserId, u1.Reputation As QuestionUserReputation, u1.DisplayName As QuestionUserDN , p1.tags AS Tags, p1.id AS QuestionId, p1.Score AS QuestionScore, p1.title ,p1.body AS QuestionBody, p1.CreationDate AS QuestionDate, p1.AcceptedAnswerId AS AcceptedAnswer,u2.id AS AnswerUserId, u2.Reputation As AnswerUserReputation, u2.DisplayName As AnswerUserDN, p2.Score AS AnswerScore, p2.id AS AnswerId, p2.body AS AnswerBody, p2.CreationDate AS AnswerDate
from Posts as p1
inner join Posts as p2
on p1.id = p2.parentid

inner join users as u1
on p1.OwnerUserId = u1.id

inner join users as u2
on p2.OwnerUserId = u2.id

where p1.Tags Like '%machine-learning%' 
and p1.PostTypeId = 1
and p1.creationdate >= '2015-01-01'
and p1.AnswerCount >= 1

order by p1.id

Enter Parameters

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